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', SQL will ...
This includes data, such as name, order history and billing address. WooCommerce uses a combination of both WordPress database tables ...
If you have PHPMyAdmin try and find the data your looking for.
select. p.ID as order_id,. p.post_date,. max( CASE WHEN pm.meta_key = ' _billing_email' and p.ID = pm.post_id THEN pm.meta_value END ) as billing_email,.
Recently, for a client site, I needed to export WooCommerce information about customers, their orders and the products that they had bought so ...
Fixed query select p.ID as order_id, p.post_date, i.order_item_name, max( CASE WHEN im.meta_key = '_product_id' and i.order_item_id = im.order_item_id ...
What is the best way to move WooCommerce orders between sites while keeping the order number the same between them? In reality, this is ...
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.
Another option is PHPMyAdmin. I haven't used it to export to CSV but it may prove useful. Check with your host for how to connect. Good luck!
To export the orders from your existing WooCommerce store to a CSV or XML file , go to the admin side of the website. From the WordPress dashboard, navigate to ...