SAP Knowledge Base Article - Public

1832112 - Error Message "Product Category ID XYZ does not exists", While Uploading Materials Using MS Excel


When you try to Upload New Materials using Microsoft Excel, system throws below error message:

"Product Category ID XYZ does not exist"


SAP Business ByDesign

Reproducing the Issue

  1. Go to Product Data work center.
  2. Select Materials view.
  3. Select New button and choose Material from MS Excel.
  4. Download the Excel and update the Material details.
  5. Select Save Data To in the Excel.


There could two possibilities which caused the issue:

  1. The Product Category entered by you in the excel is wrong.
  2. You have assigned the Product Category ID to another field instead of Product Category field.


Solution 1: Check in the system (Product Category view in Product Data work center) whether the Product Category exists and assign the correct Product Category ID.

Solution 2: Check the excel again and assign the Product Category ID to correct field.


KBA , SRD-MD-PRD-PRD , Product , How To


SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1902