InventoryItems

Returns a list of inventory items.

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
  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:

Tracked, HarmonizedSystemCode, CountryCodeOfOrigin, ProvinceCodeOfOrigin, UnitCostAmount

The following pseudo-column can be updated:

InventoryItemCountryHarmonizedSystemCodes

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally-unique ID.
LegacyResourceId	String	True		The ID of the corresponding resource in the REST Admin API.
VariantId	String	True		A globally-unique ID.
Sku	String	True		Inventory item SKU.
Tracked	Bool	False		Whether inventory levels are tracked for the item.
LocationsCount	Int	True		The number of locations where this inventory item is stocked.
RequiresShipping	Bool	True		Whether the inventory item requires shipping.
DuplicateSkuCount	Int	True		The number of inventory items that share the same SKU with this item.
HarmonizedSystemCode	String	False		The harmonized system code of the item.
InventoryHistoryUrl	String	True		The URL that points to the inventory history for the item.
CountryCodeOfOrigin	String	False		The ISO 3166-1 alpha-2 country code of where the item originated from.
ProvinceCodeOfOrigin	String	False		The ISO 3166-2 alpha-2 province code of where the item originated from.
CreatedAt	Datetime	True		The date and time when the inventory item was created.
UpdatedAt	Datetime	True		The date and time when the inventory item was updated.
TrackedEditableLocked	Bool	True		Whether the attribute is locked for editing.
TrackedEditableReason	String	True		The reason the attribute is locked for editing.
UnitCostAmount	Decimal	False		Decimal money amount.
UnitCostCurrencyCode	String	True		Currency of the money.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.