1 files changed, 8 insertions, 3 deletions
diff --git a/kitchen/helpers.py b/kitchen/helpers.py
index a4be79c..7853fd7 100644
--- a/kitchen/helpers.py
+++ b/kitchen/helpers.py
@@ -25,10 +25,15 @@ def find_ingredient(name):
 
 
 def get_pantry_total(ingredient_id):
-    """Get total quantity of an ingredient across all pantry locations."""
+    """Total quantity of an ingredient across all locations, excluding items
+    marked 'out'. Null quantities count as 0 (presence is tracked via state,
+    not this number — see the pantry redesign in plan.md)."""
     total = Decimal("0")
-    for item in PantryItem.objects.filter(ingredient_id=ingredient_id, quantity__gt=0):
-        total += item.quantity
+    for item in (
+        PantryItem.objects.filter(ingredient_id=ingredient_id)
+        .exclude(state=PantryItem.State.OUT)
+    ):
+        total += Decimal(item.quantity or 0)
     return total