Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Unable to Import Data ...
Sales forum
Unanswered

Unable to Import Data to Opportunity Product

Posted on by 5

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)

pastedimage1677184501638v2.png

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.

pastedimage1677184433161v1.png

Can any one help me here to update the Opportunity Product import for Duplicate Products

  • Consultant1 Profile Picture
    Consultant1 5 on at
    RE: Unable to Import Data to Opportunity Product

    Hi,

    I have tried this. I have updated Product Name to Product ID, i got Unit is not matched error shown in the screenshot above

  • Eiken Profile Picture
    Eiken on at

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans