can I prevent sold out items from appearing in search

[mespe]

Just like title says, how can I prevent items with "0" quantity from appearing in searches?

[mc12345678]

Do you still want or still display such items on your site? (meaning that one could still get to them if the uri is known?)
From what search(es) are you trying to block the item(s)?

[mespe]

After I sell a part, I move it to the "Sold" folder with "0" quantity.
All I want to do is prevent any item with "0" quantity from appearing in any search in my store.

[mc12345678]

After I sell a part, I move it to the "Sold" folder with "0" quantity.
All I want to do is prevent any item with "0" quantity from appearing in any search in my store.

So is the "Sold" folder navigable by a customer at your site?

Point is that until a search engine detects that the product is no longer reachable, it will maintain it in its list. There are multiple ways to try to inform it of such, but generally speaking it takes a while for it to get to the search engine just like it takes a while for it to be removed.

[mespe]

No, you don't understand. I don't mean search engines, I'm talking about searching within the store, using the search button provided by zencart. Sorry if I wasn't clear in my OP

[mespe]

This is what I want to do, but just don't know how to accomplish it,,,
https://www.zen-cart.com/showthread....91#post1245791

[yaseent]

Hi mespe,

open this file:

includes/modules/pages/advanced_search_result/header.php

search for this line:
$where_str = " WHERE (p.products_status = 1

change it to:
$where_str = " WHERE (p.products_status = 1 and p.products_quantity > 0

[mespe]

Hi mespe,

open this file:

includes/modules/pages/advanced_search_result/header.php

search for this line:
$where_str = " WHERE (p.products_status = 1

change it to:
$where_str = " WHERE (p.products_status = 1 and p.products_quantity > 0

I hope you mean header_php.php as that's the file in the advanced_search_result directory
,,, yes it works,,, THANKS

[yaseent]

Potayto Potaato...

Yes that's the one.

You can also prevent sold out items from appearing in New Products listing, All Products listing and a few other places by doing a similar thing with the default_filter.php.