Endpoint

Get Inventory Items

Name

get_inventory_items

Description

Gets a list of inventory items. Each Product Variant has Inventory Item Id .. Its one to one relationship with Product Variant and Inventory Item. Query get_product_variants to get InventoryItemId and use as Id in this endpoint. [API reference]

Related Tables

InventoryItems

Parameters

Parameter	Label	Required	Options	Description
ids	Inventory Item Id(s) - Comma separated	YES		Restrict results to records specified by a comma-separated list of IDs. Max IDs per request controlled by BatchSize property (found in PaginationParams)
limit	Page Size	NO		The maximum number of records to show.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		`False`
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
Cost	`DT_WSTR`	`nvarchar(255)`	255	`False`
Tracked	`DT_BOOL`	`bit`		`False`
RequiresShipping	`DT_BOOL`	`bit`		`False`
CountryCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProvinceCodeOfOrigin	`DT_WSTR`	`nvarchar(50)`	50	`False`
CountryHarmonizedSystemCodes	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
HarmonizedSystemCode	`DT_I8`	`bigint`		`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`

If the column you are looking for is missing, consider customizing Shopify Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_I8`	`bigint`		`False`

Required columns that you need to supply are bolded.

Examples

SSIS

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

Read from InventoryItems table using API Destination

This Endpoint belongs to InventoryItems table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify

InventoryItems

Select, Lookup

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get inventory items

SELECT * FROM get_inventory_items
WHERE Id = 'abcd-1234-ids'

get_inventory_items endpoint belongs to InventoryItems table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get inventory items

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_inventory_items
WHERE Id = ''abcd-1234-ids''';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

get_inventory_items endpoint belongs to InventoryItems table(s), and can therefore be used via those table(s).