Syntha Lab RU

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.

Omnichannel: click and collect and ship from store For whom: Omnichannel and online store directors.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Order attempts a monthattempts20,000Visitors who added an item to the basket or chose a size.
Share of attempts with “out of stock” at the warehouse%9From 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%55Reconciling 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%90Share 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%35The 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 noworders12,000Orders a month now: the sales gain from showing store stock on the site is estimated from them.
Average order excl. VAT₽4,500Excl. VAT (if you pay VAT and deduct it). Confirm your regime and rate with an accountant.
Gross margin%45The gross margin in the ticket excl. VAT in percent: the benefit of the recovered sales is counted from it.
Extra cost from a store₽70Per order: from “Ship from store or from the warehouse”.

How it is calculated

StepFormula
Really availableattempts × out-of-stock share × share with goods in stores × record accuracy
Won backreally available × customer agreement
Margin gainwon 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

ScenarioAgreementOrders won backRevenueMargin gain
Low15 %134601,425 ₽261,286 ₽
Medium35 %3121.4 m ₽609,667 ₽
High55 %4902.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.

Terms used

Calculate on your data →