Customers import

[MP-zoho]

Hi,

After a new install (1.6.1.6), I would like to import my customers and their address.

 

So, I make my CSV file and I have my customers in "Customers" and their address in "Address".

 

But, if I open a customer profile, in the address block, I don't have his address : how can I link them ?

 

Thanks

[shokinro]

Are you sure the customer records and addressed records are imported correctly?

When you import, make sure you choose option  "Force ID" so that the address ID and Customer ID are maintained and the relationship will be maintained too.

Otherwise, if all ID are new assigned, then the Customer - Address relationship will be lost - you will not see the address of the customer.

[MP-zoho]

Re,

Yes, I'm sure.

After more search, some customers have their right address, but most of them not (id_customer in ps_address has been changed with import : I don't know why).

Finally, I just made directly in my DB

UPDATE ps_address SET id_customer=id_address;

and it seems good.

 

Thanks

[shokinro]

After more search, some customers have their right address, but most of them not (id_customer in ps_address has been changed with import : I don't know why).

 

 

 

As I mentioned previously, you have choose option to "Force ID" to keep ID not changes.

 

 

Finally, I just made directly in my DB

UPDATE ps_address SET id_customer=id_address;

and it seems good.

 

 

 

This SQL might be not working for all customer address.

I suggest you check all your customer and address relation. 

 

It is better to use "Force ID" at import.

 

 

[MP-zoho]

It is better to use "Force ID" at import.

Re,

 

Yes, I check this option, but not working.

 

Thanks

[shokinro]

You have chosen both of following?

 

Delete all customers before import  : Yes

Force all ID numbers     : Yes  

 

 

[MP-zoho]

You have chosen both of following?

 

Delete all customers before import  : Yes

Force all ID numbers     : Yes  

Re,

 

Yes for both of them and I have no error after import.

Just, in DB, most of id_customer in ps_address are changed between my file and the DB : I don't know why.

As it's a new install without customer, I can make same ID in my CSV for ps_customer (id_customer) and ps_address (id_address and id_customer).

 

 

Thanks

[shokinro]

 

 

 

As it's a new install without customer, I can make same ID in my CSV for ps_customer (id_customer) and ps_address (id_address and id_customer).

 

If that is the case, then you can use your SQL to update after import.