SAP Knowledge Base Article - Public

2731306 - Error "Item for Product ID XXXX already exists", When Migrating Price Lists

Symptom

Error "Item for Product ID XXXX already exists" while migrating price lists

* XXXX represents the Product ID

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Configuration work center
  2. Search activity Migration of Price Lists
  3. Choose migrate price lists using the migration tool
  4. Choose the migration mode add new records
  5. Execute Migration Step by Step
  6. Error "Item for Product ID XXXX already exists" in simulation step

Cause

There can be many reasons for this error. One of the reasons can be that, there are two items associated with the same product - XXXX in the system for that Price List.

  1. Go to Products work center
  2. Go to Price List view
  3. Choose the price list
  4. Go to edit
  5. Go to items tab
  6. Search with the product ID
  7. There are two entries for the same Product, one with status Released and the other Not Released 

Resolution

Delete the item associated with the product XXXX, which is in Not Released status before executing the migration.

To delete the items follow the below steps:

  1. Go to Products work center
  2. Go to Price List view
  3. Select the price list
  4. Go to Edit
  5. Go to the items tab
  6. In the find field search with the product ID
  7. There are two entries for the same product
  8. Choose the entry with status Not Released
  9. Choose remove button to delete it
  10. Save the price list

Keywords

Migration of Price List, Product ID exists, Price List , KBA , item for product id already exists , migration of price list , LOD-LE-MIG-MWB , LEAP Migration workbench , Problem

Product

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