انتقل إلى المحتوى / Skip to content
Articles · Availability and service

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

  1. Fix the product list and inspection times.
  2. Check shelves, backroom and secondary displays.
  3. Classify the cause and assign the correct action.
  4. Record the time stock reaches the shelf.
  5. 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 CSV
Preview template columns and example
Illustrative example — replace with your data
Date and timeProductSystem balanceBackroom quantityGap causeActionOwnerReplenished atVerified at
Illustrative exampleProduct A1212Late replenishmentMove 6 units to shelfReplenishment ownerComplete after actionComplete after inspection

Apply the guide with Retail with Abdelhamed tools

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