Multisite - an installation success story

[nsspyder]

The greatest part of the adventure is merging customers and orders. I did not merge products because one site has all of them. I use the product tables from that site.

My two basic tools for the merging process are PhpMyAdmin and EXCEL.

First, I assigned customer number ranges for customers and orders.
Site 1 had order numbers 1 to 1999999 and customers 1 to199999
site 2 orders 2000000 to 2999999 Cutomers from 200000 to 299999
etc

These number ranges are critical to aboid problems when mergin the tables.

First use the store manager function to set an order number higher than any you will be merging.

Ther are 7 tables to bring from old sites:
address_book
customers
customers_info
orders
orders_products
orders_status_history
orders_total

If you use attributes your will need the orders_attributes table also.

My method is to export to EXCEL with column headings.

Only for the first site, add two colums to the table structure. I called them w1 and w2. Dont't forget order_site on the orders table. It will stay when you are finished.

Using EXCEL, I copy the old order/address/customer columns to the work colums. Then enter the adjustment calculation into the orginal column.

Example for the custome table. Copy customer number and default address number to w1 and w2. Then in the customer column enter =w1+300000 and in the default address =w2+300000

I used w1 and w2 but you will use the actual column.row. Once it is calculatin the first one correctly, copy it to the whole column.

Make sure to change the page tab name in excel to match the table name in mysql if it is different.

Now save it, backup your DB and import it.

I'm starting tonight with the second site conversion.

I'm not sure how often I can check in here. You can ask questions. But, you may get a few "I don't know" or I don't remember" type answers. Remember, I'm 67 years old. So I figure that if I can do it, you can too.

Oh, and BTW, I speak fluent typo-nese and suffer from FFTS (fat finger typing syndrome) so, please, no comments about my errors.