Inside Our Catalogue: 323,474 SKUs

A catalogue of 323,474 browsable products is easy to advertise and harder to describe honestly. The number is real and it is audited, but it answers only one question: how many model-and-brand combinations we can present. It does not answer whether an item is in stock, whether its dimensions are complete, or whether the photograph you are looking at is a real photograph.

This is a data review of our own catalogue, written for buyers who need to know what a coverage figure actually promises before they rely on it. Every figure below is a current audited total.

What the numbers measure - and what they do not

The headline totals describe presentation, not inventory. Understanding the difference is the whole point of publishing them.

Coverage versus availability

Each figure below describes the range we can present and order. Availability - whether an item actually sits on a shelf today - is a faster-moving fact that has to be checked at the point of enquiry, so read the catalogue count as coverage and confirm stock separately.

• 323,474 browsable products. Model-and-brand combinations we can display and order.
• 291,217 unique model designations. Distinct model numbers, before brand is applied.
• 439,071 archived SKU records. The wider historical record set, including consolidated duplicates.
• 212,868 products, 65.8%, with a complete dimension set. Bore, outside diameter and width all present.
• 253,034 products, 78.2%, with a thumbnail image. An image of some kind attached to the record.

Read together, these say that the catalogue is broad and reasonably well documented, but they do not say that 323,474 bearings are in stock. Coverage is the range we can present; availability is a separate, faster-moving fact that has to be checked at the point of enquiry.

How duplicate consolidation changed the catalogue

The archive once held 439,071 SKU records, which is 115,597 more than the browsable total. Those extra records were duplicates: the same model-and-brand pair appearing more than once, sometimes with slightly different text and sometimes with a different incomplete set of attributes.

We consolidated 115,597 duplicate records, 26.7% of the archive, and pointed each one at its canonical page with a 301 redirect. For a buyer the effect is simple but important. Every model-and-brand pair now resolves to one page, so a search result, a bookmark or an old link lands on a single stable URL rather than on one of several near-identical records. That stability is what lets a cross-reference point at a page that will still exist next season, and it is why the interchange lookup can rely on a clean set of destination pages.

Stable URLs are a data feature, not a marketing one

A redirect map is the unglamorous part of a catalogue, and it is the difference between a link that resolves and a dead end. When two records for the same model exist, every cross-reference, enquiry and saved bookmark splits between them. Consolidating to one canonical page removes that ambiguity permanently.

Why 34% of the catalogue has an incomplete dimension set

212,868 products carry a complete bore, outside diameter and width set, which leaves roughly 34% without one. That is not a gap in the physical range; it is a gap in the data attached to some records.

Incomplete dimensions usually come from records that arrive with a designation but no dimension table, or with a partial table that is missing width. Since ISO 15 fixes all three dimensions for a designation, a missing dimension is almost always fillable. The practical route is to request it: send the designation and any measurement you have, and we will supply the missing boundary dimensions. The ISO 15 boundary dimension guide shows how to read the values for any designation, and the bearing selector can filter by the dimensions you already have so a partial record still produces useful alternatives.

The 34.2% gap is a data task rather than a range gap: the parts exist, the dimension table attached to some of them does not. A buyer who needs an exact envelope on an incomplete record should ask rather than assume, because a guessed width is the single easiest way to order a part that seats badly.

What "78.2% with images" does and does not mean

253,034 products, 78.2%, carry a thumbnail image. That is a statement about presence, not about quality, and the distinction matters when you are trying to confirm an envelope visually.

Many images are dimensional drawings, not photographs

A thumbnail can be a product photograph, a line drawing with the boundary dimensions marked, or a generic illustration for the series. A dimensional drawing is genuinely useful for confirming bore, outside diameter and width, but it will not show a seal lip or a cage, so it cannot be used as evidence of construction. Treat the image as a first check on the envelope and the record's data as the authority.

Brand share and the house brand

The catalogue spans 11 brands, and one of them is ours. That skews the brand counts in a way a buyer should read deliberately rather than skim.

Reading a count comparison

The practical consequence is that a count comparison is not a like-for-like comparison. The house brand covers a broad, deep range by design, while a named brand covers a curated selection. When you compare a branded item with an unbranded equivalent, compare the dimensions and the suffix rather than the product count, and remember that an unbranded item is not automatically interchangeable with a branded one just because the envelope matches. A house-brand record and a named-brand record that share bore, outside diameter and width are dimensionally interchangeable but may still differ in clearance class, cage material and tolerance, so the suffix is the field that decides. The brand directory lists every range we carry.

Category distribution

The range spans 14 product categories, and the count inside each category says something about where the bulk of interchange demand sits.

The largest category is other-bearings at 97,564, which collects special, non-standard and thin-section designs that do not belong to a single standard series. The next largest are the cylindrical and tapered roller families at 38,259 and 34,808, followed by deep groove ball bearings at 31,521. Those six categories carry the bulk of the interchangeable demand, which is why category is the fastest single filter available. If your requirement is a standard metric bore, you are working inside a few hundred thousand rows; if it is a special, you are in the other-bearings group deliberately rather than by accident.

Step-by-step: from catalogue to a qualified shortlist

1. Start with the category. Pick the family that matches the load direction - deep groove or cylindrical roller for radial, tapered roller for combined load.
2. Filter by bore. The bore narrows the range faster than any other attribute, because it is the one dimension the shaft has already fixed.
3. Filter by outside diameter and width. The full ISO 15 envelope removes anything that cannot physically seat, which is where most wrong enquiries are eliminated.
4. Choose the brand. Decide whether you want a named brand or a house-brand equivalent, then compare the suffix rather than the count.
5. Check the record's completeness. If the dimension set is incomplete, request the missing values rather than guessing them, and confirm the tolerance class under ISO 492 if the position is precision-sensitive.
6. Verify before ordering. Confirm the designation and suffix on a canonical page, then compare the alternatives side by side before releasing the order.

Limitations of this data

• Counts describe coverage, not availability. A browsable product is one we can present and order, not one guaranteed to be on a shelf.
• Dimension completeness is 65.8%. A record without a full dimension set needs a request before it can be relied on.
• Images are not all photographs. Many thumbnails are dimensional drawings, useful for the envelope and silent on construction.
• Brand counts are skewed by the house brand. The 142,486 ANDGE products reflect a broad house range, not a ranking of quality.
• Duplicate consolidation is finished, but data gaps are not. The redirect map is stable; individual records still improve as missing values are filled.

The honest summary is that a large catalogue is a starting point, not an answer. The numbers say we can present 323,474 model-and-brand combinations across 11 brands and 14 categories; they do not say every record is complete or every part is in stock. A buyer who filters by category, bore and outside diameter, then confirms the suffix and the documentation, turns a six-figure count into a shortlist of parts that will actually fit. Compare a single named listing against a house-brand record - an SKF or TIMKEN page against the equivalent house-brand entry - and read the B2B e-commerce review for the distribution context behind those listings. If a record is missing data you need, the enquiry desk will fill the gap, and the counterfeit risk guide explains why an undocumented substitute is not a safe shortcut.