quantity discount for unique items

I am developing an ecommerce site for event registrations. You have already helped me attach an attendee to each registration but now I have another issue.

The company gives a $5 discount off of each registration when you register 3-5 people at the same time, $8 off each registration when you register 6-9 at the same time, and $10 off for 10-20 registrants.

I tried using this calculation/discount as you explained in another thread:

TotalItemDiscount:
((abs([Quantity] >= 3 && [Quantity] < 6)?5:0) + (abs([Quantity] >= 6 && [Quantity] < 10)?8:0) + (abs([Quantity] >= 10 && [Quantity] < 20)?10:0)) * [Quantity]

then define the discount on the discount tab as:
Trigger: Number of unique items in the cart

Calculation: Based on multiple of column subtotal

Subtotal of column "TotalItemDiscount" "times" "1" "plus" "0"

However, it doesn't work in my situation because the registrations are no longer grouped together because the different attendees make them a unique and separate item.

I hope you can help.

in this case you wont be able to use the calcualtion. You will need to use a Discount rule for each quantity break.

In the discount rule, use the trigger "Number of Items With a specific value", you will need to know the ID of the registration Item.

for example, the discount for $5 discount off of each registration when you register 3-5 people at the same time would be set up as:

Triggers:
Number of Items With a specific value:
If the total number of items where "ID" has a value of "22" is ">=" a value of "3"

AND
Number of Items With a specific value:
If the total number of items where "ID" has a value of "22" is "<=" a value of "5"

Calculations:
Based on items With a specific value:
Total of "Quantity" where "ID" has a value of "22" "Times" "5"


this example assumes the ID of the item is 22. The other discount rules will be similar, just changing the quantity breaks and the multiplier.

Since this rule applies to every 90-minute webinar we do, is there any way to accomplish this without having to make a new rule each time we add another webinar? We are currently doing several webinars a week and this would be terribly time-consuming.

I was hoping there was some way to use the productCatergoryID. This field has a value of 1 for all of our webinars. Is there anyway to count how many items in the cart have a 1 in this field and discount each by the corresponding amount?

use the same rule structure as outlined above, but swap the ID column for the productCatergoryID column and use the value 1 instead of 22.

That works to give the discount on any 3 or more webinar registrations but is there a way to now limit it to 3 or more of the same registrations without having to specify for each different webinar?

no, the only way to limit to a unique webinar is through the ID, and crate a seperate set of rules for each ID.

OK... well thanks for your help.

you're welcome.