By "product number", I assume you're referring to the SKU. If so, then I've heard of some implementations that track the SKU in place of the product name, then use Classifications to add metadata. This is the same process as you've described.
Then, the difficulty is usually around managing the Class...