Custom Field in database and backend but not in emails

[swilliams88]

I have a few custom fields added to our customer account section that they provide when they create their account. The information they enter does find it's way into the correct database fields and is displayed in the admin section, however, it is not passed through in the email confirmations either when an account is created or when an order is placed by the customer.

How do I pass the custom field info along in the emails?

[DrByte]

You'll have to edit the code that builds the email content so that it includes the data you wish to add to it. The order.php class and your custom create_account.php module are key places to start with that.

[swilliams88]

Thanks for the fast response. Yes I've been in there for a while but cannot for the life of me get it to follow though to the email. I used your suggestions for a different thread but I couldn't get it working.

I think it might be because rather than put the fields in the $this->info = array(); a new one was created for the custom fields called $this->customer_extra_info = array();

This has been added around line 241

function get_customer_extra_info() {
global $db;
$customer_extra_info_query = "select customers_fax, customers_taxid, customers_lmnum
from " . TABLE_CUSTOMERS . "
where customers_id = '" . (int) $this->customer['id'] . "'";

$customer_extra_info = $db->Execute($customer_extra_info_query);

$this->customer_extra_info = array('fax' => $customer_extra_info->fields['customers_fax'],
'taxid' => $customer_extra_info->fields['customers_taxid'],
'lmnum' => $customer_extra_info->fields['customers_lmnum']);
}


And in the Order Confirmation emails (for example) the following was added to pull the info in the Office Only section but it doesn't come through:

// send additional emails
if (SEND_EXTRA_ORDER_EMAILS_TO != '') {
$this->get_customer_extra_info();
$extra_info=email_collect_extra_info('','', $this->customer['firstname'] . ' ' . $this->customer['lastname'], $this->customer['email_address'], $this->customer['telephone'], $this->customer_extra_info['fax'], $this->customer_extra_info['taxid'], $this->customer_extra_info['lmnum']);
$html_msg['EXTRA_INFO'] = $extra_info['HTML'];


Am I missing something?

[DrByte]

If you're trying to stuff the output into the office-use-only section, then you'll need to alter the email_collect_extra_info() function to know what to do with the extra data you're passing to it.

[swilliams88]

Yes I did

$extra_info=email_collect_extra_info('','', $this->customer['firstname'] . ' ' . $this->customer['lastname'], $this->customer['email_address'], $this->customer['telephone'], $this->customer_extra_info['fax'], $this->customer_extra_info['taxid'], $this->customer_extra_info['lmnum']);

[DrByte]

No, that's passing data TO the function. You haven't updated the function itself to handle the extra parameters you're passing to it. So it's just spitting out the stuff it knows to do, and ignoring your extra parameters.