InventoryItemInventoryLevels

Shows overall inventory level details for each item and its stocking locations.

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, StockAtLegacyLocation

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A unique identifier for this inventory level record.
InventoryItemId	String	True	InventoryItems.Id	A unique identifier for the inventory item associated with this level entry.
LocationId	String	True		A unique identifier for the location where this inventory level is tracked.
CanDeactivate	Bool	True		Indicates whether the inventory items tied to this level can be safely deactivated without affecting availability or fulfillment operations.
DeactivationAlert	String	True		Provides information on the consequences of deactivating the inventory level, or explains why deactivation is restricted.
CreatedAt	Datetime	True		The date and time when the inventory level record was first created.
UpdatedAt	Datetime	True		The date and time when the inventory level record was most recently modified.

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 current available quantity of the inventory item at the specified location that can be sold or allocated.
OnHand	Int	The total quantity of the inventory item physically on hand at the location, before accounting for reservations or allocations.
StockAtLegacyLocation	Bool	Indicates whether activation is permitted at or away from a fulfillment service location when SKU sharing is disabled. Deactivation removes inventory at all other locations.