CData Python Connector for Shopify

Build 23.0.8839

InventoryLevels

Query, create, and update information regarding different inventory levels.

Table-Specific Information

Select

To query this table InventoryItemId, LocationId or both should be specified. The supported SQL operators are '=' and 'IN'. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM InventoryLevels WHERE InventoryItemId = '123' 

SELECT * FROM InventoryLevels WHERE InventoryItemId = '123' AND LocationId = '456'

SELECT * FROM InventoryLevels WHERE InventoryItemId IN ('123', '456') AND LocationId IN ('123', '456')

Insert

  • Adjust the available quantity of an inventory item at a single location:

    INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available, Operation) VALUES (534169354263, 1448280087, 5, 'Adjust')

  • Connects an inventory item to a location by creating an inventory level at that location:

    INSERT INTO InventoryLevels (InventoryItemId, LocationId, Operation) VALUES (534169354263, 4484497431, 'Connect')

  • Sets the inventory level for an inventory item at a location:

    INSERT INTO InventoryLevels (InventoryItemId, LocationId, Available, Operation, DisconnectIfNecessary) VALUES (534169354263, 4484497431, 42, 'Set', true)

Delete

You must specify the InventoryItemId and LocationId to delete an inventory level of an inventory item at a location.

DELETE FROM InventoryLevels WHERE InventoryItemId = '153681943' AND LocationId = '45678'

Columns

Name Type ReadOnly References Description
InventoryItemId [KEY] Long False

InventoryItems.Id

The ID of the inventory item that the inventory level belongs to.

LocationId [KEY] Long False

Locations.Id

The ID of the location that the inventory level belongs to. To find the ID of the location, use the Locations view.

Available Int False

The quantity of inventory items available for sale. Returns null if the inventory item is not tracked.

UpdatedAt Datetime True

The date and time (ISO 8601 format) when the inventory level was last modified.

Operation String False

An operation to apply to the InventoryLevel. Valid values for order: adjust, connect, set.

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.

Name Type Description
RelocateIfNecessary Bool

Whether inventory for any previously connected locations will be relocated. This property is ignored when no fulfillment service location is involved. Used in insertions.

DisconnectIfNecessary Bool

Whether inventory for any previously connected locations will be set to 0 and the locations disconnected. This property is ignored when no fulfillment service is involved. Used in insertions.

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