adding specials as featured, doesn't show special price

[CheapStairParts]

When I try to add a product that I have listed as Special, to Featured, it does not show the special discounted price under the featured category.

[Ajeh]

Is the Special Active? As in is there a GREEN dot on the Special?

Do you see the Special Price on the Product _info page?

What version Zen Cart?

What add-ons?

Is this happening just in your template or also in the Classic Template?

[Gomlers]

I have the oposite problem... I would really like to NOT show the specials-price on the featured products...

Any way to do this?

[Ajeh]

You would have to customize the select statement to exclude files that are in the specials table ...

You can customize the featured_products.php module using your templates and overrides by changing the two SELECT statements to read:

  $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id
                           from (" . TABLE_PRODUCTS . " p
                           left join " . TABLE_FEATURED . " f on p.products_id = f.products_id
                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
                           where p.products_id = f.products_id
                           and p.products_id = pd.products_id
                           and p.products_status = 1 and f.status = 1
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" . "
                           and p.products_id not in (select products_id from " . TABLE_SPECIALS . ")";

And the other:

    $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id
                                from (" . TABLE_PRODUCTS . " p
                                left join " . TABLE_FEATURED . " f on p.products_id = f.products_id
                                left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id)
                                where p.products_id = f.products_id
                                and p.products_id = pd.products_id
                                and p.products_status = 1 and f.status = 1
                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                and p.products_id in (" . $list_of_products . ")" . "
                                and p.products_id not in (select products_id from " . TABLE_SPECIALS . ")";

I think I have that right ...