Save codes as identifiers, not as accidental text fragments.

Uniqueness

Capture scope: worldwide, by supplier, by store or internally.

Normalization

Recognize allowed write variants such as dashes or spaces without merging different codes.

Historical codes

Use controlled mapping when customers keep searching for old item numbers.

Exact ranking

A valid identifier is a strong explicit signal and should not lose from wide semantic matches.