Product Catalogue Analysis: Stock & Discontinuation Insights

Analysis of 10,000 products across 9,241 brands revealing that 20% are discontinued and only 17% are in stock, with insights into brand diversity and pricing trends.

APAkashdeep Patra

Apr 30, 2026

Conversation Story

Chapter 1

08:42 PM

analyse this

Products Data.csv1.5 MB

AI Analysis

Nearly 1 in 5 products is discontinued — and only 1 in 6 is actually in stock. That's the headline hiding inside this 10,000-product catalogue.

Visualization

Made withSreniq

Visualization

Made withSreniq

The first thing that jumps out: 9,241 brands for 10,000 products. That's basically one brand per product — this catalogue isn't dominated by a few power players; it's an ocean of micro-brands, each with a tiny footprint.

Visualization

Made withSreniq

Visualization

Made withSreniq

Here's the plot twist: only 16.44% of products are actually "in stock" and ready to ship. The rest are locked in availability limbo.

Product Availability Breakdown

Made withSreniq

🚨 Availability Reality Check

Made withSreniq

What's remarkable is how perfectly even the distribution is — each status holds roughly 16–17% of products. That's not natural market behavior; it suggests either a catalogue that needs serious pruning, or one that's being populated at a uniform rate across all stages.

Visualization

Made withSreniq

Prices run from $1 to $999 with an average of $503. But the shape of that distribution tells a richer story.

Price Distribution — Where Products Cluster

Made withSreniq

Visualization

Made withSreniq

The $750–$999 tier is actually the largest single band at 25.66%. This catalogue skews premium, not mass-market.

Visualization

Made withSreniq

With 34 categories and ~295 products each on average, the spread is remarkably balanced. But inventory value tells a different story about where the real money is locked up.

Top 10 Categories by Product Count

Made withSreniq

Top 10 Categories by Inventory Value ($)

Made withSreniq

Notice Cycling — it doesn't crack the top 10 by product count, but jumps into the top 10 by inventory value. That's because its average price ($536) is among the highest. Cycling products are fewer but pricier, driving disproportionate capital exposure.

Visualization

Made withSreniq

Stock Level Distribution Across All Products

Made withSreniq

The good news: 50% of products sit at "Healthy" stock levels (500+ units). The bad news: 460 products are in critical territory with fewer than 50 units — and given that 34% of the catalogue is discontinued or out-of-stock already, some of these critical-stock items may be on their way there.

Healthy vs At-Risk Stock

Made withSreniq

Visualization

Made withSreniq

With 18 distinct sizes and 140 unique colors, this is a visually and dimensionally diverse catalogue — though size distribution is remarkably flat (each size holds ~5.4–5.95% of products), suggesting no single size dominates demand signals in the data.

Top 10 Colors by Product Count

Made withSreniq

The color names read like a CSS spec sheet — these look like system-generated or programmatically assigned values rather than consumer-facing color names. Worth flagging for data quality.

Visualization

Made withSreniq

What This Data Is Really Saying

Made withSreniq

Tell your own data story

Upload a CSV or spreadsheet and let AI turn your data into a polished, shareable story — in minutes.

Try Sreniq free

No credit card required