Inventory visibility: how many sales a single stock view of stores and warehouse brings back
Estimates what part of online orders lost to “out of stock” at the warehouse can be won back by showing and offering goods from stores: allowing for how often they are there, how accurate the records are and whether the customer agrees to collection or delivery from a store. Gives the sensitivity to customer acceptance.
At a glance
- What question does it answer?
- How many lost orders a single stock view of stores and warehouse brings back.
- What data is needed?
- Order attempts and the share of “out of stock” at the warehouse.
- How to read the result?
- Of 1,800 attempts with “out of stock” the goods really are in stores in 891; at 35% agreement 311.85 orders are won back (2.6% uplift), revenue 1.40 m, margin gain 0.61 m a month. Example on the default values: Attempts with “out of stock” a month: 1,800; Of them, the goods really are in stores: 891; Won-back orders a month: 312 orders; Order uplift: 2.6%. The figures are illustrative: enter your own to see your result.
Why and how to reason
A customer sees “out of stock” in the warehouse although the item lies in stores: a sale is lost. A unified stock view lets you show and offer goods from stores. But not everything can be recovered, only what passes four filters. Order attempts 20,000 a month, “out of stock” in the warehouse in 9% of cases, that is 1,800. The item is in stores in 55% of cases: 990. Store records are 90% accurate: really available 891. The customer agrees to pickup or delivery from the store in 35% of cases: 312 orders a month recovered. That is +2.6% to 12,000 orders, revenue 1.4 million. Margin per order after the cost premium for picking in the store = 2,025 − 70 = 1,955, margin gain 609,667 a month. The weakest link is buyer consent: so the calculation gives sensitivity to it (15, 35, 55%).
When to use it
Use it when deciding whether to show store stock on the site and connect it to online orders. It suits a retailer and a brand with stores and an online channel. It does not suit weak store records or no data on order attempts with “out of stock”. Assumptions: shares, consent and record accuracy are your estimates; the cost premium per order is constant.
How to read the result
Look at “recovered orders” and “margin gain” and at sensitivity to buyer consent: if even at low consent (15%) the gain is positive, implementation is worthwhile. Compare the gain with integration and store training costs: this is a project decision. Show store stock not as a bare number but with a reserve (for example “in stock if more than two”) so as not to promise the last piece. Check buyer consent with a test on part of the traffic. The decision: whether to launch stock display and which stores to connect first. A month after launch recalculate the result on actual data: consent and record accuracy almost always differ from the estimate.
Common mistakes
Assuming that every lost “out of stock” sale will return: in practice losses occur at each filter. Taking buyer consent from surveys rather than a test. Not including store record accuracy: when low it wipes out the benefit. Showing stock without a reserve: promising the last piece means a cancellation.
What data is needed?
- Order attempts and the share of “out of stock” at the warehouse.
- Share of cases with goods in stores, record accuracy, customer agreement.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Order attempts a month | attempts | 20,000 | Visitors who added an item to the basket or chose a size. |
| Share of attempts with “out of stock” at the warehouse | % | 9 | From your site logs. An example: enter your own data, there is no single standard in Russia. |
| Share of those cases where the goods are in stores | % | 55 | Reconciling warehouse and store stock on the same items and sizes. An example: enter your own data, there is no single standard in Russia. |
| Record accuracy in the stores | % | 90 | Share of lines where the records matched the count: see “Stock accuracy and the cost of mismatches”. An example: enter your own data, there is no single standard in Russia. |
| Customer agreement to collection or delivery from a store | % | 35 | The share who will buy rather than leave. An estimate from a test, replace with yours. An example: enter your own data, there is no single standard in Russia. |
| Orders a month now | orders | 12,000 | Orders a month now: the sales gain from showing store stock on the site is estimated from them. |
| Average order excl. VAT | ₽ | 4,500 | Excl. VAT (if you pay VAT and deduct it). Confirm your regime and rate with an accountant. |
| Gross margin | % | 45 | The gross margin in the ticket excl. VAT in percent: the benefit of the recovered sales is counted from it. |
| Extra cost from a store | ₽ | 70 | Per order: from “Ship from store or from the warehouse”. |
How it is calculated
| Step | Formula |
|---|---|
| Really available | attempts × out-of-stock share × share with goods in stores × record accuracy |
| Won back | really available × customer agreement |
| Margin gain | won back × (order margin − extra cost) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Attempts with “out of stock” a month
- 1,800
- Of them, the goods really are in stores
- 891Attempts × share with goods in stores × record accuracy.
- Won-back orders a month
- 312 orders
- Order uplift
- 2.6 %
- Won-back revenue a month
- 1.4 m ₽
- Margin per order after the extra cost
- 1,955 ₽
- Margin gain a month
- 609,667 ₽
Sensitivity to agreement
| Scenario | Agreement | Orders won back | Revenue | Margin gain |
|---|---|---|---|---|
| Low | 15 % | 134 | 601,425 ₽ | 261,286 ₽ |
| Medium | 35 % | 312 | 1.4 m ₽ | 609,667 ₽ |
| High | 55 % | 490 | 2.21 m ₽ | 958,048 ₽ |
Show a store’s stock not as a bare number but with a buffer (for example, “in stock if more than two”) so as not to promise the last piece. Whether the customer really waits for delivery from a store, test on part of the traffic.
Nuances and limits
- At record accuracy below 80% cancellations will follow.
- Test customer agreement.