Symptom
You are trying to import product categories into your system, using the Data Workbench tool, but you are receiving the below error message:
"Only one top category is permitted; more than one top category exists"
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the Data Workbench work center.
- Click on Import.
- Select the Individual Business Object radio button.
- Search for Product Categories in the object list.
- Click on Next.
- Upload your template.
- Click on Next until you reach the Import button.
- Go to the Monitor view and see the import has failed, with the error message mentioned in the Symptom section.
Cause
In the CSV template, you may be creating subcategories directly under ROOT, if you are creating these subcategories directly under ROOT the 'Parent_Product_Category_ID' value should be 'ROOT', instead of empty.
Resolution
To solve the error, add the value ROOT to the 'Parent_Product_Category_ID' of the subcategories you wish to create directly under ROOT and import the file again.
Keywords
data workbench, import, product categories, product category hierarchy, only one top category is permitted, subcategory , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-LE-PRD-PRD , Product + Product Category Hierarchy , Problem