Shopify search by SKU not working? Why exact part numbers fail, and how to fix it

The symptom

Stores that sell by reference see the same pattern. A shopper knows exactly what they need: a bearing reference such as 6204-2RS, an oil filter number such as OC90, an EAN scanned from a box. They paste it into the search bar and one of two things happens:

• The results page lists many products that share a digit sequence or a word with the query, and the product they wanted is somewhere in the middle, or on page two.
• The results page is empty, because the shopper typed 62042RS or 6204 2RS instead of 6204-2RS, or typed only the part of the reference they remembered.

Either way, a customer who arrived with a precise reference, ready to buy, leaves without adding anything to the cart. For auto parts, industrial supplies, electronics and spare parts, this is the most common way to lose a sale that was already won.

Why Shopify search behaves this way

Shopify's storefront search does index variant SKUs and barcodes. The reference is in the index; the issue is how results are chosen and ranked.

• It interprets, it does not match. The search is built to understand what a shopper means from natural language. That is useful for "waterproof jacket", and unhelpful for "OC90", which has no meaning to interpret. An exact reference is treated like any other token and competes with everything that looks similar.
• Exact matches are not privileged. A product whose SKU is exactly the query is not guaranteed to rank first. Products with the same digits in a title, a description or another SKU can appear above it.
• Separators and case matter. 6204-2RS, 6204 2RS, 62042rs and 6204.2RS are the same part for your customer and different strings for the search engine. Manufacturers, catalogues and suppliers rarely write a reference the same way.
• Fragments are not handled. A shopper who types 6204 expects to see the 6204 family of bearings. A shopper who types the last six digits of a barcode expects the product. Prefix and fragment matching on references is not what the native search is tuned for.

What you can do without an app

Some merchants work around the problem by editing their catalogue.

• Put the reference in the product title. Titles weigh more in ranking, so "Bearing 6204-2RS" ranks better than a product whose reference lives only in the variant SKU. Limits: it does not help when the reference is typed without the dash, it does nothing for products with several variants and several SKUs, and it makes titles long and repetitive.
• Add references as tags. Tags are searchable and can hold several spellings of the same reference. Limits: you have to maintain every spelling by hand, tags show up in filters and collections, and the exact tag still does not force the product to rank first.
• Turn off unrelated content in search. Some themes let you exclude pages and articles from results, which reduces noise. Limits: product-to-product noise, which is the actual problem, remains.

These steps reduce the number of misses. They do not give a shopper the behaviour they expect from a parts counter: type the reference, get that part.

What MT: SKU & Part Number Search does

MT: SKU & Part Number Search adds predictable matching to the search bar your theme already has. It does not replace your theme's search, does not change your products, and never writes to your store.

• Exact match returns that product alone. When the query equals a SKU, a barcode (EAN/UPC) or a manufacturer part number, the shopper gets that product, not a list.
• Separators and case are ignored. 6204-2RS, 6204 2RS and 62042rs all resolve to the same variant.
• Prefix and fragment matching. Typing the beginning of a reference, or a distinctive part of it, lists the matching references in a predictable order.
• Barcode scan on phones. On mobile, a camera icon in the search bar lets the shopper scan the barcode on the box instead of typing thirteen digits.
• Silent fallback. If the app is unavailable, the theme's native search takes over. The shopper never sees an error.
• Read-only. The app reads products to build its index. It writes nothing to your store, so uninstalling leaves your catalogue exactly as it was.

Setup is a theme app embed switched on in the theme editor. The customer guide walks through installation, the test bench that lets you try references before customers do, and the list of searches that returned no result.

View MT: SKU & Part Number Search on the Shopify App Store

Frequently asked questions

Does Shopify search index SKUs and barcodes?
Yes. Variant SKUs and barcodes are indexed. The problem is ranking, not indexing: an exact reference is treated like any other word, so it is mixed with loosely related products, and a missing dash or a different case can prevent the match.

Why does searching a part number return products that have nothing to do with it?
The search is designed to interpret what a shopper means rather than to match a string exactly. For "blue running shoes" that helps. For "6204-2RS" it means products sharing a fragment, a digit sequence or a similar word are returned too, and the exact part is buried among them.

Can I fix this without installing an app?
Partly. Putting the reference in titles or tags improves the chance of a match, but it does not force the exact result to rank first, does not handle references typed without dashes or spaces, and does not cover partial references or barcode scans. It also clutters titles and tags for every variant.

What happens if the app is unavailable?
The app falls back silently to Shopify's native search. The search bar keeps working as before.