web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM 2016 - im...
Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Verified answer
    Somesh2207 Profile Picture
    Somesh2207 1,563 on at

    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.

  • Suggested answer
    Luke Sartain Profile Picture
    Luke Sartain 1,266 on at

    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.  

  • Community Member Profile Picture
    Community Member on at

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

    Thanks,

    Karen

  • Somesh2207 Profile Picture
    Somesh2207 1,563 on at

    Thanks Karyn, Glad it helped 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
NeerajPawar Profile Picture

NeerajPawar 2

#2
jlattimer Profile Picture

jlattimer 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans