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
- 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.
- Floor price for each product: cost plus fees plus shipping, divided by one minus the minimum margin, with the arithmetic shown.
- 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.
- Exceptions: out-of-stock competitors, sellers with poor ratings, bundle offers, sale days.
- 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.






