We are in the Retail business, we need to define a product number, what is the recommend way to give proper naming convention to Product number in D365 commerce?
we have more than 70,000 products with different unit of measures
we have a list Category hierarchy, lets say
Category Hierarchy
Food
- Drinks
- Fruit Drinks
- Non-Sugar
- Sugar
- Coffee Drinks
- Healthy Drinks
- Soft Drinks
- Water
- Flavored Water
- Non-Flavored Water
- Fruit Drinks
What is the recommend way of naming the product number?.
Ex: Coffee Drinks(sub category) -> Nescafe Mocha Drink (product)
so product code like CFEDR0001, so the next product when I create on the same category, the product number to be CFEDR0002
Or Just Auto generate product number regardless of any Category hierarchies