Choose a markdown tool: 
Excel: An Internal Tool or a Dedicated Solution

Choosing a markdown tool means, first and foremost, calculating the cost of a poorly planned markdown: giving up margin too early, applying markdowns too uniformly, leftover inventory, wasted team time, and poorly maintained 30-day reference prices.

Excel is sufficient for a small scope; the internal tool holds its own with a dedicated data team. Beyond that, a dedicated solution must demonstrate that it runs simulations, makes decisions on a per-store basis, explains its recommendations, and ensures compliance on its own.

At the end of every season, the same question comes up: when to mark down prices, by how much, and where. Many retailers still answer this question using a spreadsheet and a pricing grid that’s the same across the entire network.

This article is intended for pricing, sales, and procurement departments that are considering implementing a new system.

He compares the three options—Excel, an in-house tool, and a dedicated solution—in terms of their actual costs, and then outlines what a markdown tool must demonstrate before it is selected.

Tiered price tags on an end-of-season rack; image of a markdown tool

Markdown tool: What is it?

A markdown tool is software that determines, on a per-SKU and per-store basis, when to lower a price to move inventory and by how much, by simulating the effect of each price level on sales, margin, and remaining inventory.

It does not replace commercial policy. It replaces the way markdowns are currently determined: a spreadsheet, a standard pricing grid used across the entire network, and a lot of last-minute decisions.

A pricing or sales team looking to regain control has three options: stick with Excel, develop a tool in-house, or choose a dedicated solution.

Our beliefis this:the issue isn't the cost of the tool; it's the cost of a poorly decided markdown. As long as that cost isn't taken into account, the three options seem equally valid.

The True Cost of a Poorly Managed Price Markdown

The cost of a price reduction is reflected in the reduced margin, not in the advertised discount rate.

The mechanics of this are described in our method for moving inventory without selling it off too early. Here, the question is a different one: what is the cost of making the wrong decision?

Too early, too strong, too late: three margin leaks

Offering a discount too early means giving a discount to customers who would have bought the item at full price. Profit is lost without a single additional item being sold.

Applying too steep a discount means applying the same discount to a product that’s still selling and to one that’s not moving. The former is being sold off at a bargain price, but that doesn’t mean the latter will start selling again.

If you wait too long to mark down prices, you’ll have to push harder to move the same inventory—even though demand has already dried up. The remaining stock ends up in a clearance sale, as a donation, or as dead stock.

These three errors have a common cause: a decision made by category and applied to the entire network, even though sales are determined by brand and by retail location.

Remaining inventory and shift schedules

Inventory left over at the end of the season ties up cash and space, and then weighs on the following season.

The best approach is to plan this out weeks before the first delivery, as explained in our article, to account for remaining inventory and seasonal trends.

Then there's the least visible cost: the days spent consolidating sales, recalculating thresholds, and resending files to stores. That time isn't spent making decisions.

30-Day Reference Price: The Regulatory Cost

As of May 2022, any advertisement for a price reduction must display a strikethrough price equal to the lowest price charged in the previous 30 days.

1 in 3

One in three businesses offering price reductions was found to be in violation during the DGCCRF’s 2024 inspections, out of nearly 5,300 businesses and 350 locations inspected.
(DGCCRF, “Black Friday”: Beware of False Promises, November 2025)

When it comes to markdowns, the impact is tangible. A promotion launched a few weeks before the sales can lower the list price and reduce the discount you’re allowed to advertise.

Successive price reductions within the same transaction may retain the price from before the first reduction. However, the tool must be able to distinguish between the two cases, item by item.

The display rules are detailed in our article on genuine discounts and properly marked-down prices.

Excel, an in-house tool, or a dedicated solution: comparing the options

The three options don't cost the same, and prices vary by location. The table below compares them based on what really matters during a clearance sale season.

CriterionExcelInternal toolDedicated Solution
A Grain of DecisionOne grid per categoryThe one on the team who knows how to codeProduct Code and Retail Location
Pre-delivery SimulationManual, rarely doneTo be built and maintainedSales, Margin, and Inventory
30-Day Reference PriceVerified by handTo be developedCalculated and controlled
Team TimesRaised every seasonLow in usage, high in maintenanceFocused on the decision
Main RiskThe Average DecisionThe Author's DepartureA tool that was poorly designed from the start

Managing Markdowns in Excel

