Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / The price level id is ...
Microsoft Dynamics CRM (Archived)

The price level id is missing?

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All,

I'm trying to do a mass import products into a Price List with an Excel file. I'm getting an error that says

"An error has occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support."

 and under More Information its telling me 

"The price level id is missing".

Can anyone help out on this. My method so far has been to use a "Price List Item" template and fill in all the required columns:

Price List

Product

Unit

Quantity Selling Option

Pricing Method

Percentage

Rounding Policy

I then import it back in using the Import Wizard and I get the errors mentioned above.

*This post is locked for comments

  • Gabriel Barreto Profeta Profile Picture
    Gabriel Barreto Pro... 15 on at
    RE: The price level id is missing?

    I don't know if this will help you dear man, but I made an advanced localization with all the product items I needed, downloaded it via FetchXml, then went to XrmToolbox, and added the "pricelevelid" column, saved my result as a view in the system, and downloaded it again in Excel format, only then I could import it from the other side in CRM, hope this helps.

  • Suggested answer
    Dhanraj IncubXpert Profile Picture
    Dhanraj IncubXpert 15 on at
    RE: The price level id is missing?

    Have you found any solution?

    If not, try to edit column names in the Excel sheet this will Popup the 'Custom Data Mapping' page while importing and you can now map the correct fields and you should not get any error. It will get imported successfully.

  • Joe@layer1holdings.com Profile Picture
    Joe@layer1holdings.com 5 on at
    RE: The price level id is missing?

    I am having the same issue, I've spent 3 days on it. I'm still learning how to work with "custom data mapping" if you recall anything to add for this detail it would be helpful

  • Community Member Profile Picture
    Community Member on at
    RE: The price level id is missing?

    To All,

    I had to mess around with the custom data mapping to get it to work.

    Thanks for all of the help.

  • Community Member Profile Picture
    Community Member on at
    RE: The price level id is missing?

    Daniel:

    Price Level ID is a Primary Field.

  • Community Member Profile Picture
    Community Member on at
    RE: The price level id is missing?

    Damon,

    Thanks for the response.

    I tried with and without Amount and Discount List being blank.

    Unit is correct.

    I have a Master Product List that these Price Lists are pulling their List Price from, I have other Price Lists that are working fine and that have been imported the same way I've been trying. Thats whats really confusing me.

    Column A-C are columns that are automatically put in whenever I export data from CRM. I've tried to import the file with and without those columns present.

    Import-A_2D00_C.JPG

    Does anyone know what "Price Level ID" is?

  • Community Member Profile Picture
    Community Member on at
    RE: The price level id is missing?

    Hello Daniel:

    Try to add these two columns Amount and Discount List

    No value in both of them.

    Also make sure the Unit is right.

    Do you have a Master Price List?

    Also When you're looking at the import list look at the columns does it start with Col A.

    I'm looking at your columns and it's starting with D. There might be unwanted Columns A-C

    that need to be deleted

  • Community Member Profile Picture
    Community Member on at
    RE: The price level id is missing?

    Hello Aileen,

    Here is the data example. I'm using a template of type "Price List Item".

    I'm trying to input 274 Price List Items (products) of this type.

    Import-Data.JPG

    Here is the report I'm getting after using the Import Wizard. 

    Import-Data.JPG

    The successes are coming from the 3 Items that I input into the Price List Manually. 

    Yesterday I found the post you linked above, that doesn't seem to be my problem. 

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at
    RE: The price level id is missing?

    Daniel,

    Can show us the data example?

    Refer to this if possible:

    community.dynamics.com/.../150718

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 54

#3
dkrishna Profile Picture

dkrishna 6

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans