Admin Invoice Show Product ID NOT Model #

[jamisonfitz]

Hello All,

 

First of all id like to thank anyone whom may have a idea or reply to this as ive worked on it for a good bit and cant get it... what i need is for the Invoice, Package Slip and Orders Info to show the Product ID NOT the Model #. See i use easy populate for 2,000+ items and OSC assigned the model #'s automaticlly so they dont match the product ID in the admin as they do on the store front... ive found where its called in all three files but im not sure what i need to change model to instead...

 

$order->products[$i]['model']

 

Anyone know?

[kgt]

In admin/includes/classes/order.php around line 80:

 

Change

 

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

 

to

 

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

 

Around line 82, change

 

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

 

 

To

 

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price'],

'products_id' => $orders_products['products_id']);

 

Then in the invoice, change

 

$order->products[$i]['model']

 

to

 

$order->products[$i]['products_id']

 

Where ever you want products_id instead of products_model.

 

(I didn't test this, but I think it should work.)

[jamisonfitz]

KGT! Thank you so much, worked great... cant thank you enough! :)