PDA

View Full Version : QTpro v1.0 - Quantity Tracking Professional



michael_s
10-19-2008, 10:51 PM
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... (http://addons.oscommerce.com/info/888)