How can I hide any item that is out of stock so it doesnt show in the product pages?
How can I hide any item that is out of stock so it doesnt show in the product pages?
I have found a fix hopefully there would be a way for it to do it automatically but as a temp fix I just run this in Tools>SQL after each update:
I update everything using a csv file.PHP Code:UPDATE products SET products_status = 1 WHERE products_quantity >= 1;
UPDATE products SET products_status = 0 WHERE products_quantity <= 0;
Last edited by ryanb4614; 10 Feb 2010 at 04:16 PM.