Reputation: 1060
I have a live WordPress website which is based on WooCommerce, now I have another website (uploaded on QA Server) which is updated version of live site, Some extra plugins also installed in it.
Now I have to replace live site with Updated version of it which is uploaded on QA Server, plus I have to save all transactions of live site (so replacing database is not a good option).
What to do?
Upvotes: 0
Views: 74
Reputation: 26329
My favorite tool for migrating WP databases is: WP Migrate DB Pro
But the answer largely depends on what you've updated on the testing site. Using the above plugin you could pull all the database tables except wp_posts
and wp_postmeta
and that should get you any new options you've configured with your new plugins without overwriting your Orders.
Granted this means you would you not automatically pull in any new pages/posts/products, etc either. But for that could use the Import method described in sanki's answer.
Upvotes: 0
Reputation: 2275
Then hit "Download Export File" button. You'll get an xml file as download.
Now move on to the LIVE site,login to admin panel.
Transactions will be imported on the live site.
Upvotes: 0