Choose a version:

fulfillments

The fulfillments schema captures fulfillment, shipping, and delivery timing after orders move through fulfillment events. It supports operational duration reporting and shipped-or-fulfilled order counts across carriers, providers, and locations.

Anchor to Use casesUse cases

Timing by carrier: Compare median_hours_order_to_fulfillment, median_hours_order_to_shipping, and median_hours_order_to_delivery by shipping_carrier to see which carriers move orders fastest.
Fulfilled volume: Group orders_fulfilled by fulfillment_provider or inventory_location_id to see which locations and providers handle your volume.
Cross-country delivery: Use fulfillment_origin_country with median_days_shipping_to_delivery to see how long cross-border shipments take to arrive.
Timing distribution: Filter order_to_fulfillment_hours or fulfillment_to_shipping_hours buckets when building timing distributions.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

FROM fulfillments

SHOW orders_fulfilled, orders_shipped, orders_delivered,

median_days_order_to_fulfillment, median_days_order_to_shipping,

median_days_order_to_delivery, orders_delivered_fast_rate

TIMESERIES week

DURING this_quarter

COMPARE TO previous_period

ORDER BY week ASC

VISUALIZE median_days_order_to_delivery TYPE stacked_area

Examples

Description

Track weekly [`median_days_order_to_delivery`](#fulfillmentsmetric-propertydetail-mediandaysordertodelivery) this quarter, with the fulfillment and shipping stages behind it. This example charts only `median_days_order_to_delivery`, while the per-stage medians come back as table columns beside it.

ShopifyQL

FROM fulfillments
  SHOW orders_fulfilled, orders_shipped, orders_delivered,
    median_days_order_to_fulfillment, median_days_order_to_shipping,
    median_days_order_to_delivery, orders_delivered_fast_rate
  TIMESERIES week
  DURING this_quarter
  COMPARE TO previous_period
  ORDER BY week ASC
VISUALIZE median_days_order_to_delivery TYPE stacked_area

Description

Rank carrier-and-origin-country lanes by `median_days_order_to_delivery` this quarter, fastest first. This example uses [`HAVING`](/docs/api/shopifyql/latest/syntax/having) `orders_delivered > 25` to drop thin lanes from the speed ranking.

ShopifyQL

FROM fulfillments
  SHOW orders_fulfilled, orders_delivered, median_days_order_to_delivery,
    orders_delivered_fast_rate, orders_with_tracking_included_rate
  GROUP BY shipping_carrier, fulfillment_origin_country WITH TOTALS
  HAVING orders_delivered > 25
  DURING this_quarter
  ORDER BY median_days_order_to_delivery ASC
  LIMIT 50
VISUALIZE median_days_order_to_delivery TYPE horizontal_grouped_bar

Description
Track weekly median hours from order to fulfillment this quarter, with the fulfillment-to-shipping and order-to-shipping stages behind it. This example uses [`WITH PERCENT_CHANGE`](/docs/api/shopifyql/latest/syntax/with#percent-change-columns) with [`COMPARE TO previous_period`](/docs/api/shopifyql/latest/syntax/compare-to) to show how each stage moved from the quarter before.
ShopifyQL
```
FROM fulfillments
  SHOW median_hours_order_to_fulfillment, median_hours_fulfillment_to_shipping,
    median_hours_order_to_shipping
  TIMESERIES week WITH PERCENT_CHANGE
  DURING this_quarter
  COMPARE TO previous_period
  ORDER BY week ASC
VISUALIZE median_hours_order_to_fulfillment TYPE line
```
Description
Rank the 10 `fulfillment_provider` values with the highest `median_hours_order_to_fulfillment` last month. This example pairs [`ORDER BY`](/docs/api/shopifyql/latest/syntax/order-by) `median_hours_order_to_fulfillment DESC` with `LIMIT 10`, so the sort decides which 10 providers survive the cut.
ShopifyQL
```
FROM fulfillments
  SHOW median_hours_order_to_fulfillment
  GROUP BY fulfillment_provider WITH TOTALS
  DURING last_month
  ORDER BY median_hours_order_to_fulfillment DESC
  LIMIT 10
VISUALIZE median_hours_order_to_fulfillment TYPE horizontal_bar
```

Anchor to MetricsMetrics

Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.

Metrics you can use when querying FROM fulfillments.

Anchor to median_days_fulfillment_to_shipping median_days_fulfillment_to_shipping: The middle number of days from fulfillment to the shipping handoff for shipped orders in your results.
Anchor to median_days_order_to_delivery median_days_order_to_delivery: The middle number of days from order placement to delivery for delivered orders in your results.
Anchor to median_days_order_to_fulfillment median_days_order_to_fulfillment: The middle number of days from order placement to fulfillment for fulfilled orders in your results.
Anchor to median_days_order_to_shipping median_days_order_to_shipping: The middle number of days from order placement to the shipping handoff for shipped orders in your results.
Anchor to median_days_shipping_to_delivery median_days_shipping_to_delivery: The middle number of days from the shipping handoff to delivery for delivered orders in your results.
Anchor to median_hours_fulfillment_to_shipping median_hours_fulfillment_to_shipping: The middle number of hours from fulfillment to the shipping handoff for shipped orders in your results.
Anchor to median_hours_order_to_delivery median_hours_order_to_delivery: The middle number of hours from order placement to delivery for delivered orders in your results.
Anchor to median_hours_order_to_fulfillment median_hours_order_to_fulfillment: The middle number of hours from order placement to fulfillment for fulfilled orders in your results.
Anchor to median_hours_order_to_shipping median_hours_order_to_shipping: The middle number of hours from order placement to the shipping handoff for shipped orders in your results.
Anchor to median_hours_shipping_to_delivery median_hours_shipping_to_delivery: The middle number of hours from the shipping handoff to delivery for delivered orders in your results.
Anchor to orders_delivered orders_delivered: Counts each order one time when it's delivered, even if the order has more than one delivery event.
Anchor to orders_delivered_fast_rate orders_delivered_fast_rate: The percentage of delivered orders that reached delivery within five days.
Anchor to orders_fulfilled orders_fulfilled: Counts each order one time when it's fulfilled, even if the order has more than one fulfillment event.
Anchor to orders_shipped orders_shipped: The number of unique orders that reached the shipping handoff in your results.
Anchor to orders_shipped_fast_rate orders_shipped_fast_rate: The percentage of shipped orders handed off and scanned by the carrier within 36 hours.
Anchor to orders_with_tracking_included_rate orders_with_tracking_included_rate: The percentage of fulfilled orders that included a valid tracking number and carrier information.

DAY_DURATION

A duration measured in days.

HOUR_DURATION

A duration measured in hours.

INTEGER

A whole number without decimal places, used for counts, quantities, and other discrete numeric values.

PERCENT

A percentage value represented as a decimal, where 0.25 represents 25%.

Anchor to DimensionsDimensions

Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns.

Dimensions you can use when querying FROM fulfillments.

Anchor to day day: The day a fulfillment event happened.
Anchor to day_of_week day_of_week: The day of the week a fulfillment event happened, with values Monday through Sunday.
Anchor to fulfillment_event_days fulfillment_event_days: The number of days taken for a fulfillment event. The duration reflects the event type, such as order to fulfillment for fulfilled events, order to shipping for shipped events, and order to delivery for delivered events.
Anchor to fulfillment_event_hours fulfillment_event_hours: The number of hours taken for a fulfillment event. The duration reflects the event type, such as order to fulfillment for fulfilled events, order to shipping for shipped events, and order to delivery for delivered events.
Anchor to fulfillment_id fulfillment_id: Shopify identifier for the fulfillment
Anchor to fulfillment_origin_country fulfillment_origin_country: The country where the fulfillment started, shown as a country name.
Anchor to fulfillment_provider fulfillment_provider: The name of the app or service that handled the fulfillment.
Anchor to fulfillment_provider_id fulfillment_provider_id: Use fulfillment_provider_id with fulfillment_provider to show readable fulfillment provider names.
Anchor to fulfillment_to_shipping_days fulfillment_to_shipping_days: The number of days from fulfillment to the shipping handoff for shipped events.
Anchor to fulfillment_to_shipping_hours fulfillment_to_shipping_hours: The number of hours from fulfillment to the shipping handoff for shipped events.
Anchor to hour hour: The hour a fulfillment event happened.
Anchor to hour_of_day hour_of_day: The hour of day a fulfillment event happened, with values 0 through 23.
Anchor to inventory_location_id inventory_location_id: The Shopify identifier for the inventory location connected to the fulfillment. Use inventory_location_id with inventory_location_name to show readable location labels.
Anchor to minute minute: The minute a fulfillment event happened.
Anchor to month month: The month a fulfillment event happened.
Anchor to month_of_year month_of_year: The month of the year a fulfillment event happened, with values 1 through 12.
Anchor to order_id order_id: The unique Shopify identifier for the order connected to the fulfillment.
Anchor to order_to_delivery_days order_to_delivery_days: The number of days from order placement to delivery for delivered events.
Anchor to order_to_delivery_hours order_to_delivery_hours: The number of hours from order placement to delivery for delivered events.
Anchor to order_to_fulfillment_days order_to_fulfillment_days: The number of days from order placement to fulfillment for fulfilled events.
Anchor to order_to_fulfillment_hours order_to_fulfillment_hours: The number of hours from order placement to fulfillment for fulfilled events.
Anchor to order_to_shipping_days order_to_shipping_days: The number of days from order placement to the shipping handoff for shipped events.
Anchor to order_to_shipping_hours order_to_shipping_hours: The number of hours from order placement to the shipping handoff for shipped events.
Anchor to quarter quarter: The quarter a fulfillment event happened.
Anchor to second second: The second a fulfillment event happened.
Anchor to shipping_address_id shipping_address_id: The unique Shopify identifier for the shipping address on the order.
Anchor to shipping_carrier shipping_carrier: The carrier or tracking company for the shipment.
Anchor to shipping_to_delivery_days shipping_to_delivery_days: The number of days from the shipping handoff to delivery for delivered events.
Anchor to shipping_to_delivery_hours shipping_to_delivery_hours: The number of hours from the shipping handoff to delivery for delivered events.
Anchor to shop_id shop_id: The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.
Anchor to week week: The week a fulfillment event happened.
Anchor to week_of_year week_of_year: The week of the year a fulfillment event happened, with values 1 through 53.
Anchor to year year: The year a fulfillment event happened.
Anchor to inventory_group_id inventory_group_id: Shopify identifier for the inventory group
Anchor to inventory_location_name inventory_location_name: Name of the inventory location
Anchor to shop_name shop_name: Name of your store
Anchor to is_b2b_order is_b2b_order: Whether the order is a B2B order, with values true and false.
Anchor to is_canceled_order is_canceled_order: Whether the order is canceled, with values true and false.
Anchor to order_checkout_currency order_checkout_currency: The currency the buyer saw at checkout when placing the order. Values are currency codes such as USD, CAD, EUR, and GBP.
Anchor to order_fulfillment_status order_fulfillment_status: The order's fulfillment state, with values Fulfilled, Partial, Restocked, and Unfulfilled.
Anchor to order_includes_duties order_includes_duties: Whether the order includes duties, with values true and false.
Anchor to order_name order_name: The name or number of the order as the customer sees it.
Anchor to order_payment_status order_payment_status: The order's payment state, such as Authorized, Paid, Partially refunded, or Pending.
Anchor to order_sales_channel order_sales_channel: The sales channel where the order was placed, shown as a channel name such as Online Store or POS.
Anchor to order_sales_channel_id order_sales_channel_id: The unique Shopify identifier for the order's sales channel. Use order_sales_channel_id with order_sales_channel to show readable channel labels.
Anchor to is_shop_referral_order is_shop_referral_order: Whether the order was referred from the Shop app or shop.app, with values true and false.
Anchor to order_landing_page_path order_landing_page_path: Path of the first page of the user session that resulted in the order
Anchor to order_landing_page_url order_landing_page_url: First page of the user session that resulted in the order
Anchor to order_marketing_event_id order_marketing_event_id: Shopify identifier for the marketing event associated with the order
Anchor to order_referrer_domain order_referrer_domain: Domain of the site that led to the order
Anchor to order_referrer_name order_referrer_name: The readable name of the site that led to the order.
Anchor to order_referrer_path order_referrer_path: Path of the site that led to the order
Anchor to order_referrer_site order_referrer_site: Site that led to the order
Anchor to order_referrer_source order_referrer_source: The referrer type that led to the order, such as organic or email.
Anchor to order_referrer_url order_referrer_url: External page that referred a customer and led to the order
Anchor to order_utm_campaign order_utm_campaign: UTM name of the campaign associated with the order
Anchor to order_utm_content order_utm_content: The UTM content value associated with the order, often used to distinguish ads, links, or content variations.
Anchor to order_utm_medium order_utm_medium: The UTM medium associated with the order, such as email, social, or paid search.
Anchor to order_utm_source order_utm_source: The UTM source associated with the order, such as Google, Facebook, or a newsletter.
Anchor to order_utm_term order_utm_term: The UTM term associated with the order, often used for paid search keywords or other tracked terms.
Anchor to number_of_products_bought_together number_of_products_bought_together: Total unique products in the same order
Anchor to number_of_variants_bought_together number_of_variants_bought_together: The number of unique product variants in the same order, with each SKU counted a single time.
Anchor to products_bought_together products_bought_together <>: The product names that appear in the same order.
Anchor to products_bought_together_ids products_bought_together_ids <>: The Shopify product identifiers for products in the same order.
Anchor to variants_bought_together variants_bought_together <>: The product variant labels that appear in the same order, such as size, color, or style combinations.
Anchor to company_id company_id: The unique Shopify identifier for the company. Use company_id with company_name to show readable company labels.
Anchor to company_name company_name: Name of the company that placed the order
Anchor to company_location_id company_location_id: The unique Shopify identifier for the company location. Use company_location_id with company_location_name to show readable company location labels.
Anchor to company_location_name company_location_name: The company location or branch that placed the order
Anchor to referring_channel referring_channel: Marketing channel that referred the customer to place the order
Anchor to referring_medium referring_medium: The marketing medium that referred the customer to place the order, such as email, social, or search.
Anchor to referring_platform referring_platform: The marketing platform that referred the customer to place the order, such as Google, Facebook, or Instagram.
Anchor to traffic_type traffic_type: The type of traffic that led to the order, such as organic, paid, or direct.
Anchor to order_marketing_event_target order_marketing_event_target: The platform or channel where the marketing activity was deployed, such as Email, Facebook, Google, or Instagram.
Anchor to order_marketing_event_type order_marketing_event_type: The type of marketing activity that led to the order, such as Ad, Affiliate, Newsletter, or Retargeting. PLA means Product Listing Ads, and SEO means Search Engine Optimization.
Anchor to market market: Market you've defined in Shopify, like a geographical market or customer group
Anchor to markets markets <>: Markets or customer segments associated with the order
Anchor to order_cancellation_reason order_cancellation_reason: The reason specified for the order cancellation, such as Customer, Other, Fraud, or Inventory.
Anchor to order_risk_level order_risk_level: The fraud risk level Shopify assigned to the order, with values Low, Medium, High, None, and Pending.
Anchor to order_is_shopify_protect_covered order_is_shopify_protect_covered: Whether the order has met Shopify Protect fulfillment requirements, including proper shipping and tracking, with values true and false.
Anchor to order_is_shopify_protect_eligible order_is_shopify_protect_eligible: Whether the order qualifies for Shopify Protect, with values true and false.
Anchor to order_is_shopify_protect_protected order_is_shopify_protect_protected: Whether the order has full Shopify Protect coverage against fraud, with values true and false.
Anchor to order_tag order_tag: Tag associated with the order
Anchor to order_tags order_tags <>: Set of tags associated with the order
Anchor to agentic_referring_channel agentic_referring_channel: The AI agent or assistant that referred the session to your online store, with values ChatGPT, Google AI Mode and Gemini, Microsoft Copilot, and Shop.
Anchor to channel_handle channel_handle: Name of the marketing channel or platform that drove the marketing engagement
Anchor to marketing_activity_id marketing_activity_id: The unique Shopify identifier for the marketing activity. Use marketing_activity_id with marketing_activity_title to show readable activity labels.
Anchor to marketing_activity_status marketing_activity_status: Current status of the marketing activity (such as Active or Paused)
Anchor to marketing_activity_title marketing_activity_title: Name of the marketing activity
Anchor to marketing_activity_url_parameter_key marketing_activity_url_parameter_key: URL parameter key for the marketing activity
Anchor to marketing_activity_url_parameter_value marketing_activity_url_parameter_value: URL parameter value for the marketing activity
Anchor to marketing_automation_id marketing_automation_id: Unique ID that Shopify uses to identify the marketing automation
Anchor to marketing_delivery_channel marketing_delivery_channel: Channel through which the marketing activity is delivered
Anchor to marketing_event_id marketing_event_id: Unique identifier for the associated marketing event
Anchor to marketing_platform marketing_platform: The marketing platform that created the marketing activity, shown as a platform name.
Anchor to page_host page_host: The host name of the session landing page.
Anchor to page_path page_path: The path of the session landing page.
Anchor to page_url page_url: The URL of the first page viewed in the session.
Anchor to referrer_url referrer_url: External page that led to an online store session
Anchor to utm_campaign utm_campaign: UTM name of the campaign associated with the session
Anchor to utm_content utm_content: The UTM content value associated with the session, often used to distinguish ads, links, or content variations.
Anchor to utm_medium utm_medium: The UTM medium associated with the session, such as email, social, or paid search.
Anchor to utm_source utm_source: The UTM source associated with the session, such as Google, Facebook, or a newsletter.
Anchor to utm_term utm_term: The UTM term associated with the session, often used for paid search keywords or other tracked terms.
Anchor to shipping_city shipping_city: City of the shipping address
Anchor to shipping_company shipping_company: Company of the shipping address
Anchor to shipping_country shipping_country: Country of the shipping address (e.g., United States, Canada)
Anchor to shipping_postal_code shipping_postal_code: Postal code of the shipping address
Anchor to shipping_region shipping_region: State or province of the shipping address (e.g., California, Ontario)

DAY_TIMESTAMP

A date value truncated to day precision.

DAY_OF_WEEK

A day within a week, used for weekday-based grouping and filtering.

IDENTITY

A unique identifier for a Shopify resource such as a customer, product, or order.

STRING

A sequence of characters representing text data.

HOUR_TIMESTAMP

A timestamp truncated to hour precision.

HOUR_OF_DAY

An hour within a day, typically represented as an integer from 0 to 23.

MINUTE_TIMESTAMP

A timestamp truncated to minute precision.

MONTH_TIMESTAMP

A date value representing the start of a month.

MONTH_OF_YEAR

A month number within a year.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

SECOND_TIMESTAMP

A timestamp truncated to second precision.

WEEK_TIMESTAMP

A date value representing the start of a week.

WEEK_OF_YEAR

A week number within a year.

YEAR_TIMESTAMP

A date value representing the start of a year.

BOOLEAN

A true or false value representing binary states.

ARRAY

A list of values. The element type appears inside angle brackets, such as ARRAY<STRING>.

Anchor to Related schemasRelated schemas

shipping_labels: Label-level costs and carrier spend, paired with the same carrier and lane attributes.
subscriptions: Subscription order activity when you want to track recurring fulfillment separately from one-off orders.
sales: Sale-level data when you want to tie fulfillment timing back to revenue.

Was this page helpful?