Analyze WooCommerce Order Export CSV Files
WooCommerce order exports contain your transaction history with columns for billing, shipping, line items, and payment details. The CSV structure varies based on your export plugin, but most include order metadata that needs cleaning before analysis.
Upload your WooCommerce order export and get clean product sales tables, refund summaries, and coupon usage counts without formulas or manual splitting.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| order_id |
| order_date |
| order_status |
| billing_email |
| billing_first_name |
| billing_last_name |
| shipping_method |
| order_total |
| order_subtotal |
| order_shipping |
| order_tax |
| payment_method |
| coupon_code |
| line_items |
Common questions
How do I analyze a WooCommerce order export CSV?
Import the WooCommerce order export CSV into a spreadsheet, then clean line_items by splitting product names and quantities. Filter out refund rows using order_status, normalize status codes like wc-completed to readable labels, and split multi-coupon fields to count usage accurately.
Why do some orders appear twice in my export?
Refunds create a second row with the same order_id but negative amounts. Filter by order_status to separate original orders from refunds, or use order_id with a status check when calculating totals.
How do I count sales for a product that has variations?
The line_items column contains 'T-Shirt - Blue - Large x1, T-Shirt - Red - Medium x2'. Split this cell by commas, then extract the base product name before the first dash. Group by that text to sum across variations.
Can I separate orders by shipping country?
Yes, use the shipping_country column. If it contains country codes like 'US' or 'GB', you may need a lookup table to convert them to full names for reports.
What does order_subtotal exclude that order_total includes?
order_subtotal is the product total before shipping, tax, and discounts. order_total adds shipping and tax, then subtracts coupon discounts. Check order_shipping, order_tax, and discount_total columns to reconcile the difference.
Why are some billing_email cells empty?
Guest checkouts or manual orders may not require an email. Some export plugins also place emails in a customer_email column instead. Check both columns and use a formula to combine them.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file