Export/Import Products – Issue with product IDs in orders

I am rebuilding a shop from scratch and am attempting to import the products from the current WooCommerce site onto the new one. I have tried to use the default WooCommerce “Export/Import” tools however, the product ID isn’t mapped onto the new products and WordPress is instead assigning a new unique ID. This is fine however, the orders which have also been imported are still referencing the original product ID’s which is not ideal.

I am also unable to update the references to the product ID in the database to match the original ID as new posts/revisions have been assigned these and doing so would cause conflicts.

What is the best way to proceed? Could I map the products to the orders using something other than the ID like the SKU?