Hide sold out products from category listings and search without disabling product.

[illum]

I have products that are completely discontinued, that I will probably never sell again and they have 0 quantity in stock, the shopping cart button says sold out... all of this is fine, however...

I don't want them to show up under the category listing and searches performed by zencart as it clutters the products I do have in stock. I know I could just disable the product, which I would love to but it makes the link to the product no longer work.

I would like search engines and other links which point back to a product on the site to be able to see a discontinued product if the exact url is used. I just do not want discontinued products to show up unless that is the case, is this possible to do?

[kobra]

See the posts by Ajeh here
http://www.zen-cart.com/forum/showth...=disable+stock

[illum]

See the posts by Ajeh here
http://www.zen-cart.com/forum/showth...=disable+stock

Ready through that whole thread, I figured all that out already. ZenCart allows you to show a product which is out of stock by setting the configuration that shows the soldout button instead of add to cart button if quantity = 0.

Since I don't want to see all those sold outs on the category listing/search pages I also have the option to set the product_status = 0, either through the stock configuration or manually through the edit product view. Which hides all products on the frontend of the website.

That's all find and dandy, exactly how I want it in fact, however there is one instance that I want the products to show up. And that is if you manually go the the exact url of the product. Then I want the product to show the out of stock page.

This is so search engines that already have links to the product and other websites that linked to it in the past don't get a product not found page, rather they get a product out of stock page. In other words I don't want links which used to work to no longer work anymore. (broken links)

Just wondering if I will have to hack Zen Cart to do this, or if there is another way? Cause the only thing that I can think of is changing some of the queries to not pull products with quantities of 0 or less. Or writing a custom configuration, will have to dig through you code to see how this is done.

[Ajeh]

Edit the file:
/includes/index_filters/default_filter.php

and add the code around line 27 that is in red above the code in black:

  $alpha_sort .= " and p.products_quantity > 0 ";
  if (!isset($select_column_list)) $select_column_list = "";

[illum]

Edit the file:
/includes/index_filters/default_filter.php

and add the code around line 27 that is in red above the code in black:

  $alpha_sort .= " and p.products_quantity > 0 ";
  if (!isset($select_column_list)) $select_column_list = "";

Did exactly what I wanted, thanks!

[illum]

Do you know the path of the file that I need to edit to add to the 'p.products_quantity > 0' to the search query?

[Ajeh]

I gave you the exact location of that file ...

Look at your site and you will find the file in that location ...

[frank18]

Edit the file:
/includes/index_filters/default_filter.php

and add the code around line 27 that is in red above the code in black:

  $alpha_sort .= " and p.products_quantity > 0 ";
  if (!isset($select_column_list)) $select_column_list = "";

Nice one Ajeh! Thanks a lot - that code should be a permanent one in all installs for SE purposes ...

[Ajeh]

Thanks for the update that this is now working for you ...

[brewtusplease]

Hi Ajeh,

Nice job! I applied this as a test for my products and it works like a charm. I will not be able to use it on my site as there are some products that I do still want to show as a Sold Out...ones that I am still replenishing stock on and want the customers to see that I still carry it. And that's ok...I'll carry on as I currently am.

The only reason I mention this is that it might be a good future addition to the software to add some flexibility to a feature like this, even if it was embedded as an option for each product id. For example, we decided to sell watches during the fall on a limited basis. We now have the remaining watches on Clearance and do not plan to re-order them. I still want the links through the search engines to show 'Sold Out' and want the menu filter to not show them anymore. But I do have a purse that I also sold out of, but will be receiving new shipments soon. I have customers that search for this type of purse and I want it to appear within the menu even when 'Sold Out' so they know I offer the product.

If you can think of possibilities around this, great! Certainly not a priority, just a thought...
Thanks for the help.