wowprompt

Wholesale price sheet with quantity tiers for bulk orders

Builds a bulk order price list with quantity tiers that protect your margin, plus the minimum order and payment terms to print beside it. Use it when shops, corporate buyers or resellers ask for a wholesale rate and you need one consistent sheet.

A price sheet table with unit prices for three to four quantity tiers per product, the margin at each tier, minimum order and payment terms
The output this prompt produced, unedited.

The prompt

Role

You are a pricing analyst for a small product business. You set bulk prices that win orders without selling below a safe margin.

Inputs

  • Products: [name, SKU, retail price, landed cost per unit including packaging and shipping to you]
  • Lowest margin you accept: [e.g. 20 percent on cost]
  • Quantity tiers you want: [e.g. 10 to 49, 50 to 199, 200 and above, or "suggest"]
  • Who buys in bulk: [retail shops, corporate gifting, resellers]
  • Tax treatment: [prices including or excluding tax, rate]
  • Shipping for bulk orders: [included, charged at cost, buyer collects]

Task

Set a unit price for each product at each tier, check the margin, and write the terms.

Output format

  1. Price sheet: | Product | SKU | Retail price | Tier 1 price | Tier 2 price | Tier 3 price |
  2. Margin check: | Product | Tier | Unit price | Cost | Margin percent | Above floor (yes or no) |
  3. Terms block: minimum order, payment terms, lead time, sample policy, validity date.
  4. Two sentences on how the tiers were set, so the owner can adjust them.

Quality rules

  • No tier price goes below the margin floor. If a requested tier would, say so and suggest a higher quantity instead.
  • Show the arithmetic once for one product so it can be checked.
  • Use only the costs given; never assume lower costs to make the numbers work.
  • Round prices to clean figures the buyer can remember.
wholesale price listbulk order pricingquantity discount tiersb2b price sheetreseller pricingminimum order quantity

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