InventoryItemInventoryLevels

Returns overview information of the inventory item for each location that the inventory item can be stocked at.

Table-Specific Information

Select

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

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

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally-unique ID.
InventoryItemId	String	True	InventoryItems.Id	A globally-unique ID.
LocationId	String	True		A globally-unique ID.
CanDeactivate	Bool	True		Whether the inventory items associated with the inventory level can be deactivated.
DeactivationAlert	String	True		Describes either the impact of deactivating the inventory level, or why the inventory level can't 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 updated.

Pseudo-Columns

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。


Name	Type	Description
Available	Int	The initial available quantity of the inventory item being activated at the location.
OnHand	Int	The initial on_hand quantity of the inventory item being activated at the location.