Exporting Orders

The Orders export gets your orders out of Shopify as a CSV or Excel file — one order per group of rows, with every line item, tax line, and refund you choose to include. It spans all your connected stores at once, so you can pull a single spreadsheet of orders across every shop, or narrow it to one. For the builder itself — column picker, formats, destinations, schedules — see the exporting overview.

If you've exported orders from Shopify admin before, the Shopify Standard template gives you the familiar column names out of the box.

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 order number customers see, e.g. #1001.
Email	Contact email on the order.
Created At	When the order was placed.
Currency	Store currency for the order (ISO 4217).
Financial Status	Payment status — paid, pending, refunded, and so on.
Fulfillment Status	How far fulfillment has progressed (fulfilled, partial).
Total	Order total before returns, including taxes and discounts.
Current Total	Order total after returns.
Subtotal / Total Discounts / Total Shipping / Taxes: Total	The money breakdown for the order.
Paid At / Fulfilled At	Derived dates for when payment was captured and the first shipment was created.
Tags, Note, Purchase Order Number	Merchant fields on the order.
Shipping / Billing address	Name, company, street, city, province, country, zip, phone.
Discount Codes / Shipping Methods / Payment Gateway Names	Combined lists of codes, rates, and gateways on the order.
Customer: Email / Name / Tags / Total Spent	Profile fields for the customer linked to the order.
Store	Which connected store the order belongs to.

Switch to Template (Advanced) mode to open the full nested column tree — individual line items, per-line tax lines, refunds, transactions, fulfillments, metafields, and timeline events — and to rename column headers.

One row per line item

An order almost always has several line items, so the export expands to multiple rows: one row per line item, with the order-level fields (number, email, status, dates, addresses, totals) repeated on each row. This is the same shape the Orders import expects, so an export can round-trip back in.

If you include refund columns (Refunds. paths), rows expand one row per refund as well; the same applies to transaction, fulfillment, metafield, and event columns. When more than one of these is selected, the number of rows for an order is the largest of the counts, and each column fills down its own list. The Row # and Top Row columns mark where each order begins so the file stays readable in Excel.

Filtering what you export

Add a filter to narrow the export to a slice of your orders. The Orders filter offers common slices:

• Store — one shop, or leave it open for all connected stores.
• Date created — a date range for when orders were placed.
• Order status — open, archived, or cancelled.
• Payment status — paid, pending, voided, or unpaid.
• Fulfillment status — fulfilled, partially fulfilled, or unfulfilled.
• Order total — a money threshold.
• Tags and product in the order (line-item title).

The filter you set in the wizard is part of the export and is independent of whatever filter you last used on the Orders dashboard.

Exporting from the dashboard vs the wizard

The 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 orders across your stores. The full Export Wizard is the place to combine Orders with other entities in one run, or to save the export on a schedule.

Scheduling

Any 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 how schedules work.

Tutorial: export last month's paid orders to Excel

1. Go to Exports → New export (/exports/new) and, in Step 1, tick Orders.
2. In Step 2, keep Simple columns and apply the Shopify Standard template (or pick your own columns).
3. Add a filter: set Payment status to Paid and Date created to last month's range. Add a Store filter if you only want one shop.
4. In Step 3, choose Excel (.xlsx) and set the destination to Email.
5. In Step 4, name the export and choose Run now.
6. When the file is ready you'll get an in-app notification; open the Excel file to see one row per line item with the order fields repeated.

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 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 order? Orders expand to one row per line item, with the order-level fields repeated on each row. Refund, transaction, and fulfillment columns expand the same way.

Does the export include refunds and taxes? Yes — refund and tax columns are available. In Simple mode you get order-level totals and up to five tax lines; in Template mode you can expand per-refund and per-line-item detail.

Can I export 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 an orders export? Yes — save it as a daily, weekly, or monthly schedule; each run rebuilds from live data.

Will the file re-import into EcomSolo? Yes — the one-row-per-line-item shape matches the Orders import, and matching is by order Name.