Is there a way to use the pricing fields to create bulk discounts, whereby the higher quantity the user requires the lower the price per unit. This would have to be done by way of some formula. The default formula is:
Price x Quantity
I am looking to have something like:
(Price - (Quantity - 1)) x Quantity
So the formula is fairly simple, but different from the original. I have tried doing this using a drop down list for quantity and using values to define the price multiplier, but it does not work well if a user wants a large quantity, and also the same multiplier is added to any later options which is not what I want.
I hope someone can point me in the right direction to defining a custom pricing formula.
Thanks!