Product catalog entities

 

Updated: November 29, 2016

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

A product catalog is a collection of products with their pricing information. The product catalog entities let you create a rich product classification system in Microsoft Dynamics 365 that provides support for:

  • Defining hierarchical structure of product families and products with configurable properties (attributes) that help you reduce the number of product stock keeping units (SKUs) needed to maintain your product catalog.

  • Selling individual products or grouping them into bundles and kits. A bundle or a kit is a collection of products that is sold as single unit. Product bundling is useful in grouping products in a way that customers get more benefit from the full line of products or to offer discounts on bundled products.

    System_CAPS_noteNote

    Kits are deprecated in the current release of Dynamics 365. You should use bundles instead.

  • Defining related products in the system (substitute, cross-sell, up-sell, or accessory). The related products for a product are displayed as suggestions to the sales agents when they add the product to an opportunity, quote, order, or invoice.

  • Defining multiple pricing and discounting models. You can also use custom pricing instead of the Dynamics 365 system pricing to calculate prices when you associate a product or bundle to an opportunity, quote, order, or invoice. Further, you can select whether to apply discounts for products at the per-unit or line level.

  • Specify whether you want the price level (price list) to be automatically set for an opportunity, quote, order, or invoice based on the sales territory relationship of the user.

  • Specifying localized values for certain product properties (attributes) to make the product names and descriptions available in the user-preferred languages.

Use the following entities in Dynamics 365 to manage your product catalog.

Entity

Description

Product

A product is either a physical inventory item (such as lumber or a nail), or a service (such as a haircut or tree pruning) that a company sells. Products from the product catalog can be used to build quotes and orders, and can be associated with opportunities or service cases. In addition, each product can contain links to sales literature and links to information about competitors and their products. More information: Product entity messages and methods

ProductSubstitute (Product Relationship)

A product relationship contains information about the selling relationship between two products, including the relationship type, such as up-sell, cross-sell, substitute, or accessory. More information: ProductSubstitute (product relationship) entity methods and messages

DynamicProperty (Property)

A property stores information about a product property such as its name, the product family record that its associated with, attributes such as data type, whether its read only, hidden, or required.

DynamicPropertyOptionSetItem (Property Option Set Item)

A property option set item stores information about individual options for a product property of option set data type.

DynamicPropertyInstance (Property Instance)

A property instance stores the instance of a product property along with its values. More information: DynamicPropertyInstance (property instance) methods and messages

PriceLevel (Price List)

A price list contains one to many individual product and bundle prices, aggregated together into a list for categorization purposes. This enables easier maintenance and usability of the list. More information: PriceLevel (price list) entity messages and methods

ProductPriceLevel (Price List Item)

A price list item represents configurations that enable a business unit to control how prices are calculated in Microsoft Dynamics 365 such as quantity selling options, pricing method, rounding policy, and the rounding option. More information: ProductPriceLevel (price list item) entity messages and methods

Discount

Discounts enable a product to have different sales prices, depending on the quantity purchased. More information: Discount entity messages and methods

DiscountType (Discount List)

A discount list is an aggregation of different discounts, specifying how much of a discount the user can receive when the purchasing amount falls between certain ranges. Discount lists can exist at each quantity level, together with detail lines that contain the quantity breakpoints, and the reduction in the price. More information: DiscountType (discount list) entity messages and methods

UoM (Unit)

A unit is a measurement that specifies in what quantity a product will be sold. More information: UoM (unit) entity messages and methods

UoMSchedule (Unit Group)

A unit group contains one to many types of unit of measurement, as calculated from a base unit. A product is tied to a unit group in which it is sold. More information: UoMSchedule (unit group) entity messages and methods

These videos describe how products are administered and used in Microsoft Dynamics CRM 2015 and Microsoft Dynamics CRM Online 2015 Update:

Microsoft Dynamics 365

© 2016 Microsoft. All rights reserved. Copyright

Community Additions

Show: