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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

How do i extract both a price list and product list?

(0) ShareShare
ReportReport
Posted on by 5

So i have 2 separate lists my product list has a product code but no price and my price list has the listed price but no product code this is a hassle because I'm attempting to make labels in my storefront and need both information in a excel doc however when i export both lists they end up mismatched (i also have multiple product lists separated into categories of products but just one big price list) anyone have any ideas on how to get the data to match up I've been racking my brains about this for weeks it seems so simple

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Rippermaster,

    As yoummentioned, “i have 2 separate lists my product list has a product code but no price and my price list has the listed price but no product code”

    Which means you are using Product and Price List entities?

    Because I did not find a price field in the price list entity, but I found price list item has price.

     pastedimage1625026633357v1.png

    Maybe you can provide screenshot of them in the crm, which can meke me help you easily.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Suggested answer
    dian74 Profile Picture
    2,481 Most Valuable Professional on at

    You can create an advanced find view from pricelist items and pull in the product data that way (since there is a 1 to many relationship between product and pricelist items). From there you can export the list to excel. Example screenshot below. Is this what you're trying to do?

    pastedimage1625063800253v1.png

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Nagaraju_Matta Profile Picture

Nagaraju_Matta 121

#2
ManoVerse Profile Picture

ManoVerse 71 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans