Quantity discounts based on same item

I am trying to implement quantity discounts based on the number of the same item ordered. I can see that I can apply a discount based on the quantity of a specific item in the cart but as I understand it I would have to provide the specific item number. I want this to work across the whole site (roughly 4000 products) so the customers can get a discount for buying 5 and 10 of the same product. To do this using the quantity of a specific item in the cart trigger would require 4000 rules. Could you kindly point me in the right direction? This is a customer request for an ASP site.

Many thanks.

you would need to have a Cart column for the category and store the category in that column using the add to cart buttons.

instead of using a calculation for this, you would use a discount rule on the discounts tab.

Set the trigger to:
"Number Of Items with A Specific Column value"

if the number of items where "category" has a value of "category name" is ">=" a value of "3"


and in the calculations section, use:
"Based on items with a specific value"
Total of "Total Price" where "category" has a value of "category name" "times" "0.10"

Originally Said By: Jason Byrnes

  you would need to have a Cart column for the category and store the category in that column using the add to cart buttons.

instead of using a calculation for this, you would use a discount rule on the discounts tab.

Set the trigger to:
"Number Of Items with A Specific Column value"

if the number of items where "category" has a value of "category name" is ">=" a value of "3"


and in the calculations section, use:
"Based on items with a specific value"
Total of "Total Price" where "category" has a value of "category name" "times" "0.10"  

Hi Jason,

I have set that up but it does not work how I want it to. I have set the rule to look at the VolumeDiscount column in eCart and then give 10% discount if there are 3 of more of the VolumeDiscount category in the cart. See attachment: rule.

This works fine, see attachment: invoice. Both items have the same VolumeDiscount and they total up to 3 and the discount is applied.

What I want to happen is that the discount is only applied if a single or multiple rows meets the rule so in the attachment: invoice if 43956 was set to quantity 3 and 79700 was set to 1 I would like the rule to work for row 43956 and apply 10%. Equally if both 43956 and 79700 where set to quantity 3 then the rule would apply discounts for both rows.

Maybe the rule has to calculate based in a unique ID and VolumeDiscount, only guessing here..

Hope you follow.

Many thanks.

So the discount should only apply to an item in the category if the quantity is 3 or more.

OK, so that has to go back to the calculation method.


[Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)

Hi Jason,

I have set the following that you supplied to TruePrice, ss that correct

[Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)

and then I changed TotalPrice to:

([Price] - ((Abs([Quantity]>=3 && [VolumeDiscount] == 7)*[Price]*0.1)) * [Quantity]

As a result I now get this:


Microsoft VBScript compilation error '800a03ea'

Syntax error

/dmbc/WA_eCart/dmbp_VB.asp, line 320
itmObj.TotalPrice = (itmObj.Price - ((Abs(itmObj.Quantity>=3 && itmObj.VolumeDiscount == 7)*itmObj.Price*0.1)) * itmObj.Quantity'c
--------------------------------------------------------------^

My end goal here is to have 3 different order quantities that will result in the following discounts for VolumeDiscount = 7, is it possible to evaluate 2 or more VolumeDiscounts in this calculation or not

3 +- 10%
10+ - 15%
20+ - 20%

Sorry, you did not specify this was ASP, I thought it was PHP

in ASP
&& [VolumeDiscount] == 7

should be:
AND [VolumeDiscount] = 7

to have multiple break points, you need multiple conditions:
((Abs([Quantity]>=3 AND [Quantity]<=9 [VolumeDiscount] = 7)*[Price]*0.1) + ((Abs([Quantity]>=10 AND [Quantity]<=19 [VolumeDiscount] = 7)*[Price]*0.15) + ((Abs([Quantity]>=20 AND [VolumeDiscount] = 7)*[Price]*0.2)

Hi Jason,

I will have a play around now I know how the format works. I will come back to you if I hit any problems but I am fairly confident that I can proceed.

Yet again, superb support, totally unrivalled.