Forums / General Questions / Import Customers+Orders Only

Import Customers+Orders Only

Locked

Views: 1,356

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
14 Jan 2008, 1:21 AM
#1
names avatar

names

New Zenner

Join Date:
May 2007
Location:
Oregon
Posts:
31
Plugin Contributions:
0

Import Customers+Orders Only

I have fully upgraded a local copy of my site from 1.3.7 to 1.3.8a

I would like to import any new orders/customers to the upgraded
local dbase before uploading the whole thing.

What fields do need to import?

TY

14 Jan 2008, 3:41 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Import Customers+Orders Only

All order?? and customer?? tables and if you have mods that added tables for either of these like Super orders those also

Zen-Venom Get Bitten

14 Jan 2008, 4:06 PM
#3
names avatar

names

New Zenner

Join Date:
May 2007
Location:
Oregon
Posts:
31
Plugin Contributions:
0

Re: Import Customers+Orders Only

What about

address_book
address_format

any others I might might miss?

Thanks again.......

3 Feb 2008, 3:38 AM
#4
fortune_cookie avatar

fortune_cookie

New Zenner

Join Date:
Jan 2008
Posts:
3
Plugin Contributions:
0

Re: Import Customers+Orders Only

thank you, thank you!

i imported the customers table and the customers_info tables over from as oscommerce/mysql4 -> zen/mysql5 and was having a bit of trouble.

i read your post and imported the address_book table and it fixed the problem.

i don't think you have to import address_format because it doesn't contain a customer_id field; i think we only need tables linked to customers (those w/ the customer_id field). :smile: