AbleCommerce Shopping Cart Software

I would like to display some of the custom customer fields in the shipment information of the shipping confirmation email.

The default shows variables like $orderItem.SKU, $orderItem.Name, etc... What variable would the custom fields be?

Thanks in advance!
Bruce.

You mean custom fields you defined for products?

Here is how you can access them

The custom fields are customer fields I had defined in the Product Templates.

I made a modification to the customer notification email template to replace the $orderItem.Name with just the custom fields to see if it would work.

After entering a dummy order and putting some values in the custom fields on the order to ensure some values, the email notification just shows a blank in the description column. See script...

#foreach($orderItem in $order.Items.FilterByShipmentAndSort($shipment.OrderShipmentId))
#beforeall
<tr>
<td><strong>SKU</strong></td>
<td><strong>Description</strong></td>
<td><strong>Quantity</strong></td>
<td><strong>Price</strong></td>
</tr>
#each
#if ($orderItem.OrderItemType == "Product")
<tr>
<td>$orderItem.Sku</td>

<!-- <td>$orderItem.Name</td> -->

<td>
#foreach($customField in $orderItem.Product.CustomFields )
$customField.Name : $customField.Value </br>
#end
</td>

<td>$orderItem.Quantity</td>
<td>$orderItem.ExtendedPrice.ToString("C")</td>
</tr>
#end
#end


The Sku and Quantity fields are populated but not the custom fields. If you see the problem, please inform.

Thanks,
Bruce.

please try $customField.FieldName and $customField.FieldValue instead of $customField.Name and $customField.Value

Same result with

<td class="Email">
#foreach($customField in $orderItem.Product.CustomFields )
$customField.FieldName : $customField.FieldValue </br>
#end
</td>

oops I am sorry. $oderItem.Product.CustomFields will return the custom fields defined not the user specified values for the custom fields.

This should work ... although I haven't tested this either.

WooHoo. Spot on! That did it. Thank you!

sohaib,

This question is not related to the topic but ...
How do I use the ac_CustomFields table?
I cannot find anyplace in admin where I can work with this table.

There isn't any place in the admin right now. Joe has an add-on on his site that adds them to the admin.

Thanks a bunch Judy.

Thanks for the plug Judy

My add-on works with ac_Products custom fields though. I could probably adapt it to the ac_CustomFields, but it's not something I've explored in-depth at this point.