CSV Improved for Joomla 1.5 is the fastest and best way to quickly and easily populate your Joomla 1.5 VirtueMart store.
We're setting up several new web stores that will be selling a variety of items. VirtueMart is the most popular e-store / shopping cart component for Joomla 1.5 and I've used it a number of times in the past. After spending a few years fighting with osCommerce, VirtueMart is an absolute thrill to implement.
Once VirtueMart is set up, the first challenge is entering all of the products we wish to offer for sale. If you're running a small store with only a handful of products, doing this by hand via VirtueMart's native interface is pretty simple. If you've got hundreds, or even thousands of products, this would be a tiresome and tedious chore.
Fortunately, a number of our distributors with whom we're working supplied us with their product listings in CSV format. I'll explain more about this file format later, but this allows us to import an entire catalog into our new store in just a few steps using another Joomla! component called "CSV Improved". If you read the reviews of CSV Improved on Joomla's extensions site, you'll notice two things that nearly every reviews says:
- CSV Improved is THE tool to do what we're attempting.
- CSV Improved has a HUGE learning curve.
Since none of the alternatives were appealing, I decided to dig into CSV Improved and see how hard it really is. I download and installed the 30-day trial and then headed over to the documentation.
I've worked with hundreds of third-party add-ons for various open source programs, and I found CSV Improved's documentation to be one of the most lacking examples I've encountered. While I'll give CSV Improved's author credit for using a wiki to document his project, the examples and tutorials aren't very straightforward and there are NO pictures. Of course I'm well versed in the English language (which appears to be a secondary language for the author), but when explaining how something works on the computer, a picture truly is worth a thousand words.
So I figured I'd take this opportunity to make a few journal entries here on the Tech Diary chronicling my learning process with CSV Improved. My aim is to provide simple, easy-to-follow instructions on how to get CSV Improved fully up and running.
I'm doing it here on Tech Diary for a couple of reasons. First, the Tech Diary is a place where I can keep track of the various projects I'm working on. If I record everything here, I'll always know where to go when I have to do it again. Second, I'm hoping that this will be a resource for other VirtueMart and CSV Improved users that might be initially discouraged by its apparent difficulty to use. By the end of the tutorial you'll be an expert at using CSV Improved for Joomla 1.5.
