ORDER_CREATION_NOTIFICATION email

I have 3 custom fields that I want to display in the email. For some reason I can't seem to get it correct. I added three fields to the language file. I then added this to the email form and the language displays properly but not the data from the fields. Do I have the incorrect fields?

<?php echo JText::sprintf('CUSTOMER_DATE_REQUEST',$address->daterequested);?>
<br/>
<br/>
<?php echo JText::sprintf('CUSTOMER_DATE_PICKUP',$address-->pickupdate);?>
<br/>
<br/>
<?php echo JText::sprintf('CUSTOMER_IRS_EIN',$address->irs_ein);?>

Hi olddirtret,

The values: $address->daterequested / $address->pickupdate / $address->irs_ein don't exist in the email variables, that's why you don't have the data from the fields.

Nicolas

<?php echo JText::sprintf('CUSTOMER_DATE_REQUEST', $data->cart->billing_address->daterequested); ?>
Doesn't work.
I see the Date of Customer Request title but no data from the address table daterequested field.. The placement on the email notification is exactly where I want them but no data.

Any thoughts.?

The three custom fields were added to the address table. Two date fields and one text field.

I'm using the Business version. Went to System->Emails and opened the Order Creation Notification email.

I edited the HTML version and added it at about line 21 right after this line.
<?php echo JText::sprintf('HI_CUSTOMER',@$data->customer->name);?>

Nicolas

I tried you suggestion
<?php
$address =& $data->order_addresses[$data->cart->billing_address->address_id];
echo JText::sprintf('CUSTOMER_DATE_REQUEST', $address->daterequested); ?>

Same results. No data but text like the example I posted.

All suggestions would be appreciated.

Semi-success. This code almost works. Except the pickupdate field only displays the number 1 but not a date. Daterequested displays fine and
so does Customer_IRS_EIN.

<br/>
<br/>
<?php echo JText::_('CUSTOMER_DATE_REQUEST'); ?>
<?php $address =& $data->order_addresses[$data->cart->billing_address->address_id];
echo $address->daterequested; ?>
<br/>
<br/>
<?php echo JText::_('CUSTOMER_DATE_PICKUP'); ?>
<?php echo $address-->pickupdate; ?>
<br/>
<br/>
<?php echo JText::_('CUSTOMER_IRS_EIN'); ?>
<?php echo $address->irs_ein;?>
<br/>
<br/>

Screen shot of my custom fields

We changed the custom fields for the request date and the pickup date. We added them to the order table and removed them from the address table.
These two fields are now displayed with the order.

The IRS-EIN still remains in the address table. The following code resides at about line 21 of the email.

<br/>
<br/>
<?php echo JText::_('CUSTOMER_IRS_EIN'); ?>
<?php $address =& $data->order_addresses[$data->cart->billing_address->address_id];
<?php echo $address->irs_ein;?>
<br/>
<br/>

Had we realized the potential of the custom fields, it would have made it easier to do the customization.

The notification email and the administration email now work the way we want.

Thank you for all your help.

Here is the link to the Computer Ministry web site www.compministry.org/ . We are a non-profit ministry.

Consider this problem resolved...

Joomla 2.5.20

Hikashop 2.23 Business

Website www.compministry.org

Needed to add to custom fields to the Order_Creation_Notification

2 years ago this thread took care of the problem with Hikashop 1.5.7

This thread fixed the problem. But now the CUSTOMER_IRS_EIN & CUSTOMER_EMAIL_ADDRESS field names are displayed. However the field data is not displayed. Here is the code that we have been using that was working.

<?php echo JText::_('CUSTOMER_IRS_EIN'); ?>
<?php $address =& $data->order_addresses[$data->cart->billing_address->address_id];
echo $address->daterequested; ?>
<?php echo $address->irs_ein;?>
<br/>
<br/>
<?php echo JText::_('CUSTOMER_EMAIL_ADDRESS'); ?>
<?php echo $address->emailaddress;?>

Any thoughts?

That fixed the problem.