Daily Low Stock Report Script :
FROM inventory
SHOW ending_inventory_units, ending_inventory_value
WHERE inventory_is_tracked = true
GROUP BY product_title, product_variant_title, product_variant_sku,
inventory_item_cost WITH TOTALS, CURRENCY 'USD'
HAVING ending_inventory_units >= 1
AND ending_inventory_units < 10
DURING today
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_units TYPE table
For 1 Month Stock Report :
FROM inventory
SHOW ending_inventory_units, ending_inventory_value
WHERE inventory_is_tracked = true
AND product_status = 'active'
GROUP BY product_title, product_variant_title, product_variant_sku, inventory_item_cost
HAVING ending_inventory_units >= 1 AND ending_inventory_units < 10
WITH TOTALS, PERCENT_CHANGE
SINCE startOfMonth(-1m)
UNTIL endOfMonth(-1m)
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_units TYPE table
For showing only active products low inventory (today) :
FROM inventory
SHOW ending_inventory_units, ending_inventory_value
WHERE inventory_is_tracked = true
AND product_status = 'active'
GROUP BY product_title, product_variant_title, product_variant_sku, inventory_item_cost
HAVING ending_inventory_units >= 1 AND ending_inventory_units < 10
WITH TOTALS, PERCENT_CHANGE
SINCE today
UNTIL today
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_units TYPE table
