Dynamic Discounts
Hello, I have the coupon discount working & a discount if user is logged in working that is statically set to 5% (* 0.05). Now my problem is how to get this 0.05 value from the database. In the members table I have this value but it may change if the member is a frequent shopper etc which is why it needs to come from the DB. I have a recordset that gets the value on the cart page.
I have tried a few things & read this article here but this article is like the coupon & I don't want them to submit any form. I don't know whether to bind a new column or set a new eCart session, if its a session what trigger & value do I give it. I have attached the screen shot of the logged in discount so hopefully someone can help me out.
Any help appreciated. Chris