Forums / Upgrading from 1.3.x to 1.3.9 / Importing Customer Accounts from 1.3.7 - 1.3.8

Importing Customer Accounts from 1.3.7 - 1.3.8

Locked

Started by bignath on 11 May 2009, 3:08 PM · Views: 1,452

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
11 May 2009, 3:08 PM
#1
bignath avatar

bignath

New Zenner

Join Date:
Feb 2007
Posts:
43
Plugin Contributions:
0

Importing Customer Accounts from 1.3.7 - 1.3.8

Hi There
I have recently built a fresh 1.3.8 site and now I need to import my live customer accounts (and their details) over into the 1.3.8 db.

Now I have backed up and copied the live 1.3.7 db and run an upgrade on this to bring it in line with 1.3.8.

How do I import customer account and login details into the new 1.3.8 site as we have over 5000 customers and I obviously don't want them to have to create a new account when they visit the new version of the site.

In particular what db fields do I need to import through MySql.

Many Thanks in advance

11 May 2009, 3:25 PM
#2
qdixon avatar

qdixon

Support Team

Join Date:
Feb 2004
Location:
Simcoe, Ontario, Canada
Posts:
1,906
Plugin Contributions:
1

Re: Importing Customer Accounts from 1.3.7 - 1.3.8

It doesn't work that way. When you upgrade your 1.3.7 database to 1.3.8 you will simply use that same database. Nothing really changes for your customers and no importing of customers details are needed. There are a few altered tables and a few new ones for added features and bug & security fixes.

Windows, BSD, Linux, Cisco, Hardware & IT Security Tech
AEIIA - Zen Cart Certified & PCI Compliant Hosting

12 May 2009, 12:13 PM
#3
bignath avatar

bignath

New Zenner

Join Date:
Feb 2007
Posts:
43
Plugin Contributions:
0

Re: Importing Customer Accounts from 1.3.7 - 1.3.8

Hi Qdixon
Thanks for the reply!

Is there any way at all that I can import the customer accounts from the live 1.3.7a into my new fresh 1.3.8a version?

The reason being is that I have built a new site from scratch as the live site at present does not use template overrides etc and the site got quite messy. The new test site has new products and info and features etc - I just need to get the customer details over into this site so they dont have to create a new account when they visit the new site when it goes live - (next week - eeek!)

Thanks

12 May 2009, 12:30 PM
#4
qdixon avatar

qdixon

Support Team

Join Date:
Feb 2004
Location:
Simcoe, Ontario, Canada
Posts:
1,906
Plugin Contributions:
1

Re: Importing Customer Accounts from 1.3.7 - 1.3.8

It is much easier to upgrade what you have rather than transfer data.

Customer data is linked to a few other tables for account info like purchases etc. Don't get me wrong it can be done...but that can cascade into a mess.

Template overrides wont change anything in the database...only the override or template name that it is using and that can be changed of course.

What I would do it open the admins side by side and just run though the settings matching them if that is the worry.

Windows, BSD, Linux, Cisco, Hardware & IT Security Tech
AEIIA - Zen Cart Certified & PCI Compliant Hosting