How to read shelf reports and identify problems in them: a guide for manufacturers

You regularly receive shelf reports: photos, tables, and display assessments. There is a lot of data, the numbers vary, but the main question remains unanswered: “Where exactly are we losing money, and what should we do about it?”

Shelf reports are a powerful tool if you know how to read them. But most manufacturers see only three things in them: “before/after” photos, a “good/bad” assessment, and the overall percentage of KPI completion. Behind these numbers, however, there are specific problems, each of which is taking money out of your pocket.

Let’s look at what you really need to pay attention to.

1. A photo is only the beginning, not the end of the analysis

The most common scenario: a photo of the shelf comes in, the manager looks at it — “seems fine” — checks the box and forgets about it. This is the main mistake.

One photo does not provide context. What happened before it? What does the shelf look like over time during a week or a month? What do the neighboring categories look like? What traffic does this spot get at different times?

What to do correctly: look at a series of photos over time. One shot today and another three days later already give you a picture. Is the shelf perfect on Monday and ruined by Thursday? Then the problem is not the display, but the frequency of visits or the work of the store staff.

2. The key parameter ignored by 80%

Reports almost always include a “shelf level” field: upper, middle, or lower. But few people analyze this parameter together with sales.

Meanwhile, moving a product from the lower shelf to the middle shelf gives an average sales increase of +300–500%. Moving it from the upper shelf to the middle shelf gives +150–200%. This is not theory; it is practice confirmed many times over.

Problem pattern: if your product consistently ends up on the lower shelf in 30% or more of locations, you are losing at least 20% of potential revenue, even with perfect display and price tags in place.

What to do: create a table “location → shelf level → sales for the period.” If the correlation is obvious, and sales on the lower shelf are several times lower, this is not a “store-specific feature”; it is a systemic problem that needs to be resolved through negotiations with the retailer.

3. Fake empty spaces and real out-of-stock

Reports often indicate “product availability: yes/no.” But there are two fundamentally different situations:

• Real out-of-stock: there is no product at all. The space is empty. This is a disaster — sales equal zero.
• Fake empty space: the product is available, but pushed deep into the shelf, standing behind a neighboring item, or lying in a box on the floor next to the rack. Formally, “the product is present at the location,” but the customer does not see it.

The difference can only be noticed in a high-quality photo or during a personal visit. In a report that simply has an “availability” checkmark, this problem is not reflected.

What to do: require the report to include not just a “yes/no” mark, but two separate points: “the product is visible to the customer” and “the product is available to take from the shelf.” The difference between them is exactly where your invisible losses are.

4. Shelf neighbors: who is stealing your sales

A good report shows which brands are placed to the left and right of your product. A bad one does not. And that is a serious omission.

Studies show that if a product with brighter, larger, or more aggressive packaging is placed nearby, your sales may drop by 20–40% without any other changes.

Problematic neighbors:

• a product from the same category, but from a better-known brand;
• a product with a strong price promotion;
• large packaging that visually “blocks” yours;
• a bright, loud design that pulls attention away.

What to do: identify stable “bad pairs” in the reports and set a task for the merchandiser or sales department: try moving the product on the shelf by at least 1–2 slots to the side.

5. Price tags: a small detail with major consequences

It would seem, what could be simpler than a price tag? But practice shows that in 15–20% of retail outlets, the price tag is either missing, does not match the product, is damaged, or is placed so that it cannot be seen. A customer who does not see the price simply does not put the product into the basket in 30% of cases. They will not look for a scanner or call a consultant for the sake of one item.

What to check in the report: not only the presence of a price tag, but also:

• whether it matches the product, since sometimes the price tag from a neighboring item is placed on yours;
• whether it is easy to read, not worn out, upside down, or covered by another price tag;
• whether there is information about a promotion, if one is active.

6. Trends, not one-time failures

The most common analytical mistake is reacting to a single bad report. Today the shelf is not in order, tomorrow it has been fixed — the problem is considered closed.

But real losses come from systemic failures that repeat week after week, month after month.

What to do: keep a simple table for each location: “inspection date → display assessment (1–5) → product availability → shelf level.” After just 3–4 reports, you will see:

• locations where quality is consistently low, meaning more frequent work is needed there;
• locations with strong “swings” — today 5, tomorrow 2 — which points to a problem with store staff or your merchandiser;
• locations where everything is good, where the frequency of visits can be reduced to save budget.

Checklist: how to read a report in 5 minutes and find the main problems

Take any shelf report and ask yourself five questions:

1. Geometry: what shelf level is the product placed on? If it is not on the middle shelf, this is a potential loss.
2. Availability: is the product really visible, or is it hidden in the back? The photo should show this.
3. Neighbors: who is standing nearby? Is a competitor overpowering you visually or by price?
4. Price tag: is it there, is it the correct one, and is it readable?
5. Dynamics: is this a one-time failure or a recurring problem at this location?

Brief summary

A shelf report is not just a “work completed” checkbox. It is an X-ray of your sales at each specific location. If you learn to read it correctly, you will see not just “where the display is bad,” but “where and exactly what money is lying on the floor.”

Start small: in the next report, look not at the overall score, but at the shelf level and neighboring products. Most likely, you will already find something that can be fixed without additional budgets — simply through attention and negotiations.