Excel has one real advantage: it's already there, and everyone knows how to use it. For a few hundred SKUs and a single retail location, it's often all you need.

Its hidden cost isn't the pricing formula error—even though that happens frequently. It's the compromise it forces: a single pricing grid, since it's not possible to recalculate each item in every store every week.

53%

53% of operations professionals encounter a spreadsheet error every week, and 22% encounter one every day.
(DOSS, Spreadsheet Errors Survey, May 2026)

The other limitations of spreadsheets—from traceability to sharing among teams—are detailed in our article on the limitations of Excel for price management.

Develop an in-house markdown tool

Building your own tool makes sense when a data team is already in place. The prototype comes together quickly, and it aligns with the company's established practices.

That's when the challenge begins. You have to model elasticity by reference, recalibrate after each season, incorporate the 30-day rule, and cope with the departure of the person who wrote the model.

Choose a dedicated markdown solution

A dedicated solution comes with proven templates, built-in compliance, and a team to maintain them. It requires a subscription fee and an implementation project.

Its value increases as the number of SKUs, retail locations, and seasons to manage grows. It increases even more if it shares the same database as your regular prices and promotions.

We make this point in our article on a single tool for pricing, promotions, and markdowns: the conflict between promotions and markdowns only becomes apparent when both decisions are made in the same place.

Which Markdown Software to Choose: What It Must Prove

In the demo, all the solutions show a nice inventory curve that drops to zero at the end of the season. What sets them apart can be seen in your history.

A viable solution must demonstrate four things before it is selected.

She runs simulations before making a recommendation. Each proposed tier must include its expected impact on sales, margin, and remaining inventory—not just a discount percentage.

She makes the right call. The same item doesn't call for the same decision in a store that's ahead of schedule versus one that's behind schedule sell-through rate. Sometimes, keeping the full price is the best decision.

She explains her recommendation. A buyer won't apply a 40% discount if they don't understand it. The factors justifying the discount must be clear.

She is solely responsible for compliance. The 30-day reference price must be calculated and verified by the tool, not checked manually the day before the sales begin.

Finding the right balance between margin and sales velocity remains a management decision.

Key Questions to Ask a Publisher

Four questions are often all it takes to decide between publishers.

What data will you start with? A solution that requires a complete historical record and a data connector before it can produce any results will delay the first useful season by a year. It’s better to start with your sales, inventory, and pricing exports.

How do you measure the gain? The margin achieved must be compared to a control group over an actual end-of-season period. This is the purpose of a well-defined pricing proof of concept (POC).

What does the tool do when the bearing isn't working? If the flow doesn't resume after a reset, the problem may be the exposure or the remaining size. A good tool will flag this instead of suggesting another reset.

Who has the final say? Minimum margin, maximum depth, excluded stores: Your rules must govern every recommendation, and your teams must approve them.

These questions apply to any tool project, as outlined in our guide to selecting and implementing a pricing tool.

Markdowns and Assortment: What the Field Data Shows

Markdowns aren't just for the end of the season. They often reveal an overly broad selection, part of which is no longer selling.

A garden center chain in the Caribbean that we are working with has set a clear goal:to reduce its product lineup from 20,000 to 12,000 items and free up 200 k€ in cash flow. This goal is currently being pursued.

Before discontinuing a product, the team first tests a price reduction and monitors the impact on sales. Price markdowns become a tool for making decisions about the product mix, not just a way to clear out the shelves.

This relationship between seasonality, inventory, and price is unique to each industry. We explore it in detail with regard to pricing in the home improvement and gardening sectors, as well as for the early detection of end-of-season items and dormant inventory.

Stand out less, or stand out better?

Our approach as practitioners: The goal is not to apply as little force as possible. It is to apply force earlier, with less intensity, and only where the flow breaks down.

That's the logic behind our Markdown and markdownofferings: the right discount, at the right time, item by item and store by store, simulated before being applied.

For the timeline and the depth of the tiers themselves, see our article on how to create a tiered markdown grid. And if you’re not yet sure where the lost margin lies, a price diagnostic can help you pinpoint it.

Would you like to know how much your price markdowns are really costing you?

Our experts work with you to simulate your end-of-season clearance prices—item by item and store by store—before any decisions are made.

Let's talk about your markdowns

FAQ: Choosing a Markdown Tool

The one that simulates the effect of each discount before recommending it, at both the product and retail levels.

