I am trying to import/export orders from one WooCommerce website to another. After using the WordPress import/export tool for the "orders", the individual order page no longer shows the product(s) that were ordered for each invoice. When I view an individual order, the "Order Items" box is empty. Is there a way to fix this? Here is an image to show what I am talking about.
Since WooCommerce orders and products are actually custom post types, using that importing tool will only transfer limited amount of data.
To transfer the order details as well, you need to use phpMyAdmin to import the following two tables to your new site's database
You can try to move your orders automatically using
cart2cart. The process of migration is quite easy. You simply have to follow a step by step instruction. You will also have a possibility match order statuses, so they were the same as on your current store. Here are details. Nonetheless, it is a commercial tool but probably exactly what you are looking for.
All in all, you can try free demo migration to see how it works.