The Right Markdown Date

Right Markdown Date

The Right Markdown Date Is Hidden in the Selling Window

A store manager looks at a rack of seasonal jackets and says, “They’ve only been here five weeks. It’s too early to mark them down.”

That sounds reasonable if the decision is about how long the jackets have been in the store. But the business problem is how much useful selling time they have left.

Merchandise can still feel new while its opportunity to sell at the current price is running out.

The better question is: Will this stock sell through before customers stop having a good reason to buy it?

That changes markdown timing from a reaction to ageing merchandise into a comparison between inventory and opportunity.

Compare the stock clock with the selling clock

Every seasonal product has two clocks running.

The stock clock measures how long your inventory would take to sell at the current sales rate:

Weeks of inventory = units available ÷ units sold per week.

The selling clock measures the realistic weeks remaining in which customers are likely to buy that merchandise on acceptable terms.

If you have 240 units and sell 30 each week, you have eight weeks of inventory. If only five useful selling weeks remain, your stock needs more time than the market is likely to give it.

You don’t need the product to look tired to recognise the mismatch.

Markdown pressure begins when the stock needs more selling time than the product has left.

That’s a signal to investigate, not an automatic instruction to discount. Sales might accelerate. You might transfer stock to stores with stronger demand.

A presentation problem might be suppressing sales. But continuing at the same price now requires a credible explanation for how the gap will close.

“We still have time” isn’t that explanation. You need to know how much time, at what sales rate.

The selling window also isn’t necessarily the number of weeks until the season officially ends. Customers may stop buying spring jackets well before summer begins.

Holiday decorations lose much of their appeal before the holiday itself. An incoming range may displace the current collection from its strongest position.

The calendar gives you an outside boundary. Customer demand and store conditions determine how much of that time is commercially useful.

Make waiting prove its case

Consider a hypothetical apparel store with 180 lightweight spring jackets remaining.

The jackets have sold at an average of 20 units a week over the last three reasonably comparable weeks.

The manager expects six useful selling weeks before warmer weather and the summer assortment weaken their appeal.

At the current rate, the store holds nine weeks of inventory:

180 ÷ 20 = nine weeks.

It has six weeks of selling opportunity.

If the current pace continues, it will sell 120 jackets and have 60 left when the useful window closes. That’s a planning estimate, not a prediction.

Its value is that it makes the consequence of waiting visible.

The manager now has a second calculation:

Required weekly sales = units remaining ÷ useful selling weeks remaining.

To sell all 180 jackets within six weeks, the store needs to sell 30 a week. That’s 50% above its current pace.

The decision becomes sharper: what will produce those additional ten sales each week?

Perhaps the jackets were poorly positioned and a better display can improve their visibility. Perhaps a planned event will bring relevant customers into the store.

Perhaps another location is selling the same style faster.

Each possibility deserves examination. None should be counted as extra demand simply because it would make the numbers more comfortable.

Suppose the manager waits two weeks without changing anything. The store sells another 40 jackets.

It now has 140 jackets and four useful weeks remaining. The required rate has risen to 35 a week, 75% above the original pace.

Waiting has made the job harder even though inventory has fallen.

That’s the mechanism managers often miss. Selling some units doesn’t necessarily improve your position.

If selling opportunity disappears faster than stock, the remaining inventory becomes more difficult to clear.

A falling stock count can hide a worsening clearance problem.

An earlier, measured price reduction might have allowed the store to test customer response while there was still time to adjust. It wouldn’t guarantee a successful sell-through.

But delaying the decision has removed two weeks in which the manager could learn, respond and sell.

Give the selling window an honest value

The comparison is only useful if both sides are realistic.

Start with the sales rate. One unusually strong promotional week can make inventory look healthier than it is. A week affected by stock being kept in the back room can make demand look weaker than it is.

Use recent, comparable weeks, then examine what influenced them. Were key sizes available? Was the merchandise accessible? Was the price consistent? Did an event temporarily lift traffic?

You’re trying to estimate the pace you can reasonably expect under current conditions.

Then examine the remaining weeks. They rarely have equal selling power.

If jacket demand is already softening as temperatures rise, six calendar weeks shouldn’t automatically become six weeks at the present rate. Ask what happens if sales slow.

If colder weather could extend demand, consider that possibility without making it the only plan.

A simple range can be enough: current pace, slower pace and a plausible stronger pace. If the stock fits only under the strongest scenario, maintaining price is a bet on favorable conditions.

That may be a defensible bet. It should be recognized as one.

Aggregate inventory can also conceal the real problem. A style may appear to have six weeks of stock overall while the remaining units are concentrated in sizes that sell slowly.

The average rate achieved with a balanced size range may no longer apply.

The question is whether the stock you actually have left can sell within the remaining window.

Use the gap to choose the next action

You don’t always need to finish with zero units. A small carryover may be acceptable for a continuing product. A seasonal line with little future demand may need a much tighter exit target.

Set that target explicitly. If the jacket store is comfortable retaining 20 units, it needs to sell 160 in six weeks, roughly 27 a week. That’s still above its current pace, but it’s a different problem from requiring 30.

Now ask whether an intervention can credibly achieve the required rate.

If you test a display change before reducing price, give the test a deadline. “Let’s improve the display” is incomplete.

