TDV Adapter for Shopify

Build 24.0.9060

InventoryItems

Returns a list of inventory items.

Table-Specific Information

Select

The adapter uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The adapter processes other filters client-side within the adapter.

  • 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, InventoryItemCountryHarmonizedSystemCodes (references 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.

InventoryItemCountryHarmonizedSystemCodes String False

List of country-specific harmonized system codes.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060