Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Dynamics CRM 2016 - import price list items (products) into multiple price lists

Posted on by Microsoft Employee

I have a set list of Price List Items (Products) that I need to associate to multiple Price Lists. I cannot find a way to quickly add the Price List Items (Products) to each Price List. I can see that I can export the Price List Items (Products) but I do not see a way to import them into each individual Price List. Can this be accomplished through the front end?

I am using Dynamics CRM 2016.

*This post is locked for comments

  • Somesh2207 Profile Picture
    Somesh2207 1,563 on at
    RE: Dynamics CRM 2016 - import price list items (products) into multiple price lists

    Thanks Karyn, Glad it helped you

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM 2016 - import price list items (products) into multiple price lists

    Somesh, Thank you for the detailed instructions. This works perfectly.

    Thanks,

    Karen

  • Suggested answer
    Luke Sartain Profile Picture
    Luke Sartain 1,266 on at
    RE: Dynamics CRM 2016 - import price list items (products) into multiple price lists

    You have a couple of options.  One option is to go to Settings > Data Management and then Templates for Data Import.  Once filled you can import via Settings > Data Management > Imports > Import Data.

    Another option would be to use the Kingswaysoft SSIS adaptor and then use SSIS to import the records.  This provides a bit more flexibility on the source format of your data but does require knowledge of SSIS.  

  • Verified answer
    Somesh2207 Profile Picture
    Somesh2207 1,563 on at
    RE: Dynamics CRM 2016 - import price list items (products) into multiple price lists

    Hi kmc333,

    You can import the data through excel and that is the fastest way to do it.

    Follow the steps:

    1. Create an CSVfile with columns as mentioned in below screenshot:

     You can see it has price list name as well as product id along with other required fields.

    Ans10.png

    2. In CRM, use Data management wizard to import the CSVto CRM. The data management wizard allows you to map the entity and fields. You can learn more on Data import wizard in this video, if you are new to it:

    https://www.youtube.com/watch?v=0KwKjpmhyzA 

    Ans8.png

    Ans10.png

    I have done this lots of times, sometimes with pricelist items more than 30-40 k

    Please check this and let me know.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans