Importing and exporting your products in Joomla Virtuemart doesn’t have to be a hassle. Check out the tutorial below for a step by step guide through the process of using CSVI to import, browse, organize, and export your products.
Importing and Exporting Products in Joomla Virtuemart with CSVI
Video Tutorial Transcription
“Hello there, my name is Luke — I’m going to be going over with you today how to import or even export products into your website. We’re going to go with a Joomla! website. It’s a free content management system (CMS). You can get it from Joomla.org or by searching Joomla.
So to get started, you’re gonna want to go to a website called CSVI Improved. CSVI for Virtuemart is a software that will let you move and remove different products from your site without having to do all the saving and all the individual product and page manipulation. To get it, you’re going to need to register with CSVI Improved and they’re going to ask you the basic information, and then you’ll be able to download a little file that will allow you to create the software in Joomla so you can do importing and exporting.
Let me show you how to do that …
Go into your back end and go to extension and then you go to install / uninstall.
You’re going to browse the file that you downloaded from CSVI and you’re going to instal the file. Once that’s installed you need to go to your components and you’re going to see CSVI Virtuemart installed in your components.
The next phase is going to be to go to the extra sub menu it gives you and go to export. There, you’ll see the different options to export, and CSVI product export is what will allow you to export all of your products. Here is offering to export 20 different fields that relate to all the different features that I can associate with my products. We’re going to click export in the upper right and it’s going to ask to export this as an excel document. That’s a perfectly acceptable option, but we’re going to use an even easier way to manipulate this — we’re going to use Open Office. Notice this is called a CSV. CSV’s are much easier to deal with in Open Office, so we’re going to save this file, go to Open Office, select “file-open,” we’re going to go to our downloads and we’re going to open it up through Open Office. Open Office is going to know what to do about the formatting of this file … The first thing it’s going to need to know is how to separate the information. We can see down in here, there are rows, but inside the rows there are tildes and carrots, so we need to establish what the tildes and carrots are going to be. We’re going to separate, through “other,” and we’re going to establish your carrot as a line delimeter and we’re going to create another text delimiter and we’re going to use tilde as our text delimiter. It now looks nicely formatted, so when we click “ok” we can see it’s a perfectly readable spreadsheet.
Go back to the CSVI and use the import function to browse and import that CSVI.”