Reference

Endpoint Insert Inventory Levels

Name

post_inventory_level

Description

No description available

Related Tables

InventoryLevels

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
InventoryItemId DT_I8 bigint
LocationId DT_I8 bigint
UpdatedAt DT_DBTIMESTAMP datetime
Available DT_I4 int
If the column you are looking for is missing, consider customizing Shopify Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
InventoryItemId DT_I8 bigint
LocationId DT_I8 bigint
Available DT_I4 int
Required columns that you need to supply are bolded.

Examples

SSIS

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

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 insert inventory levels:

API Destination - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
InventoryLevels
Insert
Optional Parameters
ContineOn404Error False
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Insert Inventory Levels 

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

post_inventory_level endpoint belongs to InventoryLevels 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:

Insert Inventory Levels 

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

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