CData Python Connector for Shopify

Build 23.0.8839

InventoryItems

Query and update information regarding different inventory items.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id column. 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 InventoryItems WHERE Id = '123'

SELECT * FROM InventoryItems WHERE Id IN ('123', '456')

Update

You must specify the Id to update an inventory item. For example:

UPDATE InventoryItems SET Sku = 'lamo', Tracked = false WHERE Id = '123'

UPDATE InventoryItemsSET Cost = 45.95, CountryCodeOfOrigin = 'AU', CountryHarmonizedSystemCodes ='[{"harmonized_system_code":"701912","country_code":"CA"},{"harmonized_system_code":"701912","country_code":"US"}]', HarmonizedSystemCode = '701912', ProvinceCodeOfOrigin = 'NC', SKU = 'Test1', Tracked = FALSE WHERE Id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

A unique numeric identifier for the fulfillment.

Cost Decimal False

The unit cost of the inventory item.

CountryCodeOfOrigin String False

The two-digit code for the country where the inventory item was made.

CountryHarmonizedSystemCodes String False

An array of country-specific Harmonized System (HS) codes for the item.

HarmonizedSystemCode String False

The general Harmonized System (HS) code for the inventory item. Used if a country-specific HS code is not available.

ProvinceCodeOfOrigin String False

The two-digit code for the province where the inventory item was made. Used only if the shipping provider for the inventory item is Canada Post.

SKU String False

The unique SKU (stock keeping unit) of the inventory item.

Tracked Bool False

Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify.

RequiresShipping Bool True

Whether a customer needs to provide a shipping address when placing an order containing the inventory item.

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 last updated.

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