Customers are already on a pricelist and I need to offer a pallet discount. If they buy 100 items the price will be £x. The percentage discount causes some problems for us.

Anyone know a good way to setup Quantity based discounts, I need to discount by value or a fixed price? I can only find percentage discounts.

Any help appreciated. Thankyou in advance.