Competitive Assortment Analysis: Turning Market Data Into Better Product Decisions

Most retailers know their own assortment inside out. They can tell you which SKUs sell and which ones sit in the warehouse. What they often can't tell you is what their competitors added to their ranges last month.

Finding that out is the job of competitive assortment analysis: tracking which products competitors sell, launch, and remove, and comparing their ranges with yours. Done regularly, it shows where your product mix falls short of the market and where it already stands apart.

Sales history, inventory performance, and customer behavior still guide most assortment decisions, but they only show your side of the shelf. They won't tell you that a competitor has expanded into a category you haven't touched or that another is trimming its range where you have room to stand out. A new product type can build a presence across several retailers well before it reaches your sales reports.

What Assortment Planning Misses Without External Data

Internal data shows what is working in your own business: which products sell well, which SKUs underperform, where inventory is moving slowly, and how different locations or channels are performing. Teams rely on it to make decisions about their existing assortment.

What it can't show is how the market is changing around you. Your sales data won't reveal that three other retailers  have recently expanded into a new subcategory or that one of them has launched a product at a price point you don't cover. If a product drops out of a competitor's catalog, your own numbers can't tell you whether that's a temporary stock issue or a deliberate change to their range.

External data covers those questions, and it works best alongside your internal planning: internal performance tells you how your business is doing, and external market data shows the competitive environment it operates in.

What Competitor Assortment Data Reveals

Competitor assortment data is useful when you track it consistently and organize it so you can compare like with like. Five kinds of change tell you the most.

• New product launches show where competitors are investing. When one sub-category keeps getting new SKUs, they probably see demand building there.
• Discontinued products can mean their priorities have shifted. Check whether the cause is weak demand, portfolio rationalization, seasonal turnover, or a move toward another product group.

• Whole categories can grow or shrink. If another retailer's range grows significantly in a category while yours stays the same, find out why before the gap shows up in your sales. 
• Private-label expansion can change a category's price structure, the variety on offer, and how branded products are positioned.

• Pricing tiers can leave part of the market uncovered, for example, when the market offers entry-level, mid-range, and premium options while your assortment sits in only one or two of them.

A longer product list on the other side isn't a gap in itself. The useful question is where your ranges differ and whether those differences are worth closing.

A Simple Example: Spotting an Assortment Gap Early 

Take an outdoor equipment retailer. Its core camping range is selling steadily, so the assortment has stayed largely the same. Looking only at sales, there's no reason to change it.

A competitive assortment analysis shows something else. Over six months, three competing retailers have been adding ultralight backpacking gear. One has grown from 15 to 40 SKUs in that sub-category, four new brands have appeared, and prices now run from $150 to $500. The retailer still carries just four ultralight products, all priced around $300.

Historical sales won't flag this, because they only record demand for products the retailer already carries. Competitor data is where this kind of shift shows up first.

The usual first step is a closer look before adding anything. The team can compare the new products, brands, and price points against its own range, check how widely they're available, and then judge whether those retailers have found real demand or are still experimenting.

How to run a competitive assortment analysis

You can apply the same approach to any category in five steps.

1. Choose your competitors and categories: Start with the retailers and marketplaces your customers compare you with, and focus on categories where you have assortment decisions coming up.
2. Collect their catalogs on a schedule: Capture product names, brands, SKUs, specifications, pack sizes, prices, availability, and category placement. Repeating this regularly builds the history you need to spot trends.
3. Match and normalize products: Map each competitor listing to its equivalent in your catalog, and standardize units, pack sizes, and brand names so each product is compared with its true equivalent.
4. Compare the ranges: Look at overlap (products you and a competitor both carry), breadth (how many product types each covers), depth (how many options within each type), price-band coverage (which tiers each serves), and exclusive SKUs (products only one of you carries).
5. Prioritize the gaps: Rank each gap by how strong the demand looks and how well it fits your strategy. Several retailers expanding the same range, items that stay in stock, and few markdowns are all good signs. Then decide whether to add, test, or leave it.
   ‍

Why Assortment Intelligence Needs Continuous Monitoring

Competitor ranges change every week. Products are launched, removed, replaced, repositioned, briefly out of stock, or added to new channels throughout the year. A seasonal review gives you a useful snapshot, but it misses everything that happens between planning cycles.

‍

Regular tracking builds a history of those changes. Instead of asking only "What does this competitor sell today?" teams can also ask:

• Which products were recently added?
• Which products disappeared?
• Which categories are expanding?
• Which brands are getting more shelf space?
• Which price bands are getting crowded?

That history also helps you read the signals correctly. If a product is missing in one check, it's probably out of stock. If it's missing for three or more checks in a row, it has likely been dropped.

‍

From Competitor Catalogs to Assortment Intelligence

In competitive assortment analysis, collecting competitor catalogs is the easy part. The hard part is making them comparable. Every retailer and marketplace lists products in its own way, with different names, SKUs, brand spellings, specifications, sizes, pack quantities, and category structures.

That's why product matching matters. The same product might be "Brand X Water Bottle 750 ml" on your site and "Brand X Insulated Bottle 0.75 L, Pack of 2" on a competitor's. Without accurate matching and normalization, identical products look different, and different products get counted as the same. Either mistake skews every comparison you build on top of it. 

Once products are matched and categorized properly, you can compare assortment breadth, overlap, new and discontinued products, brands, categories, and price ranges with real confidence. WebDataGuru has previously covered how competitive match rates affect the reliability of market comparisons and why poor matching leaves gaps in your competitive view.

Where Assortment Intelligence Fits Into the Bigger Data Picture

Assortment data is more useful when you connect it to other market information. A new competitor product tells you more when you can also see its price, availability, brand, category, specifications, and promotions. Put together, the flow looks like this:

Product data → Competitor assortment → Product matching → Pricing → Availability → Market context

Connecting the data this way takes you past a simple SKU count. Say a competitor has 20 more products than you in a category. After matching and comparing, you may find that most are variants of items you already carry and only a handful are new to your range.

The aim is to know where your range overlaps with the rest of the market, where it's thin, and where it stands apart.

If you're pulling product, pricing, and availability data into one place, our Retail Data Lake Blueprint shows how to bring product, pricing, availability, competitor, and market data together as a base for competitive intelligence.

How WebDataGuru Supports Assortment Intelligence

Tracking competitor ranges well takes more than a list of product pages. WebDataGuru collects and structures data from retailer websites, marketplaces, competitor catalogs, and other external sources. The data is then normalized, matched, validated, and delivered in a format that fits your existing data and analytics setup.

For competitive assortment analysis, that means your team can:

• Track competitor catalogs and how they change
• Spot new and discontinued products
• Compare product ranges across retailers and marketplaces
• Match comparable products across different sources
• Monitor category and brand changes
• Build structured datasets of external market data

‍

With competitor data collected regularly and in a comparable format, your team spends less time checking catalogs by hand and more time working out what the changes mean for your product strategy.

Through PriceIntelGuru, matched products also link to live competitor pricing, so you can see what competitors sell and what they charge.
‍

Your assortment strategy needs a view beyond your own catalog

A strong assortment strategy answers two questions at once: how are your products performing, and what is changing in the market around you? Your sales data answers the first and competitor data answers the second. Competitive assortment analysis brings the two together.

That gives your team a clearer picture of where categories are heading and where your coverage is thin, so decisions about what to add, remove, or look into further are based on what the whole market is doing.

Share your category and top competitors, and we'll show you where your assortment overlaps with theirs and where the gaps are.
‍