Migrate WooCommerce Orders [closed]

The reason copying those messed up your site was probably because of id mismatches. That is, posts with the ids of the stuff you’re importing already exists.

Regardless, since woocommerce stores orders as a custom post type, your safest bet here is probably the built in wordpress post import/export tool.
1. In the wordpress backend for the old site select Tools->Export
2. Choose “Orders”
3. Download the export file.
4. In the wordpress backend for the new site select Tools->Import
5. Click “WordPress” (install the plugin if you need to).
6. Choose/Upload the file you created in step 3.

If you need to do this through SQL for some reason, the place to start will be with

SELECT * from wp_posts WHERE post_type="shop_order"
Then you’ll need to export the result of that query and increment all of the IDs by whatever the auto increment value is on the new table. But that will give you a pretty messy table…