The Product Catalog in Microsoft Dynamics
365 for Sales helps you track the items you’re
selling and how much you've sold them for.
In this video, we'll see how to configure
the different components that make up a product catalog.
 
Fabrikam a LED television company,
needs to structure their new product catalog
based on Units, Product families, Product
bundles, and Price lists.
Units are the quantities or measurements that
you sell your products or services in.
A Unit group is a collection of these different units.
For this example, the Unit group is Electronics
and, because televisions are sold as a single
piece, the unit will be Piece.
Think of the primary unit as lowest common
unit of measure.
In the Sales Hub, go to settings and select
Unit Groups.
Select new.
This will open the create Unit Group dialog
box.
In name, enter the Unit group name Electronics,
and for primary unit, enter Piece.
Select ok.
Now you can add units of measure for this unit group.
Select the Related tab and click Units.
You’ll see Unit group information along
with the primary unit that you added.
Click add new unit.
Create a unit called Box.
One box contains 6 pieces, so enter 6 in quantity
and select piece in base unit.
Save and close the unit.
Products are items or services that you can sell
to your customers.
When you have similar products, you can group
them as a product family, which makes them
easier to manage.
In this example, we will create a product
family called LED Television and assign common
properties like screen size, resolution, sound
type, and voltage requirement.
These properties are inherited by the products
added to this family.
Then we’ll add the products Proseware LED32
and Southridge LED32 under this family.
We’ll also add a product called Headphones,
which will not belong to any product family.
Go to settings and select families and products.
Select add family.
In the quick create product form, enter
name as LED Television and Product ID as LED_Television.
Save the form.
On the product properties tab, click add new
property.
In the New Property window, in name, enter
screen size.
Configure the other fields
make sure the read only field is No.
Set the required field to Yes.
Make sure that the hidden field is No
On the Properties tab, in data type, select
Option Set and save the form.
Add the option set values by clicking add
button.
In the quick create form, in name, enter 32-inch
screen and value as 32.
Similarly create the following options set
values
43-inch screen, 43
55-inch screen, 55
65-inch screen, 65.
On the property type tab, select the Default
Value as 32-inch screen.
Save and close the form.
Now, let’s create other common properties.
Resolution with data type as Single Line Of Text
Sound type, Single Line Of Text
Voltage requirement, Single Line Of Text.
Next, let’s add products to this family.
Go to the families and products page.
Select the product family LED television and
click add product
On the add product page, in name, enter Prosware LED32
Product ID is used to identify the product
in the catalog with a number.
In Product ID, enter PLED_32.
In the unit group lookup field, select Electronics.
Save the product.
Now, in default price list, select Retail
of which the currency is in US dollar.
We’ll talk more about pricing later.
Save the product.
Add product
Southridge LED32. In Product ID enter SRLED_32.
and in default unit, select Box.
Add another product by clicking Add new product.
Ensure that this product is not linked to
any product family.
Name as Headphones with product ID as Headphones_001,
unit group as Electronics.
Since we want to sell headphones with televisions
as a bundle, we selected the unit group Electronics
default unit as Piece and default price list as Retail.
Just like you sell an individual product,
you can also pair a top-selling product with
a less popular one and create a bundle of
products.
You can maximize the benefits for customers
by offering special pricing discounts on bundled products.
Let’s create a bundle by adding the products
Proseware LED32 and Headphones with a price
listed at $499.
On the Families and Products page, select
Add Bundle.
In the new bundle window, in name, enter Television
and Headphone and in Product ID, enter TV_HEADPHONES.
In the parent field, use the lookup and select
LED Television family.
In the Default Unit field, use the lookup
and select Piece.
In the Decimals Supported field, enter 0.
Select save.
This helps to display more details that you
can enter for this bundle.
In the additional details section, select
Add new price list item on the Price list
items sub-grid.
On the pricing information tab, in Pricing
method, select as Currency amount
and in amount, enter 499.
We’ll talk more about pricing later.
Save and close the form.
On the Bundle products tab, select Add new
product associations.
In the Bundle product window, select Product
as Proseware LED32.
In the Quantity field, enter 1.
Select the Required field as Required.
Select the Units field as Piece.
Save and close the form.
Now, add the product Headphones to the bundle
products.
After creating the bundle, publish the items in this order products family,  product and product bundle.
The Price list contains pricing details of
your products.
You can define price list items based on the
units in which the product is sold.
We are going to add currency as US dollar,
create a price list named Retail and price
list items for Proseware LED32.
In the sales app, go to Settings > Business
Management and then select Currencies.
Select New.
Select lookup on the Currency Code and the
select United States with US Dollar as Currency name
that is in English.
Select Add.
Since we are using US dollar, the conversion
rate is configured to 1.
For other currencies, configure the rate accordingly.
Save and close the currency.
In your sales app, go to App settings > Price
lists.
Select New.
In name, enter Retail.
In currency, select Lookup > Look up more
records, and then select US dollar.
Save the price list form.
This helps to display more details that you
can enter for this price list.
On the Price list items tab, select Add new
price list item.
In Product name, select Proseware LED32 and
then for Unit select Piece.
In Quantity selling option, select No control.
On the Pricing information tab, in Pricing
Method, select Currency Amount and in Amount,
enter 399.
Save and close the price list form.
Repeat this procedure for Southridge LED32
and Headphones as well.
You have just completed setting up a product
catalog.
Now your sales representatives can use this
to create sales opportunities.
