3.2.3 Export Customers

Sub-pages listing:

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 & Orders" section of Store Manager for PrestaShop.

Customers and groups

Welcome

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

Export customers option

Select File

To select a file for export use a browser button or enter the file name in the proper field.

To add customers to the file that is located on the FTP server 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

Select Customers to Export

The filter page allows to choose the amount of exporting data. Select relevant checkboxes for that:

Select Customers to Export

Select Fields Delimiter and Quote Character

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

Select Fields to be Exported

In the left pane, you can see the data that can be exported. Already formed groups of data allow uploading necessary fields from a certain area you want to export and transfer them automatically to the right pane.

Groups of fileds

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

This button with an arrow serves for canceling your previous actions.

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

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

Arrow number '4'

Confirm your choice to launch the process.

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

Add Expression Field

and open the "Expression Editor" window.

Expression Editor form

Finish

Type necessary expressions in it, click [Execute Expression] to test them and press [OK] to exit 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. To do so press [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.