Why is the customer email address stored in the orders table???

If a customer places an order and then changes their email address in the My Account area, they do not receive any email updates since the system sends the email to their old address.

Shouldn't the mail routine be using the email address from the customers table rather than the orders table?

Hellooooooo???

All the customer/order data is stored as a snapshot as at the point-in-time when the order was taken. Surely you wouldn't want a customer altering important information such as address details and phone numbers etc and then claiming that they never received their goods ... because you'd sent it to one place and then they changed the details later. The email address is part of that snapshot.

If you'd like to change that functionality, you're certainly welcome to alter it to suit your needs.

::sigh::

I guess data redundancy is not frowned upon by everyone afterall.

Look at the registration process as it has been designed. You have a section for "Personal Details" and a different section for "Login Details" and the email address is captured under "Login Details" (as it should be).

Then, in the "My Account" section you have the email mixed in with the "Personal Details" which seems rather odd, considering that you have to use your email address to Login.

Oh well.

Still, it's a great product for the price. ;)