Order Confirmation Email - I want to add more details

[shaza]

So I've been having major problems with the order confirmation emails.

The client of mine insists on wanting the product description show up in the confirmation email as well as the individual price for each item (it shows only according to quantity by default).

Is there any way to do this? I am banging my head on it, it's kind of silly either way that it doesn't do it automatically.

[DrByte]

First, you should tell them that they shouldn't be doing ANY order-fulfillment or accounting based on the emails. They should be using the admin UI for that.
But, you and I both know they'll fire you if you tell them that

So ... you'll have to get your sleeves dirty and alter the code in the create_add_products() method of the order class at /includes/classes/order.php where it builds the $this->products_ordered and $this->products_ordered_html variable contents:

      // build output for email notification
      $this->products_ordered .=

Note that the product description is never stored as part of the order (and frankly in my opinion if the product name and model aren't adequate then the storeowner really needs to rethink things anyway), so if you need the description, you're going to have to run a new query to retrieve it from the database ... a fresh query for each line item in the order.