Hi all,

I am new to zencart. Please help if anyone can.

I want to add couple of details in the order confirmation email. I have noticed that the contents displayed in email are fetched from table called 'zen_orders' from the database.

My problem is that i want to add a field called 'customers_dob' which i am using for referral details. The field is not in 'zen_orders' table but in table called 'zen_customers'. How do i go about it.

I also want to add order status to the email. I feel that can be easily done caus the field is in table 'zen_orders'.

Thx in advance.
Pratik