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
- Go to Business Configuration work center
- Search activity Migration of Price Lists
- Choose migrate price lists using the migration tool
- Choose the migration mode add new records
- Execute Migration Step by Step
- 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.
- Go to Products work center
- Go to Price List view
- Choose the price list
- Go to edit
- Go to items tab
- Search with the product ID
- 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:
- Go to Products work center
- Go to Price List view
- Select the price list
- Go to Edit
- Go to the items tab
- In the find field search with the product ID
- There are two entries for the same product
- Choose the entry with status Not Released
- Choose remove button to delete it
- 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