title: Using an alternate price field in OpenCart
body: <p>I have an OpenCart installation that is running two stores, one wholesale and one retail. The product catalog is shared, but the problem is that OpenCart doesn't natively support multiple pricing options. So I added a new field to the oc_product table, retail_price. The idea is that I would use the price field for wholesale pricing and the retail_price field for -- you guessed it -- retail pricing.</p>
  
  <p>I have everything pretty much covered on the admin side, so my new field is showing in the product section and is being updated in the database.</p>
  
  <p>Now the issue is getting the price to change on the front end for the retail store. Needless to say, product price is used in a ton of different scripts. So I figured the best/sneakiest method would be to change the price field when the database is queried and the price data is initially set. This is kind of where I got lost... I changed it in some places I thought were right but the price doesn't change on the front end. Sometimes OpenCart can be a mysterious fig.</p>
  
  <p>Can anyone give me a clue as to where the best place(s) to change the price would be?</p>