Fill in these first
- Product category: [e.g. ready-to-eat breakfast cereal]
- Stores visited: [paste rows: store name, type such as supermarket, kirana or chemist, city area, date]
- Products seen: [paste rows: brand, variant, pack size, MRP, selling price, offer, shelf level such as eye level or bottom, number of facings]
- Your product, if planned: [variant, pack size, intended price]
- What you want to decide: [e.g. launch price and pack size for a 300 g pack]
Task
Build a clear picture of the shelf so the price and pack decision is based on what buyers actually see.
Output format
- | Brand | Variant | Pack size | Selling price | Price per 100 g or per unit | Offer | Shelf level | Facings | Stores seen in |
- Price ladder: products ordered from cheapest to most expensive per unit, grouped into value, middle and premium bands.
- Patterns: the pack sizes most brands use, how often offers appear, which brands own eye level.
- Gaps: price bands or pack sizes with few or no products, and whether the gap looks like an opportunity or a sign of weak demand.
- If a product is planned: where it would sit on the ladder and two price options with the reasoning.
- What to check on the next round of visits.
Rules
- Work out price per unit from the selling price, not the MRP, and show the sum for one example.
- Mark any product seen in only one store as a single sighting.
- Use only the products and prices pasted; do not add brands from memory.






