Skip to content
Practice

Spare Parts Search by Part Number: SKUs and OEM Numbers That Actually Get Found

Someone who types in a part number knows exactly what they want. If the shop finds nothing, the customer is gone, or picks up the phone instead. Yet the search rarely fails because the part is missing. Usually it comes down to formatting: the number is stored in the shop with leading zeros, and the customer types it without them. This article shows where spare parts search by part number goes wrong, and how it can still find the right part.

5 min read Last updated:

Who Searches by Number

The people who search by number are mainly workshops, trade customers and experienced DIYers. They've read the number off the old part, from the manual, from a previous invoice, or from the manufacturer's catalog. These customers often order several parts at once and come back again. Greet them with “No results” and you don't just lose one order, you lose a repeat customer.

Here's the key point: the number the customer has isn't necessarily yours. Several numbering systems are in circulation:

Number Where the customer got it Where it can live in Shopify
Your SKU Invoice, delivery note, earlier order Variant SKU
OEM number old part, manual, manufacturer catalog Barcode or metafield
Model designation Nameplate, vehicle documents Category in the catalog
Name own words, workshop terms Product title

A good spare parts search covers all four.

Why Search by Part Number Fails

  • Leading zeros. The catalog lists 00341005, the part itself reads 341005.
  • Separators. The same number appears as 12-345-678, 12 345 678, 12.345.678 or 12345678, depending on who copied it down.
  • A different numbering system. The customer has the OEM number, the shop only knows its own SKU.
  • Replaced numbers. The manufacturer has replaced the part with a successor. The old number is still on the part the customer is holding.
  • Numbers that only appear in the drawing. If a number exists only in the PDF catalog and not in the product data, no search can find it.

Normalizing: The Same Number in Every Format

The solution is normalizing. Before comparing, the search term and the stored number are treated the same way: separators are dropped, leading zeros don't matter, and case doesn't matter either. On top of that, the search doesn't just look for the whole word but also for parts of it. That way, 341005 finds the product 00341005, and 12345678 finds 12-345-678.

Techparts' catalog search searches word by word and regardless of formatting: hyphens don't get in the way, and neither do leading zeros. There's nothing to configure for this.

Results With Context

In a spare parts catalog, many names repeat over and over. “Cylinder & Crankshaft” exists under every model, and the same screw appears in forty assemblies. A results list that shows only names would look like the same entry repeated twenty times. That's why every result has to state its path, for example “Kymco › MXU 500 › Cylinder”.

Even more important is where the result leads. If the customer lands on a product page, they have to check for themselves whether the part fits their machine. Better: the click opens the assembly's drawing, highlights the hotspot, and shows the product card with price and add-to-cart button. The customer sees their part in its place and can be sure it's the right one.

Search should also find not just parts, but categories too. Someone typing "MXU 500" isn't searching for a part, but for their vehicle. The results list therefore separates parts and categories. In the shop, the parts finder handles this, together with selection by manufacturer, model and model year.

Search field in the store with an open list of suggested assemblies and items
Search with suggestions — Search by name, SKU or OEM number, and every result states its path.

Search Within the Parts List

Within an assembly, a second, smaller search is needed: a filter above the parts list. It searches the name, SKU and OEM number of each position, shows a counter like “3 of 52”, and hides rows with no match instead of removing them. That way, expanded alternatives and chosen quantities are preserved. For customers who already know their numbers, there's also a “parts list only” view without the drawing.

"Parts list only" view: only the list of items is visible
Parts list only — For buyers who already know their part number and want to go straight to the cart.

Keeping Replaced Numbers Findable

When a supplier changes a number, two things need to happen:

  1. Replace the product everywhere. In Techparts, the “replace hotspot product” function searches by a product or an OEM number, shows every place it's used first, and then swaps the product in all drawings at once. Alternatively, the new product is just added alongside, and the old one stays in place.
  2. Keep the old number searchable. The customer still has it in hand. Mention it in the successor's title, for example “Clutch plate (replaces 12345)”. The catalog search scans the name, so it will find the successor via the old number too.

Shop Search and Catalog Search Side by Side

The search built into a Shopify theme's header is made for products. It doesn't know about assemblies, positions or a catalog path. The catalog search doesn't replace it, it complements it: it sits on top of the catalog and searches parts and categories. It doesn't need an external search service. Its index is broken down by search terms, and with every search the customer loads only the matching slice, measured at about 128 kB on average, no matter how big the catalog is.

Checklist for Part Number Search

  • Every SKU is assigned exactly once.
  • OEM numbers live in a fixed field, the same one across the whole shop.
  • The search finds numbers with or without separators, and without leading zeros.
  • Results state their path: make, model and assembly.
  • Clicking a result takes you to the hotspot in the drawing.
  • Models and assemblies are searchable too.
  • Replaced numbers stay findable.
  • Searches with no results are reviewed regularly and treated as gaps.

Frequently Asked Questions

Where's the best place to store OEM numbers in Shopify?

In a fixed field that applies across the whole shop: the barcode, if you don't need it for EAN codes, or a product metafield. Techparts reads the OEM number from one of these sources, or directly from the hotspot in the drawing. Which one it is gets set once during setup.

What if a product has several OEM numbers?

That happens when the same part fits machines from different manufacturers. Choose the hotspot in the drawing as the source of the OEM number. Then every hotspot carries its own number: in manufacturer A's drawing, the same product appears with A's number; in manufacturer B's drawing, with a different one.

Does the catalog search need an external search service?

No. It's built when the catalog is published and lives as files hosted by Shopify. There's no setting, no search service and no extra bill.

Does the search also catch typos?

The catalog search normalizes formatting, meaning hyphens, leading zeros and capitalization, and it also searches for partial words. It won't find numbers that are simply mistyped, and for part numbers that's actually correct: one digit off is a different part.

See your own catalog in your own shop.

Install Techparts, set up one assembly, view it in the shop. The free plan covers fifteen products with a drawing, with no time limit.