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 connector uses the Shopify API to process WHERE clause conditions built with the InventoryItemId column, which supports the '=' comparison operator.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId='VALUE'
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. |