Page 1 of 1
moving customers from one store to another.
Posted: Sat Oct 08, 2016 10:34 pm
by snappyfish
Hi,
I have a 1.5.x store running with a few thousand customers, I am in process of merging my two websites into one, and wish to take all customer details from the 1.5.x store to a new 2.3.0.2 store.
what's the best way to handle this in terms of keeping customer details etc?
Thanks
Re: moving customers from one store to another.
Posted: Sat Oct 08, 2016 11:59 pm
by EvolveWebHosting
snappyfish wrote:Hi,
I have a 1.5.x store running with a few thousand customers, I am in process of merging my websites into one, and wish to take all customer details from the 1.5.x store to a new 2.3.0.2 strore.
what's the best way to handle this in terms of keeping customer details etc?
Thanks
You can export / import the `customer` and `address` tables. Double check the structure of each but I don't think they've changed.
Re: moving customers from one store to another.
Posted: Sun Oct 09, 2016 1:33 am
by artcore
They changed quite a bit with new columns and for custom fields from serialized encoded data to json_encoded.
Also don't forget about customer_groups.
If you want to merge data make sure the references stay intact. So all primary keys link to the correct customer, address, language and customer group. If you also want to import/merge orders and products this can be a daunting task
In other words, if you were to import a new customer from shop A that has an existing ID in the new shop, make sure it doesn't overwrite the existing one. Same for the other dependant tables.