Disabled items showing in specials list

[jbrit]

Hi,

Running 3.7.1

When adding a new special, the product list that appears contains both enabled and disabled products. Is there any way to stop it from displaying the disabled products?

Thanks
James

[frank18]

Take a look at this thread (even though the disabled items in that thread are showing up in bestsellers list)

http://www.zen-cart.com/forum/showthread.php?t=14760

You may also want to scroll down to the bottom of this page and see similar threads

[jbrit]

Thanks for the links.

I already did some searching and I'm sure this is the code I need to insert:

and p.products_status = 1

I'm just not 100% sure where I should be using it, looking in admin\specials.php around line 256 at this code, I tried adding it as per the examples given for the best sellers bug fix but did not see any change so maybe I'm looking in the wrong place:

$product = $db->Execute("select p.products_id, pd.products_name, p.products_price, p.products_priced_by_attribute,
                                      s.specials_new_products_price, s.expires_date, s.specials_date_available
                               from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
                                        TABLE_SPECIALS . " s
                               where p.products_id = pd.products_id
                               and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                               and p.products_id = s.products_id
                               and s.specials_id = '" . (int)$_GET['sID'] . "'");

If I add a disabled item as a special they do not appear in the store - I just want to tidy up the admin side so the disabled items do not appear in the list when adding a new special.