How to add data to database after migration and update

[Henrik41]

Hi There,

    I am migrating and updating prestashop from 1.7.1 -> 1.7.7 on my test server as well as changing the theme. All is good except that by the time I migrated and updated more data was added to the original server. I did not change the DNS yet.

   Data that was updated are only sales made and new customer added.

   Any suggestion on how I can add those data to the new server? What data is added in Prestashop when a new sale is made or a new customer is added? How do I handle the billings?

   Any suggestions are welcomed.

 

[SmartDataSoft]

Hello,  This is difficult to do manually, you need to use any paid module from PrestaShop addons to do that.  There are many table is related with it. custom, oders, oder details, invoice etc. So manually migration is difficult. You can do one things just export both table data and then compare . I think new migration didn't change any table structure. If structure is same. you can just point the old database , hope it will work

 

Thank you

[Henrik41]

Thanks. My strategy is to compare the 2 databases and just add the rows. Hopefully this will work

 

many thanks

 

 

[SmartDataSoft]

@Henrik41

 

Ignore the ps_connection and other table which is not associated with oder, product , invoice. as they are visitor record. If database is not much change other than oder, product you can try by point our old database. It may work.

Thank you