Excluding sold products from the search

Hi - Is it possible to modify the way the search function works so that it will not return sold products in its results? I have a category "gallery" of sold products because I do a lot of custom orders, but it's really starting to make my site search function pretty useless. I'm using 1.3.7 and my store is here: http://dichroicjewelry.net/glass

thank you :)
-Lis

Giving this a bump & hoping that someone can help me. :)

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

Find

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

Replace by:

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

I'm assuming that your sold products have the quantity of 0.

Perfect! Thank you so much! :)

... or you could just set your cart to deactivate the sold products when their quantity becomes 0 ... Admin->Configuration->Stock
But that would exclude them everywhere ... and would negate the "gallery" idea you mentioned.

I think she has a special category for the sold products, so can't really do that.

Yes, that's right - I have a category that I'm using as a showcase of sold products (my customers base a lot of custom orders off of it) - I just move them there and reactivate them with a zero quantity when they sell. But they were totally interfering with the search and frustrating my customers so I'm super excited that it's fixed.

This is great as I am using a sold gallery for the same purpose.

Is there also a way to keep sold items (ones with quantity 0) from appearing on the All Products page too?

Great tip, which I will apply to my sold gallery.

Is there a way to apply this same fix so that 0 quantity items don't rotate through "New Products"? I have my "New Product Listing - Limited to ..." set to "0= All Products", which is fine for my situation except for the sold gallery items.

I would prefer if the sold gallery only presents itself to those that actually visit the gallery.

Thanks!

I just came across this and I am also wondering if there is a way to make sure my "sold category" does not show on the ALL PRODUCTS / NEW PRODUCTS links.

The way I am using the gallery mod is for IN STORE ONLY products and I don't want visitors thinking there is no stock at the physical location of the store, so I just want to remove those items from the all products and new products, because it displays OUT OF STOCK there. As opposed to when looking at the actual product, no price or quantity will display.