MSRP Add On - Not On Front Page

[NathanLee0921]

Hello everyone,

I just installed the MSRP Add On and I don't want to MSRP to show on the front page. I want it to show on the order pages, but not the front page.

This is the website. Take a look. RC-Access.com

So, my question is how to make the MSRP not display on the front page?

[Ajeh]

If you want absolutely NO Prices to display on the Home page of your site, you could customize the display price function:

////
// Display Price Retail
// Specials and Tax Included
  function zen_get_products_display_price($products_id) {
    global $db, $currencies;

    $free_tag = "";
    $call_tag = "";

// do not show prices on home page
    global $this_is_home_page;
    if ($this_is_home_page) {
      return '';
    }

[BettyC]

I don't understand Step 1 of the mod for MSRP. What exactly do we put in the SQL query under admin? I put in what is indicated in step one and I get errors.

This is what I get -

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products' at line 1
in:
[ALTER TABLE zen_ tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


What is the correct verbiage that I am supposed to use to get this part to work?

I am using version 3.8

Please advise. I would appreciate it. Thanks