Low-Stock Products, PrestaShop

Low-Stock Products for PrestaShop stores, tracked live in Vortex IQ Nerve Centre. What it counts, why it matters, and how to act on it.

Card class: Supporting Metrics * Category: Catalog & Inventory * Chart: kpi

At a glance

COUNT(stock_availables WHERE quantity > 0 AND quantity <= products.low_stock_threshold) for active products (threshold>0).

What it measures	COUNT(stock_availables WHERE quantity > 0 AND quantity <= products.low_stock_threshold) for active products (threshold>0).
Format	number
Time window	RT
Alert trigger	>0
Roles	owner, operations
Data type	Real-time

Calculation

COUNT(stock_availables WHERE quantity > 0 AND quantity <= products.low_stock_threshold) for active products (threshold>0).

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

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