I use Zencart, along with EasyPopulate(spreadsheet that uploads products, descriptions, etc) and MAP pricing module. I need to be able to add a field to this spreadsheet for MAP Pricing (Minimum Advertised Price), which will override retail price.
For example: I want to sell a widget for $95.00. My distributor tells me I can only advertise it for $99.00. So I need the price from my distributor to be the display price ($99.00) but use the MAP Price Module ("add to cart to see purchase price") to display the selling price to the customer ($95.00). If there is a MAP price for a product in my spreadsheet, I need this price to over-write the selling price.