Stop Disabled Products From Showing in New Products for Category?

[way10c]

I've been setting up a music downloads category for my site and putting in the products. However, most of them are disabled until their licenses are valid. ZC still shows the disabled products in the New Products for >month< area. How do I fix that? It will frustrate the customers.

Thanks,

--Allen

[bigdiogi]

Having the same issue. Any suggestions?

[bigdiogi]

Read the other threads I could find regarding this issue. Am using v1.3.9, read several places this was a known issue in 1.3.8. Had already ensured that -

Config>Stock>Products status in Catalog when out of stock should be set to =0

Which should prevent out of stock and disabled products from EVER showing, correct?

What'd I miss this time?

[Ajeh]

Check that the file:
/includes/modules/new_products.php

is current and up to date and includes the reference to the products_status = 1

in both of the SELECT statements ...

Note: you may have a template and override file in:
/includes/modules/your_template_dir/new_products.php

[bigdiogi]

Check that the file:
/includes/modules/new_products.php

is current and up to date ... Note: you may have a template and override file in:
/includes/modules/your_template_dir/new_products.php

Clean, new install of latest version, why would it not be current? No other version present in template overide directory.

Version info is " * @version $Id: new_products.php 6424 2007-05-31 05:59:21Z ajeh $"

and includes the reference to the products_status = 1

in both of the SELECT statements ...

Here is the 2nd SELECT statement -

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                  p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_id in (" . $list_of_products . ")";

The first SELECT statement has this line at the end -

and   p.products_status = 1 " . $display_limit;

Forgive my overwhelming ignorance, but should I just add that to the second statement as well. Cut and past after the final line? Obviously, I'm once again in WAY over my head. Don't want to screw things up trying to solve a fairly minor annoyance.

Thanks for your help and your patience.

[Ajeh]

Compare the original code from:
/includes/modules/new_products.php

with your templates and overrides:
/includes/modules/your_template_dir/new_products.php

Do they both have the products_status = 1 in both SELECT statements?