New Products with sold out

I want to show out of stock items with the sold out warning when looking at products in a category of the shop but I also get sold out products in the New Products listing page.

Is there a way to only show in stock products in the New Products pages?

Thanks.

You would have to custom code this in stock check into the new products and whats new files

BACK UP FIRST!

edit includes/modules/pages/products_new/header_php.php

Add

and p.products_quantity > 0 

after

WHERE p.products_status = 1
AND p.products_id = pd.products_id

which is found on around lines 30 - 31

Make sure you back this file up, as there is no override system for this folder!

Absolute

Excellent,
Thanks

I tried this fix, but it made no difference at all. I am still getting sold out (zero quantity) showing up in New Products.

This fix will only remove teh sold out products from the New Products page - not the New Products box which appears in various locations within the store. Is this where the sold out products are appearing?

Absolute

The phantom new products are showing up in the new products for "month" boxes that show up when you click catagories and sub catagories. The do Not appear when you click the New Products link.

For that box, you would need to edit includes/modules/YOUR_TEMPLATE/new_products.php

Add the following code to the SQL starting line 23 ater and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

and p.products_quantity > 0

That's it.

Absolute

Nope. That didn't work. Sorry.

Just to reiterate, I am talking about the New Products for "month" box that shows up when you click on a catagory, or sub catagory. IE: New Products for January

Nothing I've done, short of actually deleting the product, has removed it from that box.

That's the file you need to edit. Have you placed it in your active template folder, or in a folder called YOUR_TEMPLATE?

Absolute

I figured out what I did wrong. You said to put the code in the section starting at line 23. However that is the section for manufactureres. A little further down, around line 41 where it says $new_products_query is the section to put the line in. I put it there, and now it works perfectly.

Thanks very much for your help.