WooCommerce Orders CSV to Dashboard
WooCommerce doesn't standardize its order export the way a hosted platform does, the exact column set depends on whether you use the built-in Analytics export, the Customer/Order/Coupon Export extension, or a third-party plugin. That's not a knock on WooCommerce, it's just the tradeoff of an open, self-hosted platform. The breakdowns below adapt to whatever header row your export actually has.
Step 1: Export Your Orders
The built-in path is Analytics → Orders → Advanced → Export, which downloads a CSV with fields like Order Number, Order Status, Order Date, and Order Total. If you use an export plugin instead, the labels may differ slightly, that's expected.
Step 2: Pick a Breakdown
Revenue by Order Status
Upload your export and Pivot Table opens pre-configured to sum Order Total by Order Status.
Revenue by Product
Open Pivot Table directly and pick your export's product/line-item column, header naming for this one varies too much across export plugins to preset reliably.
Deduplicate Customers
Catch near-duplicate customer records from slightly different name/email formatting.
Also Selling on Shopify? →
Same style of breakdown for Shopify order exports.
Frequently Asked Questions
Why do you say column names "vary" instead of listing exact ones?
WooCommerce's own export documentation explicitly warns against relying on fixed column order or naming, because the exact header row depends on which export path you use (core Analytics export, the Customer/Order/Coupon Export extension, or a third-party plugin) and which fields you've enabled. The presets below use the most commonly seen labels; if a field comes up empty after uploading, just re-pick it inside the pivot.
Does this require a WooCommerce REST API key?
No. Export orders as CSV from WooCommerce Analytics (Analytics → Orders → Advanced → Export) or your export plugin of choice, then upload the file here directly.
Need a custom breakdown?
Open Pivot Table directly and pick any rows, columns, and measures from your export.
Open Pivot TableTurn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.