B2B commerce

Spare parts catalogue management: fitment first

Spare parts catalogue management means every part is described, priced and linked to the machines it fits. Structure, fitment, old numbers and safe bulk import.

A fine-line chart of ruled rows in three columns, like a ledger, under a small Saturn in its rings.

The short answer

  • Buyers search from the machine, not from your product tree. Build fitment first.
  • Separate the product, its variants and the machines it fits. Each changes on its own.
  • Keep old and alternative part numbers searchable; they are how buyers actually ask.
  • Bulk import is where catalogues break. Validate before anything goes live.
  • Give every field an owner, and a review date for fitment.

Spare parts catalogue management is the work of keeping every part a business sells described, priced, stocked and linked to the machines it fits, so that a buyer or a counter clerk can find the right part from a machine, a model or an old part number. Listing parts is the easy half. The hard half is fitment, replaced part numbers and keeping thousands of records right as they change.

What a parts catalogue has to answer

A parts buyer rarely knows your catalogue's categories. They know their machine, a number stamped on the old part, or a photograph of it. A good catalogue starts from those questions.

  • Will it fit my machine?From the make, model and, where it matters, the serial range or year.
  • Is this the same as my old number?From the manufacturer's number, a replaced number or a cross-reference.
  • Is it in stock, and where?By the warehouse or plant the buyer would be supplied from.
  • What will it cost me?At the buyer's own price, not only the list price.
  • What else is needed?Seals, gaskets or kits that go with the part for the job.
  • When can it arrive?The lead time if it is not in stock.
Six questions a parts buyer brings to a catalogue. A catalogue built only by product category answers the third and fourth, and misses the rest.

Products, variants and the machines they fit

Hold the catalogue as separate layers that link together, because each changes on a different clock. A part's description changes rarely. Its price changes every price list. The machines it fits grow every time a new model launches.

  1. ManufacturerThe maker of the machine, and of the original part.
  2. Machine type and modelAn excavator, a tractor or a scooter, and the model within it.
  3. PartThe item a buyer orders, with its own number and description.
  4. VariantA size, a rating or a pack quantity of the same part, each with its own code.
  5. Stock and priceHeld by variant, at each location the business supplies from.
The layers of a spare parts catalogue. Fitment joins the machine to the part; stock and price hang off each variant.

The link between a machine and a part is fitment. It is many-to-many: one filter fits a dozen models, and one model takes hundreds of parts. Store it as its own set of links, each with a source (the manufacturer's data, your own engineering, a dealer's confirmation), so that a wrong link can be traced and fixed.

Collections sit across these layers: a service kit, a season's fast movers, the parts for a given fleet. They are views a sales team or a buyer uses, not a new copy of the parts.

Old numbers, new numbers and cross-references

Parts change numbers. A manufacturer replaces one part with an improved one; an aftermarket maker sells an equivalent under its own code; a dealer has used an internal number for years. A buyer will search with any of them.

Kind of numberWhat it meansHow the catalogue should treat it
Current part numberThe number you sell under nowThe main record
Replaced numberAn older number this part now supersedesSearchable, and points to the current part
Manufacturer's numberThe original maker's number for the partSearchable, shown on the part's page
Equivalent partAnother maker's part that does the same jobLinked, with a note on any difference
Internal or dealer codeA code used inside your networkSearchable by staff, not shown to buyers

Never delete a replaced number. A buyer holding the old part is the buyer most ready to order, and a search that returns nothing sends them to someone else.

Bulk import without breaking the catalogue

Most parts catalogues arrive as spreadsheets: from a manufacturer, an ERP export or years of a counter clerk's notes. Importing them in one go is where duplicates, wrong fitment and blank prices get in.

  1. Fix the templateThe catalogue owner sets the columns, codes and allowed values.
  2. Clean the fileThe data team removes duplicates and fills required fields.
  3. Validate before loadingEvery row is checked against the template; failures come back with reasons.
  4. Load a small batch firstOne category goes live, and the counter team searches it as buyers would.
  5. Load the restIn batches, with each batch's errors fixed before the next.
  6. Spot-check fitmentEngineering samples machine-to-part links in each batch.
Six steps to import a parts catalogue in bulk, each with an owner, so errors are caught before buyers see them.

After the first import, decide which system is the source for each field. Descriptions might be kept in the catalogue; prices and stock usually come from the ERP. Our guide to B2B ecommerce and SAP integration sets out what flows which way.

0 of 6 ticked

Your ticks are kept in this browser only.

Six rules for a parts catalogue that stays right after the first import. Tick off the ones yours already keeps.

How Intellsys OS handles spare parts catalogue management

Intellsys OS holds a catalogue with variants, collections, machine fitment and parts, with bulk import. Stock is held by plant and storage location. Beside it sit business-to-business quotations, covered in quotation management, requests for quotation, covered in the RFQ process, and payment links sent by message.

Dealer ordering, checkout and order management sit on the same record as the catalogue, stock, quotations and requests for quotation, so a part found by fitment is ordered and tracked in one place. A dealer network that also sells parts through its outlets will find the same idea in a dealer management system. See the commerce part of the platform.

Questions people ask

What is spare parts catalogue management?

It is keeping every part a business sells described, priced, stocked and linked to the machines it fits, so buyers and staff can find the right part from a machine model, an old part number or a cross-reference.

What is fitment in a parts catalogue?

Fitment is the link between a part and the machines it fits, by make, model and, where needed, year or serial range. One part fits many models and one model takes many parts, so fitment is held as its own set of links.

How should replaced part numbers be handled?

Keep them. A replaced number should stay searchable and point to the current part, because buyers often search with the number on the part they are holding. Deleting it sends them elsewhere.

What is the safest way to import a parts catalogue in bulk?

Fix a template, clean the file, validate every row before loading, go live with one category first and have the counter team test it, then load the rest in batches while engineering spot-checks fitment.

Should prices live in the catalogue or the ERP?

Decide one source per field. Descriptions and fitment are often kept in the catalogue, while prices and stock usually come from the ERP. What matters is that each field has one source and one owner.

Read next

See it on a live workspace.

A demo shows the parts of Intellsys OS that are in use today, with the people who run it.

Request a demo
Request a demo