“Let’s measure sales for one week, then recalculate the required pace” preserves accountability to the selling window.

Apply the same discipline to a markdown. A reduction isn’t progress merely because the ticket price changed.

It needs to generate a sales rate that brings inventory back towards the exit target. If it doesn’t, the remaining time keeps shrinking.

Earlier action also carries a tradeoff: you may reduce margin on units that would have sold at full price.

The purpose of this comparison is to expose that tradeoff while you still have choices, not to declare that earlier discounts are always better.

Before leaving a seasonal line at its current price, write down its remaining units, realistic selling weeks, acceptable closing stock and required weekly sales.

Compare that requirement with the pace the remaining assortment can support.

Then apply one rule: If you can’t explain credibly how the stock will reach its exit target within the selling window, don’t let waiting remain the default decision.

AI Diagnosis

AI Prompt

Assess whether keeping my merchandise at its current price has a credible path to my inventory exit target before its useful selling window closes: [Describe your merchandise, remaining units, recent weekly sales, realistic selling weeks remaining and any acceptable closing stock, plus relevant demand changes, size imbalances or planned interventions. Example: We have 180 lightweight spring jackets remaining. Sales over the last three weeks were 22, 19 and 19 units at the same price. We estimate six useful selling weeks before warmer weather and our summer range reduce demand. We can carry over 20 units. Most remaining jackets are small and extra-large. We’re considering a better entrance display or a markdown, but have no evidence yet of how either will affect sales.] Compare the stock clock with the selling clock using recent comparable sales, and flag anything that makes the observed rate unreliable for the assortment remaining. Show a compact calculation table with current weekly sales, weeks of inventory, required weekly sales to reach the exit target, the percentage increase needed and estimated closing stock if the current pace continues. Then calculate how waiting two weeks at that pace changes the required weekly sales, provided the selling window allows it. If demand may weaken, include one clearly labelled illustrative slower-sales scenario without treating it as a forecast. Distinguish evidence from assumptions, and don’t invent missing figures; where essential information is absent, explain the calculation that remains unresolved and give the strongest conditional assessment possible without asking follow-up questions. Finish with a concrete decision: whether holding price is supported, whether a short test is justified or whether intervention is needed now. Tie that decision to the sales pace required, give any test a deadline within the remaining window and state the measurable result that would justify continuing. Don’t invent a discount percentage or assume a markdown will produce a particular sales lift.

AI Output

Using the spring-jacket example supplied, holding the current price without intervention isn’t supported by the numbers.

A short display test is justified, but it needs a one-week deadline and a measurable sales target.

Measure Calculation Result
Current weekly sales (22 + 19 + 19) ÷ 3 20 units
Weeks of inventory 180 ÷ 20 9 weeks
Useful selling window Supplied estimate 6 weeks
Units to sell to reach exit target 180 − 20 160 units
Required weekly sales 160 ÷ 6 26.7 units
Increase needed over current pace (26.7 ÷ 20 − 1) × 100 33.3%
Estimated closing stock at current pace 180 − (20 × 6) 60 units
Stock above acceptable carryover 60 − 20 40 units

Your inventory needs nine weeks to sell completely at the observed pace. Even allowing the 20-unit carryover, you need eight weeks to reach your target. You estimate only six useful weeks remain.

What waiting two weeks does

If you sell 40 jackets over the next two weeks, you’ll have 140 remaining and four useful selling weeks left.

To finish with 20 units, you’ll then need to sell:

(140 − 20) ÷ 4 = 30 jackets a week.

The required increase rises from 33.3% now to 50% after waiting. Your stock count improves, but the pace needed to avoid excess carryover becomes more demanding.

What could make the baseline too optimistic

The three supplied weeks show a reasonably consistent sales pace at an unchanged price. However, they don’t establish that the remaining assortment can sustain it.

Most remaining jackets are small and extra-large. If earlier sales included a broader size selection, the 20-unit average may overstate demand for what’s left. Sales by size would help determine that, but those figures weren’t supplied.

The six-week window is also a planning estimate. Warmer weather and the summer range could weaken demand before it ends. Neither the display change nor a markdown has a demonstrated sales lift in the information provided.

Illustrative slower-sales scenario, not a forecast

Suppose sales average 16 jackets a week, an assumed 20% reduction from the recent pace.

Over six weeks, you’d sell 96 jackets and finish with 84 units, which is 64 above your carryover target. This illustrates your exposure to softer demand; it doesn’t predict that outcome.

Decision: intervene now with a tightly timed display test.

Improve the entrance display and measure sales for one week. The minimum numerical result that supports continuing at the current price is 27 jackets sold, with sales coming from the sizes you actually need to clear.

After selling 27, you’d have 153 jackets and five weeks remaining. Reaching the 20-unit exit target would still require 26.6 sales a week. One successful week therefore supports continuing only if that pace remains credible. It doesn’t resolve the problem permanently.

If the test falls short, reassess price or another concrete intervention immediately. For example, selling only 20 leaves 160 jackets and five weeks, raising the requirement to 28 a week.

Keep the current price only while the remaining assortment can credibly achieve the recalculated required pace. A lower stock count alone isn’t evidence that waiting is working.