Skip to main content
Card class: 🦸 Hero * Category: Abandoned Carts * Chart: kpi

​
At a glance

COUNT(carts WHERE cart.id NOT IN (SELECT id_cart FROM orders)) windowed on cart.date_upd - a cart that never became an order.
What it measuresCOUNT(carts WHERE cart.id NOT IN (SELECT id_cart FROM orders)) windowed on cart.date_upd - a cart that never became an order.
Formatnumber
Time window30D vsP
Alert trigger>2x 30D avg, driven by sentiment_key: abandonment_rate
Sensitivity bandlower is better - good at/below 65, bad at/above 80
Rolesowner, marketing, operations
Data typeDerived

​
Calculation

COUNT(carts WHERE cart.id NOT IN (SELECT id_cart FROM orders)) windowed on cart.date_upd - a cart that never became an order.
PrestaShop order classification uses the order-state machine: paid = 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.

​
Why it matters

Abandoned Carts is part of the PrestaShop executive pulse in Vortex IQ Nerve Centre. Vortex Mind investigates automatically when this card breaches its sensitivity band, and Ask Viq can explain the movement in plain English with a citation back to this card.