A useful markdown software program does more than just suggest a percentage: it shows the expected impact on sales, margin, and remaining inventory, and explains the factors behind its recommendation.

It must also comply with your rules (minimum margin, maximum depth) and calculate the 30-day reference price on its own. The best test is still an actual end-of-season performance, compared to a control group.

Based on what a poorly decided price reduction costs today, not on a list of features.

Discounts offered too early, uniform markdowns across the entire network, remaining inventory sold at a loss, days spent on spreadsheets: these costs alone already indicate what kind of tool to look for.

Next, compare the solutions based on their ability to build on your existing export data, make decisions by retail location, explain their recommendations, and measure the gains on a control group.

By automating the calculation—not the discount itself. BOOPER first sets the acceptable end-of-season remaining inventory, then calculates the exact discount needed, item by item.

Perceived value declines when discounts are deep, consistent, and predictable. Customers then learn to wait for sales.

Tiered markdowns, triggered by actual sales volume, avoid this pitfall: they are implemented earlier, are less steep, and apply only where sales are slumping.

Products bearing the brand's logo may be excluded or subject to a cap based on a business rule. The tool also adheres to the 30-day reference price.

Results observed among our clients: an increase in profit margins ranging from +0.5 to +3 points in just a few months, across all pricing, promotions, and markdowns.

Yes, if it takes into account the flexibility of each product and the time remaining until the end of the season.

The appropriate inventory level depends on how demand responds to a price reduction, the amount of inventory to be sold, and the residual value if the product remains unsold.

A good tool recalculates weekly based on actual sales. It can also determine that no discount is needed at a store that is ahead of schedule, or that a stock transfer is more profitable than an additional discount.

Yes, on a small scale: a few hundred products and just a few retail locations.

Beyond that, the spreadsheet forces a compromise. Since we can’t recalculate each SKU in every store every week, we apply a standard pricing grid that slashes prices where the product is still selling but doesn’t go far enough where it’s not moving.

Added to this are formula errors, the consolidation period, and the manual verification of the reference price 30 days before each discount announcement.

Rarely, unless you have a dedicated data team focused on pricing over the long term.

The prototype is released quickly. The costs come later: modeling elasticity by reference, recalibrating after each season, incorporating regulatory changes such as the 30-day reference price, and maintaining the tool when its developer changes jobs.

This cost is calculated over several years, taking into account maintenance hours and the risk of relying on a few key individuals.

By calculating, for each item, the lowest price charged in the 30 days prior to the discount.

This is the price that should appear as the crossed-out price. A promotion launched shortly before the sales can therefore reduce the discount that can be displayed during the markdown.

Successive price reductions within the same promotion may retain the price from before the first reduction. A markdown tool must perform this calculation automatically, item by item, and issue a warning before a non-compliant announcement is sent to the store.

‍

Articles
similar
Three lines of light framing a negotiation area, with a price tag in the center
November 17, 2026
Minimum price: Give the salesperson a range rather than a specific price

The floor price is the price below which a sale cannot be finalized without approval. Together with a target price and a ceiling price, it forms a range that guides the negotiation without locking it in.

The sales rep retains their autonomy, the company maintains its margin, and sales that fall below the threshold become transparent. AI helps set these thresholds by customer segment, provided that the sales rep understands where they come from.

Read the blog post
A light strand connecting a series of price tags to decision points on a frieze
November 16, 2026
Price Traceability: Knowing Who Set This Price, When, and Why

The history shows what price was listed. Traceability shows who decided it, when, on what basis, and with what approval.

It is used to provide evidence during an audit, to justify a price to a supplier, a franchisee, or management, and, above all, to link each decision to its outcome. With AI, it distinguishes between what the machine suggests and what a human decides.

Read the blog post
Two meshing gears forced to rotate in the same direction; a spark at the point of contact
November 16, 2026
Automating a Vague Pricing Policy: AI Amplifies Your Contradictions

A vague pricing policy works as long as a human makes decisions on a case-by-case basis. When automated, it applies a set of priorities that no one has chosen, across the entire catalog and with every recalculation.

Conflicting objectives, implicit rules, and exceptions that have become the norm must be resolved beforehand. With AI, the stakes are even higher: a poorly defined objective is optimized with formidable precision.

Read the blog post
Ready to
 booster
What about your profit margins?

The pricing intelligence solution for retail leaders. Accuracy, speed, and controlled margins.

Let's discuss your pricing challenges
‍
‍