Some stores have a high product turnover rates with lots of products disabled.
QT Pro doesn't account for this issue and can be a nuisance when checking stock for active products.
To fix this simply change
$prod_query = tep_db_query("SELECT products_id FROM " . TABLE_PRODUCTS);
To:
$prod_query = tep_db_query("SELECT products_id FROM " . TABLE_PRODUCTS . " where products_status = '1'");
in admin/includes/functions/qtpro_functions.php
And in
admin/stats_low_stock_attrib.php
add products_status = '1' somewhere after the sql where clause on line 101.
I'm still new to the code so there might be other files that need this change.
More...




LinkBack URL
About LinkBacks









Bookmarks