how to handle multiple prices levels in eCart
I'm developing a site that has three price tiers - Retail, Wholesale, and designer. These prices are all set up as separate fields in my products table. My question is how do i handle it when it comes to eCart. I have used security assist and have 3 tiers of logins and depending on what you login tier is you will only see the price for you tier, however how should I go about handling the price column in eCart so the the 3 different fields funnel into the same price column depending on your login.