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