Export orders

Download your orders as a spreadsheet (CSV) file you can open in Excel, Numbers or Google Sheets, or hand to your accountant.

Download your orders

1. Go to WooCommerce → Export orders
2. To export only some orders, fill in Ordered from and to. Leave both empty for every order
3. To export only some statuses, tick them under Statuses. Leave all unticked for every status
4. Select Download orders

The file holds customers’ names, addresses and emails. Keep it somewhere safe and delete it when you’re done.

What’s in the file

One row per order, in the order WooCommerce created them (by order ID):

• The order number, status, dates (in your site’s timezone) and currency
• The customer’s billing and shipping details, and their note
• How they paid
• The totals: subtotal, discounts, shipping, tax, the order total and the amount refunded
• Every product in the order, with its quantity, amounts and any add-on answers, plus the product’s SKU as it is today (empty if the product has since been deleted)
• Shipping, fees, tax lines and coupons
• Refunds and order notes
• A column for each of your checkout fields

Orders in the bin aren’t exported. Neither are checkout drafts, the unfinished carts WooCommerce saves while someone is still checking out.

How items are written

An order can hold several products, so the line_items column packs them into one cell:

name:Blue shirt|sku:BS-1|quantity:2|total:40;name:Cap|quantity:1|total:15

• Items are separated by ;
• An item’s details are separated by |
• Each detail is a name, a :, then its value

The shipping_items, fee_items, tax_items, coupon_items, refunds and order_notes columns work the same way. When a value itself contains |, ; or \, the file writes a \ before it.

Good to know

• Amounts are written as WooCommerce holds them, with a . as the decimal point and no currency symbol, so 40 and 40.00 can both appear
• A cell that starts with =, +, -, @, a tab or a line break and isn’t a number gets a ' in front, so a spreadsheet shows it as text instead of running it as a formula
• There’s no order import yet. To move orders between sites, ask your Dirigible developer