How to show only active products in "Products low stock"?

[navido]

I have searched after this whithout finding any answer.

In "Admin - Reports - Products low stock" the report shows products which are not active(red). Is there any way to only list the report for active products(green status)?

Thanks

[navido]

Hmmmmmm..no one knows?

How to see if something is sold out or nothing on stock? The stock report is no use since iit also show inactive products

[navido]

Hmmmmmm...still havent solved it. Anyone please?

[navido]

Hmm..i still havent solved this..can anyone help?

This is the code from the file stats_products_lowstock.php

$products_query_raw = "select p.products_id, pd.products_name, p.products_quantity, p.products_type from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id='" . $_SESSION['languages_id'] . "' order by p.products_quantity, pd.products_name";

Dont know how to change this..hmm.

[navido]

YES. thanks to myself i fixed it.

  $products_query_raw = "select p.products_id, p.products_status, pd.products_name, p.products_quantity, p.products_type from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id='" . $_SESSION['languages_id'] . "' AND p.products_status='1' order by p.products_quantity, pd.products_name";

[Ajeh]

Thanks for the update that you got this working and for posting your solution to add the products_status to the WHERE statement ...

[navido]

Thanks for the update that you got this working and for posting your solution to add the products_status to the WHERE statement ...

Thanks Ajeh.

But i must say i am disappointed over the help here. Hmm.

[Ajeh]

Maybe looking in the bottom of your screen at the Similar Threads would of shown you the solution I posted to this same question that perhaps you missed when you searched the forum ...

Sometimes ... we get busy and just cannot get to every question right away ...