View All Products showing OOS items :(

[UncleSteve]

I have installed the "View All Products" contrib, however I've just discovered a problem with it.

 

If I mark a product as being out of stock (OOS) in the Admin, it disappears from the catalogue listings (customer side) which is good. However I now find the "View all products" still shows the OOS items which is not what I want.

 

Anyone got a way to change this please?

 

I need to check, but I think its this version I have installed v 4.4 MS 2.2 by Jack_mcs (I tried another, but wasn't suitable)

 

Thanks in advance for any help and guidance :)

[Guest]

change

 

$listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id  $where order by pd.products_name";

 

to

$listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id  $where and p.products_status = '1' order by pd.products_name";

[UncleSteve]

change

snip

to

snip

Hi Mark, That's sorted my problems, thanks for your prompt help :D