Importing Orders from Staging Server

  • Resolved lisabagg

    (@lisabagg)


    1 year, 8 months ago

    We recently migrated the theme on this site to a new one. When we did this, we copied the site over to the staging server to work on. When we pushed it live, we overwrote the existing orders that happened between the time we copied and the migration of the new theme.

    I have the orders listed in a backup file. But I am unsure how to import these into the new site.

    There were some new orders placed before we migrated the new theme over, which means that we have some duplicate order IDs, which are creating problems.

    My developer says: “When we started working on the staging website, we imported theme data, at that time new pages, images are imported which has certain post ids. At the same time live site there are some new orders placed, which also has new order ids [In mysql table orders are store in posts table only]. That’s why when we try to import the new orders, wordpress search those order ids in the database and if those orders don’t have the data in the table.”

    Any advice? Thank you!

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Saif

    (@babylon1999)

    Hello @lisabagg,

    Thank you for reaching out!

    I have the orders listed in a backup file. But I am unsure how to import these into the new site.

    This entirely depends on the type of backup file you have. You can try to adopt the following approach: first, identify the last order ID number currently on your website. Then, when importing the orders from the backup, replace the original order IDs with new ones generated sequentially. For instance, if the last order ID on your site is 449, you would import the orders with new IDs such as 550, 551, and so on.

    You might find it easier to use an import plugin like Import Export Suite for WooCommerce, rather than dealing with the database directly.

    I suggest you give it a try (we don’t offer trials but we have?a 30 day refund policy). If this extension turns out to be not what you were looking for,?please reach out to us via email?and we’ll be more than happy to help find alternatives. :?)


    Also to make sure things like this don’t happen, consider checking Jetpack backup. It integrates easily with WooCommerce so you don’t need to worry about deleted orders when restoring to a previous backup point.

    Let us know if you have any other questions.

Viewing 1 replies (of 1 total)
  • The topic ‘Importing Orders from Staging Server’ is closed to new replies.