Our Magento platform is connected to our product database. We're first building a wholesale site and want to display the price as the attribute "list_price" instead of the standard "price" which is our MSRP.
It's not a flat rule like a % off so I can't use the catalog pricing rules. Also we will be building out retail sites using the same catalog so I need to retain the "price" value to be used on different websites.
We have Magento's attributes synced to custom values in our DB using a staging table, so it seems most logical to somehow substitute 'price' for 'list_price' with this website only. I just don't see how to do that.
We could connect our "list_price" to an existing attribute in Magento if that would be easiest. Special_Price comes to mind but I just want it to display as the normal price and not as a special price.
Any ideas on the best way to do this? Thanks so much. Here's the site btw: http://wholesale.navajomfg.com