Hey guys, I got a tough one.
I've been researching for days, weeks even, to try and solve this. And I'm sure I'm going to kick myself if/when I get a solution.
I've set up an ecommerce website from scratch (no prestashop, oscommerce, none of that), and I need to figure out how to decrease price on quantity.
Ex;
Umbrellas are $12.00 a piece.
If you order 2 dozen (24) Umbrellas, they are only $10.00 a piece.
I can't seem to figure out a way to make it work..
I have set up in my database the following columns.
p - base price ($12)
p1 - price after first increment ($10)
q1 - quantity of first break (24)
p2
q2
p3
q3
Hit me with your best shot.