Magento Order & Customer History Importing From Live Site

We have a staging site ready to deploy to a live environment. The current live site is Magento version was 1.4.2, and the staging site is now 1.5.

We need to place the current live site (they are both hosted on same server) in ‘maintenance mode’, update all historical customer data, and move the staging server to the live site. We also need someone to transfer from live site to new live site.

However we need to make sure all order/customer/review/newsletter data is transferred from the live site across to the staging site, so we do not lose any history when we transfer.

We have set all products up etc.. so it is only historical customer/order data we need. All products, payment gateway details, shipping configuration, modules etc.. are all set up on the staging server – it is only this historical data we need (e.g. customer accounts, order / invoice / credit memo / shipment /transactions data, newsletter subscribers, reviews)

The staging site has been set up on a sub directory inside the main domain, the database will stay the same etc.. so we are hoping this is straight forward in terms of just moving the files outside of subdomain into the root.

This staging site will then be the ‘live’ site, with the fresh install / database we have set up. We need to make sure we do not lose anything when transferring over as order data & customer data is extremely important.

Realistically we would need to try and do this ‘out of hours’ here in the UK so if possible we could be do this between hours of 12 midnight to 9am. We are happy for you to test these out on the test server first as well to ensure all is correct.

So for example you could transfer say 99% of the data prior to switching the live site in ‘maintenance mode’, and then transfer across any remaining crossover data whilst the live site is down. We need to do this so that all orders/data processed on the live site is fully up to date on the staging site prior to transfer. This is very important.

Currently there are circa 1300 customers, 6000 orders, slightly less than orders for shipments / invoices (around 5100), credit memos 80, transactions 4500, newsletter 1100.

Please let me know you understand how to do this from 1.4 to a 1.5 integration, and how you will do this.

Leave a Reply

Your email address will not be published. Required fields are marked *