Queries

Available queries

No direct query for stock levels. Stock levels are available as subqueries of variants.

---

Available fields

id Int
Id of the stock level

variant Variant
Variant concerned

location Location
Location

on_hand Float
On hand quantity

available Float
Available quantity

incoming Float
Incoming quantity

reserved Float
Reserved quantity

reorder_point Float
Re-order point

bin location String
Bin location

to_reorder Float
Quantity to re-order

last_sold_date String
Date of the last variant sold for the location