What overselling costs a Shopify store
Calculate retail exposure from a stock gap, then use your own order records to estimate what overselling actually cost.
When a stock mismatch surfaces, someone will ask what it cost. The count can show how many more units the store offered than the connector was expected to make available. To work out the bill, you need to see which orders were affected and what you did about them. Keep those two calculations separate so a risk estimate doesn’t end up in the incident report as lost revenue.
Estimate the retail value of the units at risk
Use a pair of snapshots that cover the same SKU, location group and stock rules. Subtract the quantity you expect the connector to send from Shopify Available for the same stock pool. If the result is positive, multiply the extra units by the current retail price per unit. Use zero exposure from this calculation if the store is offering the same or fewer units. See the manual reconciliation guide for a way to match the stock pools first.
For a fictional example, the store offers 12 units, the expected connector quantity is seven after any buffer, and the offer is priced at $36. The five-unit difference puts $180 of retail value at risk at that moment. If nobody orders those extra units, there may be no oversold order. If an incoming receipt clears in time for shipping, you may be able to fulfill an order that looked exposed earlier.
Record the price, currency and time with each calculation. If the same units are listed in several bundles or channels, check whether the offers draw on one pool before you add the figures. If the store intentionally takes preorders or backorders, check the promise you made to shoppers. For products with inventory tracking enabled, Shopify’s Continue selling when out of stock setting lets shoppers buy online after stock runs out. A comparison of Available counts alone won’t capture that extra exposure. Shopify guidance on selling out of stock
Find the orders that were actually affected
Find the window from the earliest evidence of the issue to the point it was resolved. Pull order lines for the affected SKU and check which couldn’t be fulfilled as promised. Use order notes, fulfillment records and support conversations to confirm the reason. A cancellation for an unrelated reason can fall in the same window. Keep orders with an unknown cause marked as such.
For each affected line, record the quantity, the net price after discounts, any refund or credit, and the outcome. A cancelled line belongs in a different bucket from a delayed order that still shipped. If only one item was affected in a multi-item order, assign only the costs that changed because of that item. Include the rest of the order when the mismatch caused the whole order to change.
Compare the expected and actual contribution
For each affected order or line, use the same cost categories for two columns. One column shows what would have happened on an ordinary fulfillment. The other shows what actually happened. In each, start with the money retained from the sale, excluding taxes you pass through. Subtract the costs attributable to the sale, such as the cost of units shipped, pick and pack, postage and payment fees. Include extra support time at your own internal cost rate if you track it.
Subtract actual contribution from expected contribution to estimate the incident impact. For an illustrative cancelled $72 order, a normal shipment would have used $28 of stock, $6 in fulfillment and postage, and $3 in payment fees. The expected contribution was $35. After a full refund, suppose you retain no revenue and incur a $3 fee that wasn’t returned plus $4 in support time. Actual contribution is minus $7, for an estimated impact of $42.
Use your actual statements to see which fees were returned. Record a refund as a reduction in retained revenue. Counting it again as an expense would overstate the impact. Likewise, skip the cost of goods for a cancellation where no goods were consumed. Record a substitute, rush shipment or second parcel at its actual incremental cost. There’s no need to assign lost margin to a line that still earned it.
Use a consistent treatment for credits. If a credit was already included in the retained amount, leave it there. If you offered a voucher for a future purchase, track its redemption separately. That gives you a way to update the estimate once you know which costs actually materialized.
Close the report with what you can support
Keep a column for confirmed cash and labor costs and another for estimated contribution lost. Note the assumptions for costs you allocate between items. If you want to track effects such as future purchases or lost goodwill, record the evidence separately. Leave the amount open when you can’t attribute it to the incident.
Report the number of affected orders, the total impact you can support and the measurement window. Keep the peak retail exposure as a separate figure, with its own timestamp. Adding up every recheck of the same stock gap would count the same units over and over. For deciding when to recheck and when to escalate, use the guide to sync lag and real drift.
If you want to try planned alerts that surface retail exposure by SKU, you can request early access to the pilot.