Feature Request: Live Inventory Tracking by Aisle / Pallet Replenishment

[Shalom-Karr]

Problem Description

Currently, our application does an excellent job of tracking overall items picked and total items remaining to be fulfilled for the session. However, we lack granular visibility into where that inventory physically sits on the floor.

During a live picking session, pickers are depleting stock from specific aisles or specific pallets. Without live location-based tracking, warehouse managers don't know an aisle has run out of a product until pickers start complaining, creating bottlenecks and stopping the line while a new pallet is fetched.

Proposed Solution

We need to implement a Live Inventory Tracking System that maps items to their physical picking locations (aisles/slots) and monitors their depletion in real-time so managers know exactly when and where to drop a new pallet.

Key Requirements:

1. Aisle/Location Initialization:

   • When setting up the system for a new run, we should be able to define how much starting stock of an item is placed in Aisle 1 vs Aisle 2 (e.g., 500 boxes of Matzah in Aisle 1, 300 boxes in Aisle 2).
   • Note: The codebase has some commented-out logic referring to a 3 lane csv for itmTotals. We should investigate reviving or modernizing this approach.

2. Picker-Side Depletion:

   • When a volunteer starts an order, they select which Aisle they are walking down (this feature partially exists but needs to be strictly tied to inventory math).
   • Every time they pick an item and hit "Submit", that specific quantity must be subtracted from the live total of that specific aisle, not just the global total.

3. Admin Dashboard Visibility (/kadmin?page=items):

   • Update the "Manage Inventory" dashboard to break down stock by physical location.
   • Low Stock Alerts: Implement visual warnings (e.g., highlighting a row red) when a specific aisle drops below a designated threshold (e.g., < 20 items remaining).
   • This gives forklift drivers/managers a heads-up to bring a new pallet before the aisle is empty.

4. Replenishment Action:

   • Provide a quick-action button on the Admin Dashboard to "Add Pallet" to an aisle.
   • Clicking it prompts for a quantity (e.g., +200) and instantly adds it to that specific aisle's running total.

Acceptance Criteria

• Picker app successfully subtracts items based on the Aisle they selected at the start of the order.
• Database/JSON structure updated to support multi-location stock tracking per item.
• Admin Dashboard displays live counts separated by Aisle.
• Admin Dashboard prominently flags aisles that are running out of stock.
• Admins can add stock back to a specific aisle dynamically during a run.