Migrating staging website precaution

  • Resolved Steve Szasz

    (@wpclinic)


    4 years, 5 months ago

    Hi all,

    I have a very important question for all that need to migrate a staging website to replace a live website.

    I made a copy of an original eCommerce website that uses Woocommerce. Since I made the copy and developed the staging site the original website has continued to make sales.

    My question is, how do I make sure I do not overwrite the sales data of the original website when I complete the migration of the staging site? I don’t want to import the sales data of the staging website because that data was taken when I made the original copy.

    Thank you in advance.

    Steve

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi Steve,

    Great question! This is quite tricky, as WooCommerce orders live in your _posts and _postmeta database tables, just like non-WooCommerce WordPress posts and pages. Therefore, you can’t just overwrite these tables to bring new content over from your staging site to your live site.

    I’d recommend leaving your live site database completely intact. You can then install the theme you developed on your staging site on your live site to bring over your new site design. Finally, manually recreate or import any new posts and pages you’ve created on the staging site onto the live site.

    This is a bit more manual work, but will ensure that you don’t lose any of the WooCommerce order data on your live site.

    If I can help answer any other questions about this please let me know!

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migrating staging website precaution’ is closed to new replies.