Home StreamsDynamics 365 The Product Catalog in Dynamics 365 Sales: Products, Price Lists and Prices That Compute Themselves

The Product Catalog in Dynamics 365 Sales: Products, Price Lists and Prices That Compute Themselves

by Mo Faheem
The Product Catalog in Dynamics 365 Sales: Products, Price Lists and Prices That Compute Themselves

Ask a sales team where their prices live and you will usually hear “in the quote template” — which is a polite way of saying “in whatever the rep remembered to type”. Dynamics 365 has carried a full product catalog since its earliest days: products, unit groups, price lists and discount lists that turn quoting from typing into picking. Setting it up takes an afternoon, and it is the difference between quotes that are right by construction and quotes you have to proofread.

The four building blocks

Everything lives in the Sales Hub’s App Settings area, under Product Catalog. Products are the things you sell — and they can be organized into families (hierarchies for related items) and bundles (sell-together kits with their own price).

Product catalog in Dynamics 365 Sales showing the All Products Families and Bundles view with sample coffee products and the Add Family, Add Product and Add Bundle commands
The catalog: products, families and bundles, managed under App Settings in Sales Hub.

Unit groups answer “in what quantities?” — a bag of coffee might sell as Each, Case of 12, or Pallet, each unit converting to the base. Price lists are where money enters the picture, and discount lists layer volume breaks on top. The mental model: a product describes the thing; a price list entry describes what the thing costs in a specific context — currency, customer segment, channel, or season.

Price lists do the pricing

A price list is a named set of prices in one currency. Open one and its Price List Items tab is the actual price book — one row per product per unit:

Price List Items tab in Dynamics 365 showing products with their units and currency amounts on a price list
The price book: one row per product per unit, in the price list’s currency.

Because prices live here and not on the product, the same catalog supports a CAD list and a USD list, a retail list and a wholesale list, this year’s list and next year’s — without duplicating a single product. Put a default price list on an account (or let territory defaults do it) and every new opportunity, quote and order for that customer starts from the right prices automatically.

Pricing methods: more than a number

Open a single price list item and there is more intelligence than you might expect:

Pricing information tab of a price list item showing pricing method Currency Amount, the amount and rounding options
Pricing methods go beyond flat amounts — percent of list, markup, margin, and rounding policies.

Currency Amount is the simple case — this product costs this much. But the pricing method dropdown also offers percent-based methods: percent of list price, or markup and margin percentages based on the product’s standard cost. Set the wholesale list to “90% of list” once, and every product’s wholesale price follows the retail list forever — no spreadsheet reconciliation. Rounding policies then keep the computed results looking like prices instead of long division (ending in .99, rounded to the nearest 5, and so on).

Where it pays off

The payoff arrives on the opportunity and quote. Reps add products, not text lines: pick from the catalog, set a quantity, and price, discount and totals compute themselves. Nobody quotes the old price of the Café A-100, because there is no place to type a price at all — write-in products remain possible, but they become the exception you notice rather than the norm you cannot audit. Reporting gets the same upgrade: “revenue by product family, this quarter versus last” is a real query the moment line items reference real products.

Start small: one unit group, your top twenty products, one price list. Wire the price list to your five biggest accounts and quote from the catalog for a month. The afternoon of setup will feel cheap the first time a price change takes one edit instead of an email to the whole sales team.

Related Articles

Leave a Comment