Matching Parts Diagram Numbers to Shopify SKUs Without Errors

A parts diagram is only useful if clicking item 14 adds the right part to the cart. Here is where the numbering breaks down and how to keep it straight.

Published 2026-10-19

A parts diagram links two different numbering systems that were never designed to agree with each other: the item numbers printed on the manufacturer's drawing, and whatever your Shopify catalog actually uses as a SKU. When those two line up cleanly, clicking a number adds the right part to the cart. When they do not, shoppers see "no product yet," or worse, the wrong part goes in the cart and comes back as a return.

This guide covers why the mismatch happens, how to find it before you publish a diagram, and how to keep your catalog clean enough that it happens less often.

Three Numbers, One Part

The item number is just a position on the drawing: 1, 2, 3, and so on. It is unique to that page and means nothing outside it. The part number, sometimes called the OEM number or manufacturer number, is the part's real identity, printed in the table next to the item number. The SKU is whatever your own store uses to track that part in inventory, which may or may not be the exact same string as the part number.

A working diagram has to connect all three: the item number points to a part number, and the part number has to resolve to a real SKU in your Shopify catalog. Break that chain anywhere and the diagram looks finished but does not actually work.

Where the Mismatch Comes From

The mismatch usually comes from one of four places:

You built your own SKU scheme, maybe prefixed with a supplier code, instead of using the OEM number as it is printed
The same physical part ships under a different OEM number after a supersession, and your supplier only sells the newer number now
The OEM number has formatting your Shopify SKU does not: stray spaces, dashes, or leading zeros that make the two strings look different even though they are the same part
One Shopify product covers several variants, like size or color, that all share one position on the diagram but need different SKUs per variant

When One Position Covers Several Variants

A diagram position does not always map to a single SKU. An exploded-view drawing showing a handlebar grip, for instance, might carry one item number even though your store sells that grip in three colors, each its own Shopify variant with its own SKU.

Decide, before you publish, whether that hotspot should link to the parent product, letting the shopper pick a variant on the product page itself, or to one specific variant's SKU, if the diagram only ever applies to a model that shipped with a single color. Either works; what breaks a diagram is leaving that decision unmade and linking to whichever variant happened to be first in the catalog.

The Manual Way: Build a Lookup Table

Before you touch a diagram, export your Shopify catalog's SKUs and titles to a spreadsheet and put it next to the manual's parts table. Go down the table row by row and match each part number to a SKU, noting two things as you go: which item numbers have no matching product at all, and which part numbers do not match any SKU by a simple text comparison even though you are fairly sure the part exists in your catalog.

This is the exact step that automatic matching does for you, and it is also where a lot of parts catalogs quietly break: merchants skip the row-by-row check, publish the diagram anyway, and only find the gaps when a customer reports one.

Keeping Part Numbers Usable as SKUs

Where it is practical, store the OEM or manufacturer part number as the Shopify SKU itself, so there is one fewer translation step between the drawing and the catalog. If your business already depends on its own SKU scheme, keep the OEM number somewhere structured and searchable on the product; a dedicated metafield holds up better over time than burying it in the description text.

Decide once how you will handle punctuation, whether dashes and spaces stay or go, and apply that rule consistently across every product, since matching by exact text only works if both sides follow the same convention. When a part is superseded, update the old diagram's link to point at the new product rather than leaving a dead "no product yet" hotspot where a customer expects to find it.

How Automatic Matching Handles This

DiagramCart syncs your store's catalog through Shopify's product API, then matches each part number it reads from the manual's table against your catalog's SKU field. Anything that matches cleanly gets linked automatically; anything that does not is flagged so you fix it once by hand instead of guessing why clicking item 14 shows nothing.

This still depends on your SKUs being reasonably close to the OEM numbers to begin with. The cleanup from the section above is worth doing regardless of which path, manual or automatic, you use to build the diagram.

Checklist Before You Publish a Diagram

Catalog synced and current as of today
SKUs match OEM numbers, or the OEM number is mapped somewhere structured on the product
Every item number on the drawing has a status: matched, flagged for review, or confirmed not sold separately
Out-of-stock parts actually show as out of stock rather than disappearing from the diagram
One test click on the live product page before you call the diagram done