Skip to main content
Card class: 🦸 Hero * Category: Margin & Profitability * Chart: gauge

​
At a glance

SUM(order_details.total_price_tax_excl - product_quantity*original_wholesale_price) / SUM(total_price_tax_excl) for paid-state orders in window.
What it measuresSUM(order_details.total_price_tax_excl - product_quantity*original_wholesale_price) / SUM(total_price_tax_excl) for paid-state orders in window.
Formatpercent
Time window30D vsP
Alert trigger<35% (margin pressure), driven by sentiment_key: margin_pct
Sensitivity bandhigher is better - good at/above 45, bad at/below 30
Rolesowner, finance
Data typeDerived

​
Calculation

SUM(order_details.total_price_tax_excl - product_quantity*original_wholesale_price) / SUM(total_price_tax_excl) for paid-state orders in window.
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

Gross Margin % 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.