SKU and part number search: the B2B ecommerce guide

Distributor buyers search by code because they are reordering, not discovering. They work from an invoice, a shelf label, a supplier's catalog or a handheld scanner, and they type what is printed there. In wholesale catalogs a large share of all queries contain a code.

Three things follow. Code search is the highest-volume query type on a distributor storefront. It is the highest-intent, because the buyer already knows what they want. And it is the least forgiving: a buyer who types a code and gets nothing does not browse, they phone in the order or open another supplier's portal.

A good code search resolves five variants of the same SKU. Testing a search tool means typing all five and checking that each returns the same product.

Most retail-first tools pass the first test and fail the third and fifth. They tokenise codes as words, so a fragment that is not a whole token finds nothing, and typo tolerance tuned for words either ignores codes or returns the wrong product with confidence.

Partial matching works when the index stores each code as a sequence of segments and matches on prefixes, suffixes and interior runs, ignoring dashes, dots, slashes, spaces and letter case. The buyer should never have to know how the code is formatted in the catalog. "RAW1-1/4", "raw 1 1/4" and "RAW114" are one query.

Barcode lookup resolves a UPC or EAN to the product and shows the price for the signed-in account. A handheld scanner types the barcode into the search field exactly like a keyboard, so no special integration is needed if the search index holds barcode fields from the ERP. Buyers in a stockroom can scan a shelf and reorder without knowing the product name. Case and inner-pack barcodes should resolve to the same product with the matching unit of measure when those barcodes are in the item master.

Typo tolerance for codes must be tighter than for words. One wrong letter in "menthol" is harmless. One wrong digit in a part number is a different product, possibly a different price and pack size. The right behaviour is to treat transposed digits and single-character substitutions as near matches, rank them below any exact or partial hit, and label them visibly as a suggestion. A tool that silently returns the near match as if it were exact will eventually ship the wrong item.

The buyer may know the manufacturer's code, the distributor's internal SKU, a code the product carried last year, or a competitor's code for the same item. Good code search indexes every alias field the ERP holds, so any of them finds the product. Superseded codes should resolve to the replacement with a note when the ERP stores that relationship. Cross-references to competitor codes are the hardest to maintain and the most valuable, because they capture buyers switching suppliers. Shopsense searches the alias fields you map. It does not keep a second cross-reference list.

Quick order lets a buyer paste a list of codes and quantities and have every line resolved in one step. It is the fastest path from a purchase order to a cart. The search tool should flag lines that are out of stock, discontinued or not available to that account, and offer the replacement where one exists. Shopsense does not document a quick-order paste on this site until that feature is in the product.

Code search is only as complete as the code fields in the index. When the index is built from a product feed, alias and barcode fields are often dropped on the way. When the index reads the ERP's item master directly, every code the business already maintains is searchable with no second list. Shopsense is a B2B ecommerce search engine for distributors and wholesalers that connects directly to ERP systems. See the guide to ERP-integrated ecommerce search.

Test code search with your own data, not the vendor's demo catalog. A 30-minute test is enough.

1. Export 50 SKUs, including 10 with dashes or slashes and 10 with aliases.
2. Type each one exactly, then without separators, then as a mid-string fragment.
3. Transpose two digits in 10 of them and check that the right product appears, labelled as a suggestion.
4. Scan 10 barcodes with a handheld and check unit resolution. Check case resolution if those barcodes are mapped.
5. If the tool offers quick order, paste 20 code-and-quantity lines and time the result.
6. Pull last month's zero-result queries from your current search log and run them all.