Supply chain | Supply Chain Management, Commerce

Unanswered

Quantity Discount Set-Ups

(1) Share

Report

Posted on by mclutinger

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.

All responses (4)

Answers (0)

mclutinger 21 on at

Like (0)

Report

Quantity Discount Set-Ups

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.

Shafeeque P.

6,507 Super User 2025 Season 1 on at

Like (1)

Report

Quantity Discount Set-Ups

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 21 on at

Like (0)

Report

Quantity Discount Set-Ups

@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. 6,507 Super User 2025 Season 1 on at

Like (1)

Report

Quantity Discount Set-Ups

I couldn't understand your questions. Could you site some examples?

Community site session details

Quantity Discount Set-Ups

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Quantity Discount Set-Ups

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates