Varying Percentages Discount Based on Quantity
I am trying to add a percentage discount to our eCart5 when a user adds 3 of a certain product, BUT some of these products will offer 10% off if you buy 3 and some will offer 20% off and also 50% off....How can this be achieved? also what addition do I have to make in the database?, add another column with the percentage? ie: 20 so if this column has a value then that product has a discount applied to it?
Please can someone assist, need to have this complete over the weekend :o(
Many thanks in advance.