Add new field to product table

[aeava]

Hi,

I've added a new field to the products table "products_bin". This is very similar to the "products_model" field. I need it to appear on the e-mail confirmation. Can anyone help me?

Looking at the checkout_process.php file, I've found the following line of code that creates the lines in the e-mail with the product details, so I've added the text in red:

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


I've also gone to the 'order.php' class file (includes\classes) and edited it so that every time there was an instance of "model", I added "bin".

I've also added a field in the orders_products table named 'products_bin'.

Anyone can help? Pleeease??

thanks in advance,

A.-

[aeava]

I couldn't get it to work "the right way", so I cheated and did the following:

Filename: checkout_process.php
Lines: around 288
**new code in red **

//request bin code
$bins = tep_db_query("select products_bin from products where products_model='" . $order->products[$i]['model'] . "'");
$bins_values = tep_db_fetch_array($bins);

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

If anyone has got a nicer way of doing this, please let me know. don't want to have to run additional queries for each product ordered...



A.-