Recommendations for "importing" orders that occurred while developing new version of site

Scenario: Our client currently has a nopCommerce 3.5 website. I recently upgraded it to 3.9, at a different "test"/"staging" server. We'll need some time to perform a redesign and also set up the various plugins again (e.g. payment, shipping).

So, by the time those other tasks are completed, there will be a whole slew of new orders that have occurred on the live 3.5 site.

Any recommendation on the best way to import the "Delta"/changes to the database that occurred on the 3.5 site, when we're ready to launch the 3.9 instead?

For example, will the the Export function in Admin / Orders do the job? (For one thing, I'm worried about a conflict of record Ids if ANY test orders are placed on the test site).

Or should I bite the bullet and use T-SQL copy/insert data?

After you get all the redesign done on your 3.9 test/staging site, I'd look into deploying that codeset back onto your 3.5 production site.  If that isn't an option, then I'd go the SQL route so that you have full control.  This would also give you an opportunity to remove any test records from the database.

Sorry, but I'm not quite sure what you mean by "code set." If you mean files that have changed, that's not really what I'm concerned about. I'm only concerned about changes to the database (e.g. changes to Store Settings, Shipping and payment methods).

Hi guys,

I have a similar problem.

I would like to import data (customers and orders only) from my old database (running on a live site on Nopcommerce 3.2) to the new database (running on a test site on Nopcommerce 4.0). I decided to download the old database and run the upgrade scripts to Nopcommerce 4.0. I have tried to use the import data function in SQL Server but it's giving me errors.

Ideally, I would replace the new database with the old database but I have already made major changes to the new database on the test site, that's why I only want to update the customers and order table. Can you please advise me on how to import the data successfully? Please help.