Learned playbook
Fulfillment triage — 5 rules
Flag against the carrier's own promised window, not a fixed company-wide cutoff
Compare each order's delay to what that specific carrier and shipping method promised, not one universal deadline.
Escalate to support proactively if a delayed order already has an open ticket
Cross-check delayed orders against open support tickets and surface the connection automatically.
Apply supplier-specific thresholds, not one rule for every supplier
Flag a historically reliable supplier at 2 days late, and a known-slower supplier only at 4 days late.
Track on-time rate on a rolling 7-day window
Recalculate the on-time percentage every day across the trailing week, not monthly.
Route returns by reason, not as one queue
Send defect-reason returns to a different review queue than preference-reason returns.