Post by snappyfish » Sat Oct 08, 2016 10:34 pm

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
Last edited by snappyfish on Sun Oct 09, 2016 12:29 am, edited 1 time in total.

Active Member

Posts

Joined
Thu Apr 14, 2011 4:36 am

Post by EvolveWebHosting » Sat Oct 08, 2016 11:59 pm

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.

Image
https://www.evolvewebhost.com
$10.49 .com Registration and $9.99 .com Transfers in now
Guaranteed top level opencart performance and support. Risk free 30 day money back guarantee & free transfers.
Image


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by artcore » Sun Oct 09, 2016 1:33 am

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.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands
Who is online

Users browsing this forum: No registered users and 56 guests