Inventory turns when half your sales are special orders

The inventory report shows brisk movement. Then you walk the warehouse and recognize the same recliners, the discontinued dining set, and the floor samples still awaiting a markdown decision. The ratio and the aisle are telling different stories.

First check the scope of the calculation. If total cost of goods sold includes special orders while the inventory denominator contains only the stock program, the result overstates how quickly that stock is moving. Separate the two kinds of business before using turns to set the buying budget.

Use cost of goods sold over matching average inventory

Inventory turns divide cost of goods sold by average inventory at cost for the same period. Shopify’s turnover guide describes that cost-based calculation.

For annual turns, approximate inventory days are 365 divided by the turn rate. Keep the unrounded turn rate in the calculation, then round the displayed result. Dividing by an already rounded number can change the apparent days on hand.

Average inventory should represent the period, not just the lowest balance the store reached. Dated month-end values are a practical starting point; more frequent observations help where large receipts or promotions make the month-end unrepresentative.

Use the same cost definition on both sides. Landed COGS divided by factory-only inventory is another mismatch, even if both amounts came from a spreadsheet labeled Inventory.

Work through the misleading blended ratio

Here is a worked example. The store records $1.3 million of annual COGS, with 55% belonging to special orders. Average inventory for the separate stock program is $250,000.

Dividing all $1.3 million by that stock-only balance produces 5.2 turns. But only 45% of the COGS belongs to the inventory being measured.

The stock program has not slowed because you changed the calculation. The revised ratio has exposed the pace that the broader numerator concealed.

A properly constructed whole-business ratio could include the corresponding inventory investment across both programs. It would still be less useful for deciding whether those particular stocked recliners deserve replenishment.

Judge the stock program by category and vendor

Calculate turns for the stock program, then look at vendors and categories where the overall result conceals different movement. A fast-selling accent range can offset a slow dining program in the combined figure.

Pair turns with age and gross-profit dollars. Low turns may reflect overbuying, a discontinued program, a weak display, or an intentional sample investment. High turns may reflect successful replenishment or too little stock to serve demand.

The sources reviewed here do not establish one reliable furniture-stock benchmark. Set a working target against your own replenishment lead times, stockout experience, margin, and cash needs, then compare like programs over time.

Use GMROI by vendor to add the margin earned on that inventory investment. Turns explain movement; GMROI helps explain the return from it.

Count floor samples while recognizing their purpose

Owned floor samples that remain inventory belong in the stock calculation. Displaying a sofa does not remove its acquisition cost from the money the store has tied up.

Keep their role visible. A floor sample may generate special-order sales while rarely being sold itself. Record that contribution separately, and establish a replacement and markdown plan rather than expecting its stock turnover to explain the entire program.

Identify samples clearly in the review so the buyer can distinguish a deliberate display from forgotten saleable stock. The discontinued dining set should not acquire permanent residency simply because it photographs well.

For the financial count, use the year-end inventory guide to organize the records and exceptions.

Keep received special orders visible even when they are held

Received special orders can remain inventory when the store still owns the goods. A customer deposit, reservation, or warehouse label does not by itself settle the ownership and recognition question.

The IRS’s inventory guidance distinguishes goods by ownership, including goods held for sale in display spaces and excluding sold goods when title has passed. Review the specific year-end treatment with your CPA; the operational held status is not a substitute for that assessment.

For management reporting, keep customer-specific goods in the special-order segment. That keeps the stock buying decision clear while preserving the financial inventory and commitments that still exist.

Stock later reserved for a customer needs a consistent rule too. Keep the owned stock in the same population until the related sale and COGS are recognized, rather than removing it from the denominator as soon as a deposit arrives.

Give special orders their own performance measures

Review made-to-order business through landed margin, funding, and elapsed time. Those measures answer the questions that stock turns cannot.

A sofa that spends only a short time in the warehouse can still require substantial early vendor payments. Conversely, a fully paid order can occupy space while waiting for the customer’s renovation. Keep both cases visible.

The owner’s dashboard guide brings these measures together without treating written sales, cash receipts, and delivery as the same event.

Classify quick-ship and mixed configurations by how you buy them

A quick-ship label describes availability or lead time; it does not tell you whose inventory is being measured. If the store buys and holds a range for future sales, it belongs in the stock program. If it orders a piece specifically after a customer commits, it belongs in the customer-order program.

A configurable sofa can appear in both. The stocked oatmeal version and a freshly ordered navy version may share a template while using different sourcing decisions. Classify the units and transactions, not just the product name.

Write the rule once and keep it consistent through sales, COGS, and inventory snapshots. If a canceled special order becomes general stock, record that movement between the management segments so the next review can explain it.

Use Order New on the showroom iPad when the customer wants a fresh piece and the store intends to retain the floor sample.

Use OrderPilot’s stock and sourcing records

OrderPilot shows stock here, stock elsewhere, and Order New when staff choose the source for a line. That makes the buying decision visible at the sale rather than leaving receiving to infer it later. Received template units can become stock on a stocked variant. Units bought for a customer are held for the order line, while the linked PO identifies the incoming commitment. Store, warehouse, customer, and dropship destinations explain where the goods are going. The held-stock guide explains how the reservation protects the customer’s piece. The Orders list’s Awaiting pickup tab helps staff find goods whose next step is handover. OrderPilot supplies the operational separation and costing records; calculate turns from matching sales and dated inventory values in your reports or books. Its source, held, and incoming records help the reviewer explain which population each unit belongs to.

Recalculate monthly and act on the split

A monthly review with a consistent trailing annual period is a practical starting rhythm. Shorter periods can help investigate a promotion or a delivery interruption, but compare them with equivalent periods and label any annualization.

Use this split sheet to finish the review:

Keep the totals reconcilable to the whole business. Separating the review should explain the records, not make goods vanish between two worksheets.

Then take the slow stock decisions and customer-order exceptions to the owner’s dashboard. A useful turn rate should agree with what the team can see when it walks the warehouse.

Sources

1. Publication 538: Accounting Periods and Methods, Inventories — Internal Revenue Service, January 2022 edition; ownership and inventory guidance.
2. Inventory Turnover Ratio: Formula and How to Improve — Shopify, June 9, 2023.