alert_list
At a glance
Paid-but-not-shipped orders (current_state IN 2,3,9) ageing past 48h on date_add - staffing / picklist / 3PL issue before the customer emails.
| What it measures | Paid-but-not-shipped orders (current_state IN 2,3,9) ageing past 48h on date_add - staffing / picklist / 3PL issue before the customer emails. |
| Format | number |
| Time window | RT |
| Alert trigger | >10 paid orders aged >48h in states 2,3,9, driven by sentiment_key: unfulfilled_count |
| Sensitivity band | lower is better - good at/below 10, bad at/above 50 |
| Roles | owner, operations |
| Data type | Real-time |
Calculation
current_state in (2 Payment accepted, 3 Processing, 4 Shipped, 5 Delivered, 9 Backorder paid, 11 Remote payment accepted); shipped/fulfilled = (4, 5); refunded = (7, 15); cancelled = (6); payment error = (8). Read live from the PrestaShop Webservice API and snapshotted nightly into the Nerve Centre KPI store.