In the system but missing from the shelf: diagnose availability gaps
A positive system balance does not guarantee that customers can find a product. It may sit in the backroom, another display or an inaccurate stock record. Begin with the shelf and investigate the cause before placing an order for every gap.
Edited by Abdelhamed Mohamed · Updated:Define availability before measuring it
Use a stable list of core products and important promotions. Count a product as available when customers can access saleable stock in the expected location. Keep the inspection timing consistent for meaningful comparisons.
If stock appears only on a secondary display, record that condition and check customer guidance. Exclude formally discontinued products using a clear rule; an outdated list can exaggerate active-product gaps.
Distinguish four causes
Stock may be in the backroom awaiting replenishment; in another location unknown to the team; missing despite a positive system balance; or genuinely exhausted. Each cause requires a different action and owner.
Do not close a replenishment gap with “ordered”. Do not adjust a stock record until backroom locations, displays and outstanding receipts have been checked. Correct diagnosis reduces excess orders and misleading adjustments.
Measure recovery time as well as availability
In an illustrative check of 50 products, ten are missing. Six are in the backroom, two have stock-record differences and two are genuinely out of stock. Replenishing the six raises availability from 40/50, or 80%, to 46/50, or 92%. The other four cases remain open.
Record discovery and shelf-restoration times. A good evening snapshot can hide hours of lost availability earlier in the day. Average recovery time adds context, while unusually late cases need separate attention.
Correct the order using demand evidence
Review sales rate, delivery lead time, open orders and saleable stock. Sales recorded during a stockout may understate demand. Reducing the next order from those sales alone can prolong the shortage; flag stockout days when reviewing forecasts.
While waiting, offer a suitable alternative and explain relevant differences in size, price or use. Avoid unconfirmed arrival promises. Repeated product-level complaints may reveal an issue hidden in total department sales.
Prevent the recurring gap
Inspect before and after peak trading. Assign replenishment and verification roles according to store size. Review recurring products weekly for access problems, unsuitable order thresholds or unclear ordering authority.
Close the issue using an observed result. If the same gap returns repeatedly, give it a preventive action, deadline and measurement instead of another short-lived shelf refill.
Actions to start today
- Fix the product list and inspection times.
- Check shelves, backroom and secondary displays.
- Classify the cause and assign the correct action.
- Record the time stock reaches the shelf.
- Review repeat gaps and open orders weekly.
Sample shelf availability
Available products ÷ active products inspected × 100
46 available products out of 50 = 92%. A limited promotion sample does not establish whole-store availability.
A reusable tracking template
Download the CSV and open it in Excel or your spreadsheet application. Use the template columns, replace any illustrative rows with your store data and add a row per case. Keep sensitive customer and employee information out of shared logs.
Download the tracking template CSVPreview template columns and example
| Date and time | Product | System balance | Backroom quantity | Gap cause | Action | Owner | Replenished at | Verified at |
|---|---|---|---|---|---|---|---|---|
| Illustrative example | Product A | 12 | 12 | Late replenishment | Move 6 units to shelf | Replenishment owner | Complete after action | Complete after inspection |
About this guide and its references
This practical guide is edited by Retail with Abdelhamed. Examples are illustrative, not verified results from named stores. Check your data and company policy before applying it; general guidance does not replace the requirements of your local authority.
GS1 Global Traceability Standard — Further reading on product traceability, events and data, not a source for the illustrative figures.
Report a correction or a reference that needs updating