Returns SKU inventory levels grouped by location 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 InventoryLocationId support the following operator: =.

For example, the following queries are processed server side:

SELECT * FROM InventoryByLocation WHERE Sku = '7001'

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

Columns

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