InventoryItems
Lists inventory items (SKU-level records) with tracking and cost data.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=, IN' comparison operators.
- Sku supports the '=, !=' comparison operators.
- CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
- UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM InventoryItems WHERE Id = 'Val1'
SELECT * FROM InventoryItems WHERE Sku = 'Val1'
SELECT * FROM InventoryItems WHERE CreatedAt = '2023-01-01 11:10:00'
SELECT * FROM InventoryItems WHERE UpdatedAt = '2023-01-01 11:10:00'
Update
The following columns can be updated:
Sku, Tracked, RequiresShipping, HarmonizedSystemCode, CountryCodeOfOrigin, ProvinceCodeOfOrigin, MeasurementWeightValue, MeasurementWeightUnit, UnitCostAmount, InventoryItemCountryHarmonizedSystemCodes (references InventoryItemCountryHarmonizedSystemCodes)
InventoryItemCountryHarmonizedSystemCodes Temporary Table Columns
| Column Name | Type | Description |
| CountryCode | String | The ISO 3166-1 alpha-2 country code for the country that issued the specified harmonized system code. |
| HarmonizedSystemCode | String | The country-specific harmonized system code. These are usually longer than 6 digits. |
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the inventory item. | |
| LegacyResourceId | String | True |
The identifier of the corresponding inventory resource in the REST Admin API. | |
| VariantId | String | True |
The globally unique identifier of the associated product variant. | |
| Sku | String | False |
The stock keeping unit (SKU) code used to uniquely identify the inventory item. | |
| Tracked | Bool | False |
Indicates whether inventory levels are being tracked for this item. | |
| LocationsCount | Int | True |
The number of locations where this inventory item is stocked. | |
| LocationsCountPrecision | String | True |
The precision level applied to the location count value. | |
| RequiresShipping | Bool | False |
Indicates whether the inventory item requires physical shipping. | |
| DuplicateSkuCount | Int | True |
The number of inventory items that share the same SKU as this item. | |
| HarmonizedSystemCode | String | False |
The harmonized system code (HS code) for the item, used for customs and trade classification. | |
| InventoryHistoryUrl | String | True |
The URL linking to the inventory history record for this item. | |
| CountryCodeOfOrigin | String | False |
The ISO 3166-1 alpha-2 country code representing the item's country of origin. | |
| ProvinceCodeOfOrigin | String | False |
The ISO 3166-2 alpha-2 province or state code representing the item's region of origin. | |
| CreatedAt | Datetime | True |
The date and time when the inventory item was created in Shopify. | |
| UpdatedAt | Datetime | True |
The date and time when the inventory item was last updated. | |
| TrackedEditableLocked | Bool | True |
Indicates whether the 'tracked' attribute is locked from editing. | |
| TrackedEditableReason | String | True |
The explanation for why the 'tracked' attribute is locked from editing. | |
| MeasurementId | String | True |
The globally unique identifier of the measurement record for this inventory item. | |
| MeasurementWeightValue | Double | False |
The numeric weight of the item, measured using the unit specified in 'MeasurementWeightUnit'. | |
| MeasurementWeightUnit | String | False |
The unit of measurement for the item's weight value (for example, 'g', 'kg', 'lb'). | |
| UnitCostAmount | Decimal | False |
The per-unit cost of the inventory item, expressed as a decimal amount. | |
| UnitCostCurrencyCode | String | True |
The currency code associated with the unit cost amount. | |
| InventoryItemCountryHarmonizedSystemCodes | String | False |
The list of country-specific harmonized system codes (HS codes) associated with this inventory item. |