How to make category not show on search?

On my website I have a Sold Items category qhere I put the items aftey they were sold. Everytime somebody search for something the products from the Sold Items category show up also but I dont want them to show up. How would I do it?

I dont know if there is a direct way to do it but you can modify the search related file to not include the products in the search results which are sold

How can I do that?

Replace this line

$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 ";

with this

$where_str = " WHERE (p.products_status = 1
			   AND p.products_quantity > 0
               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 ";

Please take the backup before you make this change

includes/modules/pages/advanced_search_result/advanced_search_result/header_php.php

Wait a minute .... instead of just moving the items to the sold category, why not just mark them sold out? (or both?)
That way you wouldn't need to modify any code.

Thanks superprg, that worked. swguy if I do that it will still have the sold out items in the category with the items for sale. I want to have all the sold ones separate.

Punkristo:

Thanks superprg, that worked. swguy if I do that it will still have the sold out items in the category with the items for sale. I want to have all the sold ones separate.

Why not have the soldout category disabled that way no one will find them?

or am I missing something here???