# 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.

B2B commerce · The Intellsys team · 18 November 2026 · 6 min read

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.

## 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.

## 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.

- **Manufacturer** The maker of the machine, and of the original part.
- **Machine type and model** An excavator, a tractor or a scooter, and the model within it.
- **Part** The item a buyer orders, with its own number and description.
- **Variant** A size, a rating or a pack quantity of the same part, each with its own code.
- **Stock and price** Held 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 number | What it means | How the catalogue should treat it |
| --- | --- | --- |
| Current part number | The number you sell under now | The main record |
| Replaced number | An older number this part now supersedes | Searchable, and points to the current part |
| Manufacturer's number | The original maker's number for the part | Searchable, shown on the part's page |
| Equivalent part | Another maker's part that does the same job | Linked, with a note on any difference |
| Internal or dealer code | A code used inside your network | Searchable 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 template** The catalogue owner sets the columns, codes and allowed values.
2. **Clean the file** The data team removes duplicates and fills required fields.
3. **Validate before loading** Every row is checked against the template; failures come back with reasons.
4. **Load a small batch first** One category goes live, and the counter team searches it as buyers would.
5. **Load the rest** In batches, with each batch's errors fixed before the next.
6. **Spot-check fitment** Engineering 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](https://intellsys.cloud/blog/b2b-ecommerce-sap-integration) sets out what flows which way.

- [ ] **Every part has one current number** No two live records for the same part.
- [ ] **Every variant has its own code** Size, rating and pack quantity are never hidden in a description.
- [ ] **Every fitment link has a source** So a wrong one can be traced and corrected.
- [ ] **Replaced numbers stay searchable** And point to the current part.
- [ ] **Images show the actual part** Not a picture of a similar one.
- [ ] **Each field has an owner** And fitment has a review date.

*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](https://intellsys.cloud/blog/quotation-management-system), requests for quotation, covered in the [RFQ process](https://intellsys.cloud/blog/rfq-process), and payment links sent by message.

> **How Intellsys OS handles it.** Intellsys OS links parts to machines through fitment, holds variants and collections, imports catalogues in bulk and keeps stock by plant and storage location.

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](https://intellsys.cloud/blog/what-is-a-dealer-management-system). See [the commerce part of the platform](https://intellsys.cloud/platform/commerce).

## 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.

---

[Request a demo](https://intellsys.cloud/demo) · [Blog](https://intellsys.cloud/blog)

This is the Markdown version of https://intellsys.cloud/blog/spare-parts-catalogue-management. Intellsys is built by GrowthJockey, a full stack venture architect.
