Returns SKU inventory levels for the connected account.

View-Specific Information

Select

The connector will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

• Sku, InventoryWarehouseId and InventoryLocationId support the following operator: =.

For example, the following queries are processed server side:

SELECT * FROM Inventory WHERE Sku = '7001'

SELECT * FROM Inventory WHERE InventoryWarehouseId = 'se-1234'

SELECT * FROM Inventory WHERE InventoryLocationId = 'se-1234'

Columns

Name	Type	References	Description
Sku [KEY]	String		The SKU (stock keeping unit) identifier for the inventory item.
OnHand	Integer		The total quantity of inventory on hand.
Allocated	Integer		The quantity of inventory allocated to open orders.
Available	Integer		The quantity of inventory available for new orders.
AverageCostAmount	Decimal		The average cost amount of the inventory item.
AverageCostCurrency	String		The currency of the average cost.
InventoryWarehouseId	String	InventoryWarehouses.Id	The Id of the inventory warehouse.
InventoryLocationId	String	InventoryLocations.Id	The Id of the inventory location.