Order Confirmation Email

[northshore]

If anyone could help me with a small mod - I would really appreciate it.

 

I am trying to add the word (taxable) after the product name in the confirmation email.

Since some products in my store are taxable and some are not - it would make it easier to distiguish the

products when issuing refunds.

 

the sql field is the table that controls taxable goods is called : products_tax_class_id

 

if products_tax_class_id = 0 (item is not taxable)

if products_tax_class_id = 1 (item is taxable)

 

I need help creating the SQL query to check this value for a product.

 

I am thinking if i add it just before this line on checkout_process.php

 

$products_ordered .= $order->products[$i]['qty'] . ' Case(s) ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) .$products_ordered_attributes . "\n\n";

 

-----

 

like so - it will work:

 

SQL taxable goods query???

 

if products_tax_class_id <>0

$taxable = 'taxable'

 

$products_ordered .= $order->products[$i]['qty'] . ' Case(s) ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) .$taxable. $products_ordered_attributes . "\n\n";

 

-----

note in abovce i added the variable $taxable to the product_ordered variable in hopes the word "taxable" will print in the sent email

only for items which are taxable...

 

 

If anyone can help me build this taxable goods query OR helpme mod this into checkout_process.php - I thank-you in advance