if stock is 0, dissapear product

[heinzmty +]

Hi,

I have only 300 items, and seems that more of 90 are right now in "0" stock level

is possible to disappear items? if is 0 ?

thanks !

urgent !

Heinz

[novista +]

Heinz,

Open /includes/display/class.category.php and find

PHP Code:

$query = "
    SELECT
        COUNT(DISTINCT ca.productid) AS numproducts
    FROM
        [|PREFIX|]categoryassociations ca
        INNER JOIN [|PREFIX|]products p USE INDEX (PRIMARY) ON p.productid = ca.productid
    WHERE
        p.prodvisible = 1 AND
        ca.categoryid IN (" . $this->GetProductCategoryIds() . ")
        "; 


Change p.prodvisible = 1 AND to read p.prodvisible = 1 AND p.prodcurrentinv > 0 AND

PHP Code:

$query = "
    SELECT
        COUNT(DISTINCT ca.productid) AS numproducts
    FROM
        [|PREFIX|]categoryassociations ca
        INNER JOIN [|PREFIX|]products p USE INDEX (PRIMARY) ON p.productid = ca.productid
    WHERE
        p.prodvisible = 1 AND p.prodcurrentinv > 0 AND
        ca.categoryid IN (" . $this->GetProductCategoryIds() . ")
        "; 


This is how you change it for the Category page. If you use Featured Products, New Products etc, you'll need to modify each of these PHP files as well. You'll find these in /includes/display. If you want to change Featured Products, open HomeFeaturedProducts.php. Look for WHERE p.prodvisible='1' AND (imageisthumb=1 OR ISNULL(imageisthumb)) and replace it with AND p.prodcurrentinv > 0

What you are doing is limited the product query to exclude all products where the inventory level is greater than zero.
Let me know if you have any problems getting this to work.

[heinzmty +]

thanks !

I will try


..

[heinzmty +]

perfect!

seems to work perfect

just for the record, the path is :
includes/classes/class.category.php

thanks a lot!

Heinz

[Szukacz]

Hi
Is it possible to adapt this solution to dissapear product variations with stock=0?
How it should be done?

Greetings
Peter