Exporting Draft Orders
The Draft Orders export gets your draft orders out of Shopify as a CSV or Excel file — the draft's customer, status, totals, and every line item you choose to include. It spans all your connected stores at once, so you can review open quotes and invoices across every shop, or narrow it to one. For the builder itself — column picker, formats, destinations, schedules — see the exporting overview.
What you can export
In Simple mode you pick from a curated list of the fields merchants export most. These are the key ones:
| Field | What it is |
|---|---|
| Name | The draft order identifier, e.g. #D123. |
| The customer email the invoice is sent to. | |
| Status | The draft order status (open, completed, invoice sent). |
| Customer Name | The customer the draft is for. |
| Price: Total | Total price, including taxes, shipping, and discounts. |
| Price: Subtotal / Discount / Shipping / Taxes: Total | The money breakdown for the draft. |
| Currency | The shop currency used for the draft. |
| Tags, Notes, PO Number | Merchant fields on the draft. |
| Invoice URL / Invoice Sent At | The checkout link and when it was last emailed. |
| Created At / Updated At / Completed At | Draft lifecycle dates. |
| Line items | Item name, quantity, price, SKU, and per-line taxes. |
| Company (B2B) | Purchasing company, location, and contact. |
| Shipping / Billing address | Name, company, street, city, province, country, zip, phone. |
| Store | Which connected store the draft belongs to. |
Switch to Template (Advanced) mode to open the full nested column tree — per-line-item variant and product detail, order-level tax lines, metafields, and timeline events — and to rename column headers.
One row per line item
A draft order usually has several line items, so the export expands to multiple rows: one row per line item, with the draft-level fields (name, customer, status, totals, addresses) repeated on each row. The Row # and Top Row columns mark the first row of each draft — the row that carries the order-level fields — so the file stays readable in Excel.
If you include metafield or event columns, those expand as additional rows too; the number of rows for a draft is the largest of the selected counts.
Filtering what you export
Add a filter to narrow the export to a slice of your draft orders:
- Store — one shop, or leave it open for all connected stores.
- Date created — a date range for when drafts were created.
- Email — the customer email on the draft.
- Total — a money threshold.
- Line items count — how many line items the draft has.
- Tags.
The filter you set in the wizard is part of the export and is independent of whatever filter you last used on the Draft Orders dashboard.
Exporting from the dashboard vs the wizard
The Draft Orders dashboard has an Export button (the Export Builder) for a quick single-entity export scoped to what you're looking at — Current page, Filtered (everything matching your dashboard filters), Selected (only ticked rows), or All draft orders across your stores. The full Export Wizard is the place to combine Draft Orders with other entities in one run, or to save the export on a schedule.
Scheduling
Any draft orders export can run on a recurring daily, weekly, or monthly schedule, rebuilding from live data each time and delivering to your destination. See the exporting overview for details.
Tutorial: export open draft orders with their line items
- Go to Exports → New export (
/exports/new) and, in Step 1, tick Draft Orders. - In Step 2, keep Simple columns. Add the Line Items columns you want — for example Item Name, Item Quantity, Item Price, and Item Sku.
- Add a filter: set Store to the shop you want, and a Date created range if needed.
- In Step 3, choose Excel (
.xlsx) and set the destination to Email. - In Step 4, name the export and choose Run now.
- Open the file — one row per line item, with the draft fields repeated on the top row of each draft.
Permissions
- View Exports (
viewExports) — build the export and configure columns. - Download Exports (
downloadExports) — download the finished file.
Account owners have both. Grant them to team members from their permissions.
FAQ
Can I export Shopify draft orders to Excel? Yes — choose Excel (.xlsx) in
Step 3 (or CSV). A combined multi-entity workbook is always Excel.
Why does my export have several rows for one draft? Draft orders expand to one row per line item, with the draft-level fields repeated on each row.
Does the export include line-item and order taxes? Yes — per-line tax columns are in the Line Items section, and up to five order-level tax lines are available in Template mode.
Does it cover B2B drafts? Yes — the Company (B2B) section exposes the purchasing company, location, and contact.
Can I export draft orders from all my stores at once? Yes — an export spans every connected store by default. Add a Store filter to narrow it to one.
Can I schedule a draft orders export? Yes — save it as a daily, weekly, or monthly schedule; each run rebuilds from live data.