Orders are a Custom Post Type (CPT), so they are stored in the wp_posts table. If you search the post_type field for 'shop_order', ...
WooCommerce orders are a Custom Post Type so they're located in the wp_posts table. This contains information like: Example of order data ...
Orders live in the wp_posts table ( post_type = 'shop_order' ). More data is available by looking up the order's post_id in the wp_postmeta ...
This includes data, such as name, order history and billing address. WooCommerce uses a combination of both WordPress database tables and ...
...and any connected duplicated entries in other tables. UPDATE - I made this to achieve the above. NOTE a) Replace the following with your data: DB-NAME-HERE, ...
I would guess that linked products are stored in the database as a separate table and that is why they don't come over. If I was doing this, I would use a mysql ...
including the following rows store in the post meta table:.
Meaning the orders in WooCommerce are going to impact all other queries
Sort order of the bundled item relative to other items in the same bundle. The woocommerce_bundled_itemmeta table stores all bundled item options as meta data, ...
I'd recommend using MySQLWorkbench or the like to export to a CSV. http://stackoverflow.com/questions/17113812/how-to-export-table-data-in-mysql ...