Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Importing product to unit group in dynamics365

(0) ShareShare
ReportReport
Posted on by 366 User Group Leader

Hello,

I have like 5,000 products to add to the product catalogue in the Dynamics 365, but i need to create unit group for each products. IS there anyway i can import the Unit Group (that contains Name and Primary Unit) or is there anyway i can make the unit group not required from the product list area in Dynamics 365???

I will appreciate your help.


Thanks

*This post is locked for comments

  • RE: IMPORTING PRODUCT TO UNIT GROUP IN DYNAMICS 365

    Hello Hammed

    You can ask your developer to always automatically create price list

    item in CRM.

    community.dynamics.com/.../auto-create-price-list-item-for-dynamics-crm-2011-products.aspx

    It is easier later as basically in CRM, you cannot create a Quote and also key in

    Opportunity product without having a Price List.

    I know you might not need this because you don't have Price List for each

    product and it seems like another additional work.

    Let we know the usage and the purpose of this Price List:

    1. Price List will be used to choose products that are parts of a Price List

    as Price List Item

    2. To get default pricing

    3. To count the default extended amount, otherwise you have 0.

    However, You can still choose product that is not a Price List Item of that

    Price List, but you need to have Default Price List for that product.

    So, for another word, yes, you need to have at least 1 Price List for 1

    Product as the Default price List.

    Anything you want to know about Default Price List you can see this post:

    missdynamicscrm.blogspot.com/.../10-facts-about-default-price-list-in-CRM2011-2013-that-you-might-not-have-noticed.html

    And since you said you have imported 500 products and you have the Excel

    Template for Product, I would suggest you to continue this method, but now is

    to Import the Price List Item.

    The Price List Item is basically a combination of Price List and Product and

    Unit.

    And it is very recommended to have one Price List, as per I mentioned before,

    you only need 1 Price List, at least, no need to have many Price List unless

    you have 1 Product in different Price and Unit, for example:

    1. Product ABC 1 PC in Price List Normal Price is $1000

    2. Product ABC 1 PC in Price List Thanksgiving Promotion Price is cheaper,

    $800

    3. Product ABC 1 PC in Price List Clearance Sales November Promotion price is

    even cheaper, it is $500

    Then you need 3 Price Lists + 3 Price List Item for 1 Product ABC

    But dont worry, you can still using the same method for your 500 Products,

    that is using Import Wizard.

    First, you need to create a Price List as I mentioned before.

    You can refer to this link:

    rc.crm.dynamics.com/.../importpricelist.aspx

    You can download the Import Template:

    From Data Management --> Templates for Data Import --> Choose Price List Item

    And Download It.

    Then you will have the .XML File and then you need to key in the Mandatory Field (a Bold column)

    You can compare to the Price List Item'

    If you only have a Price List then you can name it to Normal Price List, All, or Default Price List.

    And to see what you have imported you can see this post as well:

    niiranen.eu/.../working-price-list-items-dynamics-crm

    I think if still using the Import Template it is the most efficient way for Sales people.

    If you want to know more about Import Template you can refer to this link:

    missdynamicscrm.blogspot.com/.../understanding-import-template-crm-2011-2013-fields.html

    I hope this can help you.

    Thank you.

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans