Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

What is the recommend way to define product number in D365 commerce for Retail Business?

(0) ShareShare
ReportReport
Posted on by 30

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

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

  • Suggested answer
    P Jackson Profile Picture
    1,611 on at
    RE: What is the recommend way to define product number in D365 commerce for Retail Business?

    It does not matter. All alpha, all numeric or alpha-numeric. Create them as you wish, they do not need to be consecutive and can be manually defined.

  • Shafeeque P. Profile Picture
    6,509 Super User 2025 Season 1 on at
    RE: What is the recommend way to define product number in D365 commerce for Retail Business?

    It requires customization.

  • Liamneesan Profile Picture
    30 on at
    RE: What is the recommend way to define product number in D365 commerce for Retail Business?

    Is that possible to Auto generate Product ID based on Category while creating a product master?

  • Suggested answer
    Shafeeque P. Profile Picture
    6,509 Super User 2025 Season 1 on at
    RE: What is the recommend way to define product number in D365 commerce for Retail Business?

    I don't think there is an out  of box functionality to have  a specific item code sequence based on the category. I wouldn't say this is not a standard practice as I have had two of our clients request this. Most of them go with the a single sequence itself.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 462 Moderator

#2
Danny Bilodeau Profile Picture

Danny Bilodeau 156 Moderator

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 120 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans