Woocommerce Export/Import Staging Issue

Hi I am on the latest version of woocommerce and everything is up to date. I am using a staging environment to be able to make changes to my e-commerce site and test them before making them live. However, while I am in staging my live site continues to get orders and unfortunately orders are posted to the posts and postmeta tables which are the same DB tables for pages where I am making the changes.

Therefore, what I am trying to do is export out the orders using the wordpress export orders, then move the staging site to live and then use the wordpress tools importer and re-import the orders. This process seems to be correct, however when I import the order the order #, customer, address, email and everything seems to be imported correctly except what product the customer actually ordered. Here is a screenshot of the table showing empty “Purchased” column.

I have looked into other plugins to handle this via csv but I feel this can be accomplished without those? I have also tried exporting and importing “all content” assuming that maybe those are done in another wp_ table but that did not work as well. Is anyone else facing this problem or is there something else I should try or a different import/export plugin? I have tried doing different import settings by assigning the import content to different users and that didn’t work either. Thank you all for your help.