Quote:
Originally Posted by cflsystems
Inventory update bug - inventory update will not update any variants as the search for them results in only one variant id returned.
Open /provider/inv_update.php and find
Code:
if (!empty($active_modules['Product_Options'])) {
$vid = func_query_first_cell("SELECT $sql_tbl[variants].variantid FROM $sql_tbl[variants], $sql_tbl[products] WHERE $sql_tbl[variants].productid = $sql_tbl[products].productid AND ($sql_tbl[variants].productcode='$columns[0]' OR $sql_tbl[variants].variantid = '$columns[0]') ".$provider_condition);
}
replace with
Code:
if (!empty($active_modules['Product_Options'])) {
$vid = func_query_first_cell("SELECT $sql_tbl[variants].variantid FROM $sql_tbl[variants], $sql_tbl[products] WHERE $sql_tbl[variants].productid = $sql_tbl[products].productid AND ($sql_tbl[variants].productcode='$columns[0]' OR BINARY $sql_tbl[variants].variantid = '$columns[0]') ".$provider_condition);
}
|
I have tried this manual patch and it is NOT working. I place orders for products in a variant chart and the inventory does not get updated.
Please advise how this can be fixed as 50% of our products are in variant charts.