Customers CSV import

[jofera]

Hello! This morning I installed PS 1.5.4.1 because I decided to migrate my shop from zen-cart to PS. I build a script that exports all my customers to a CSV file, with the syntaxis specified on the backend. I made sure that the charset is correct and all the fields is correctly filled, but when I try to make the import I get a success message but I can see that anybody customers had been imported. I also have tried to import only 1 or 2 customers although I'm on a dedicated server, but it didn't work.

 

I'm quite desperated. I have lost a lot of hours with this problem and I'm been unabled to solve. Also find some people in forums with the same problem, but nobody posted a solution.

 

Could anybody gently help me with the migration?

 

Thanks in advance

[shimony]

Hello! This morning I installed PS 1.5.4.1 because I decided to migrate my shop from zen-cart to PS. I build a script that exports all my customers to a CSV file, with the syntaxis specified on the backend. I made sure that the charset is correct and all the fields is correctly filled, but when I try to make the import I get a success message but I can see that anybody customers had been imported. I also have tried to import only 1 or 2 customers although I'm on a dedicated server, but it didn't work.

 

I'm quite desperated. I have lost a lot of hours with this problem and I'm been unabled to solve. Also find some people in forums with the same problem, but nobody posted a solution.

 

Could anybody gently help me with the migration?

 

Thanks in advance

Hi

 

I have the same problem - i imported my customers and got successfully imported message, but no customers been imported.

 

If anyone have a solution for this, please advise.

 

thanks.

[shimony]

Hi

 

I have the same problem - i imported my customers and got successfully imported message, but no customers been imported.

 

If anyone have a solution for this, please advise.

 

thanks.

 

Just solved it -

From SQL admin, use this sql query:

SELECT `id_customer` , `active` , `id_gender` , `email` , `passwd` , `birthday` , `lastname` , `firstname` , `newsletter` , `optin` , "1"

FROM `ps_customer`

 

Click on Export, choose CSV, remove the "&quot& and replace the "," with ";".

Copy the output to a text file with .CSV at the name

Import

Done.

Edited October 6, 2013 by shimony (see edit history)