4. Export Products
Export products wizard will help you to export your VirtueMart products to comma-separated values file (.csv) which can be easily opened in MS Excel or other application for detailed analysis.
To start Export Products procedure you need to click on a button which calls the Import/Export Wizard.
Or you can use "Export Grid" button for fast Export as well.
Products Import/Export Wizard is similar to Categories Import/Export Wizard. To export VirtueMart products follow-up several steps listed below:
Select "Export" and click "Next >" button to continue.
You can find Export wizard from the top toolbar or from the context menu :
Import/export wizard available in the upper sections menu of Store Manager as well:
Store Manager can export VirtueMart products to .csv file.
You should enter the file name or select one (using browse button) replace the current file. Here you can also load or save export settings (configuration).
If your file to import is on the FTP server and you have the properly FTP configuration - check the lower checkbox and fill the empty fields :
Make sure you use the correct FTP credentials, in another case you will get the one of the following error messages:
To be able to proceed you should go to the FTP section in Preferences of Store Manager and check the correctness of the FTP details by pressing the test option:
Or you need to contact your hosting provider to verify your credentials.
Once data is correct and after clicking on the browser button the FTP categories tree appears, specify a directory, where your store is placed with all necessary files, such as tmp, app, media etc.
'Use Configuration' field allows upload previously saved configuration and thereby facilitate the passage of exporting steps:
Fields Delimiter page has some important settings. Check them to ensure proper configuration.
The first option is delimiter character. Most popular delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.
The export file is usually generated for further import. If the incorrect delimiter is specified during import, the file will not be parsed properly and the products will not be imported. The second option is quote string values. It is used to separate strings in CSV file.
The next page of Export Wizard includes Base Formats and separators. They can be set by default.
At the next page, you can see some general VirtueMart product export options.
Export image name - is exporting image names as they are in products (database): some_image.jpg when 'AS IS' option is checked. If you select the Full option, image name field will contain URL that can be opened in a browser.
On the selection step of export wizard by using the drag-and-drop method or the options in the middle you can move fields between left-right panels to form the list with the data which will be exported :
I.e., all available fields that can be exported are listed in the left pane. Select fields you want to be exported and click ">" button to move them to the right pane. If you'd like to export all fields simply press ">>".
The order in which columns will be saved in .csv file can be changed. To do this you can move exported columns up and down using the corresponding buttons.
In case you manage the multilingual store and want to transfer products details for each store view choose the group of the appropriate data from the drop-down listing of top option:
and all data relate to the selected store view will be drop to the right pane at once.
To modify data during export launch the Expression Editor and specify the formula by using the set of SQL statements which returning a single value.
Press 'SQL Help' button to get the integrated SQL help for creation such formula.
'Export column title as first row' field should be checked if you want to have the fields name in the first row of exported file , if not - leave this field unchecked.
Attention! When you press "Export" Button, export process will start! You can save all your Export Settings for future export of VirtueMart products or Load the settings you have saved previously.
Go to the next step of the wizard.
Preview export file and proceed.
The 'Save configuration' area allows place the current export configuration directly in the wizard list or separately to a file by using the following options:
To remove selected configuration from a list use the option below:
Choose what action to perform after saving export data, use "None" option and Wizard will be automatically closed. If you wish to open a directory containing result file, check the corresponding option.
Open result file option allows you to see export file opened in Excel.