An order export looks simple until the file opens badly in Excel. Check these points.
1. Filters
Date range and statuses.
2. Columns you choose
Customer, addresses, items, SKU, totals, coupons.
3. Per order or per item
Accounting needs one row per order; product analysis one row per item.
4. Excel-ready
UTF-8 with BOM, the right separator and decimal mark. See exporting to Excel.
5. Large stores
Orders read in batches, no timeout.
6. HPOS compatible
New WooCommerce stores use high-performance order storage.
A monthly routine
On the first day of the month, export the previous month’s processing and completed orders for your accountant. Read our monthly sales review.
Common mistakes
- Exporting all orders every time instead of a date range.
- Opening a comma file in a European Excel.
- Forgetting refunded orders in accounting.
Quick checklist
- Date and status filters
- Choice of columns
- Per order or per item
- Excel-ready file
- Batch processing
- HPOS compatible
Our option
Exportly ticks these boxes. See the demo.
Frequently asked questions
Why are accents broken in my CSV?
The file needs UTF-8 with BOM.
Can I export only completed orders?
Yes, with a status filter.
Does it work with HPOS?
Exportly does.