Here's an example post on exporting orders using a SQL query. However, you'll need SQL access on your server (not always available ...
For example: “How many orders have I had for a certain product?
Automatically export and send your file to a remote server via FTP, HTTP ... When you begin a bulk export or export items from the Orders or Users lists, ...
I managed to work this out by trial and error. Here's the query that worked in the end: select p.order_id, p.order_item_id, p.order_item_name, ...
I'm trying to obtain all orders for particular day/time and then order products using SQL (MySQL) as seen in the query below: select p.ID as order_id, p.post_date, ...
Also, WC needs to store the price at the time of the order as the customer may have had a discount or the product price may have changed.
A client of mine has a rather large WooCommerce database. We've been trying to run reports using the WooCommerce Customer/Order CSV Export plugin
Using "completed" order status for paid orders is correct. Here is a custom function with a SQL query, that will output an formatted array of User ...
http ://codecharismatic.com/sql-script-to-get-all-woocommerce-orders-
Need a convenient place to backup your sales data? This integration will automatically save new orders from WooCommerce to a new row in SQL Server, giving ...