InventoryItemInventoryLevelQuantities
Reports current inventory quantities for items across store locations.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- InventoryLevelId supports the '=, IN' comparison operators.
- Name supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE InventoryLevelId = 'Val1'
SELECT * FROM InventoryItemInventoryLevelQuantities WHERE Name = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for this inventory level quantity record. | |
| InventoryItemId | String | A unique identifier for the inventory item associated with this quantity entry. | |
| InventoryLevelId | String | A unique identifier for the inventory level that tracks this item's stock availability. | |
| InventoryLevelLocationId | String | A unique identifier for the location tied to this inventory level, such as a warehouse or fulfillment center. | |
| Name | String | The descriptive name that identifies the inventory quantity being tracked. | |
| Quantity | Int | The current stock quantity recorded for the specified item and location. | |
| UpdatedAt | Datetime | The date and time when the inventory quantity was most recently updated. |