InventoryItemInventoryLevels

Shows per-location inventory level summaries for an inventory item.

Table-Specific Information

Select

The server uses the Shopify API to process WHERE clause conditions built with the following column and operators. The server processes other filters client-side within the server.

InventoryItemId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId = 'Val1'

Insert

The following columns can be used to create a new record:

InventoryItemId, LocationId

The following pseudo-columns can be used to create a new record:

Available, OnHand, StockAtLegacyLocation

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The globally unique identifier of the inventory level.
InventoryItemId	String	True	InventoryItems.Id	The globally unique identifier of the inventory item associated with this level.
LocationId	String	True		The globally unique identifier of the location tied to the inventory level.
CanDeactivate	Bool	True		Indicates whether the inventory level can be deactivated for the associated item at this location.
DeactivationAlert	String	True		Explains the impact of deactivating the inventory level or the reason why it cannot be deactivated.
CreatedAt	Datetime	True		The date and time when the inventory level was created.
UpdatedAt	Datetime	True		The date and time when the inventory level was last updated.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.


Name	Type	Description
Available	Int	The starting available quantity of the inventory item when it is activated at the location.
OnHand	Int	The starting on-hand quantity of the inventory item when it is activated at the location.
StockAtLegacyLocation	Bool	Indicates whether activation is allowed at or away from a legacy fulfillment service location when SKU sharing is disabled. Enabling this option deactivates inventory at all other locations.