Catalog Index Bloat Audit
Large catalogs accumulate indexable junk from pagination, sort orders, session tokens, tracking parameters, and abandoned facet paths. The count itself is not the harm - the harm is crawl attention spread across pages that will never rank, so refreshed prices and new stock get picked up slowly. Deindexing indiscriminately is worse than the bloat, because some of those URLs are earning revenue.
Use when Search Console reports far more indexed URLs than you have products and categories, and rankings on core pages have drifted down.
The skill file
What you need first
- Search Console page indexing export and crawl stats
- a full crawl of the site at reasonable depth
- organic landing page data for the last 6 months
Method
- 01 Compare indexed URL count against your true page count from the database. A ratio above roughly three to one on a stable catalog means bloat rather than legitimate depth.
- 02 Join the indexed URL list against organic landing pages. URLs indexed for 6 months with zero organic entrances are the removal shortlist - everything else stays until proven otherwise.
- 03 Classify the shortlist by generating pattern before touching anything: pagination, sorts, tracking parameters, dead facets, orphaned old products. Fix the generator, not the individual URLs.
- 04 Strip tracking parameters at the edge with a redirect to the clean URL, rather than canonicalising them, so they stop being crawled at all.
- 05 Leave paginated pages self-canonical and indexable but ensure they carry no unique copy. Canonicalising page 2 onwards to page 1 orphans the deeper products from crawl discovery.
- 06 Re-measure crawl stats at 8 weeks. Success is a rising share of crawl requests hitting product and category URLs, not a lower indexed number on its own.
What this produces
A pattern-level remediation plan showing which URL generators to fix, with the removal shortlist filtered by zero organic entrances.
Where this goes wrong
- canonicalising paginated pages to page one, which cuts crawl paths to products that appear only on deeper pages
- deindexing by pattern without checking landing page data first and killing URLs that were quietly converting
- treating a lower index count as the win when crawl allocation to money pages has not actually improved
Use this skill in your own AI
The download is a plain markdown file with the name and trigger in its frontmatter. Where an assistant supports skills it can load itself, that frontmatter is what it reads to decide this one applies.
Questions about this skill
When is an audit better than simply deindexing the junk?
When Search Console reports several times more indexed URLs than you hold products and categories, and core pages have drifted down. Deindexing by pattern in bulk is worse than the bloat, because some of those URLs convert. Use this when you need to find the generators producing the junk rather than to remove URLs one pattern at a time.
What do I need before drawing up a removal shortlist?
The Search Console page indexing export and crawl stats, a full crawl at reasonable depth, and six months of organic landing page data. The landing page data is the safety check: without it the removal shortlist rests on pattern alone and you kill URLs that were converting. Without a true page count from the database there is no ratio to judge bloat against.
What does the audit produce, and which part stops the bloat returning?
A pattern level remediation plan naming which URL generators to fix, with a removal shortlist filtered to URLs indexed six months with zero organic entrances. The generator list is the part that matters, since fixing the pagination or tracking parameter that mints the URLs stops them returning, while removing them individually invites the same volume back next quarter.
What is the mistake that ruins an index bloat clean up?
Canonicalising paginated pages back to page one. It looks like tidy consolidation and it cuts the crawl path to every product that appears only on deeper pages, so the index count falls and discovery of your tail goes with it. Judge success on crawl share reaching product and category URLs, not on a lower indexed number.
More in Ecommerce SEO
Faceted Navigation Crawl Control
Use when a category with a few hundred products has generated tens of thousands of crawlable fil...
Category Page Copy That Ranks
Use when category pages sit in positions 8 to 20 for their head term and the page is a bare grid...
Product Descriptions At Scale
Use when you have thousands of SKUs on manufacturer-supplied copy and product pages get impressi...
Out Of Stock And Discontinued Products
Use when products go out of stock or get discontinued and you need to decide what happens to the...