SQL query to export all data from customers (name, adderess, vat number, and all other fields)

[André Castro]

Good afternoon.

I need to export all customers data from prestashop store version 1.7.2.4 to a CSV file to a new prestashop 1.7.7 store i'm creating.

It must include client name, addresses, vat number and all other fields.

Is there an SQL query that does this?

Thank you.

Edited January 8, 2021 by André Castro (see edit history)

[Prestachamps]

Hi, 

Yes, that can be done, but you'll face issues on orders. 

However can I ask you kindly :

1.why don't you just upgrade the store instead? 
2. Also you could migrate the store with the following module 

https://addons.prestashop.com/en/data-migration-backup/8934-migrationpro-prestashop-upgrade-and-migrate-tool.html

I personally would choose the upgrade part- would make things easy.

 3. Here is another one :

https://addons.prestashop.com/en/data-import-export/7286-export-customers-database.html

Regard's, 

Leo

PS: the MySQL can be done, just don't seem to efficient

[André Castro]

Thank you for your kind answer.
I made another version from the sore.
It was made from scratch, and now i need the customers and all its data in the new fresh store.
I will try the SQL query for now.

[Prestachamps]

Hi, I'm having some meetups, but I'll try to send you early tomorrow. 

As a free option I found this on the forum (never used it myself) 

https://www.prestools.com/info/copy-shopdata

Kind Regards, 

Leo

[André Castro]

"but I'll try to send you early tomorrow"
I would apreciate that very much.

I'm trying to make my own query width inner join or left join between ps_customer and ps_address tables but it always gives me undefined "checkedForm" error.
Perhaps a prestashop 1.7.2.4 bug exporting mysql queries?