ODBC Driver for Shopify

Build 24.0.9062

InventoryItemInventoryLevels

Returns a list of the inventory item's quantities for each location that the inventory item can be stocked at.

View-Specific Information

Select

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

  • InventoryItemId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM InventoryItemInventoryLevels
  SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
InventoryItemId String

InventoryItems.Id

A globally-unique ID.
LocationId String A globally-unique ID.
CanDeactivate Bool Whether the inventory items associated with the inventory level can be deactivated.
DeactivationAlert String Describes either the impact of deactivating the inventory level, or why the inventory level can't be deactivated.
CreatedAt Datetime The date and time when the inventory level was created.
UpdatedAt Datetime The date and time when the inventory level was updated.

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