Discount on Quantity of Individual items
I have a site where I need to set up discounts based on the quantity of individual items in the cart.
I couldn't find a similar situation in the forum.
I have about 240 drill bits of varying styles and sizes, it's not practical to do the individual cart item discounts by ID.
I need it to work as per the following example:
In the cart :-
Over 100 x 1mm drill bits attracts a discount of $2.50 per drill
Less than 100 x 2mm drill bits gets no discount
Over 500 x 3mm drill bits gets $3.50 discount per drill
Allowed Discounts are totaled in the cart.
Basically discounts will kick in and tally where individual drill bits quantities in the cart reach certain points, e.g. 100, 500, 1000, 2000, 3000, etc. (about 6 discount formulas)
I'm OK with setting up the quantities, but at present I can only get it to work on the total quantity of drill bits in the cart, rather than the individual item quantities.
e.g. If I add only 150 x 1mm drill bits, the discount works, but when I add 50 x 2mm drill bits (no discount), the discount is applied to that quantity also, as it's working on total quantity of items in the cart.
If I use the individual item ID's method, there would be 240 X 6 discounts set up.
I hope I have explained this OK.