Fulfillments

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

28 fields — 17 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 being placed to this fulfillment being created. Skips fulfillments whose order date is 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.