--- title: inventory_shipments description: >- Reference for the ShopifyQL `inventory_shipments` table. Every metric and dimension, paired with worked example queries. api_version: 2026-07 source_url: html: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_shipments md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_shipments.md api_name: shopifyql --- # inventory\_​shipments The `inventory_shipments` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures shipment line items that move inventory between locations. It focuses on shipment quantities, outcomes, and the transfer or operational context attached to the shipment. ### Use cases * **Quantities**: Compare [`shipped_quantity`](#inventoryshipmentsmetric-propertydetail-shippedquantity) and [`received_quantity`](#inventoryshipmentsmetric-propertydetail-receivedquantity) by [`shipment_name`](#inventoryshipmentsdimension-propertydetail-shipmentname) to spot shortfalls between what was sent and what arrived. * **Outcomes**: Group [`accepted_quantity`](#inventoryshipmentsmetric-propertydetail-acceptedquantity) and [`rejected_quantity`](#inventoryshipmentsmetric-propertydetail-rejectedquantity) by [`shipment_status`](#inventoryshipmentsdimension-propertydetail-shipmentstatus) to review shipment outcomes. * **Attribution**: Track [`shipment_count`](#inventoryshipmentsmetric-propertydetail-shipmentcount) by [`shipment_app_name`](#inventoryshipmentsdimension-propertydetail-shipmentappname) or [`staff_id`](#inventoryshipmentsdimension-propertydetail-staffid) to break shipments down by app or staff. Examples ### Examples * #### ##### Description Rank carriers by \`rejection\_rate\` this quarter, with acceptance rate and shipment count. This example uses \[\`HAVING\`]\(/docs/api/shopifyql/latest/syntax/having) \`shipment\_count > 5\` to drop low-volume carriers from the ranking. ##### ShopifyQL ```shopifyql FROM inventory_shipments SHOW acceptance_rate, rejection_rate, shipment_count GROUP BY carrier HAVING shipment_count > 5 DURING this_quarter ORDER BY rejection_rate DESC LIMIT 25 VISUALIZE rejection_rate TYPE horizontal_bar ``` * #### ##### Description Track weekly \`shipped\_quantity\` by destination country as a stacked area across this quarter. This example pairs \[\`PERCENT\_CHANGE\`]\(/docs/api/shopifyql/latest/syntax/with#percent-change-columns) with \[\`COMPARE TO previous\_period\`]\(/docs/api/shopifyql/latest/syntax/compare-to) to add a column measuring each week against the prior quarter. ##### ShopifyQL ```shopifyql FROM inventory_shipments SHOW shipped_quantity, received_quantity, unique_items_shipped GROUP BY destination_country WITH PERCENT_CHANGE TIMESERIES week DURING this_quarter COMPARE TO previous_period ORDER BY week ASC VISUALIZE shipped_quantity TYPE stacked_area ``` * #### ##### Description Track weekly \`accepted\_quantity\` and \`rejected\_quantity\` across this quarter. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a quarter-to-date total beside the weekly rows. ##### ShopifyQL ```shopifyql FROM inventory_shipments SHOW accepted_quantity, rejected_quantity TIMESERIES week WITH TOTALS DURING this_quarter ORDER BY week ASC VISUALIZE accepted_quantity, rejected_quantity TYPE line ``` * #### ##### Description Compare monthly \`received\_quantity\` this year against last year. This example uses \[\`COMPARE TO previous\_year\`]\(/docs/api/shopifyql/latest/syntax/compare-to) to set last year as the year-over-year baseline. ##### ShopifyQL ```shopifyql FROM inventory_shipments SHOW received_quantity TIMESERIES month WITH PERCENT_CHANGE DURING this_year COMPARE TO previous_year ORDER BY month ASC VISUALIZE received_quantity TYPE bar ``` *** ## Metrics 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 inventory_shipments`. * **acceptance\_​rate** **PERCENT** If no items were received in the results, [`acceptance_rate`](#inventoryshipmentsmetric-propertydetail-acceptancerate) is `null`. `Acceptance rate = accepted_quantity / received_quantity` * **accepted\_​quantity** **INTEGER** Quantity accepted after quality checks * **received\_​quantity** **INTEGER** Quantity received at destination locations * **rejected\_​quantity** **INTEGER** Quantity rejected due to quality issues or damage * **rejection\_​rate** **PERCENT** If no items were received in the results, then [`rejection_rate`](#inventoryshipmentsmetric-propertydetail-rejectionrate) is `null`. `Rejection rate = rejected_quantity / received_quantity` * **shipment\_​count** **INTEGER** Number of unique shipments * **shipped\_​quantity** **INTEGER** Quantity shipped between locations * **unique\_​items\_​shipped** **INTEGER** Number of unique inventory items shipped ### PERCENT A percentage value represented as a decimal, where 0.25 represents 25%. ```ts ``` ### INTEGER A whole number without decimal places, used for counts, quantities, and other discrete numeric values. ```ts ``` *** ## Dimensions 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 inventory_shipments`. * **carrier** **STRING** Name of the shipping carrier company * **carrier\_​code** **STRING** Carrier code or abbreviation (like UPS, FEDEX, USPS) * **day** **DAY\_TIMESTAMP** The day a shipment was created. * **day\_​of\_​week** **DAY\_OF\_WEEK** The day of week a shipment was created, with values Monday through Sunday. * **expected\_​delivery\_​at** **TIMESTAMP** Estimated date and time the shipment will arrive * **hour** **HOUR\_TIMESTAMP** The hour a shipment was created. * **hour\_​of\_​day** **HOUR\_OF\_DAY** The hour of day a shipment was created, with values 0 through 23. * **inventory\_​destination\_​id** **IDENTITY** The unique Shopify identifier for the location receiving the inventory. Use [`inventory_destination_id`](#inventoryshipmentsdimension-propertydetail-inventorydestinationid) to filter to a specific receiving location. Use it with [`destination_name`](#inventoryshipmentsdimension-propertydetail-destinationname) to show readable labels. * **inventory\_​item\_​id** **IDENTITY** The unique Shopify identifier for the inventory item on the shipment line item. Use [`inventory_item_id`](#inventoryshipmentsdimension-propertydetail-inventoryitemid) to filter to a specific item. Use it with [`product_variant_sku`](#inventoryshipmentsdimension-propertydetail-productvariantsku) or [`product_variant_title`](#inventoryshipmentsdimension-propertydetail-productvarianttitle) to show readable labels. * **inventory\_​origin\_​id** **IDENTITY** The unique Shopify identifier for the location sending the inventory. Use [`inventory_origin_id`](#inventoryshipmentsdimension-propertydetail-inventoryoriginid) to filter to a specific sending location. Use it with [`inventory_origin_name`](#inventoryshipmentsdimension-propertydetail-inventoryoriginname) to show readable labels. * **inventory\_​shipment\_​id** **IDENTITY** The unique Shopify identifier for the shipment. Use [`inventory_shipment_id`](#inventoryshipmentsdimension-propertydetail-inventoryshipmentid) to filter to one shipment or to break results down by shipment. * **inventory\_​shipment\_​line\_​item\_​id** **IDENTITY** The unique Shopify identifier for the shipment line item. Use [`inventory_shipment_line_item_id`](#inventoryshipmentsdimension-propertydetail-inventoryshipmentlineitemid) to filter to a specific line in a shipment. * **inventory\_​transfer\_​id** **IDENTITY** The unique Shopify identifier for the inventory transfer that created the shipment. Use [`inventory_transfer_id`](#inventoryshipmentsdimension-propertydetail-inventorytransferid) to connect shipment line items back to a specific transfer. * **minute** **MINUTE\_TIMESTAMP** The minute a shipment was created. * **month** **MONTH\_TIMESTAMP** The month a shipment was created. * **month\_​of\_​year** **MONTH\_OF\_YEAR** The month of year a shipment was created, with values 1 through 12. * **product\_​variant\_​id** **IDENTITY** The unique Shopify identifier for the product variant on the shipment line item. Use [`product_variant_id`](#inventoryshipmentsdimension-propertydetail-productvariantid) to filter to a specific variant. Use it with [`product_variant_title`](#inventoryshipmentsdimension-propertydetail-productvarianttitle) or [`product_variant_sku`](#inventoryshipmentsdimension-propertydetail-productvariantsku) to show readable labels. * **quarter** **QUARTER\_TIMESTAMP** The quarter a shipment was created. * **second** **SECOND\_TIMESTAMP** The second a shipment was created. * **shipment\_​app\_​id** **IDENTITY** The Shopify identifier for the app that created the shipment. Use [`shipment_app_id`](#inventoryshipmentsdimension-propertydetail-shipmentappid) to filter to a specific app. Use it with [`shipment_app_name`](#inventoryshipmentsdimension-propertydetail-shipmentappname) to show readable labels. * **shipment\_​app\_​name** **STRING** Name of the app or integration that created the shipment * **shipment\_​name** **STRING** The readable shipment label that combines the related transfer label with the shipment number. Use [`shipment_name`](#inventoryshipmentsdimension-propertydetail-shipmentname) to identify specific shipments in results. * **shipment\_​received\_​at** **TIMESTAMP** Date and time the shipment was initially received * **shipment\_​shipped\_​at** **TIMESTAMP** Date and time the shipment was shipped * **shipment\_​status** **STRING** Values include Draft, In transit, Received, and Partially received. * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#inventoryshipmentsdimension-propertydetail-shopid) with [`shop_name`](#inventoryshipmentsdimension-propertydetail-shopname) to show readable store labels. * **staff\_​id** **IDENTITY** The unique Shopify identifier for the staff member who created or managed the shipment. Use [`staff_id`](#inventoryshipmentsdimension-propertydetail-staffid) to filter to a specific staff member. Use it with [`staff_member_name`](#inventoryshipmentsdimension-propertydetail-staffmembername) to show readable labels. * **tracking\_​number** **STRING** Tracking number used by the carrier to identify the shipment * **tracking\_​url** **STRING** URL to track the shipment on the carrier's website * **week** **WEEK\_TIMESTAMP** The week a shipment was created. * **week\_​of\_​year** **WEEK\_OF\_YEAR** The week of year a shipment was created, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** The year a shipment was created. * **destination\_​city** **STRING** City of the location that's receiving inventory * **destination\_​country** **STRING** Country where the inventory destination location is located * **destination\_​name** **STRING** Name of the location receiving inventory * **destination\_​region** **STRING** Province or state of the location that's receiving inventory (e.g., California, Ontario) * **shop\_​name** **STRING** Name of your store * **inventory\_​cost\_​is\_​recorded** **BOOLEAN** Whether the inventory item has a cost saved in Shopify, with values `true` and `false`. * **inventory\_​is\_​tracked** **BOOLEAN** Whether Shopify tracks inventory adjustments for the inventory item, with values `true` and `false`. * **inventory\_​item\_​cost** **MONEY** The cost recorded for one unit of the inventory item, in your store's currency. * **inventory\_​origin\_​city** **STRING** City of the location that's sending inventory transfers * **inventory\_​origin\_​country** **STRING** Country of the location that's sending inventory transfers * **inventory\_​origin\_​name** **STRING** Name of the location sending inventory transfers * **inventory\_​origin\_​region** **STRING** Province or state of the location that's sending inventory transfers (e.g., California, Ontario) * **transfer\_​created\_​at** **TIMESTAMP** The date and time the inventory transfer was created, reported in your store's time zone. * **transfer\_​name** **STRING** The display name of the inventory transfer. If no name is set, the transfer number can appear. * **transfer\_​note** **STRING** Additional note attached to the inventory transfer * **transfer\_​reference\_​name** **STRING** Reference name of the inventory transfer * **transfer\_​status** **STRING** The current status of the inventory transfer, with values such as Draft, In progress, Ready to ship, and Transferred. * **transfer\_​tags** **STRING** Custom tags assigned to the inventory transfer * **product\_​variant\_​sku** **STRING** SKU of the product variant * **product\_​variant\_​title** **STRING** Display name of the product variant * **staff\_​member\_​name** **STRING** Name of the staff member associated with the order ### STRING A sequence of characters representing text data. ```ts ``` ### DAY\_TIMESTAMP A date value truncated to day precision. ```ts ``` ### DAY\_OF\_WEEK A day within a week, used for weekday-based grouping and filtering. ```ts ``` ### TIMESTAMP A full-precision timestamp including date and time. ```ts ``` ### HOUR\_TIMESTAMP A timestamp truncated to hour precision. ```ts ``` ### HOUR\_OF\_DAY An hour within a day, typically represented as an integer from 0 to 23. ```ts ``` ### IDENTITY A unique identifier for a Shopify resource such as a customer, product, or order. ```ts ``` ### MINUTE\_TIMESTAMP A timestamp truncated to minute precision. ```ts ``` ### MONTH\_TIMESTAMP A date value representing the start of a month. ```ts ``` ### MONTH\_OF\_YEAR A month number within a year. ```ts ``` ### QUARTER\_TIMESTAMP A date value representing the start of a fiscal quarter. ```ts ``` ### SECOND\_TIMESTAMP A timestamp truncated to second precision. ```ts ``` ### WEEK\_TIMESTAMP A date value representing the start of a week. ```ts ``` ### WEEK\_OF\_YEAR A week number within a year. ```ts ``` ### YEAR\_TIMESTAMP A date value representing the start of a year. ```ts ``` ### BOOLEAN A true or false value representing binary states. ```ts ``` ### MONEY A monetary amount representing currency values such as prices, revenue, costs, and discounts. ```ts ``` *** ## Related schemas * [`inventory_by_location`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_by_location): Destination location inventory state that shipments arrive into. * [`inventory_transfers`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_transfers): Stock moves between locations alongside incoming shipments. * [`inventory`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory): Store-wide inventory state replenished by these shipments. ***