SAP Knowledge Base Article - Public

2791297 - Error: "Only One Top Category is Permitted; More Than One Top Category Exists" While Creating Product Categories Using Data Workbench


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"


SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Click on Import.
  3. Select the Individual Business Object radio button.
  4. Search for Product Categories in the object list.
  5. Click on Next.
  6. Upload your template.
  7. Click on Next until you reach the Import button.
  8. Go to the Monitor view and see the import has failed, with the error message mentioned in the Symptom section.


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.


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.


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


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions