I.. Database is done and DISCOUNT values (name, qty, value) is inserted by PRODUCTID
A. Product
1. Discount Values are selected on product detail page once ADD TO CART is submitted
2. based on QTY only those DISCOUNTS will be added:
SAMPLE: if "discountqty" <= "ecart1_qty" then "discountvalue" will apply to PRODUCT PRICE
if "ecart_qty" textfield change then DISCOUNT will display in PRODUCT DETAIL page. and updated in CART session.
EXAMPLE:
PID = 1
QTY = 2
DISCOUNT( name, qty, value)
13% OFF, 0, .13 (13%)
9% OFF, 2, .09 (9%)
18%OFF, 3, .18 (18%)
only 13% & 9% will apply until QTY is 3 then all three TOTAL of DISCOUNTS (40%) will apply.