Fulfillments

Shipments and deliveries — fulfillment volume, carriers, tracking and delivery timing, one row per fulfillment.

30 fields — 19 dimensions, 11 metrics. Date clauses (SINCE, UNTIL, DURING) use createdAt.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM fulfillments
  SHOW orders_fulfilled
  GROUP BY status
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
`status`	string	dimension	Raw fulfillment status, such as success, cancelled or error.
`display_status`	string	dimension	Merchant-facing fulfillment status shown in the admin, such as Fulfilled, In transit or Delivered.
`shipment_status`	string	dimension	Carrier-reported shipment status, such as in_transit, out_for_delivery or delivered. Only present once the carrier reports movement.
`tracking_company`	string	dimension	Carrier handling the shipment, such as UPS, Canada Post or DHL.
`tracking_number`	string	dimension	Carrier tracking number for the shipment.
`service`	string	dimension	Service that fulfilled the order — manual, or a third-party fulfillment service.
`location_name`	string	dimension	Name of the location the fulfillment was shipped from.
`order_name`	string	dimension	Name of the order this fulfillment belongs to, e.g. #1001.
`fulfillment_name`	string	dimension	Name of the fulfillment itself, e.g. #1001.1.
`requires_shipping`	boolean	dimension	Whether the fulfilled items required physical shipping.
`created_at`	date	dimension	When the fulfillment was created — the moment the order was fulfilled. The dataset's default date field, so SINCE/UNTIL window on this.
`in_transit_at`	date	dimension	When the carrier first reported the shipment in transit.
`delivered_at`	date	dimension	When the carrier reported the shipment delivered.
`estimated_delivery_at`	date	dimension	Carrier's estimated delivery date, when one was provided.
`updated_at`	date	dimension	When the fulfillment record was last updated.
`fulfillment_event_days`	number	dimension	Whole days from the order's sale time to each metric's own event — fulfilled, shipped and delivered each bucket by their own timestamp. In other query shapes it measures order to fulfillment. Skips rows whose order dates are missing rather than counting them as same-day.
`orders_fulfilled`	number	metric	Number of orders fulfilled.
`orders_shipped`	number	metric	Number of orders whose fulfillment the carrier has reported in transit.
`orders_delivered`	number	metric	Number of orders whose fulfillment the carrier has reported delivered.
`orders_with_tracking`	number	metric	Number of fulfilled orders that carry a carrier tracking number.
`orders_with_tracking_included_rate`	percent	metric	Share of fulfilled orders that include carrier tracking.
`fulfillments`	number	metric	Number of fulfillment records — higher than Orders fulfilled when an order ships in several packages.
`total_quantity`	number	metric	Total units included in the fulfillments.
`median_hours_to_deliver`	number	metric	Median hours from fulfillment to delivery, across fulfillments the carrier has reported delivered.
`median_hours_order_to_fulfillment`	number	metric	Median hours from the order being placed to it being fulfilled. Only counts fulfillments that carry their order's placed-at.
`on_time_deliveries`	number	metric	Number of delivered orders that arrived on or before the carrier's estimated delivery date.
`on_time_rate`	percent	metric	Share of delivered orders that arrived on or before the estimated delivery date.
`store`	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.
`store_id`	string	dimension	The shop's raw identifier — what an export or the API reports. Same shops as Store, shown as ids.
`store_domain`	string	dimension	The shop's myshopify.com domain. Filter with WHERE store_domain = 'shop.myshopify.com'.