Help migrating from development to live site while saving order data

We have a WordPress site that is hosted by WP Engine and I have been trying to migrate our new development website to our live site, but need to make sure I keep all WooCommerce user and order data intact when I do so. I have currently been trying to nail this down using the staging and development environments, but keep running into issues one way or another when I migrate data.

I am currently using the WP Engine Site Migration plugin and I have tried excluding all database tables that are associated to WooCommerce. However, because portions of the orders are stored in custom post types in the wp_posts and wp_postmeta database tables, the orders are still overwritten by the development site. If I exclude the wp_posts and wp_postmeta databases all together, then the whole frontend of the site is broken and none of the pages come over….but the backend admin order page looks great.

I can use the WebToffee Order Export Import plugin to get order data after migration, but this is extremely time consuming. We have roughly 45k orders, and it took a couple hours to create the export file. Then it took about 20 mins to import just 1,000 orders. With the 45k orders, that’s approximately 15 hours plus the potential for errors to occur during import. I would like to avoid going this route if possible.

I have looked at countless other plugins to try to assist in this transition, but have had no luck in finding on that will do the job. I have also trying pulling specific tables from phpMyAdmin, but this is not a simple export/import process because you also have to redirect the path names to avoid errors and there have been file changes outside of database changes, only adding to the complication.

If there is a plugin that can simplify this process, I would love to try it! I am less experienced doing this manually, but if this is the only way and someone can point me in the right direction to guide to help that would be great!

Any help, or a tip to get me in the right direction at this point would be invaluable. I have been pulling my hair out trying to figure this out, so now it’s time to ask for a hand. Thank you!!

Josh

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