[cflsystems]

BACKUP FIRST. THIS IS NOT TESTED.

Try adding this in products.php just before
$smarty->assign("cat_products", $products);

if (!empty($products)) {
foreach ($products as $k=>$v)
$products[$k]['manufacturer'] = func_query_first_cell("SELECT manufacturer FROM $sql_tbl[manufacturers] WHERE manufacturerid = $v[manufacturerid]");
}