Exporting Fulfillments
Export your fulfillments — the shipments that mark order line items as sent — to a CSV or Excel file, across one store or all your connected stores at once. It's the quickest way to get a shipping and tracking log out of Shopify: which order, from which location, with which carrier and tracking number, and when.
For the wizard itself — picking columns, formats, destinations, and schedules — see the exporting overview.
What you can export
In Simple mode you pick from a curated list of the fields merchants export most. The default set mirrors the Fulfillments dashboard; these are the most useful fields:
| Field | What it is |
|---|---|
Order | The order name this fulfillment belongs to (e.g. #1001). |
Status | Human-readable fulfillment status (Fulfilled, In transit, Delivered). |
Shipment Status | Carrier shipment milestone (in_transit, delivered, …). |
Location | The location the fulfillment was processed at. |
Total Qty | Sum of all fulfilled line-item quantities. |
Tracking Company | The carrier name. |
Tracking Number | The primary tracking number. |
Tracking URL | The customer-visible tracking URL. |
Delivered At | When the shipment was delivered. |
Estimated Delivery At | The estimated delivery date. |
Created At | When the fulfillment was created. |
Updated At | When it was last modified. |
Items | Count of fulfilled line items (a single-row summary). |
Store | The store the fulfillment belongs to. |
The export can also pull fields from the parent Order (email, financial and fulfillment status, total, currency, created date), and Custom digest columns that fold every line item and all tracking numbers/URLs onto a single row. Switch to Template (Advanced) mode for the full column tree.
One row per line item
Each fulfillment can carry several line items. As soon as you include any line-item column (title, SKU, name, fulfilled quantity, variant, vendor, product/variant IDs), the export expands to one row per fulfilled line item, with the fulfillment-level fields (order, status, location, tracking) repeated on each row. Without line-item columns it's one row per fulfillment — use the Items count or Line Items Summary custom column for a single-row view.
Filtering what you export
You can narrow a fulfillments export to a common slice:
- Store — one store, several, or all of them.
- Order — a specific order name.
- Status — Success, Cancelled, Error, Failure, Open, or Pending.
- Location — the location that processed the fulfillment.
- Tracking company — a specific carrier.
- Created At / Updated At — a date range.
The filter you set on an export in the wizard is part of that export and is independent of whatever filter you last used on the dashboard.
Exporting from the dashboard vs the wizard
From the Fulfillments dashboard, the Export button (the Export Builder) is the quick path — it exports exactly what you're looking at, scoped to Current page, Filtered, Selected, or All fulfillments across your stores. Use the Export Wizard (Exports → New export) when you want to combine fulfillments with other entities in one run, or save the export on a schedule.
Scheduling
Any fulfillments export can run on a recurring daily, weekly, or monthly schedule instead of once — useful for a standing shipping log. See scheduled exports.
Tutorial: export a tracking log with one row per shipped item
- Go to Exports → New export (
/exports/new). - In Step 1, tick Fulfillments and click Next.
- In Step 2, keep the default Simple columns (Order, Status, Location, Tracking Company, Tracking Number are included), then open the Line Items section and tick Title, SKU, and Fulfilled Qty to expand to one row per item.
- Add a Created At filter for the date range you want.
- In Step 3, choose Excel (or CSV) and a destination, then click Next.
- In Step 4, name it "Shipping log", choose Run now, and download the file.
Permissions
- View Exports (
viewExports) — build and run fulfillment exports. - Download Exports (
downloadExports) — download the finished file.
Account owners have both. Grant them to team members from their permissions.
FAQ
Can I export fulfillments to Excel? Yes — choose CSV or Excel (.xlsx) in
Step 3. A combined multi-entity workbook is always Excel.
Does the export include tracking numbers? Yes — Tracking Company, Tracking Number, and Tracking URL are all Simple columns; a Custom column also joins all tracking numbers onto one row.
Why does one fulfillment span several rows? When you include line-item columns, the export expands to one row per fulfilled line item, repeating the fulfillment fields on each row. Without them it's one row per fulfillment.
Can I include order details on each row? Yes — the Order section pulls the parent order's email, status, total, and currency, resolved by each row's order ID.
Can I export fulfillments from all my stores at once? Yes — an export spans every connected store by default; add a store filter to narrow it.
Can I schedule the export? Yes — save it as a daily, weekly, or monthly schedule and each run rebuilds from live data.