Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have a list of Products in an Excel spreadsheet that I'd like to import into the Product table. When I import I'm getting this error "ERROR - Target CRM Attribute: pricelevelid for CRM Entity: product is not ValidForCreate."
This seems odd and on further inspection it seems that the Default Price List is locked and never editable on row creation. This is why it's failing when I import and map a field to it.
It is only after the the product is created that you can enter a Default Price List.
My question is, firstly, why is this field locked during creation and secondly, how would I import a product with a Default Price List?
Why is this field locked during creation?
The field "Default Price List" is locked when the product is created and it can be edit after the product has been saved.
You can refer to the following article to know more about it.
10 Facts about Default Price List in Entity Product in CRM 2011/ 2013 that You Might Not Have Noticed ~ Ms. Dynamics CRM (missdynamicscrm.blogspot.com)
How would I import a product with a Default Price List?
Please check the template of the Product entity for importing. There is no "Default Price List" field in the template.
So you cannot set the field when importing the products.
Can you try below explanation?
First of all create date, then export them via advance find( add default price list and necessary colums to the export file). Set price list on da export date and import them again.
I have a list of Products in an Excel spreadsheet that I'd like to import into the Product table. When I import I'm getting this error " ERROR - Target CRM Attribute: pricelevelid for CRM..
sign 2008 - 2010 ? who ?
Yes, firstly the Default Price List field on product entity form for adding new product record will be disabled at the first time. Once you created and saved the product record, it will not automatically set the Default Price List and you need to manually select the Default Price List. This is the by default behavior of Dynamics 365 CRM Product Catalog.Once the product is saved, you can not directly choose the Default Price List until you have Price List Item defined for that product. Once you create Price List Item then, price from that Price List Item will be automatically set as the Default Price List.
Secondly to import the product records from excel, you can download the template excel file from Advance Settings -> Data Management -> Template for Data Import as shown in screenshot.
After opening the template file, you can see there is no column available for Default Price List field in the template. So you cannot set the value of the Default Price List when importing the product from an excel file.
You can refer the following article to know more about Default Price List in CRM.https://community.dynamics.com/crm/b/misscrm360exploration/posts/10-facts-about-default-price-list-in-entity-product-in-crm-2011-2013-that-you-might-not-have-noticed
Hope this helps.
Business Applications communities