Inventory
Returns SKU inventory levels for the connected account.
View-Specific Information
Select
The add-in 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 add-in.
- Sku, InventoryWarehouseId and InventoryLocationId support the following operator: =.
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 | The Id of the inventory warehouse. | |
| InventoryLocationId | String | The Id of the inventory location. |