I am developing an update to our website sundials.org on a local host (WAMP) and am replacing Phoca Cart with J2 Commerce (6.6.4), a much better e-commerce solution. I'm down to email templates.
I have created a custom field called Lat_Lon that requires user to enter their latitude & longitude. That works nicely on both billing and shipping address info. But now, how to I get the Lat_Lon into the email templates? It is important for both customer and for sundial admin.
I checked the database J2commerce_orders and J2commerce_ordersinfos and do not see my custom field Lat_Lon stored. Where is it stored and how can I access it for the email templates?
Forgot to mention: No Registered Users, All are Guest
Thanks,
Bob
Webmaster, North American Sundial Society