Adding model number to admin categories

[jeeperz]

I searched and searched and even found a few answers, but they didn't work well.

 

What this does is adds the products model number to the product info box for the selected item (it will diplay the model number above the price on the right hand side of the screen).

 

I have many items with the same or similar descriptions and I have to go in, choose the item, then click edit to find out what the model number is. This simply allows me to choose the item and it will be displayed.

 

This is a rough hack but it seems to work. If anyone has any other tips for doing this, I'm all ears!

 

In Admin/Categories.php search for this:

 

$contents[] = array('text' => '<br>' . tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image);

 

Insert the following AFTER the above:

// Read Product Model
		$product_query = tep_db_query("select p.products_id, pd.products_id, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
		$product = tep_db_fetch_array($product_query);
		$contents[] = array('text' => '<br>' . TEXT_PRODUCTS_MODEL . ' ' . $product['products_model'] . '');  
// End Read product Model

 

That's it!