I am building a quoting system for a client - not really a full ecommerce solution. It is only used by sales people.
The customers are entered in the database and a customer-type (dealer or retail) is assigned.
Based on that value they get a different price on each product.
Each product has two prices - dealer and retail.
I need to make it so when the employee is looking at a list of products to add to a quote he sees dealer prices because the quote is for a dealer.
I have everything working now except the ability to use those specific columns based on customer type.
In other words... I'm trying to do this.
If customer type = wholesale
- use product price "wholesale"
If customer type = retail
- use product price "retail"