wowprompt

Competitor price tracking sheet and repricing rules

Builds a sheet layout to track competitor prices for your key products and writes clear repricing rules with a floor price, so you match or undercut only where it still makes money. Use it when sellers on a marketplace keep undercutting you or before a sale when prices move every day.

A tracking sheet column list with formulas, a floor price calculation per product, a set of if-then repricing rules and a weekly review checklist
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Products to track: [paste product, SKU, our price, cost, fees and shipping for each]
  • Competitors and where they sell: [e.g. three named stores, two marketplace sellers]
  • Minimum margin we accept: [e.g. 15 per cent after fees]
  • Positioning: [e.g. lowest price, within 5 per cent of the lowest, premium with better service]
  • How often prices are checked: [e.g. daily, twice a week]
  • Things beyond price that matter: [e.g. delivery time, ratings, warranty, stock]

Task

Design the tracking sheet and write the repricing rules for these products.

Output format

  1. Sheet columns in order, as a table: | Column | What goes in it | Formula or rule |. Include our price, floor price, each competitor's price and delivery time, lowest price, gap to lowest in amount and per cent, suggested price and action.
  2. Floor price for each product: cost plus fees plus shipping, divided by one minus the minimum margin, with the arithmetic shown.
  3. Repricing rules as numbered if-then statements, for example: if the lowest competitor is above our floor and more than 3 per cent below us, set our price 1 unit below theirs.
  4. Exceptions: out-of-stock competitors, sellers with poor ratings, bundle offers, sale days.
  5. Weekly review checklist in five points.

Rules

  • Never suggest a price below the floor price.
  • Compare like for like: same pack size, condition and delivery promise, or note the difference.
  • Do not suggest collecting data in ways that break a site's terms; manual checks or permitted tools only.
  • Do not invent competitor prices; leave cells as [price] where none are given.

Example

Floor price: (520 + 90 + 60) / (1 - 0.15) = 788.

competitor price trackingrepricing rulesprice monitoringfloor pricemarketplace pricingecommerce pricing

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