web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Quantity Discount Set-Ups

(1) ShareShare
ReportReport
Posted on by 21
Is there an easier way to set up quantity discounts rather than excluding all items out of the promotion and including all of the other items in the discount? 
 
Currently, we are pulling from plan all products in stores, to exclude rather than including the items involved in the promotion and excluding the /hierarchy/ or the other products that are excluded from the promotion. 
I have the same question (0)
  • Shafeeque P. Profile Picture
    6,533 Moderator on at
    I couldn't understand your questions. Could you site some examples?
  • mclutinger Profile Picture
    21 on at
    @Shafeeque In this particular set-up we would want the buyer to buy 3 products in order to receive a 30% discount. Currently, our set up is to exclude everything NOT included in the promotion and include our product Hierarchy. Below is the current set up. I am wondering if there is a better way to set this up. I have tried to include the products in the promo and exclude the product Hierarchy, but it does not register that promo when ran then in price simulator.
  • Shafeeque P. Profile Picture
    6,533 Moderator on at
    This can be done in multiple ways. Lets assume your commerce product hierarchy contains the following categories
     
    Category No. of Products
    Men 1500
    Women 2200
    Kids 1300
     
    If you want to run a promotion where 1475 in Men's Category in it should be part of the promotion. The best option would be to add the category as included and 25 lines as excluded.
     
    Item ID  Category Line Type
      Mens Include
    EXCLUDED ITEM01   Exclude
    EXCLUDED ITEM02   Exclude
    EXCLUDED ITEM03   Exclude
    EXCLUDED ITEM25   Exclude
     
     
    If you want to run a promotion where 750  items from the Mens category should be part of the promotion. It is better to add the items (as included). You don't need to add the category as excluded.
    It is important to note: If you add the category name as excluded and add products within this category as excluded, the promotion may not work due to conflicts.
     
    Item ID  Category Line Type
    INCLUDED ITEM01   Include
    INCLUDED ITEM02   Include
    INCLUDED ITEM03   Include
    INCLUDED ITEM750   Include
     
     
    The third option, if the product list is repetitive over a period for multiple promotions. Say 600 products from Mens, 400 from Women and 250 from kids are part of the list.
    Create a new product hierarchy called "Promotions" and list the hierarchy as "Supplemental retail hierarchy" in "Category hierarchy role associations" screen. Add a new category node and lets give the name "BUY 3 on  30%". Associate all the 1250 products into this category. Use this category node in promotion.
     
    Item ID  Category Line Type
      BUY 3 on  30% Include
     
     
    In real life scenario, everyone end up mostly using product lines as included, as category is not always an option.
     
     
     
     
     
     
     
     
     
  • mclutinger Profile Picture
    21 on at
    Is there a way to set this up with just the products, not categories. Not every product in the product category applies to this promotion.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 299 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 183 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 118 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans