Skip to main content

Inventory Table Metrics Reference

This page defines every metric column available in the Synplex inventory table. For deeper explanation of how specific metrics are calculated, follow the links to the dedicated concept articles.

Stock assessment​

The stock assessment is the health status of a variant. It is derived from the 365-day inventory simulation — not from raw on-hand unit counts — and rolls up from per-location values to the variant level by taking the worst severity across all locations.

See Understanding Product Statuses for the full logic, all five values, their thresholds, and how to configure them.

Shopify status​

The publishing state of the product in Shopify.

ValueMeaning
ActiveLive and available for sale
DraftCreated but not yet published; not visible to customers
ArchivedHidden from the storefront; historical data is preserved
Synplex syncs all three states. Use the Shopify Status filter in the inventory table to
exclude drafts or archived products from your working view.

ABC grade​

Products are ranked A, B, or C based on their contribution to a configurable metric (revenue, profit, or quantity sold) over a configurable lookback period.

See ABC Analysis & Product Grading for the full calculation, default weights, and how to configure the grading period and variable.

XYZ evaluation​

Classifies demand predictability:

ValueMeaning
XStable, predictable demand
YVariable demand with some pattern
ZHighly erratic or unpredictable demand
XYZ is calculated from the coefficient of variation of historical daily sales across the
configured lookback period.

Collections and category​

Collections are synced directly from Shopify and reflect your customer-facing product groupings (e.g. "Summer Range", "Sale Items"). They are read-only in Synplex.

Category is an internal Synplex classification you assign per product for reporting and filtering. Use it to group products by department, product type, or any internal taxonomy that is not captured by Shopify collections.

Tags are synced from Shopify and can be used as additional filter dimensions in the inventory table.

Quantity metrics​

On Hand​

The total available quantity across all included locations, synced from Shopify. This is the available quantity in Shopify's inventory — it does not include quantities committed to open orders or quantities in transit.

On Hand is the starting stock value fed into the 365-day simulation. All simulation-derived metrics (Reorder Date, Coverage Date, Stockout Date, Recommended Order Qty) are based on this figure at the time the simulation last ran.

Incoming Stock​

The total quantity scheduled to arrive from confirmed purchase orders and transfer orders, summed across all future delivery dates for this variant. Draft POs and cancelled orders are excluded.

This is the incomingStock field. It is the sum of all real inbound quantities used in the stockout simulation, per inventory level, aggregated to the variant level.

Adjusted Inventory Available​

On Hand plus Incoming Stock. Represents the total supply available now or confirmed to arrive, giving a fuller picture of supply continuity than On Hand alone.

Sales and demand metrics​

Daily Sales Rate​

The average units sold per day over the configured historical lookback period (default: the period used to build the demand plan). This is the dailySalesRate field on the variant, sourced from the dailySalesRateComputed computed field on the inventory level.

It is used as the basis for the 365-day simulation's average daily demand, spread evenly from monthly demand plan totals across each day of the month.

Daily Sales Rate (7-day)​

The average units sold per day over the most recent 7 days. Used alongside the historical daily sales rate to compute the Demand Anomaly Score — a signal indicating whether recent demand is significantly above or below the historical average.

Sales Revenue​

Total revenue from sales of this variant over the configured period. Calculated as: sum of (units sold × sale price at time of sale) across all orders in the period. For new products, the period starts from the publish date, not the creation date.

Pre-Stockout Daily Sales​

The average daily sales rate recorded immediately before the last stockout event for this variant. Useful for understanding whether current demand has recovered to, exceeded, or fallen below the rate that preceded the stockout.

Time-based planning metrics​

All four metrics below are outputs of the 365-day inventory simulation. They are computed per inventory level (per variant per location) and rolled up to the variant.

For the precise definitions and how the simulation derives each value, see Forecasted Stockout Date.

MetricWhat it showsRollup to variant
Coverage DateDate current on-hand stock alone runs out (on-hand ÷ avg daily demand)Earliest across locations
Stockout DateDate stock goes negative even counting confirmed inbound POs and TOsEarliest across locations
Reorder DateDate stock hits the reorder point (leadTimeDays + bufferStockDays) × avgDailyDemandEarliest across locations
Stock Gap DaysDays between projected stockout and next confirmed inbound deliveryPer location; worst shown

