JDBC Driver for Shopify

Build 23.0.8839

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 InventoryItemId column, which supports the '=' comparison operator.

The 本製品 processes other filters client-side within the 本製品.

For example, the following query is processed server-side:

SELECT * FROM InventoryItemInventoryLevels WHERE InventoryItemId='VALUE'

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 23.0.8839