2.3 Export Customers

fmCustomers


To export customers from Store Manager to a separate .csv file you need to launch import/export wizard. At first select customers for export and press 'Import/Export Customers' button in the top toolbar

of Customers & Groups section of Store Manager for Prestashop.


Customers and groups


'Welcome' page allows you to choose necessary process (in this case - 'Export') and launch export settings.

Export customers option


When selecting a file for export, you can use a browser button or enter the file name in the appropriate field. 

To add customers to the file, that is located on the FTP server, you must specify the correct data of your FTP connection.

Select file



You can use a previously saved export configuration file by clicking 'Load Settings' button or may skip it because it is not required and press 'Next' to proceed.

Upload export configuration

The filter page allows choosing the amount of exporting data be helping with the appropriate checkboxes:

Select Customers to Export



Next window shows you some important settings:

1) delimiter character - in most cases there are three types of delimiters: comma, semicolon and tab character. Be careful, because the export file is mainly created for further imports. If you choose the wrong delimiter,

the data will be incorrectly exported to a file and can not be used to import in the future.

2) quote string  - it serves to separate rows in the file, in which data will be exported.

3) groups delimiter - there are two types of delimiters: comma (,) and semicolon (;). Choose delimiter that will separate the group data values. 

Select fields delimiter and quote charecter


Select the data you would like to export.

Middle options


 In the left side, you can see the data that can be exported. 
The already formed the groups of data allows uploading the necessary fields from a certain area you want to export and transfer them automatically to the right panel. 

Groups of fileds


If you choose the required for exporting fields and press '1' button, they will move to the right side. You can also drag and drop fields between two panels.

An arrow '2' serves for canceling your previous actions.

If you would like to export all data, just press '3' button. 

To reverse your previous action for all fields at once  - use the button number '4' as an illustration below:

Arrow number '4'

Confirm your choice to launch the process of abolishment.

You can modify the export data with the help of specified expressions. To create them simply press 'Add Expression Field' button in the top of the window

Add Expression Field


and open the 'Expression Editor' window.

Expression Editor form


Type necessary expressions in it, click 'Execute Expression' to test them and press 'OK' to exit from the editor.

'Export' button will launch the export procedure. You can see the export result in the next window, named 'Finish'. Choose one of the three proposed actions for Store Manager at the final step of the export wizard.

Finish step


In order to use current configuration during the next export process, you should save it separately to a .cfg file, pressing 'Save Export Settings' button. 

Save export configuration

To add configuration to the embedded wizard list use the option below:

Save to the wizard


Otherwise, just skip it and click 'Finish' to exit the export wizard.


By eMagicOne Inc.

Comments