Merge 2 Dbs

[Guest]

Hi,

 

Is there a way to merge 2 osCommerce 2.2 databases of thousands of customers and thousands of products?

 

I have 8 of the corresponding tables from each site saved in an excel csv file.

 

I have tried but only get one product to each new category folder so not too many products are being imported and most of the rest give blank files.

 

Any help is greatly appreciated.

 

Thanks!

[Guest]

When I had to change one DB to another (they were not the same fields) I saved each table I needed (the old and the new) into an excel format. Then copy and pasted the columns till I had them in the correct places and then saved the new file and uploaded it.

 

It was not a fun task but was possible. My advice is clear your day and turn the phone off. Then do it one column at a time.

[Guest]

Thanks but what about the different numbering of the products and customers . . . they overlap?

[Guest]

Lets take the customers table (just the first part)

 

customers_id   1
customers_gender   f
customers_firstname   Melinda
customers_lastname	Odon

 

Now you want to merge that record with a store of say 500 customers. So if in excel you would have a table with your headings

 

 

customers_id	  customers_gender 	customers_firstname 	customers_lastname

 

You would need to create another column (new customer_id)

 

customers_id new customer_id 	customers_gender 	customers_firstname 	customers_lastname

 

then use excel to add the 500 to the old customer_id table such as (b2=a2+500) and therefore the customer Melinda Odom would be customer 501.

 

Then figure out how that corresponds to the order numbers and do the same for those tables.

[Guest]

Now your old store had 500 customers, say those 500 customers placed 100 orders. If you look at the orders table

 

orders_id 	customers_id 	customers_name

 

In the store you are merging (the one with Melinda Odom) as the first and only customer placing 1 order it would look like

 

orders_id  1
customers_id  1
customers_name  Melinda Odom

 

So you would have to add to columns to your excel page (new orders_id and new_customers_id) and add 100 to the orders_id and 500 to the customers_id column. Then the orders will still reflect the correct customer .... hopefully. :-"

[♥yesudo]

Hi,

 

Is there a way to merge 2 osCommerce 2.2 databases of thousands of customers and thousands of products?

 

I have 8 of the corresponding tables from each site saved in an excel csv file.

 

I have tried but only get one product to each new category folder so not too many products are being imported and most of the rest give blank files.

 

Any help is greatly appreciated.

 

Thanks!

 

Maybe for the products - use easy-populate as that uses the model number as the unique id - not the product id.

 

So extract the products from both databases via easy-populate into a tab delimited spreadsheets - then combine the two spreadsheets (copy and paste) - then import into new db via easy-populate.

 

Cheers,

Emmett