New Products with sold out

[Boghead]

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.

[kobra]

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

[Absolute]

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

[Boghead]

Excellent,
Thanks

[wtashby]

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

[Absolute]

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

[wtashby]

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.

[Absolute]

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

[wtashby]

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.

[Absolute]

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