vzero Posted September 27, 2011 Share Posted September 27, 2011 Hello, I am working on updating the layout of a prestashop site during this process i am also updating the system to 1.4.x.x from 1.2.5. The migration is done on our testing server and we have everything very close to the way we want it. The issue is during this time a couple of orders of course have come in on our 1.2.5 live store. What I would like to do is: 1. Replace the 1.2.5 site with our updated 1.4.xx site 2. Migrate the new orders and customer over to the 1.4.xx install I can do it in phpmyadmin I am sure but don't know if the db changed dramatically between the 2 systems or all of the db fields I would have to move. Any help out there? Link to comment Share on other sites More sharing options...
vzero Posted October 5, 2011 Author Share Posted October 5, 2011 Any help on this? Seems like a pretty standard thing that would be needed. Link to comment Share on other sites More sharing options...
vzero Posted October 20, 2011 Author Share Posted October 20, 2011 Well I will press on This is what I am thinking of doing. 1. Turn the live site to catalog mode so no other orders come in 2. Download the db for the 1.25 live site then upgrade it using a local copy of 1.4 3. After upgrading go to the new 1.4 site and import the following tables from the live upgraded db using phpmyadmin ps_address ps_address_format ps_cart ps_customer ps_customer_group ps_customer_message ps_customer_thread ps_guest ps_message ps_orders ps_order_detail ps_order_history ps_order_message ps_order_message_lang ps_order_return ps_order_return_detail ps_order_return_state ps_order_return_state_lang ps_order_slip ps_order_slip_detail ps_order_state ps_order_state_lang Are there any I am missing or really don't need? Will this work without any real issues? Link to comment Share on other sites More sharing options...
Recommended Posts