Make a product that is sold out not appear in listings, sideboxes

[dgent]

Is there any way to make a product which is marked as sold out, not appear in product listings, centreboxes etc.

I don't want to delete the product or turn it off as that makes a page not found, so I want to mark it as sold out, but not come up in the current products listings on my sites.

[Ajeh]

For the Product Listing, edit the file:
/includes/index_filters/default_filter.php

and where you find in each of the SELECT statements:

       where p.products_status = 1

add to it:

       where p.products_status = 1
       and p.products_quantity > 0

For the Centerboxes, you would need to do the same thing, example for the Featured Products centerbox edit the file, using your templates and overrides:
/includes/modules/featured_products.php

copy to:
/includes/modules/your_templates_dir/featured_products.php

and add the same thing to each of the SELECT statements:

                           and p.products_status = 1 and f.status = 1

to read:

                           and p.products_status = 1 and f.status = 1
                           and p.products_quantity > 0

and that will prevent the display of Sold Out Products ...

[dgent]

Excellent thanks.

[Ajeh]

Thanks for the update that this worked for you ...

[dgent]

Actually, couple of issues. Those products still show in searches (and not for those particular products - but they just happen to have a keyword used in it, ie 'dress') and they still show in the new products page and all products page.

Any way of preventing this?

[Ajeh]

Peek at the:
/includes/modules/pages/advanced_search_result/header_php.php

$where_str = " WHERE (p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id ";