Inventory transfers

Inter-location transfer orders — how many units were ordered to move, by transfer, origin, destination, status and product. Includes DRAFT transfers, which never appear in the shipments dataset. Requires the read_reports scope; empty on stores that have not granted it.

23 fields — 19 dimensions, 4 metrics. Date clauses (SINCE, UNTIL, DURING) use day.

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 inventory_transfers
  SHOW ordered_quantity
  GROUP BY day
  SINCE -30d

See Querying with SoloQL for the language.

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

Fields

FieldTypeRoleDescription
ordered_quantitynumbermetricUnits ordered for transfer.
transfer_countnumbermetricHow many distinct transfers are in the group.
transfer_line_item_countnumbermetricHow many distinct transfer line items are in the group.
unique_items_transferrednumbermetricHow many distinct inventory items appear in the group's transfers.
daydatedimensionThe day the transfer was recorded.
transfer_created_atdatedimensionWhen the transfer was created. ⚠️ A display dimension — the report's date range filters on Day, not on this.
transfer_namestringdimensionThe transfer's document number, such as #T0001.
inventory_transfer_idstringdimensionShopify id of the transfer.
inventory_transfer_line_item_idstringdimensionShopify id of the transfer line item — this dataset's finest grain.
transfer_statusstringdimensionWhere the transfer is in its lifecycle.
transfer_notestringdimensionFree text the merchant attached to the transfer.
transfer_tagsstringdimensionTags on the transfer.
transfer_reference_namestringdimensionThe merchant's own reference for the transfer, separate from its generated name.
inventory_origin_namestringdimensionLocation the stock is transferred from.
destination_namestringdimensionLocation the stock is transferred to.
inventory_origin_idstringdimensionShopify id of the origin location.
inventory_destination_idstringdimensionShopify id of the destination location.
product_variant_skustringdimensionSKU of the transferred variant.
product_variant_titlestringdimensionTitle of the transferred variant.
product_variant_idstringdimensionShopify id of the transferred variant.
inventory_item_idstringdimensionShopify inventory item id behind the transferred variant.
staff_member_namestringdimensionWhich staff member created the transfer. Empty for transfers made through an API rather than the admin — that is a real answer, not missing data.
storestringdimensionThe shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.