SAP Knowledge Base Article - Public

2823031 - Howto Update the Product Category Description with Data Workbench


You have a Product Category Description in your system and want to add a new description in a different language. However, Data Workbench does not export the External Key that is mandatory to update the values.


SAP Sales Cloud

Reproducing the Issue

  1. Go to Data workbench work center
  2. Select on Export
  3. Search for Product Category Description
  4. Export the data
  5. Select on Monitor
  6. Open task name XXXX (where XXXX refers to Product_Category_Task_Name)
  7. External Key is blank
  8. Select Import
  9. Search for Product Category Description
  10. Upload the target entity (product category description)
  11. Select Next
  12. Go to Monitor view
  13. Open the relevant error file
  14. Error: External key does not exist for Product Categories


A Data Workbench export file does not include External Keys. This is the standard behavior.


Follow the workaround below:

  1. Extract the existing descriptions by exporting Product Category Description via Data Workbench
  2. In the extracted CSV, sort the records according to the content of ParentObjectID (= UUID of the product category) column
  3. Ensure that the data in the ParentObjectID column shows an ascending order
  4. Empty (not remove) the column ObjectID and HeaderObjectID
  5. Maintain a new External_Key for the records
  6. Maintain the data in Language and Product_Category_Description
  7. Ensure that only ParentObjectID, External_Key, Product_Category_ID, Language and Product_Category_Description are maintained

This CSV/Excel file can be used to update the required data:

  1. Go to Import view
  2. Select Individual Object tab
  3. Select Update option on object Product Category Description
  4. Complete the Upload of the file and the Import steps


Data Workbench, Update Product category Description, Languages , KBA , LOD-LE-PRD-PRD , Product + Product Category Hierarchy , Problem


SAP Cloud for Customer core applications 1905