Create VirtueMart Data Feeds Automatically Exporting Products to CSV
Date: November, 8th, 2013
Sometimes online merchants need to have all goods-related information gathered in the feed.
What basically is the feed and why you might need it?
Feed is the file with information on products that contains all related details that can be used for different purposes. You can use the spreadsheet with latest information from your shop to send it to your partners, suppliers and other external places, let’s say to notify providers that you have low inventory. Additionally, spreadsheets are used to do changes in them and then massively apply to existing goods importing the file. Feed creation is also needed for expanding client-base and placing listings with items on sell to particular search engine or merchant center.
You have already noticed that reasons why you might need to create spreadsheets with items you sell are multiple, so now you might like to get to know how to get files. The simplest way to have the actual data on your products is VirtueMart export. However, in case you need the feeds to be created more than once a week, it might become too tedious for you to run the process manually each time.
Naturally, if you have some technical skills, you can make use of coding and try yourself in script creation or applying. However, you should be careful as one incorrect action and you might need to restore backup.
For store owners who want to set up cron export without special skills and efforts, Store Manager for VirtueMart contains additionally paid Automated Product Export addon to automatically export products into .csv files on schedule.
What are the advantages you can get using Automated Product Export?
- the ability to customize your feeds by including different information fields, depending on the needs or requirements.
- possibility to select out items to be exported. This way you can refine your spreadsheets.
- planned export in period of time you decide on your own. So you have more control over the procedure running at your store when it is more convenient for you.
- one more obvious advantage is that it is not only possible to bring data to the file, saving it at your computer, but also upload it to FTP (own or remote) having access details. This way information can right away be delivered to your partners.
What is required from you to set up cron export from VirtueMart to CSV?
Basically, the process consists of 3 massive phases:
Creation of export configuration
This is first and one of the most important processes that involves indicating of all the settings, like where to save the file (or to what remote location to upload), what delimiters to use in the file to separate out data and what columns will be there.
Add task to the scheduler and set time for regular update
Pressing “Add current import to the scheduler” allows you to indicate the time and sequence of next recurring export. Please note, that in order for export could be automatically run your Store Manager should be opened.
Check results after export execution
After set time of export you can check the results or in case you need to bring the goods to the file right away, you can press “Run export” previously selecting needed export configuration.
More on how to step-by-step set up export of your goods read here -http://virtuemart-manager.com/useful-articles/product-management/virtuemart-export-products/
Important note: Automated Product Export and Import is Store Manager for VirtueMart addon and is built in the application in Demo mode (you will be able to test it with a few products only). To unlock full functionality and to be able to manage all the goods you will need to purchase addon license separately -http://virtuemart-manager.com/virtuemart-automated-product-import