Joomla Tutorials and Blog Posts

How to Import Products to Virtuemart Using CSV Import Improved

April 25, 2011 | Written by Nick Savov

One of our students had a client that needed a shop setup in Virtuemart which would have about 1,000 products. Rather than create all the products manually, we created this tutorial for our student so that he could automate the process and import all the products into Virtuemart using a CSV which he obtained from his client.

This tutorial will walk you step-by-step through how to import products into Virtuemart using a CSV.

Background Information

If you're not sure what a CSV is or why to use it, click here for a good introduction.

 

Download CSV Improved

tutuploadsmedia_1303583139277.png

We're going to be using CSV Improved to import the CSV. Click here to go to the download link directly. You should be registered (free) and logged in to download the product.

 

Install CSV Improved

tutuploadsmedia_1303583994454.png

Go to Extensions >> Install/Uninstall >> Browse... >> Upload File & Install

 

Export First So That You Have a Sample

tutuploadsmedia_1303714112583.png

The tutorial is for importing, but this is a little trick to get you a sample file so that you do not have have to create it from scratch, thus saving you time and reducing the chance of user errors. In order to perform this shortcut, you need to create at least one product in Virtuemart.

Once you have at least one product created in Virtuemart, go to Components >> CSVI Virtuemart >> Export.

 

tutuploadsmedia_1303714806738.png

Select CSVI Product Export. The rest of the default settings should be fine.

 

tutuploadsmedia_1303714842863.png

Export the CSV file to your computer.

 

Use the Exported CSV File as a Reference

tutuploadsmedia_1303715105718.png

Open up the file and voilà you now have your basic structure and you just have to format your original CSV to match. If you're not sure what all of the information means, please see the Background Information section near the top of this page.

 

tutuploadsmedia_1303716218495.png

Once you're finished formatting your CSV, then go to Import >> CSVI Product Import >> Browse...

 

tutuploadsmedia_1303716464740.png

Import, then double check your table and make sure everything matches well, once finished click Import again. Now you can go into Virtuemart and double check everything from that side.


 

 


To sign up for complete classes and support

 

Comments  

 
#1 Phil 2011-08-08 04:34
Thanks Nick, nice and clear :)
 
 
#2 iowawebco 2011-08-08 22:21
You're welcome, Phil! :)

Kind regards,
Nick
 
 
#3 nagaraja s 2011-09-14 12:12
Nice work!
Is it free ? will u be able to send me ?

Kind regards,
naga
 
 
#4 iowawebco 2011-09-15 10:12
Hi and welcome, Nagaraja!

Yes, it's free. Please read the download section of this tutorial for instructions on how to download.

Kind regards,
Nick
 
 
#5 Manuel D 2011-11-04 09:48
So if I have a OScommerce site now can I move all the products from that site to a new Joomla site using this method? If there are problems doing such a thing can you tell me the best way?
 
 
#6 iowawebco 2011-11-04 18:14
Hi Manuel,

That's correct. Although, Virtuemart 2.0 is the newest version and not quite fully ready yet. I would instead recommend using Hikashop (extensions.joomla.org/.../...) for Joomla 1.7

Kind regards,
Nick
 
 
#7 Adam 2012-04-24 08:17
Thanks for a very useful tutorial :-)
 

Add comment


 


To sign up for complete classes and support