InventoryItems
Contains records for individual inventory items, including SKU, cost, and tracking settings.
Table-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.
- 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 |
A unique identifier for the inventory item record. | |
| LegacyResourceId | String | True |
The identifier for the corresponding inventory resource in the Shopify REST Admin API, used for backward compatibility. | |
| VariantId | String | True |
A unique identifier linking this inventory item to its associated product variant. | |
| Sku | String | False |
The stock keeping unit (SKU) used to uniquely identify and track this inventory item across systems. | |
| Tracked | Bool | False |
Indicates whether inventory quantities are actively tracked for this item within the system. | |
| LocationsCount | Int | True |
The total number of physical or virtual locations where this inventory item is stocked. | |
| LocationsCountPrecision | String | True |
Specifies how precise or approximate the reported location count is. | |
| RequiresShipping | Bool | False |
Indicates whether the item must be shipped to fulfill orders, as opposed to being a digital or service-based product. | |
| DuplicateSkuCount | Int | True |
The number of other inventory items in the catalog that share the same SKU as this one, often used to identify duplicates. | |
| HarmonizedSystemCode | String | False |
The harmonized system code used for customs classification and international trade reporting. | |
| InventoryHistoryUrl | String | True |
A URL linking to the complete history of quantity and status changes for this inventory item. | |
| CountryCodeOfOrigin | String | False |
The two-letter ISO 3166-1 alpha-2 code representing the country where the item was manufactured or sourced. | |
| ProvinceCodeOfOrigin | String | False |
The two-letter ISO 3166-2 code representing the province, state, or region where the item originated. | |
| CreatedAt | Datetime | True |
The date and time when the inventory item record was initially created in Shopify. | |
| UpdatedAt | Datetime | True |
The date and time when the inventory item record was most recently modified. | |
| TrackedEditableLocked | Bool | True |
Indicates whether the 'Tracked' attribute is locked from manual edits due to system or integration constraints. | |
| TrackedEditableReason | String | True |
Explains why the 'Tracked' attribute cannot currently be edited, such as synchronization restrictions or data policy settings. | |
| MeasurementId | String | True |
A unique identifier linking this inventory item to its associated measurement record. | |
| MeasurementWeightValue | Double | False |
The numeric weight of the item expressed in the specified measurement unit. | |
| MeasurementWeightUnit | String | False |
The unit of measure used for the weight value, such as kilograms, pounds, or grams. | |
| UnitCostAmount | Decimal | False |
The monetary cost per unit of this inventory item, used for valuation and reporting. | |
| UnitCostCurrencyCode | String | True |
The ISO 4217 currency code representing the currency of the unit cost value. | |
| InventoryItemCountryHarmonizedSystemCodes | String | False |
A list of harmonized system codes specific to different countries for this inventory item, used for customs compliance. |