Product Descriptions in emails

[RSprinkel]

Hi All,

Is there a way I can get the Full Product Description in the emails. I have 15 of pretty much the same item but different descriptions and when I receive an order all I get is the title of the item and it kinda makes it hard to figure out what item is what.

Thanks much in advance.

[TheOracle]

Make a backup of your includes/classes/order.php file (and a very good one).

Then. find:

$orders_products_query = "select orders_products_id, products_id, products_name,
                                 products_model, products_price, products_tax,
                                 products_quantity, final_price,
                                 onetime_charges,
                                 products_priced_by_attribute, product_is_free, products_discount_type,
                                 products_discount_type_from
                                  from " . TABLE_ORDERS_PRODUCTS . "
                                  where orders_id = '" . (int)$order_id . "'";

    $orders_products = $db->Execute($orders_products_query); 

replace with:

$orders_products_query = "select tpo.orders_products_id, tpo.products_id, tpo.products_name,
                                 tpo.products_model, tpo.products_price, tpo.products_tax,
                                 tpo.products_quantity, tpo.final_price,
                                 tpo.onetime_charges,
                                 tpo.products_priced_by_attribute, tpo.product_is_free, tpo.products_discount_type,
                                 tpo.products_discount_type_from, tpd.products_description
                                  from (" . TABLE_ORDERS_PRODUCTS . " tpo, " . TABLE_PRODUCTS_DESCRIPTION . " tpd)
                                  where tpo.orders_id = '" . (int)$order_id . "'";

    $orders_products = $db->Execute($orders_products_query); 

Then, find:

'products_discount_type_from' => $orders_products->fields['products_discount_type_from']); 

replace with:

'products_discount_type_from' => $orders_products->fields['products_discount_type_from'],
'products_description' => $orders_products->fields['products_description']); 

Then, find:

'<td>' . $currencies->display_price($this->products[$i]['onetime_charges'], $this->products[$i]['tax'], 1) : '') .
'</td></tr>'; 

replace with:

'<td>' . $currencies->display_price($this->products[$i]['onetime_charges'], $this->products[$i]['tax'], 1) : '') .
'</td></tr>' .
'<tr><td>' . TEXT_EMAIL_PRODUCTS_DESCRIPTION . '</td></tr>' .
'<tr><td>' . $this->products[$i]['products_description'] . '</td></tr>'; 

Then, in your includes/languages/english.php file,

find:

define('TEXT_ONETIME_CHARGES_EMAIL',"\t" . '*onetime charges = '); 

add right below:

define('TEXT_EMAIL_PRODUCTS_DESCRIPTION', 'Products description'); 

Test your order (as a test order at least) and see the results. ;)

[RSprinkel]

Sorry for the delay in getting back to this thread. I have just done all the above and all I am getting is just the Product name. I tried it 2 times and got the same thing in both emails.

Thanks.