How to disable a product when it is not for sale?

Hi all!
Im new here.
now my question:

how I can disable automatically when a product is not for sale more?

i need modify the php code no? but i dont get it.. so if someone can help me..I would be grateful!
Bye! and Thanks!

Hi gootty3,

To automatically disable a product not for sale anymore, simply go in HikaShop > Configuration > Display, and under the "Default parameters for products" tab, check no for the option: "Display out of stock products".

You can too disable produts manually in HikaShop > Products, and unpublish the product by clicking on the published icon:

hi!
thanks for your quick answer!
But i need it with de "end date" of the product.

Hi,

You can do it by editing the SQL request in the file: YourSite/components/com_hikashop/views/product/view.html.php
In the listing function replace the line:

$query = $select2.' FROM '.$b.$a.$on.' WHERE '.implode(' AND ',$filters).$order;

$query = $select2.' FROM '.$b.$a.$on.' WHERE '.implode(' AND ',$filters).' AND (b.product_sale_end = 0 OR b.product_sale_end > '.time().') '.$order;