PC PartsCom Parts commerce command Acquisition open

Catalog management

Your parts catalog is either a tool or a mess. There is no middle ground.

Every industrial operation has a parts catalog, even if it is just a spreadsheet someone started five years ago. The question is whether that catalog helps people find, order, and substitute parts quickly - or whether it creates confusion every time someone opens it.

A clean catalog pays for itself in avoided mistakes.

Naming conventions are not optional

The single biggest catalog problem is inconsistent naming. The same bearing shows up as "BRG 6205", "Bearing - 6205-2RS", "SKF 6205 2RS C3", and "deep groove ball bearing 25mm" in four different rows. Nobody can search for it reliably, and duplicate purchases become inevitable.

Pick a naming format and enforce it. Lead with the noun (Bearing, Valve, Filter, Belt), follow with key specifications (size, type, material), and end with the manufacturer part number. Keep abbreviations standardized. Write the convention down and make every new entry follow it.

Category structure that scales

Flat lists break around 500 items. Tree structures with three to four levels handle most industrial catalogs well. A typical hierarchy: Category (Bearings) > Subcategory (Ball Bearings) > Type (Deep Groove) > Individual Parts.

Do not over-engineer the structure. If you have 50 types of filters, you need subcategories. If you have 8 types of belts, a flat list within the Belts category is fine. Match the depth to the volume.

  • Keep top-level categories to 10-15 maximum.
  • Use the same structure across all locations and systems.
  • Avoid creating categories for single items.
  • Review and prune annually - dead categories add noise.

Cross-referencing OEM numbers

Most industrial parts have an OEM part number and one or more aftermarket equivalents. Your catalog needs to link these so buyers can find alternatives without calling the vendor or searching Google.

At minimum, every catalog entry should have the manufacturer name, OEM part number, and a field for cross-reference or alternate part numbers. If you use a CMMS, this data should sync bidirectionally so maintenance techs and buyers see the same information.

Keeping pricing current

Catalog pricing goes stale fast. Vendor price increases, contract renewals, and market fluctuations mean last year's price is often wrong by 5-15%. Stale pricing leads to budget surprises and approval delays.

Update pricing at minimum annually, ideally quarterly for high-volume items. If your primary vendors provide electronic price files, automate the import. If they do not, schedule a quarterly review day and knock it out in one sitting.

Spreadsheet vs dedicated software

A spreadsheet works up to about 1,000 items and one location. Beyond that, you start hitting problems: version control breaks, search is slow, multiple users overwrite each other, and there is no audit trail.

Dedicated catalog software or a CMMS with good parts management handles multi-site catalogs, role-based access, approval workflows, and vendor integration. The jump from spreadsheet to software feels expensive until you calculate the cost of one mispurchase, one production delay from a stockout, or one audit finding from missing records.

  • Under 500 parts, single site: a well-structured spreadsheet is fine.
  • Under 5,000 parts, multi-site: you need software or a CMMS module.
  • Over 5,000 parts: dedicated catalog and inventory management is not optional.
  • Any regulated industry: you need audit trails that spreadsheets cannot provide.

The maintenance connection

A catalog that lives separately from your maintenance system creates a gap. Techs write part descriptions on work orders that do not match catalog entries. Purchasing cannot find what was requested. The cycle of phone calls and guessing starts again.

The strongest setup links catalog entries directly to equipment BOMs (bills of materials), so when a tech opens a work order for a specific pump, they see exactly which parts apply. That eliminates guessing and dramatically reduces wrong-part orders.