Plan a Black Friday or Holiday Sale with Margin, Stock and Calendar Checks

You get an offer check table showing margin and stock days per product, a recommended discount, a day-by-day launch calendar with risk flags, and fixes.

Prompt

Prompt
You are an ecommerce merchandising manager who has planned Black Friday and holiday sales for small online stores.

Help me plan my holiday or Black Friday sale. First, ask me these questions in one message and wait for my answers:
1. What do you sell, on which platform, and what are your sale dates?
2. For your top 5-10 products, what are the price, unit cost (including shipping and fees) and units in stock?
3. What are your average daily sales outside the sale, and how big is your email or SMS list?
4. What discount are you considering, and what is the latest date you could restock?

Rules:
- For every product, show margin after the proposed discount. Flag any offer that leaves under 20% margin.
- Estimate days of stock at 3x normal daily sales. Flag products that sell out before the sale ends.
- Recommend one main offer and one backup, with a one-sentence reason for each.
- Every calendar day has one task, one channel and a risk flag or "none".
- Use only my numbers and label any estimate as an estimate.

Output format:
1. Offer check table: Product | Price | Sale price | Cost | Margin after discount | Days of stock | Flag
2. Recommended offer and backup
3. Day-by-day calendar from 7 days before launch to 2 days after: Date | Task | Channel | Risk flag
4. Top 3 risks, each with a fix

End with one line on what data is missing or assumed. This is planning help, not financial advice; check tax or pricing rules with an accountant if unsure.

Example output

At a glanceMargin after 25% discount by productGift box falls under 20% margin; capped at 10% off it keeps 29%.
  • Cedar soy candle: 56.9%
  • Reed diffuser: 52.4%
  • Wax melt set: 46.7%
  • Holiday gift box: 14.8%

Example for: a Shopify candle shop, sale Nov 28-Dec 1, 25% off planned, list of 4,200 emails.

1. Offer check table
ProductPriceSale priceCostMargin after discountDays of stockFlag
Cedar soy candle$34.00$25.50$11.0056.9%23 (est.)None
Wax melt set$18.00$13.50$7.2046.7%10 (est.)None
Holiday gift box$72.00$54.00$46.0014.8%13 (est.)Margin under 20%
Reed diffuser$42.00$31.50$15.0052.4%3.3 (est.)Sells out on day 4
2. Recommended offer and backup
  • Main: 25% off sitewide, gift box capped at 10% off ($64.80, 29% margin). Keeps your best sellers aggressive without losing money on the box.
  • Backup: 20% off plus free shipping over $50. Use it if early-access sales are below 40 orders by Nov 27 midnight.
3. Calendar
DateTaskChannelRisk flag
Nov 21Confirm diffuser restock or set 20-unit limitSupplierRestock deadline
Nov 22Build discount codes and test checkoutShopifyCode errors
Nov 23Teaser email: "Sale starts Friday"EmailNone
Nov 24Schedule 4 Instagram postsSocialNone
Nov 25Pack 80 cedar candles in advanceWarehouseNone
Nov 26Early-access link to top 500 buyersEmailNone
Nov 27Check early orders vs 40-order targetShopifySwitch to backup?
Nov 28Launch email 7am, SMS 12pmEmail, SMSSite speed
Nov 29Reminder email: best sellersEmailDiffuser stock
Nov 30Gift box spotlight postSocialNone
Dec 1"Last day" email and SMSEmail, SMSNone
Dec 2Turn off codes, ship backlogShopifyLate shipping
Dec 3Review sales, margin, sell-throughSpreadsheetNone
4. Top 3 risks
  1. Diffusers sell out on day 4. Fix: limit 2 per order and add a back-in-stock form.
  2. Gift box loses money at 25%. Fix: exclude it from the sitewide code.
  3. Shipping backlog of 300+ orders. Fix: book a part-time packer for Nov 29-Dec 3.

Assumed 3x normal sales; your actual lift could differ, and shipping cost changes were not provided.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Margin after discount is calculated per product, so loss-making offers show up before launch, not after.
  • Stock days at 3x normal sales flag sell-outs early enough to restock or set purchase limits.
  • A backup offer with a clear trigger date gives you a decision rule instead of guessing mid-sale.

Use 3-6 weeks before your sale. Have unit costs, stock counts and normal daily sales for your best sellers ready. Works in ChatGPT, Claude or Gemini; paste your numbers when asked.

Common edits

  • Change the 3x sales lift to 2x or 5x based on last year's sale results.
  • Extend the calendar to start 21 days out if you need time for ads or new product photos.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Business