5.2 Export Users
To transfer your store customer list to a .csv file use the Export Wizard tool on the Users page of Store Manager. Press the following options:
1. The first step of Wizard is the page where you should specify the file name for exported data.
Check the FTP details firstly by moving to the Preferences of Store Manager-> FTP. 'Test Connection' button helps to verify the specified FTP credentials. You should get the next message to be able to proceed:
If you haven't access to your FTP server - please contact your hosting provider to resolve this issue.
Load configuration field - allows uploading the previously saved export configuration if any.
This significantly speeds up the passage of the following steps of the export.
Use the following ways to proceed with export:
2. 'CSV delimiter' page gives an opportunity to choose the appropriate delimiter character and quote string values.
The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.
Quote string values - this field specifies the character used to separate strings in the CSV file.
3. Next step is 'Fields to export' page that divided into two panes
Or use the options in the middle - - to transfer fields one by one or - - to move them all at once.
And, conversely, to return one by one field to their previous positions in the left press this option - or bring back all fields at once as well - .
To use the expression formula to customize the exported data open the Expression Editor form after clicking on the option at the top.
Expression helps you to increase/decrease the products price after export, combine some values positions in the appropriate fields of store database, send items in 'Out of Stock' mode automatically provided that their quantity
become '0' and more. Use 'Help' button in the top for more details on expression special syntax with provided examples.
To add the more complex formula that allows to make changes to your store database tables requires some SQL skills and can be done by helping with the Custom SQL editor.
To launch the editor form directly from this step of export use the 'Add extended expression field' option.
Check this chapter about the Custom SQL section of Store Manager to better understand its functionality.
If the export file should contain the field names in the first row - check the corresponding field at the top toolbar.
In other case leave it un-checked.
4. Export Options step - here you can choose a number of records you want to export:
And also check the multiple records separator - delimiter between multiple fields value.
You can press the 'Set Default' option to recover the default settings.
After pressing 'Export' button you start transferring your data.
5. On the export results step you can see the following actions below:
Check the one you want to be performed.
Do not forget, in order to use the current export configuration during the next export processes, to save it to the Wizard list or to a separate file.
Use the 'Save configuration' option to choose the necessary storage location.
If you have any unused or inactive configurations you can remove them from the wizard list by using the 'Delete configuration' option . To clear all configurations export list at once - press 'Clear list' command.