BeyondERP.Newsletter
Menu

Setup page · Retail and Commerce

Mix and match discounts

A setup page where you create and manage mix and match discounts, which give a discount when a customer buys a specific combination of products defined by line groups.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Create mix and match discounts in Dynamics 365 Commerce
Menu item
RetailDiscountMixAndMatch
Main table
RetailPeriodicDiscount
Data entity
RetailDiscountEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create and manage mix and match discounts, which give a discount when a customer buys a specific combination of products defined by line groups.
What you do hereUse this page to define which products belong to each line group, how many of each are needed, and how the discount is calculated (deal price, percentage, amount, least expensive or per line).
ExampleFor example, give product B free when the customer buys two items from a category together with product B in the same cart.
Mix and match discounts page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processIntroduce products › Set product prices › Create mix and match discounts in Dynamics 365 Commerce
Menu pathRetail and Commerce › Pricing and discounts › Mix and match discounts › Mix and match discounts
Set up firstMix and match line group setup Microsoft Learn Price groups Microsoft Learn
Used next byPrice simulator Microsoft Learn Distribution schedule Microsoft Learn
Related pagesMix and match line groups Microsoft Learn Commerce parameters (Distribute discounts for least expensive discounts) Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Pricing and discounts > Mix and match discounts > Mix and match discounts.
  2. On the Action Pane, select New > Mix and match discounts.
  3. Enter the discount name, price groups, priority and validation period.
  4. On the Price/discount FastTab, in the Calculation type field, select the calculation (for example Line spec).
  5. On the Lines FastTab, select Add to add the first product and set its Line group and Discount value.
  6. Select Add again for each further product or category, setting its Line group and Discount value.
  7. Set Status to Enabled.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Calculation typeHow the discount is worked out, such as a line-specific discount per product.Microsoft Learn
Line groupThe group each discount line belongs to; the customer must buy the required quantity from every group.Microsoft Learn
Discount valueThe discount given on that line when the combination is bought.Microsoft Learn
Number of least expensive linesFor least-expensive discounts, how many of the cheapest qualifying products receive the discount.Microsoft Learn
Deal price valueThe fixed total price charged for the combination when the discount type is Deal price.Microsoft Learn
Count non-discountable productsLets a product that cannot be discounted still count towards qualifying for the mix and match.Microsoft Learn
UnitRequired unit of measure on each line; it must match the sales line.Microsoft Learn UnitOfMeasure
StatusEnabled or Disabled; least-expensive settings are validated on enabling.Microsoft Learn Status

Test checklist

  1. Create a mix and match discount with two line groups, each needing 1 product, and a Unit on every line.
  2. Enable it and run the 1020 job.
  3. Ring up one product from each group and check the discount applies.
  4. Ring up only one group and check no discount applies.
  5. If Count non-discountable products is on, include a product set to Prevent all discounts and check it qualifies but gets no discount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Number sequences

ReferenceShared or per companyNote
DiscountPer companyNew records on this page take their Discount from the RetailOfferIdEx3 reference; BEAT uses number sequence Comm_79. Checked in Dynamics 365
Solution architect

5Design impact

Can it be undoneOne-way: Warning: the Discount ID and Discount type are fixed once created. Line groups and lines can be changed only while the discount is Disabled. Microsoft Learn
If you change it laterLine groups that need more than 20 products slow price calculation; use a larger unit of measure instead. The discount can only be edited while disabled. Microsoft Learn
Technical architect

6Technical

Menu itemRetailDiscountMixAndMatch Checked in Dynamics 365
FormRetailPeriodicDiscount Checked in Dynamics 365
TableRetailPeriodicDiscountShown as “PERIODIC DISCOUNT” in Record infoKey field: OfferIdChecked in Dynamics 365
Data entitiesRetailDiscountEntityPeriodic discount Microsoft data model
Who can open itPrivilegesMaintain retail discounts RetailDiscountsMaintainView retail discounts RetailDiscountsViewMaintain retail mix and match RetailMixAndMatchMaintainMaintain retail mix and match RetailMixAndMatchViewDutiesMaintain retail campaign discounts RetailDiscountOfferMaintainMaintain retail campaign discounts RetailDiscountOfferView
4 security rolesRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail merchandising manager RetailMerchandisingManagerTo use itRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): New, Copy from, Price groups, View shared products, Validation logsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailDiscountMixAndMatch
Integrate withRetailDiscountEntity data entity Microsoft data model
Data migrationRetailDiscountEntity (Periodic discount): loaded for each company.Microsoft Learn
Table definitionRetailPeriodicDiscount columns and relations Microsoft data model
Everyone

8Sources