I have a more complicated pricing formula needed… Hope you can add an update using some “min” and “average”
Like I said very complicated:
Sample:
Product price: 210usd
Min Quantity to Order: 10pcs
Max Quantity to Order: N/A
Max Discount can give: 61% if order 100pcs or more.
Now the scenario/formula:
(average(1-(0.61*(min(1,({cart_quantity}-10)/(100-10)))))*{product_original_price})
If the customer order the product with the minimum qty of 10 the total value is 2100usd but if he add 1 or 2 or more the unit price will change. instead of 210usd/item it will 210usd-discount then multiply by the item qty.
Now if the customer order 100pcs the max discount we can give is 61% but more than 100pcs still the max discount apply.
Sorry if it is to complicated but if you could just add an option to hook the product quantity
But if you have a much easier way. Very well appropriated if you could give some inputs.