InventoryItemInventoryLevels

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

Table-Specific Information

Select

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

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

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 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.