Hi,
I would like to show in my confirmation email also manufacturer (manufacturers) of the ordered products. In components/com_virtuemart/views/invoice/tmpl/mail_html_pricelist.php I put this code:
$query = 'SELECT `mf_name` ' . ' FROM `#__virtuemart_manufacturers_sl_si` ' . ' WHERE `virtuemart_manufacturer_id` =' .$item->virtuemart_category_id ;
$db->setQuery($query);
$manuname = $db->loadResult();
and after that also
<?php echo $manuname; ?>
It is not working... any suggestions?
Regards,
Peter
The manufacturer name is already provided in the item date
Just try echoing
$item->mf_name
Hi,
You have right, it is working.
Thank you very much.
Regards, Peter
Thank you for the update. Great to that your problem is solved.