cancel
Showing results for 
Search instead for 
Did you mean: 

Import/Export Customer & Sales VIA SQL WITHOUT oveerwriting existing data

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Import/Export Customer & Sales VIA SQL WITHOUT oveerwriting existing data

Hello Magento World,

 

I have successfully exported from an old magento database all the mg_sales & mg_customer fields to transfer customers and orders over to my new database which has been running for a week and has had a few orders which I don't want to lose. Most of the Data is already in the new database but the new orders are not.

 

When I imported these tables (from old database to new) they completely overwritten the existing data thus overwriting the new orders.

 

I had to restore the database back but really need these orders moving over

 

Any help would be appreciated, I am unfamiliar with SQL so please go gentle.

 

Both sites running Magento CE 1.9.2.4

 

Chris.