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);
}