Store Stockout: Check Promoted Product Before Blaming Demand

A promoted product missing from the store shelf is an execution or supply problem before it is a demand problem. Check the shelf and backroom, the store order and receipt, distributor on-hand and in-transit stock, and the promotion eligibility dates before drawing demand conclusions.

A promoted product missing from the shelf is an execution and supply question before it is a demand question. Work the chain in a fixed order: check shelf and backroom stock, the store order and receipt, distributor on-hand and in-transit stock, and the promotion eligibility dates. Only then discuss demand. This sequence prevents a common error: treating a stockout as evidence that demand exceeded supply, or writing off the campaign, when the real cause was a missed order, a short delivery or a promotion that started before stock arrived.

1. Confirm shelf and backroom stock.
2. Trace the store order, delivery and receipt.
3. Separate store, distributor and supplier stock positions.
4. Log the incident and assign ownership.
5. Interpret campaign results against actual availability.

1. Confirm the store stockout and check the backroom

A gap on the shelf is not yet a confirmed stockout. The product may be in the backroom, on a secondary display, in a different facing, or blocked by other stock. The field check should record what is visible and what is physically available.

• Count facings and units on the shelf for the promoted SKU, and note adjacent substitute products.
• Check the backroom, storeroom and any secondary display, including unopened cases.
• Record the date code and the last delivery date the store can confirm.
• Ask store staff whether the item was received and put out, and whether it was moved.
• Check two or three nearby stores on the same route to see whether the gap is local or wider.

If backroom stock exists, the issue is replenishment or merchandising, not supply. If the shelf and backroom are both empty, move to the order and receipt record.

2. Trace the store order, delivery and receipt for the promoted SKU

Store-level stockouts often start in the order-to-receipt chain. Check whether an order was placed for the promoted SKU, what quantity was confirmed, what was delivered and what was received. A confirmed order is not a delivered order, and a delivered order is not a receipt posted at the store.

• Order date, order number and quantity requested for the promotion.
• Confirmed quantity and any cut-off or allocation applied by the distributor.
• Delivery note quantity, short-delivery note or refusal reason.
• Receipt date at the store and whether the delivery was posted against the store record.
• Promotion start and end dates, and whether the store was on the target list and eligible for the offer.

3. Separate store, distributor and supplier stock positions

A shelf stockout means the product is not available to the shopper at the point of display. A backroom stockout means there is no stock in the backroom. A distributor stockout means the distributor has no available stock to fulfil store orders. These are different failures and need different owners.

At distributor level, check on-hand quantity by SKU and batch, reserved or allocated stock, open orders and in-transit shipments. Physical stock may not match the system record; returns, damaged stock and unposted receipts can all create a gap. A stock record that does not reconcile should be treated as a separate investigation, not as proof that stock exists or is missing. See why distributor stock records do not match physical inventory for a structured reconciliation approach.

4. Log the incident and assign owned next steps

A stockout that is not logged becomes an anecdote. Use one incident record per store, SKU and promotion so that field, distributor and trade marketing teams work from the same facts.

• Date and time of the check, store ID and location, field rep name.
• Promotion ID, SKU, pack size and promotion dates.
• Shelf quantity, backroom quantity and secondary display quantity.
• Last confirmed delivery date and receipt status.
• Order number, confirmed quantity and delivered quantity.
• Distributor on-hand, reserved stock and in-transit quantity.
• Root-cause category: shelf replenishment, order, short delivery, distributor stockout, inbound delay, eligibility or targeting.
• Evidence: photo of shelf and backroom, delivery note, order record and stock report.
• Incident owner, due date and next review date.
• Resolution and whether the store can still execute the promotion within its eligibility dates.

Assign one incident owner. The field rep owns the shelf and backroom check and the store conversation. Distributor operations owns the order, pick, delivery and stock record. The supplier or supply planning team owns inbound availability where the distributor has no stock. Trade marketing owns the promotion dates, target list and any decision to extend, substitute or close the offer. If promotion terms or dates change while the incident is open, record the change and the version that applies so the store, distributor and claim reviewer use the same conditions; version control for changes to a live trade promotion explains the control points.

5. Interpret campaign results against actual availability

A promotion planned for 100 stores but available in 70 does not have the same exposure as the plan. Sales results, execution rates and claim evidence should be read against the stores and dates where the promoted product was actually available, not only against the target list.

Do not convert a stockout into a lost-sales estimate without an agreed baseline, a defined period and transaction data. It is defensible to report the number of store-days without availability and the stores affected; it is not defensible to invent a sales loss from a shelf gap. Evaluation also needs an agreed cost scope and treatment of other influences before anyone attributes a sales change to the promotion.

For claim review, a store without the promoted product cannot show the promoted offer on shelf for that period. Review execution evidence by store, campaign and period, and separate task completion from reviewer acceptance and business outcome. Store trade promotion claim reconciliation sets out the approved-conditions review that this evidence feeds.

Where Airpalm fits

Airpalm publicly describes mobile visits, route planning, store audits, sales orders, inventory and promotion management (airpalm.com, checked 9 October 2026). In a stockout investigation, those records can support the fieldwork and the incident trail, but they do not by themselves prove live inventory visibility or automatic replenishment. Ask a vendor to demonstrate the supported data sources, role permissions, exception handling and what is standard versus configured. See Airpalm for the publicly described scope.

A practical next step is to run the diagnostic table on the next five promoted-product stockout reports and record which link in the chain failed. That gives trade marketing and distributor operations a factual basis for fixing the process before the next promotion.

Frequently asked questions (FAQ)

Should we stop the promotion when a store is out of stock?

There is no automatic rule. Decide with trade marketing based on the promotion eligibility dates, whether supply can recover in time and whether the store can still execute the offer. Log the gap and do not treat unstocked stores as executed.

How do we tell a shelf stockout from a distributor stockout?

Check the shelf and backroom first. If both are empty, check the order and receipt. If the store ordered and received the product, the break is at store level. If the distributor has no available stock or the shipment is still in transit, the break is upstream.

Can we estimate lost sales from a promoted stockout?

Not reliably without an agreed baseline, a defined period and transaction data. Report observed store-days without availability and the stores affected. Do not invent a lost-sales figure from a shelf gap alone.

Who should own the fix for a promoted stockout?

Assign one incident owner. Field sales owns the shelf and backroom check, distributor operations owns the order and warehouse record, supply planning owns inbound availability, and trade marketing owns promotion dates and eligibility decisions.