SAP Knowledge Base Article - Public

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

Symptom

When migrating Price Lists, you receive the below error in the simulation step:

Item for Product ID XXXX already exists

* XXXX represents the Product ID

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Configuration work center
  2. Search and select the activity Migration of Price Lists
  3. Select Migrate Price Lists using the migration tool
  4. In the Migration tool, select the migration file
  5. Select the Migration mode Add new records
  6. Select Execute Migration Step by Step
  7. You will be able to see the mentioned error in the 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. You may check it using the below steps:

  1. Go to Products work center
  2. Go to Price List view
  3. Select the Price List
  4. Select Edit
  5. Go to the Items tab
  6. Search with the Product ID
  7. You can see that 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. Select Edit
  5. Go to the Items tab
  6. In the Find field search with the Product ID
  7. You can see that there are two entries for the same Product
  8. Select the entry with status Not Released and delete it by choosing Remove button
  9. Select Save

Keywords

Migration of Price List, Product ID exists, Price List , KBA , LOD-LE-MIG-MWB , LEAP Migration workbench , Problem

Product

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