I am trying to set up a shopping cart rule like this, but I am not able to think of the best solution. This is the scenario:
I have a product X. If user buys 2 quantities of X, he should get 5% on the second X. If user buys 3 quantities of X, he should get 5% on the second X and 10% on the third X.
Is there an easy way to do this via code or extension ?
I have tried setting up 2 rules for this purpose. It works almost with a little problem.
Rule #1 (5% on 2nd X):
Condition: SKU is X Qty in cart greater than or equal to 2 Action: Discount Amount: 5% Max Qty to Apply Discount: 1 Apply on Condition: SKU is X
This is working fine. The problem is with the 2nd rule:
Rule #2 (10% on 3rd X):
Condition: SKU is X Qty in cart greater than or equal to 3 Action: Discount Amount: 10% Max Qty to Apply Discount: 1 Apply on Condition: SKU is X
It says if there are 3 or more products, apply a 10% discount on one of the products. Magento is applying the 10% discount on the already reduced 5% product instead of the unit base price.
How do I tell Magento to apply the 10% on the most expensive product or the non-discounted product ?
One solution: Applying some mathematics, I found that if I set Rule #2 to apply a discount of 10.5263% instead of 10%, it works. But the decimal points differ slightly which I can live with.
My concern is I am not sure if Magento always applies this discount on the already reduced product price or the base unit price.