We currently have two stores one for retail and one for wholesale. We set this up due to the some needs a few years back. But we are wanting to merge the two and upgrade to 1.3.9 from 1.3.7.1.

I have set up a fresh install and working on it and putting in the modules we want included dual pricing and a number of new module plus some of the module that we are currently using in the current stores. *Note not all of the current modules are being installed as we have not used them etc.

Now here comes my questions. I want upgrade the retail store and preserve all this data plus I want merge the customer and order details of the wholesale store. The problem is that the wholesale store didn't have all of the products that the retail store had.

But we want to preserve the customers from both databases and the orders associated with all customers. We have almost 5000 orders in the retail stores and only 400 in the wholesale store.

So what is the best way to upgrade the databases and to merge the customer and order data from wholesale to the new database as well as the retail data. We want to use Sales report and have this data accurate once everything is combined!

Thanks in Advance.