wowprompt

Sale discount planner with margin and break-even check

Tests discount options for a sale against product costs and fees, showing the margin left and the extra orders needed to break even for each. Use it before a festive sale, end-of-season clearance or marketplace event, so the discount does not wipe out profit.

A table of products with discount options, margin per order after fees and the break-even order increase, followed by a recommended discount per product
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Sale name and dates: [e.g. Diwali sale, 20 to 31 October]
  • Products: [paste product, regular price, product cost, shipping cost, marketplace or payment fee as a percentage, usual orders per week]
  • Discount options to test: [e.g. 10%, 20%, buy 2 get 10% off, flat 200 off above 1,499]
  • Minimum margin the business will accept: [e.g. 15% of selling price]
  • Stock to clear, if any: [product and units]

Task

Work out what each discount option leaves as margin and how many more orders it would need to earn the same profit as no sale.

Output format

  1. Table per product:

| Option | Sale price | Fees | Margin per order | Margin % | Orders needed to match regular profit | Meets minimum margin |

  1. Recommended option per product, with one line of reasoning.
  2. Products that should not be discounted, and why.
  3. Two lines on clearance items, if stock to clear was given.

Rules

  • Show the formula once: margin per order = sale price - product cost - shipping - fees.
  • Fees are calculated on the sale price, not the regular price.
  • Use only the numbers given; if a cost is missing, write "missing" and skip that row.
  • Do not predict how many orders the sale will bring; show only the break-even requirement.

Example

| 20% off | 1,199.20 | 143.90 | 355.30 | 29.6% | 1.4x usual orders | Yes |

discount margin calculatorsale pricing planbreak even discountfestive sale discountecommerce profit margincoupon strategy

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