Returns SKU inventory levels grouped by warehouse for the connected account.

View-Specific Information

Select

The driver 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 driver.

• Sku and InventoryWarehouseId support the following operator: =.

For example, the following queries are processed server side:

SELECT * FROM InventoryByWarehouse WHERE Sku = '7001'

SELECT * FROM InventoryByWarehouse WHERE InventoryWarehouseId = 'se-3456'

Columns

Name	Type	References	Description
Sku [KEY]	String		The SKU (stock keeping unit) identifier for the inventory item.
InventoryWarehouseId [KEY]	String	InventoryWarehouses.Id	The Id of the inventory warehouse.
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.