Applies to Product - Dynamics 365 Commerce
What’s happening?
Importing of Supplemental hierarchy by products entity (Hierarchy name and Product category) is adding multiple records into the RetailGroupMemberLine table, specifically two records with incorrect category assignments.
Reason:
The primary root cause of this is identified as a recursive structure in the category hierarchy, which leads to confusion during the import process. The system incorrectly assigns the category due to misinterpreting the parent-child category relationships. The category has multiple recursive parent-child relationships within the category hierarchy, where the category is both a parent and a child of another similar category. This recursive nesting of categories likely causes confusion during the import process, leading to misassignments.
Resolution:
- Restructure the category hierarchy to eliminate recursive relationships. The current recursive parent-child relationship in the category is causing confusion during the product import process, leading to misassignments.
- Run test imports to validate the changes. After adjusting both the hierarchy and the import logic, it’s important to verify that the changes have resolved this.