BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Supplemental product categories

A list page of the additional (supplemental) category hierarchies that group products for special purposes alongside the main Commerce product hierarchy.

Used by
Retail merchandising manager, Retail service
Business process
Manage sales channels
Menu item
RetailCategorySpecialManagement
Main table
EcoResCategoryHierarchy
Data entity
EcoResProductCategoryHierarchyEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page of the additional (supplemental) category hierarchies that group products for special purposes alongside the main Commerce product hierarchy.
What you do hereUse this page to create and maintain extra category hierarchies, for example for a promotion or a seasonal range, and add products to their categories; a product can appear in more than one supplemental hierarchy.
ExampleFor example, in spring put your swimwear products into a separate category hierarchy and apply promotional pricing to its categories.
Supplemental product categories page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processDevelop sales policies › Manage sales channels
Menu pathRetail and Commerce › Products and categories › Supplemental product categories
Set up firstCategory hierarchies Microsoft Learn
Used next byAssortments Microsoft Learn
Related pagesCommerce product hierarchy Microsoft Learn Channel navigation categories Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Supplemental product categories

Use this page to create and maintain extra category hierarchies, for example for a promotion or a seasonal range, and add products to their categories; a product can appear in more than one supplemental hierarchy.

Steps from Microsoft

  1. Go to Retail and Commerce > Products and categories > Supplemental product categories.
  2. Select New (Category hierarchy) to create a hierarchy, or open an existing one from the list.
  3. Select Edit category hierarchy to change the structure of categories.
  4. Select a category in the tree and, on the Products FastTab, select Add or Add products to add products or variants.
  5. On the Map vendor categories FastTab, map vendor product categories to the supplemental categories if needed.
  6. On the Category attribute values FastTab, review the category attribute values.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameThe name of the category.Microsoft Learn Name
ActiveShows whether the category is activated.Microsoft Learn
CategoryThe product category or supplemental category associated with the node.Microsoft Learn
Inherit attributes from parent categoryMakes the category inherit the attributes assigned to its parent.Microsoft Learn
Vendor product categoryThe vendor's own category mapped to this category so imported vendor products are categorised.Microsoft Learn

Test checklist

  1. Create a supplemental hierarchy and a category, and add a few products.
  2. Add the same product to a second supplemental hierarchy and check it's allowed.
  3. Link a discount to the supplemental category and check it applies to those products at POS.
  4. Check the category doesn't appear when browsing in POS, which uses the navigation hierarchy.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Supplemental product categoriesUse supplemental hierarchies only for special-purpose groupings, such as a seasonal promotion, and keep the main structure in the product hierarchyMicrosoft describes the supplemental type for additional hierarchies, for example a spring swimwear promotion with its own promotional pricing, while the product hierarchy type is used once for the overall structure.Expecting supplemental categories to drive browsing online or in POS. Only hierarchies of the navigation hierarchy type are used when customers browse by category.
Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Supplemental categories and their products can be added, changed or removed. Promotions or pricing linked to those categories follow the new membership. Microsoft Learn
If you change it laterIf a supplemental category is referenced by an active assortment, adding products to the category automatically adds them to that assortment's definition. Microsoft Learn
Technical architect

6Technical

Menu itemRetailCategorySpecialManagement Checked in Dynamics 365
FormEcoResCategoryHierarchyListPage Checked in Dynamics 365
TableEcoResCategoryHierarchyShown as “CATEGORY HIERARCHIES” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesEcoResProductCategoryHierarchyEntityProduct category hierarchies Microsoft data model RetailEcoResCategoryHierarchyEntityCategory hierarchies Microsoft data model
Who can open itPrivileges RetailCategoryAndProductWorkspaceMaintainMaintain retail item supplemental hierarchies RetailItemSpecialHierarchiesMaintainMaintain category and product workspace for retail trial. RetailTrialCategoryAndProductWorkspaceMaintainDuties RetailCategoryAndProductWorkspaceMaintainMaintain retail product reference data RetailProductReferenceDataMaintainMaintain category and product workspace for retail trial. RetailTrialCategoryAndProductWorkspaceMaintain
2 security rolesRetail merchandising manager RetailMerchandisingManagerRetail service RetailService
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the pageCategory hierarchy: Maintain, Set up, LanguagesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailCategorySpecialManagement
Integrate withEcoResProductCategoryHierarchyEntity data entity Microsoft data model
Data migrationEcoResProductCategoryHierarchyEntity (Product category hierarchies): shared by all companies, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Product category hierarchies at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionEcoResCategoryHierarchy columns and relations Microsoft data model
Everyone

8Sources