News:

Looking for documentation? Take a look on our wiki

Main Menu

Display manufacturer name in confirmation email

Started by Peterkrk, May 17, 2020, 16:37:45 PM

Previous topic - Next topic

Peterkrk

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

AH

The manufacturer name is already provided in the item date

Just try echoing

$item->mf_name
Regards
A

Joomla 4.4.5
php 8.1

Peterkrk

Hi,
You have right, it is working.
Thank you very much.

Regards, Peter

AH

Thank you for the update.  Great to that your problem is solved.
Regards
A

Joomla 4.4.5
php 8.1