Product Discount Dynamic (Name, QTY, Value)

Based on ECART 6 doesn't look like any DISCOUNT can be trigger by the product only, so I create separate TABLES to be entered by admin based on product selection by user.

1. DISCOUNT (session_id, productid, name, qty, value) will be displayed on product detail page.
(a) session_id = Cart Session
(b) productid = Product ID
(c) name, qty, value = discount

2. User can "check" all discounts, I would like to be auto selected and auto updated based on PRODUCT QTY = DISCOUNT QTY)
3. I checked ECART 6 features from what I see this isn't allowed.
4. When DISCOUNT(S) are checked will display in CART.PHP via "ADD TO CART", if user updates QTY would like to CART.PHP to display and auto update DISCOUNT(S) according to QTY changes.
5. Only PRODUCT PRICE should be effected by DISCOUNT...

The easiest way to do this is to save the discount amounts from the database into the session and then you can create a discount rule based on the saved session variable value.

Does E-CART 6 support $_SESSION arrays as example:

$_SESSION["discounttid"] = array["productid","discountname","discountqty","discountvalue");

If so can I use DATABASE entries into a this array...

I'm sure we could get that working. The shopping cart is already a session array wrapped with some extra functionality. Maybe just add a column to the cart itself for the discountname, discountqty, and discountvalue for the product as it is getting added to the cart. Then it would probably be pretty easy to apply the associated discounts and display them in the cart since all of the data is already there.

I did this in the begining but couldn't get E-CART 6 to display selected DISCOUNTS, so I made single SESSION with totals, any info you can give will be helpful - Thank You

I would use the cart column if you want each product to have a discount. It is just easier to keep track of if it is in the cart.

Once you have it in the cart, then I can help you display it how you want to.

Do you want it displayed on each line of the cart. Do you want each discount listed individually below? Do you just want the total discount shown at the bottom?

See Private

So far no errors after updating files to "new" version of E-CART 6.

OK... so what do you need help with? What exactly do you want to do?

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.