Export VirtueMart Shoppers to CSV
Date: November 21, 2013
Clientbase is important component of business process, that is why store owners need to keep an eye on all shoppers details. Thus, often there emerges the need to bring data to spreadsheet, which can be used for statistical and accounting purposes, changes implementing, moving information on VirtueMart shoppers to other store or sending it to employee or partner if necessary.
With Store Manager for VirtueMart you can get spreadsheets with customers information in files of different formats - TXT, EXCEL, HTML, XML and CSV. Those options are available if you select the one you need from export grid.
However, you have also the chance to create more advanced .csv listings with the ability to select the shoppers and information to be listed on the files after export. It is possible using Export Shoppers wizard.
Let’s go through the procedure step-by-step.
First of all, in case you would like to have in the file information on some particular shoppers only, select them.
To start the procedure you should run Export Shoppers Wizard from Ribbon menu (tab Store) or go shoppers management section and there from toolbar select appropriate action.
Next you will see new window opened, where you should indicate where the file with exported information should be saved. It can be either some folder at your PC or remote location (where the file can be uploaded via FTP).
Proceeding further you will see the step where you sill have to specify delimiters and quote characters. Basically, those values are necessary for proper file opening and data parsing when the spreadsheet will be opened after export procedure.
Base formats window contains the settings for such information as date, time, for values that have decimals etc.
The given step allows you to select whether you would like to export all the customers you have at your database or only selected ones (in case you have chosen the shoppers before running export wizard).
Moreover, in case you have multiple values in columns you can indicate delimiter for them, so while file opening, those values will be placed in one column.
Further you will see fields that you can bring to your file, so you are able to select the ones necessary. This way you can avoid overloading file with too many fields you do not need. Navigate using arrows in the center of the window to add or remove fields to export list.
Hit “Export” button to start the process of saving data to indicated file.
At the final step you will have the chance to one more preview data you will have. Moreover, you can set what action should be performed after export process is to end, so there if necessary there is the chance to open the spreadsheet or directory where it is saved right after you press “Finish”.
One more thing, in case you need to perform export of VirtueMart shoppers often enough, you might save settings you have just indicated by saving export configuration and loading it next time the procedure should be done.
Get accurately-organized spreadsheet with refined customer information included with smart export wizard of Store Manager for VirtueMart.