Discounts based on Membership Status
I have certain products that customers can receive a discount on if they are a current member with us. In the database, the MemberStatus column is set to 1 for members, 0 for non-members.
A few questions:
1. how do I set/declare a MemberStatus variable upon login?
2. if they purchase membership through the shopping cart (which is one of our products), how do I get this MemberStatus column to be assigned a "1" value after the purchase is submitted? In other words, how do I check for the presence of a certain item (which is Membership) and subsequently apply an Update Record action?
3. how do I set the member discount in the shopping cart? Basically, it'll need to do like a "if MemberStatus = 1 AND ProdCatID = 4 then flat-rate discount is $20"