wowprompt

Retail shelf audit of competing products with price per unit

Turns notes and photos from store visits into a shelf audit of a product category: which brands are stocked, pack sizes, price per 100 grams or per unit, shelf position, offers and gaps where a new product could fit. Use it before launching a packaged product, setting a price or pitching a retailer.

A table of competing products with pack size, price and price per unit, shelf position and offers, a price ladder, and the gaps a new product could fill
The output this prompt produced, unedited.

The prompt

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

  1. | Brand | Variant | Pack size | Selling price | Price per 100 g or per unit | Offer | Shelf level | Facings | Stores seen in |
  2. Price ladder: products ordered from cheapest to most expensive per unit, grouped into value, middle and premium bands.
  3. Patterns: the pack sizes most brands use, how often offers appear, which brands own eye level.
  4. 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.
  5. If a product is planned: where it would sit on the ladder and two price options with the reasoning.
  6. 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.
shelf auditretail store checkprice per unit comparisoncompetitor pack sizesfmcg market researchstore visit research

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity