Inventory KPIs Every SME Should Track

The most useful inventory KPIs for an SME are record accuracy, stock availability, sell-through, days of inventory remaining, slow or dead stock, receiving reliability and order fulfilment. The exact set depends on the operating decision. A retailer may prioritise availability and ageing; a manufacturer also needs component shortages, consumption variance and work-in-progress controls.

Use the inventory systems service when the required measures live across disconnected tools. The stock synchronisation guide addresses channel quantities, while the dead-stock guide turns ageing signals into actions.

Start with a metric contract

Write the formula, source, filters, period, owner and action before creating a chart. Specify whether returns, transfers, bundles, inactive items, consignment, tax and work in progress are included. Preserve the period dates used for every comparison. Shopify notes that some product analytics use a recent thirty-day period and processing delays; copying a label without the same definition will produce a different answer.

1. Inventory record accuracy

Accuracy should compare the system to a physical observation at the same cut-off. Decide whether a record passes only when quantity is exact or when it falls within an approved tolerance for weighed or measured goods. Report both the percentage of records correct and the value of differences. A high line accuracy can still hide a material shortage in one expensive item.

Segment accuracy by warehouse, location, item class and variance reason. If the count process itself is weak, label the result as provisional. The clean stock-count guide provides the evidence controls needed for a defensible measure.

2. Availability and stockout exposure

A stockout metric needs a denominator. Counting only the number of products at zero treats a low-priority dormant SKU the same as a high-demand item. Measure the item-days unavailable, customer demand events missed or order units not supplied for an agreed priority group. Separate true supply shortage from a channel-sync, allocation or item-status error.

3. Sell-through rate

Shopify defines product sell-through as units sold divided by units sold plus units still in inventory for the period. That definition is useful when the same opening and ending logic is applied consistently. Returns, bundles, transfers and stock introduced mid-period can change interpretation. Use sell-through to compare like products and periods, not as a universal target across seasonal and non-seasonal items.

4. Days of inventory remaining

A simple version divides ending quantity by average quantity sold per day during the selected period. It is a run-rate estimate, not a promise. A launch, promotion, stockout or seasonal shift can make the recent average misleading. Show the demand period and flag items with insufficient sales history. For critical items, compare the estimate with supplier lead time and the next confirmed inbound date.

5. Slow and dead stock

Define ‘dead’ by an operational rule rather than a universal age. The rule may combine no sales, no consumption, no open demand, age since receipt, product status, season and recoverable value. Report quantity and value separately. A large quantity of low-value packaging and one high-value obsolete component require different decisions.

6. Receiving and fulfilment measures

Receiving accuracy identifies the upstream causes of later variance. Track correct item, quantity, unit, location, lot or serial and receipt timing. Fulfilment measures should distinguish stock not available, stock available but not found, allocation failure, late picking and carrier delay. Without that split, purchasing may be blamed for a warehouse or integration problem.

A practical weekly scorecard

Data-quality gate

Before trusting the scorecard, reconcile item codes, units, locations, status and transaction dates. Check whether cancelled orders, returns and transfers are represented consistently. Compare ending quantity and value to the system of record. Xero emphasises using stock quantity, sales and value information to support purchasing and cash decisions; those decisions remain only as reliable as the underlying item and transaction data.

Worked SME example

A wholesaler begins with five weekly measures: accuracy for its A-class count sample, item-days out of stock for twenty priority SKUs, days remaining against confirmed lead time, value with no movement under its agreed rule, and receipt lines correct first time. Each metric has one owner and one action. After four weeks, the team finds that apparent purchasing shortages are mainly late receipt posting. It fixes that handover before adding another dashboard.

Sources checked

• Shopify Help Center: Product analytics overview
• Shopify Help Center: Inventory reports
• Xero South Africa: Inventory management

This resource provides general implementation guidance. Verify platform settings, tax, legal, payment and operational requirements against the current business context before making a live change.