Keep WooCommerce Data Externally?

  • Hey folks,

    When I switched from Squarespace to WordPress for my website I was super excited by the idea of a staging site – somewhere I can design and develop with reckless abandon knowing that my live site is unaffected and I can just push all the changes to the live site when they’re ready. But then I installed WooCommerce and ran into a pretty annoying snag… If I do a bunch of development on a staging site and orders keep rolling in on my live site, when I ultimately want to push the staging to live those new orders that have come in will get erased by the list of orders that existed when I set up the staging environment… This kinda destroys most of the utility of a staging site in one fell swoop…

    So I guess my question has two parts:

    1. Am I missing something here? Is there a better way to deal with staging sites and WooCommerce orders and data?

    2. If no to 1., then is there some way to store WooCommerce data externally, so that it has its own database that will be unaffected when I push changes from staging to live?

    I hope that makes sense! Thanks in advance ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    Have you considered on;u pushing the relevant database tables from staging to live rather than the *whole* database? Essentially, this means that customer/order information remains unaffected even when the underlying design changes.

    For more options in the regard, have a look at the following plugin: https://deliciousbrains.com/wp-migrate-db-pro/

    Another option would be to export a list of orders/customers/products from the live site to a CSV file, push staging to live, and then reimport the CSV file with “new” orders again.

    Thread Starter elphnt

    (@elphnt)

    Hey RK, thanks for the suggestion. Migrate DB Pro looks handy, I’ll definitely have to check that out. I had definitely considered the CSV method, was just hoping there’d be something a little less laborious, but Migrate DB Pro might just be that! Thanks for the tip ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Keep WooCommerce Data Externally?’ is closed to new replies.