零售业降价优化：从被动到主动

DATA + AI SUMMIT ![Image 3: Data+ai summit promo JUNE 15–18|SAN FRANCISCO Join us at the world’s largest data, apps and AI event. Register](https://www.databricks.com/dataaisummit?itm_source=www&itm_category=home&itm_page=home&itm_location=navigation&itm_component=navigation&itm_offer=dataaisummit)

Table of contents

Retail & Consumer GoodsMay 11, 2026

Retail markdown optimization: from reactive markdowns to proactive

Industry Outcomes: The difference between a strategic price adjustment and a forced markdown is often just data latency, and that gap is closable.

by Sarah Duffy

Summary

Chief Merchandising Officers (CMOs) are forced to make high-stakes buying decisions using slow, weekly batch reports, leading to heavy inventory and markdowns when market trends shift unexpectedly.
The challenge lies in synthesizing critical data—including trends, inventory position, and pricing—simultaneously for complex categories, which analytical tools built for a slower era cannot manage.
Databricks Genie for Merchandise Intelligence gives leaders instant, natural language access to their full data environment, enabling them to spot trend deceleration sooner, redirect open-to-buy capital, and hold better margins.

USE CASE

Assortment & Pricing Intelligence

Every Chief Merchandising Officer (CMO) has a version of the same story. A category is trending strong in week four of the season. Buying decisions build on that early signal. Six weeks later, the trend shifts, inventory is heavier than planned, and the markdown conversation begins.

This isn’t a reflection of poor judgement. It's the natural consequence of making high-stakes, high-velocity decisions with analytical tools built for a slower era. When the feedback loop between what's selling and what's being bought runs on weekly batch reports, even the best merchants are working with yesterday’s picture.

What is Markdown Optimization?

Retail markdown optimization is the practice of strategically reducing prices on slow-moving or end-of-life inventory to maximize gross margin while clearing stock by a target date. Rather than blanket discounts, optimization uses demand forecasts, sell-through rates, weeks of supply (WOS), and price elasticity models to recommend the right markdown depth on the right SKUs at the right time. Done well, it can lift margin rates versus reactive end-of-season markdowns.

Where Retail Markdown Optimization Breaks Down

Merchandising decisions sit at the intersection of trend data, inventory position, sell-through velocity, supplier lead times, and competitive pricing signals. Synthesizing all of that simultaneously — for a category with hundreds of SKUs, across dozens of locations — is exactly the kind of challenge where better data access creates outsized impact.

The Four Markdown Decisions

Which SKUs: Not every slow mover warrants a markdown. Merchants must weigh sell-through velocity, weeks of supply, and trend trajectory to decide which products to act on.
When to start: Timing is everything. Marking down too early sacrifices margin, too late forces deeper cuts and leaves less selling time.
How deep: The discount has to be large enough to actually shift demand, but calibrated against remaining inventory, price elasticity, and margin targets.
Where: The same SKU can be overstocked in one region and selling well in another, so markdown decisions often need to be made at the store or cluster level.

The real opportunity isn’t avoiding every markdown. The opportunity is closing the gap between when the data shows a shift and when the merchandising team can act on it.

Genie for Markdown and Merchandise Intelligence

Databricks Genie enables merchandising leaders to interrogate their entire data environment in natural language. A CMO can ask: 'Which categories are showing week-over-week sell-through deceleration greater than 10%, and what's our current inventory cover at current sell-through rates?' That question surfaces in seconds.

Customer Story

Turning Questions into Decisions with Databricks Genie

Coop, a cooperative retailer owned by over 4 million members, used Databricks Genie to build "AskCap" — an AI-powered assistant embedded in Microsoft Teams that lets employees query enterprise data using plain-language questions. The result: a 30% retention rate among internal users, with managers and executives now getting instant answers on deep store and market share intelligence without touching a single dashboard.

Read the full story

Why Earlier Markdown Decisions Protect More Margin

Retail competitive advantage has always had a timing dimension. The CMO who can redirect open-to-buy six weeks earlier — because they spotted the trend deceleration sooner — takes a better position on markdowns, holds more margin, and reallocates that capital to the categories that are winning. Genie doesn't make the buying decision. It gives your merchandising leaders the real-time clarity to make those decisions with confidence.

DATABRICKS GENIE · KEY DIFFERENTIATORS

Built for your data, governed by your rules, answerable to any business leader.

Unified commerce data: Genie queries across e-commerce, stores, and wholesale channels in a single conversation — no channel-switching.
Supplier data integration: Lead times and fill rates live in the same analytical environment as sell-through and margin data.
Margin-aware answers: Questions about inventory automatically include margin context — decisions are grounded in financial impact, not just units.
Historical pattern recognition: Genie can compare current sell-through patterns to comparable seasonal periods without requiring custom data pulls.

See What Genie Can Do for Your Team

Databricks Genie is available today. See how your industry peers are using it to reimagine how they access and act on their data.

Get the latest posts in your inbox

Subscribe to our blog and get the latest posts delivered to your inbox.

Sign up

*

Work Email

*

Country Country*

By clicking “Subscribe” I understand that I will receive Databricks communications, and I agree to Databricks processing my personal data in accordance with its Privacy Policy.

Subscribe

View all blogs

Image 4: databricks logo

Why Databricks

Discover

Customers

Customer Stories

Partners

Why Databricks

Discover

Customers

Customer Stories

Partners

Product

Databricks Platform

Pricing

Open Source

Integrations and Data

Product

Databricks Platform

Pricing

Open Source

Integrations and Data

Solutions

Databricks For Industries

Cross Industry Solutions

Data Migration

Professional Services

Solution Accelerators

Solutions

Databricks For Industries

Cross Industry Solutions

Data Migration

Professional Services

Solution Accelerators

Resources

Documentation

Customer Support

Community

Learning

Events

Blog and Podcasts

Resources

Documentation

Customer Support

Community

Learning

Events

Blog and Podcasts

About

Company

Careers

Press

Security and Trust

About

Company

Careers

Press

Security and Trust

Image 6: databricks logo

Databricks Inc.

160 Spear Street, 15th Floor

San Francisco, CA 94105

1-866-330-0121

[](https://www.linkedin.com/company/databricks)
[](https://www.facebook.com/pages/Databricks/560203607379694)
[](https://twitter.com/databricks)
[](https://www.databricks.com/feed)
[](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm)
[](https://www.youtube.com/@Databricks)

Image 8

See Careers

at Databricks

[](https://www.linkedin.com/company/databricks)
[](https://www.facebook.com/pages/Databricks/560203607379694)
[](https://twitter.com/databricks)
[](https://www.databricks.com/feed)
[](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm)
[](https://www.youtube.com/@Databricks)

We Care About Your Privacy

Databricks uses cookies and similar technologies to enhance site navigation, analyze site usage, personalize content and ads, and as further described in our Cookie Notice. To disable non-essential cookies, click “Reject All”. You can also manage your cookie settings by clicking “Manage Preferences.”

Manage Preferences

Reject All Accept All

Image 11: Databricks Company Logo

Privacy Preference Center

Opt-Out Preference Signal Honored

Privacy Preference Center

### Your Privacy
### Strictly Necessary Cookies
### Performance Cookies
### Functional Cookies
### Targeting Cookies
### TOTHR

#### Your Privacy

When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

#### Opting out of sales, sharing, and targeted advertising

Depending on your location, you may have the right to opt out of the “sale” or “sharing” of your personal information or the processing of your personal information for purposes of online “targeted advertising.” You can opt out based on cookies and similar identifiers by disabling optional cookies here. To opt out based on other identifiers (such as your email address), submit a request in our Privacy Request Center.

More information

#### Strictly Necessary Cookies

Always Active

These cookies are necessary for the website to function and cannot be switched off in our systems. They assist with essential site functionality such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will no longer work.

#### Performance Cookies

[x] Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

#### Functional Cookies

[x] Functional Cookies

These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

#### Targeting Cookies

[x] Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant advertisements on other sites. If you do not allow these cookies, you will experience less targeted advertising.

#### TOTHR

[x] TOTHR

Cookie List

Consent Leg.Interest

[x] checkbox label label

[x] checkbox label label

[x] checkbox label label

Clear

- [x] checkbox label label

Apply Cancel

Confirm My Choices

Allow All