Can the "Products Low Stock" Report show only active stock? Can you Print this?

[LindseyB]

I have a store in which there are a good number of items that are at 0 quantity and inactive. However I am keeping them in the store in the database (hidden from customers) in case we ever decide to activate them again.

Is there a way to have the Products Low Stock report show only the stock that I have active in the store?

Also - is there a way to print the products low stock report - besides doing a screen capture?

thanks so so much in advance!
-z.

[kobra]

Don't know about inactive

but to print from a browser > file > print

[Ajeh]

To alter the report to exclude products with products_status = 0 you can edit the report file for stats_products_lowstock.php and find the select statement:

  $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"; 

and add in the filter(s) you need such as p.products_status = 1 ...