moving customers from one store to another.

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

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.

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.