The quantity Synplex recommends ordering immediately for a given inventory level. It is the Day 0 virtual order quantity from the simulation — the amount needed right now to bring stock back above the reorder point and cover purchaseDaysOfInventoryReach days of demand (default: 90 days) after the order arrives.

This is not a simple formula based on on-hand minus safety stock. It is the output of the simulation's reorder trigger logic at Day 0, constrained by MOQ and batch size settings configured on the supplier product.

A value of zero means the simulation did not trigger an immediate order — stock is currently above the reorder point.

Financial metrics​

Cost Value​

On Hand × unit cost. The total capital currently invested in this variant's inventory. Unit cost is sourced from the supplier product record in Synplex if set, otherwise from the cost entered in Shopify.

Retail Value​

On Hand × current Shopify sale price. The revenue this variant would generate if all current on-hand stock were sold at today's price. Based on current price only — not discounted or bundle prices.

Gross Margin (unit)​

Sale price − unit cost. The gross profit per unit sold.

Gross Margin (%)​

(sale price − unit cost) ÷ sale price × 100. The gross profit as a percentage of revenue. Use the percentage to compare profitability across products with different price points.

Landed Cost​

The all-in cost per unit, calculated as a weighted average blending the cost of remaining on-hand stock with the cost of newly received stock from purchase orders. Landed cost includes unit cost, freight, duties, insurance, and any other costs recorded against the PO shipment.

Landed cost is the most accurate figure to use when calculating true gross margin.

Supplier Unit Cost vs Shopify Unit Cost​

Supplier Unit Cost is the cost recorded against this variant's supplier product record in Synplex. It reflects the current agreed price with your supplier and is used for recommended order value calculations.

Shopify Unit Cost is the cost entered in Shopify's product admin. It may be outdated if prices have changed since it was last edited. It is used as the fallback when no supplier product cost is available in Synplex.

If the two values differ, the Synplex supplier cost takes precedence for planning calculations.

Supplier and sourcing metrics​

Supplier​

The supplier assigned to this variant via a supplier product record in Synplex. A variant can have multiple suppliers; the primary supplier (lowest cost or preferred) is shown by default. Use the Suppliers filter to find all variants sourced from a specific supplier.

Lead Time​

The number of days between placing an order and receiving it, as configured on the supplier product record. This is the leadTimeDays value fed into the simulation's reorder point calculation. Per-inventory-level overrides take precedence over the shop default.

MOQ and Pack Size​

MOQ (minimum order quantity) is the smallest quantity your supplier will accept per order. Pack Size (batch size) is the quantity increment orders must be rounded to. Both are configured on the supplier product record and applied to the Recommended Order Qty shown in the inventory table.

Risk metrics​

Sales at Risk​

Estimated revenue at risk if no restock action is taken. Calculated as: stockGapDays × dailySalesRate × salePrice

This quantifies the financial impact of a projected stock gap — the period between projected stockout and next confirmed inbound delivery. A value of zero means no stock gap is currently projected.

Metadata​

FieldSourceNotes
SKUShopifyStock Keeping Unit; unique identifier per variant
BarcodeShopifyEAN, UPC, or other barcode value
Product Created DateShopifyDate the product record was first created
Product Publish DateShopifyDate the product was made available for sale; sales metrics are calculated from this date for new products
LocationShopifyThe warehouse, store, or fulfilment centre where this inventory level is held. Locations are managed in Shopify and synced to Synplex.

When do metrics update?​

Metric groupUpdate trigger
On Hand, Shopify Status, SKU, CollectionsShopify webhook (near real-time) or daily sync
Stock Assessment, Reorder Date, Coverage Date, Stockout Date, Recommended Order QtyNightly scheduled run or on-demand Refresh Metrics
ABC/XYZ gradeNightly scheduled run
Incoming StockUpdated when POs or TOs are created, updated, or received in Synplex

Shopify syncs do not by themselves recalculate simulation metrics. If you need current planning metrics immediately after receiving stock or a large sale, use Refresh Metrics.