> There is a natural PK in the form of the supplier's parts number, but ...

Or even better: Then the supplier revamps their parts numbering scheme, and every product gets a new number.