Skip to main content
Card class: 🦸 Hero * Category: Catalog & Inventory * Chart: kpi

​
At a glance

COUNT(stock_availables WHERE quantity <= 0) joined to active products (products.active = 1).
What it measuresCOUNT(stock_availables WHERE quantity <= 0) joined to active products (products.active = 1).
Formatnumber
Time windowRT
Alert trigger>0 (any OOS SKU still listed), driven by sentiment_key: out_of_stock_count
Sensitivity bandlower is better - good at/below 0, bad at/above 5
Rolesowner, operations, marketing
Data typeReal-time

​
Calculation

COUNT(stock_availables WHERE quantity <= 0) joined to active products (products.active = 1).
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

Out-of-Stock Products 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.