--- title: inventory_transfers description: >- Reference for the ShopifyQL `inventory_transfers` 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_transfers md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_transfers.md api_name: shopifyql --- # inventory\_​transfers The `inventory_transfers` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures the line items on inventory transfers, before and while stock moves. It represents planned movement between origin and destination locations, with enough detail to trace each transfer back to its source record. ### Use cases * **Planned movement**: Group [`ordered_quantity`](#inventorytransfersmetric-propertydetail-orderedquantity) by [`inventory_origin_id`](#inventorytransfersdimension-propertydetail-inventoryoriginid) and [`inventory_destination_id`](#inventorytransfersdimension-propertydetail-inventorydestinationid) to show planned movement between locations. * **Transfer complexity**: Count [`transfer_line_item_count`](#inventorytransfersmetric-propertydetail-transferlineitemcount) by [`inventory_transfer_id`](#inventorytransfersdimension-propertydetail-inventorytransferid) to rank transfers by how many distinct line items they move. * **Integration view**: Compare [`unique_items_transferred`](#inventorytransfersmetric-propertydetail-uniqueitemstransferred) by [`transfer_app_name`](#inventorytransfersdimension-propertydetail-transferappname) to split distinct transferred items by integration. * **Source records**: Use [`document_uri`](#inventorytransfersdimension-propertydetail-documenturi) with [`inventory_transfer_id`](#inventorytransfersdimension-propertydetail-inventorytransferid) when linking transfer analytics back to source records. Examples ### Examples * #### ##### Description Rank transfer routes by \`ordered\_quantity\` this quarter, with transfer count for each lane. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add the all-routes total to every row. ##### ShopifyQL ```shopifyql FROM inventory_transfers SHOW ordered_quantity, transfer_count, unique_items_transferred GROUP BY inventory_origin_name, destination_name WITH TOTALS DURING this_quarter ORDER BY ordered_quantity DESC LIMIT 50 VISUALIZE ordered_quantity TYPE horizontal_bar ``` * #### ##### Description Track monthly \`transfer\_count\` this year against last year, grouped by the app that created each transfer. This example uses \[\`WITH PERCENT\_CHANGE\`]\(/docs/api/shopifyql/latest/syntax/with#percent-change-columns) to report the year-over-year change app by app, with \[\`COMPARE TO previous\_year\`]\(/docs/api/shopifyql/latest/syntax/compare-to) as the comparison baseline. ##### ShopifyQL ```shopifyql FROM inventory_transfers SHOW transfer_count, ordered_quantity, unique_items_transferred GROUP BY transfer_app_name WITH PERCENT_CHANGE TIMESERIES month DURING this_year COMPARE TO previous_year ORDER BY month ASC VISUALIZE transfer_count TYPE line ``` * #### ##### Description Compare monthly \`transfer\_line\_item\_count\` 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_transfers SHOW transfer_line_item_count TIMESERIES month WITH PERCENT_CHANGE DURING this_year COMPARE TO previous_year ORDER BY month ASC VISUALIZE transfer_line_item_count TYPE bar ``` * #### ##### Description Track weekly \`transfer\_count\` across last quarter. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a total for last quarter beside the weekly rows. ##### ShopifyQL ```shopifyql FROM inventory_transfers SHOW transfer_count TIMESERIES week WITH TOTALS DURING last_quarter ORDER BY week ASC VISUALIZE transfer_count TYPE line ``` *** ## 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_transfers`. * **ordered\_​quantity** **INTEGER** Quantity of inventory items ordered for transfer * **transfer\_​count** **INTEGER** Number of inventory transfers * **transfer\_​line\_​item\_​count** **INTEGER** Number of line items across transfers * **unique\_​items\_​transferred** **INTEGER** Number of unique inventory items transferred ### 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_transfers`. * **day** **DAY\_TIMESTAMP** Groups transfers by the day they were created. * **day\_​of\_​week** **DAY\_OF\_WEEK** Groups transfers by creation weekday, with values Monday through Sunday. * **document\_​uri** **STRING** The Shopify path that identifies the inventory transfer, such as `/transfers/12345`. Use [`document_uri`](#inventorytransfersdimension-propertydetail-documenturi) to filter to a specific transfer or include a transfer reference in results. * **hour** **HOUR\_TIMESTAMP** Groups transfers by the hour they were created. * **hour\_​of\_​day** **HOUR\_OF\_DAY** Groups transfers by creation hour of day, with values 0 through 23. * **inventory\_​destination\_​id** **IDENTITY** The unique Shopify identifier for the location receiving the inventory. Use it with [`destination_name`](#inventorytransfersdimension-propertydetail-destinationname) to show readable labels. * **inventory\_​item\_​id** **IDENTITY** Shopify identifier for the inventory item * **inventory\_​origin\_​id** **IDENTITY** The unique Shopify identifier for the location sending the inventory. Use it with [`inventory_origin_name`](#inventorytransfersdimension-propertydetail-inventoryoriginname) to show readable labels. * **inventory\_​transfer\_​id** **IDENTITY** The unique Shopify identifier for the inventory transfer. Use [`inventory_transfer_id`](#inventorytransfersdimension-propertydetail-inventorytransferid) to filter to a specific transfer or group the line items that belong to the same transfer. * **inventory\_​transfer\_​line\_​item\_​id** **IDENTITY** The unique Shopify identifier for a line item within an inventory transfer. Use [`inventory_transfer_line_item_id`](#inventorytransfersdimension-propertydetail-inventorytransferlineitemid) to filter to one specific transferred item row. * **minute** **MINUTE\_TIMESTAMP** Groups transfers by the minute they were created. * **month** **MONTH\_TIMESTAMP** Groups transfers by the month they were created. * **month\_​of\_​year** **MONTH\_OF\_YEAR** Groups transfers by creation month of year, with values 1 through 12. * **product\_​variant\_​id** **IDENTITY** The unique Shopify identifier for the product variant on the transfer line item. Use it with [`product_variant_title`](#inventorytransfersdimension-propertydetail-productvarianttitle) or [`product_variant_sku`](#inventorytransfersdimension-propertydetail-productvariantsku) to show readable labels. * **quarter** **QUARTER\_TIMESTAMP** Groups transfers by the quarter they were created. * **second** **SECOND\_TIMESTAMP** Groups transfers by the second they were created. * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#inventorytransfersdimension-propertydetail-shopid) with [`shop_name`](#inventorytransfersdimension-propertydetail-shopname) to show readable store labels. * **staff\_​id** **IDENTITY** The unique Shopify identifier for the staff member who created or managed the transfer. Use it with [`staff_member_name`](#inventorytransfersdimension-propertydetail-staffmembername) to show readable labels. * **transfer\_​app\_​id** **IDENTITY** Shopify identifier for the app that created the transfer * **transfer\_​app\_​name** **STRING** Name of the app or integration that created the transfer * **week** **WEEK\_TIMESTAMP** Groups transfers by the week they were created. * **week\_​of\_​year** **WEEK\_OF\_YEAR** Groups transfers by creation week of year, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** Groups transfers by the year they were 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 ### 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 ``` ### STRING A sequence of characters representing text data. ```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 ``` ### TIMESTAMP A full-precision timestamp including date and time. ```ts ``` *** ## Related schemas * [`inventory_by_location`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_by_location): Location-level inventory state that transfers rebalance. * [`inventory_shipments`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_shipments): Incoming shipment data alongside transfer activity. * [`inventory_adjustment_history`](https://shopify.dev/docs/api/shopifyql/latest/schemas/inventory/inventory_adjustment_history): Manual adjustments alongside transfer-driven inventory changes. ***