web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    RE: How do i extract both a price list and product list?

    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,475 Most Valuable Professional on at
    RE: How do i extract both a price list and product list?

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 235

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 175

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 156 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans