If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.2 to 1.3.x / Move customers and reviews only

Move customers and reviews only

Locked

Started by dlite on 16 Mar 2007, 8:57 PM · Views: 2,227

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
16 Mar 2007, 8:57 PM
#1
dlite avatar

dlite

New Zenner

Join Date:
Jan 2006
Posts:
5
Plugin Contributions:
0

Move customers and reviews only

Hi All,

I am just in the process of setting up a new store on a new host (version 1.3.7), I have an existing store(version 1.2.6) on a different host but wanted to do a clean install, except that I would like to bring across the customers.

I do not care about bringing across the order history just the customers themselves? How easy will these be to do? How do I do it? What SQL will I need ? I am hoping customers is a single table which hasn't changed between versions.

Will doing the same thing with reviews be possible, much harder I expect as it will link to product and customer tables at least, so I think I will skip this one.

I assume the best time to do any inserts into the database will be immediately after doing the install on the fresh server?

Thanks in Advance.

Michael

16 Mar 2007, 10:19 PM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Move customers and reviews only

Upgrading the database is the easiest part of an upgrade from 1.2.x to 1.3.x. Upgrading and retaining part of it ... much more difficult.

You have already hinted at one of the the problems with your strategy, namely that reviews are linked to products, so if you throuw away the products data, you render the reviews useless, unless you are going to manually re-link all the reviews to new product IDs, in which case why not just retain and upgrade the old product data, and then change it if it's no longer up to snuff.

Retaining the customer details is easier, but not a single table. In addition to the customer table, you would need the address_book table and probably the customer_info table as well.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

17 Mar 2007, 11:27 AM
#3
dlite avatar

dlite

New Zenner

Join Date:
Jan 2006
Posts:
5
Plugin Contributions:
0

Re: Move customers and reviews only

thanks kuroi, much appreciated.

If I copy the 3 customer tables you suggest is that sufficient to retain the customers alone.

Thanks

18 Mar 2007, 5:13 PM
#4
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Move customers and reviews only

It should be, though that doesn't negate the need to test!

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)