exporting customer details

[deirdre]

Hi in prestashop 1.7.5.2 I want to export a list of  my customers details to include their email and  mobile phone numbers that I have recorded  in the database.Can this be done without having to go into each customer  profile individually? How can it be done please ?

[lototo]

There are many options. You can export to table csv file in PhpMyadmin or install module like https://addons.prestashop.com/en/data-import-export/7286-export-customers-database.html

[deirdre]

yes I know how to export the customer details  but it does not include the telephone numbers I have recorded and it is the telephone numbers I want to extract .

As you can see in the attachment  i have the name address zip city and country but no telephone number and i think its the same with the module you suggested do you know of a way to include telephone number?

[deirdre]

Surely there must be a way of adding  the telephone numbers to the export file without having to purchase another  add on ??

[MichaelEZ]

Best way to do it is via PhpMyadmin, or u can export whole table and edit columns in excel 

u can try out this

Edited November 20, 2019 by MichaelEZ (see edit history)

[musicmaster]

You can do that with Prestools. It is free.

[Constantino]

If you need it for one time, you can use the trial version of Store Manager for PrestaShop. you can use its customers export to extract email, phone and mobile number