User Setting Field in order confirmation email

[mfreeze]

I have successfully added a customernumber field to the UserSettings table and enabled display and update in the admin. Now I need to include this field in the Order Confirmation Email. Below is the code I used to add the field at registration.

Code: Select all

  	
                               UserSetting userSetting = new UserSetting();
                        	userSetting.FieldName = "colormidnumber";
                        	userSetting.FieldValue = colormidnumber.Text;
                        	newUser.Settings.Add(userSetting);
                        	newUser.Save();
 

How to I access this field in the Order Confirmation email and display it?

[mazhar]

You have to do something like this

Code: Select all

#set($colormidnumber = $customer.Settings.GetValueByKey("colormidnumber"))
ColorMindNumber:- $colormidnumber

[mfreeze]

I put that in and it didn't work. All I get is ColorMinNumber:- $scolormidnumber

[pezza]

Hi,

Is the s meant to be before the colormidnumber, or is that just a typo? Maybe if typo in your code, that might be why it is not getting the correct value

Andrew

[mfreeze]

The s is just a typo.

[pezza]

and is that the same with colormin and colormid, or is that meant to be different values?

Sorry, just that i used to be a proof reader in a past life

[mfreeze]

Here's what I have in the email template.

Code: Select all

#set($colormidnumber = $customer.Settings.GetValueByKey("colormidnumber"))
ColorMidNumber:- $colormidnumber

Here's what I get in the email, ColorMidNumber:- $colormidnumber

[mazhar]

Try by removing variable declaration only using something like this

Code: Select all

$customer.Settings.GetValueByKey("colormidnumber")

[mazhar]

Anyhow I just tested the code I have posted in my first comment and it seems to work for me.

[mfreeze]

At AC 7.03?

Maybe I'm putting it in the wrong place. Can you attach the order confirmation email you tested?

[mazhar]

Code should work for 7.0.3 as well.

[mfreeze]

Thanks.

Before your reply, I got it to work using

Code: Select all

<tr>
#set ($colormidnumber = $order.User.Settings.GetValueByKey("colormidnumber"))
<td class="Email"><div align="right"><strong>Colormid #:</strong></div></td>
<td class="Email">${colormidnumber}</td>
</tr>