Browse All

5 Claude Prompts Every Retail Planner Should Be Running on Monday Morning

5 Claude Prompts Every Retail Planner Should Be Running on Monday Morning

Written by

Steph Byce

Director of Demand Gen

Table of contents

Category

Learning Series

5 Claude Prompts Every Retail Planner Should Be Running on Monday Morning

Retail planners are already using AI, through vendor features, through ChatGPT, through Copilot. The question isn't whether to use it. It's whether you're using it for the right things.

Most planning workflows still have a gap between what your planning tool automates and what a general AI search can answer. The analytical middle ground, recaps, gap analysis, forward projections, markdown timing, is where Claude earns its place. These prompts are designed to bridge that gap. Paste your data, run the prompt, act on the output.

Prompt 1: Write the Monday Exec Recap

Prompt 1 Weekly Exec Recap

Here is last week's demand data by division vs. the same week last year [paste or upload your data]. Write a concise executive summary: what beat plan, what missed, and the 3 things leadership needs to know going into this week.

Replace the bracketed text with your export or paste inline.

Why it Works

The Monday recap is one of the most time-consuming low-value writing tasks in planning. The analysis is already in your head — you just need the summary. Claude turns your data into a clean, structured narrative in under a minute. Review, adjust, send.

Prompt 2: Run the Inventory Health Check

Prompt 2 Inventory Health Check

Here is my current on-hand by category and my last 4 weeks of sales [paste your data]. Flag categories where I'm at risk of a stockout before end of season, and categories where I'm carrying excess relative to trend.

Replace the bracketed text with your export or paste inline.

Why it Works

This is the audit most planners run mentally, or spend an hour doing manually in a spreadsheet. Structured as a prompt, it forces the inputs to be explicit and surfaces the same answer faster with documentation you can act on or share.

Inventory Risk by Category

Current on-hand vs. last 4-week sales rate  ·  ~13 weeks remaining in season

2 Stockout Risk
3 Watch List
2 Seasonal Excess
Season end  ~13 wks
Category Weeks of supply (max 15) WOS On-hand Wkly avg Status
Knits
5.5w
5.5WOS
23,364units
4,219/ week
Stockout Risk
Tops
8.5w
8.5WOS
13,866units
1,631/ week
Stockout Risk
Sneakers
9.2w
9.2WOS
24,024units
2,612/ week
Watch
Bags
9.8w
9.8WOS
98,937units
10,055/ week
Watch
Bottoms
9.8w
9.8WOS
85,284units
8,695/ week
Watch
Outerwear
10.0w
10.0WOS
34,510units
3,463/ week
Seasonal Excess
Boots
11.5w
11.5WOS
78,530units
6,842/ week
Seasonal Excess

Prompt 3: Build Your Markdown Shortlist

Prompt 3 Markdown Shortlist

Here are my current sell-through rates, on-hand units, and weeks remaining by item [paste your data]. Which items should I be considering for a price action this week, and what's the projected sell-through impact?

Replace the bracketed text with your export or paste inline.

Why it Works

Markdown decisions are often made on instinct shaped by experience. This prompt doesn't replace that judgment — it puts the data in front of the decision faster. You get a prioritized shortlist with projected impact, not just flags, before your Monday meeting.

Prompt 4: Explain the Plan vs. Actuals Gap

Prompt 4 Plan vs. Actuals Gap

Here is my plan for the week vs. what actually sold [paste your data]. Where is the gap largest? For anything more than 10% below plan, what are the most likely explanations based on the data?

Replace the bracketed text with your export or paste inline.

Why it Works

Every planner answers this question every Monday. This prompt changes how long the answer takes, and how much of the explanation writing you have to do yourself. Useful both for internal clarity and for the narrative you bring into your review call.

Prompt 5: Run the Forward Projection Sanity Check

Prompt 5 Forward Projection

Based on these trends through today [paste your data], what is my most likely end-of-season outcome for demand $, units, and margin? What would need to be true to still hit the original plan?

Replace the bracketed text with your export or paste inline.

Why it Works

This is the most valuable prompt on the list. Knowing in February what your May closeout looks like, while there's still time to act, is the difference between a reactive season and a managed one. Run it weekly, not once.

A Note on Data Quality

Claude works with what you give it. A clean, well-structured export produces useful output. A messy file with inconsistent naming and missing fields produces output that reflects that. The prompts above are starting points — refine them for your categories, your data structure, and your reporting cadence.

The planners getting the most out of this have iterated over a few weeks. The first attempt won't be perfect. Neither will the second. But the workflow compounds.

Getting More Out of These Retail Claude Prompts

A few principles that apply across all five:

  • Give it your actual numbers, not summaries. Claude needs raw material to generate real, specific answers, not paraphrased context.
  • Use your own terminology. If you call it "end of month receipts" or "OTB variance," use that. Claude mirrors your language back.
  • Iterate. Take the first output as a draft. Adjust tone, add context, correct anything that doesn't reflect your category's reality.
  • The more context you give Claude about your brand, your customer, and your planning cadence, the more specific, and useful, the output becomes.

Relevant Blog Posts