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
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
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 like this
Calculate Your Real Product Profit Margin After Fees, Shipping and Ads
Get a per-unit profit table for one product, covering fees, shipping and ad spend, plus your break-even ad cost per sale and break-even ROAS.
Design a Loyalty Punch-Card Program That Protects Your Margins
Get two loyalty reward structures compared by true cost per returning visit, a recommended program with card wording, anti-abuse rules and a 90-day tracking plan.
Audit an Ecommerce Product Page for Conversion Problems and Rank the Fixes
Get a 1-5 scorecard of your product page across six fixed areas, plus a ranked list of concrete fixes sorted by likely impact versus effort.
Turn Discovery Call Notes Into a Client Proposal With Three Priced Options
You get a ready-to-send client proposal that restates the problem in the client's words, then offers three options, each with an outcome, timeline and price.
Write a 3-Email Abandoned Cart Sequence That Protects Your Margins
You get three ready-to-send abandoned cart emails with send times, one objection per email, tested subject lines under 45 characters, and a discount that fits your margin.
Write a Post-Purchase Review Request Email and Follow-Up Timed to Delivery
You get a delivery-timed review request email, one follow-up, a send-timing table, and a quick check that the emails avoid incentives and review gating.