InventoryItemInventoryLevels
Returns a list of the inventory item's quantities for each location that the inventory item can be stocked at.
View-Specific Information
Select
The adapter uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The adapter processes other filters client-side within the adapter.
- InventoryItemId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM InventoryItemInventoryLevels
SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId = 'Val1'
Columns
Name | Type | References | Description |
Id [KEY] | String | A globally-unique ID. | |
InventoryItemId | String | A globally-unique ID. | |
LocationId | String | A globally-unique ID. | |
CanDeactivate | Bool | Whether the inventory items associated with the inventory level can be deactivated. | |
DeactivationAlert | String | Describes either the impact of deactivating the inventory level, or why the inventory level can't be deactivated. | |
CreatedAt | Datetime | The date and time when the inventory level was created. | |
UpdatedAt | Datetime | The date and time when the inventory level was updated. |