Delivery-Based Priority Queue

Introduce a new sortable data field, "Days Since Delivery," to the “Delivered” order processing dashboard. This feature shifts the operational focus from the order creation date to the actual physical delivery date, ensuring we meet our inspection guarantees without being skewed by transit times.

The Problem (The "Why")

Currently, our "Oldest Order" view sorts by Order Creation Date.

False Urgency: An order created 14 days ago that arrived today looks more urgent than an order created 5 days ago that arrived yesterday.

Proposed Solution

• New Field: Age_Since_Delivery (Calculated as: Current Date - Delivery Date).

• Logic: Once a tracking number is marked as "Delivered," the clock starts.

• Default View: Allow the warehouse team to toggle the "Primary Sort" between Creation Date and Delivery Age.

Success Criteria

• Zero SLA Breaches: 100% of orders are inspected within the guaranteed [X] days of delivery.

• Improved Throughput: Warehouse staff spend less time manually hunting for the "actual" oldest package in the building.