Build a tiered seasonal clearance markdown plan

Plan a phased stock liquidation calendar using staged markdowns, bundles, and segmented emails instead of immediate deep discounts.

Prompt

Prompt
Act as an inventory merchandising planner. Build a 4-week staged clearance plan to liquidate slow-moving inventory without collapsing overall store margins.

Rules:
- Stage discounts in three distinct phases: private VIP access/bundling, public modest markdowns, and final clearance.
- Include bundle mechanisms (e.g., buy 2 get 1, mystery packs) before straight percent-off cuts to keep average order value steady.
- Include margin guardrails specifying when to stop discounting and consider liquidator donation or tax write-offs.
- Avoid generic buzzwords.

Output format:
Inventory summary and objectives
Phase-by-phase clearance schedule (Table: Week, Stage Name, Offer Structure, Target Audience, Promotion Channel)
Bundle concepts (3 concrete packaging ideas)
Stock exit rules (conditions to halt markdowns)

My inventory list, units remaining, and current retail prices are below:

Example output

Example for: 400 remaining units of winter knitwear and wool beanies

Inventory summary and objectives:
Liquidate 400 surplus units of cold-weather knitwear within 28 days to free up working capital for spring stock arrivals. The target is recovering at least 1.4x landed unit cost across the run while preserving brand equity.

Phase-by-phase clearance schedule:

WeekStage NameOffer StructureTarget AudiencePromotion Channel
Week 1Secret Stockroom SaleBuy 2 get 1 free on all knitwearTop 20% past buyersVIP email list & SMS
Week 2End-of-Season Event25% off single units, 35% off setsAll newsletter subscribersSite banner & newsletter
Week 3Clearance Markdown40% off sitewide on winter tagsGeneral public & socialInstagram & retargeting
Week 4Final Vault ClearanceFixed pricing ($15 beanies, $30 knits)Bargain segment & churned buyersDedicated last-chance email

Bundle concepts:

  • Winter Warmth Duo: Pair one slow-moving heavy sweater with one high-margin beanie for a flat $55 bundle.
  • 3-Pack Cold Essentials: Allow customers to pick three assorted color beanies for $36 (cost recovery focus).
  • Winter Mystery Add-on: Offer a surprise beanie at checkout for $10 on orders over $50.

Stock exit rules:

  • Stop discounting if individual item margin dips below landed product cost plus $2 pick/pack fee.
  • After Week 4, pull remaining stock under 20 units and donate for year-end inventory tax deduction rather than running margin-negative shipping.
Written by AI from this prompt. Your results will vary.

Paste your list of excess inventory, unit counts, unit costs, and current retail prices into ChatGPT, Claude, or Gemini. Ask the model afterward to draft the subject lines and preview text for the VIP announcement email.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in E-commerce
E-commerce

Write holiday gift bundle product copy

Turn standard multi-item listings into appealing, gift-ready holiday packages. Perfect for Q4 ecommerce merchandising and seasonal promotions.

E-commerce

Create a home goods dimension and fit guide

Turn raw product dimensions into clear, shopper-friendly placement instructions. Ideal for furniture, storage, and home decor listings to reduce dimension-related returns.