Inventory Turnover, Sell-Through and GMROI: What Should Retailers Track?

Define the period and inventory being measured

Choose a store, category or SKU, meaning a stock keeping unit identifying a particular product variant. Match its sales and inventory records to the same reporting period. Mixing annual sales with one unusually low stock count can make inventory performance look stronger than it was.

Value inventory at its recorded cost, not its selling price. A beginning-and-ending average is a simple approximation; more frequent balances better capture large deliveries or seasonal peaks. Check missing product costs, returns, transfers and inventory adjustments before interpreting the result.

Use turnover to understand stock movement

Inventory turnover equals cost of goods sold, or COGS, divided by average inventory at cost. COGS represents the cost assigned to products sold during the period. Turnover expresses how many times that cost moved through the average inventory balance. Revenue divided by inventory cost is a different calculation and should not be labelled the same way.

Illustrative example: a retailer starts a quarter with 100 identical items costing $20 each, receives no additional stock and sells 60 items for $35 each, excluding sales tax. With no returns, shrinkage or other adjustments, 40 items remain. Beginning inventory is $2,000, ending inventory is $800 and the simple average is $1,400. These are fictional figures, not Lexedge client results.

Use sell-through to assess a selling period

Sell-through is a unit measure, but reports can define its denominator differently. Shopify's analytics reference uses units sold divided by units sold plus ending inventory. Some buying reports instead compare sales against a particular receipt or opening allocation. Record the definition so the team does not compare unlike percentages.

For the same illustrative quarter, 60 / (60 + 40) × 100 gives 60% sell-through. Because there were no receipts or adjustments, this also means 60% of the original 100-item allocation sold. With replenishment, returns or transfers, reconcile the units and confirm the report's treatment of each movement.

Use GMROI to connect margin with inventory

Gross margin return on inventory investment, commonly called GMROI, divides gross profit by average inventory at cost. Gross profit is net sales less COGS. Use the gross profit amount, not the gross margin percentage, in the numerator. Shopify's GMROI guide explains this relationship and why comparisons need product-category context.

In our illustrative quarter, sales are $2,100 and COGS is $1,200, leaving $900 gross profit. GMROI is $900 / $1,400 = 0.64. The inventory generated approximately $0.64 of gross profit per $1 of average inventory held during that quarter. This does not measure net profit after rent, staffing and other operating expenses.

Check what the ratios leave out

Strong turnover can coexist with lost sales if popular variants repeatedly sell out. A markdown can increase sell-through while reducing gross profit. A category average can hide both a successful item and another sitting unsold. Examine availability and product mix before calling the whole category healthy.

GMROI also cannot tell you when cash arrives or supplier invoices become payable. Keep purchasing decisions connected to a dated cash forecast. Compare similar periods and categories; there is no single healthy turnover or GMROI target for every retailer. Do not multiply one seasonal quarter by four and assume the result describes a normal year.

Turn the comparison into a buying decision

Our suggested review is a short exception list rather than a larger dashboard. Select products where movement, margin or availability changed enough to affect a decision. For each, record the observation, a possible explanation and the evidence needed before changing the order.

• Fast movement with stockouts: review variant availability and supplier lead time, the delay between ordering and receiving stock.
• Slow movement with healthy unit margin: inspect demand, seasonality, placement and the size of the original buy.
• Strong sales with weak GMROI: check discounts, product costs and inventory held; assign one action and a review date.