Endpoint Get Inventory Levels

Name

get_inventory_levels

Description

Gets inventory level for a specific location and inventory item. [API reference]

Related Tables

InventoryLevels

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Shopify Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the InventoryLevels table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Shopify

Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.

Shopify

InventoryLevels

Optional Parameters
inventory_item_ids
location_ids
Updated at or after

API Destination

This Endpoint belongs to the InventoryLevels table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get inventory levels:

API Destination - Shopify

Read and write Shopify data effortlessly. Integrate, manage, and automate customers, orders, products, and inventory — almost no coding required.

Shopify

InventoryLevels

Select

Optional Parameters
inventory_item_ids
location_ids
Updated at or after

ODBC application

Use these SQL queries in your ODBC application data source:

Read inventory levels

<p>Gets inventory levels for all locations. If you encounter a "URL Too Long" error (due to API limits), manually supply a list of <code>location_ids</code> in the <code>WITH</code> clause.</p>

select * from InventoryLevels 
		--WITH(location_ids='43512280416356, 44648752676964, ..... upto 300 to 500 more - until you hit URL limit error')

Read inventory levels by inventory item IDs

<p>Gets inventory levels for specific inventory items. Supply a comma-separated list of IDs in the <code>inventory_item_ids</code> parameter within the <code>WITH</code> clause.</p>

select * from InventoryLevels WITH (inventory_item_ids='43512280416356, 44648752676964')

Read inventory levels by location IDs

<p>Gets inventory levels for specific locations (e.g. physical store, POS). Supply a comma-separated list of IDs in the <code>location_ids</code> parameter within the <code>WITH</code> clause.</p>

select * from InventoryLevels WITH (location_ids='43512280416356, 44648752676964')

Read inventory levels by inventory and location IDs

<p>Gets inventory levels for specific inventory items at specific locations by supplying both <code>inventory_item_ids</code> and <code>location_ids</code> in the <code>WITH</code> clause.</p>

select * from InventoryLevels WITH (inventory_item_ids='43512280416356, 44648752676964' , location_ids='111100034, 111100055')

SQL Server

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

Read inventory levels

<p>Gets inventory levels for all locations. If you encounter a "URL Too Long" error (due to API limits), manually supply a list of <code>location_ids</code> in the <code>WITH</code> clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryLevels 
		--WITH(location_ids=''43512280416356, 44648752676964, ..... upto 300 to 500 more - until you hit URL limit error'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read inventory levels by inventory item IDs

<p>Gets inventory levels for specific inventory items. Supply a comma-separated list of IDs in the <code>inventory_item_ids</code> parameter within the <code>WITH</code> clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryLevels WITH (inventory_item_ids=''43512280416356, 44648752676964'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read inventory levels by location IDs

<p>Gets inventory levels for specific locations (e.g. physical store, POS). Supply a comma-separated list of IDs in the <code>location_ids</code> parameter within the <code>WITH</code> clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryLevels WITH (location_ids=''43512280416356, 44648752676964'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Read inventory levels by inventory and location IDs

<p>Gets inventory levels for specific inventory items at specific locations by supplying both <code>inventory_item_ids</code> and <code>location_ids</code> in the <code>WITH</code> clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'select * from InventoryLevels WITH (inventory_item_ids=''43512280416356, 44648752676964'' , location_ids=''111100034, 111100055'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];