We have upgraded a Magento website from 1.8.0 to the Magento ver. 188.8.131.52 and we have taken 2-3 days because website has a lot of the products and customer and it is making good amount of orders per day so our main issue was we can not down the production website for 2-3 days due to the traffics and number of orders, so we have decided to create a staging with the clone of the production website and we have upgraded the version here but the production was live and it has got good number of the orders and customers so client wants to keep these orders and customers in the upgraded version of the Magento, it was little bit hard for us but after doing some research on internet we have got the solution and here I am sharing it here, check the steps given below:
Step 1: Open The Production website database and identify the tables given below for the Customers:
Step 2: Now Export these tables but Disable foreign key checks as per the given screenshot.
Step 3: Now Open The Production website database and identify the tables given below for the Orders and Invoice:
Step 4:Now Export these tables by Disableing foreign key checks as per the given screenshot.
Step 5: Now Open the Upgraded Magento website and Identify these customer tables and rename / delete these tables and import your backup which you have taken from the production.
Step 6: Now Open the Upgraded Magento website and Identify these Orders and Invoice tables and rename / delete these tables and import your backup which you have taken from the production.
Now check the admin Panel and you will see all the updated orders and customer in the admin panel, hope that helps.
Note : it is only for the 1.7.2 to the higher version of the Magento it will not work with the below the Magento version of 1.7.2.
As you all aware of the Magento version Upgrade, why we need to upgrade the Magento version from old version to the upgraded version, Please here Why and How we can upgrade the Magento Version
Stay tuned for the Magento and Magento2 latest tutorial and updates, Hope you enjoyed reading, if you need the professional Magento Development we can help you, just Click on the Link and send me your requirements.