Hi All,
While importing data in Opportunity Product using Import Excel, I am seeing some rows are not importing. Checking the error i found Duplicates in the Product Name (Single Line Of text) (We have Duplicate Product names and that is the reason we got the error)
I have added Existing Product (look-up) column and tried to update and it gave me the same error. I have updated Exiting product Column with Product Id(Unique value in Product table) (Instead of product name) and while importing the data mapped the Existing Product Field as Product ID. Now i got the error as Unit Name is not matched. ( ihave verifoed the Unit named it is mapped to correct unit name.
Can any one help me here to update the Opportunity Product import for Duplicate Products