Need to see "model" in admin product listing

[highrecall]

Been searching the forum like crazy, but haven't found anybody else speaking of similar issue.

 

Currently on the (Categories/Products) page in admin, I can only see the product's name and status.

I was wondering if there would be a way to see more info in order to know which product to delete, etc.

Is there a method to see details at a glance that I have overlooked?

 

In my store, may have several products listed with the same product name. The only difference would be the model.

 

Any ideas are greatly appreciated!

[khime]

Easiest way to do this is to put the model number at the end of the name! This is what we do plus it gives the benefit of when search engines visit your site it probably helps give each page a higher ranking for that particular model keyword as it is in the header.

 

If you want to do it the hard way then you need to modify /admin/categories.php

 

You have to retrieve the model number from the database when in the product listing then create a new cell for the model number then insert the model number into the cell.

 

I'm not goingt to go into detail as I believe the 1st method is the easiest.

[trophy]

This is a great tip, I have been having the same problem when you get a list on the screen with all the same description you have no idea which is which, until now.

Truely a great yet simple idea.

Do you have any tips for using the same pic without having to load upload that pic for the product when listed in different categories.

To make it a tad clearer I may have a product listed under different categories so I have to upload that same pic several times.

How can I use the pic that is already loaded into my images file.

Hope that is clear enough.

Gill A

[Nullachtfuffzehn]

To add the products_model to the display on the admin site it would be necessary to change the database and do a lot of coding to make the whole thing consistent.

 

I guess you're only using one language for administering your store, so a quick and dirty solution should be easy to do. But when it comes to make a contribution that meets the requirements of OSC, it's more difficult.

 

Making one pic available for more than one product would need a new module too. Might be an interesting contribution though. I'll think about it. But right now I'm drowning in work, so it'll take some time till I can make it.

[Guest]

To add the products_model to the display on the admin site it would be necessary to change the database and do a lot of coding to make the whole thing consistent.

 

I guess you're only using one language for administering your store, so a quick and dirty solution should be easy to do. But when it comes to make a contribution that meets the requirements of OSC, it's more difficult.

 

Making one pic available for more than one product would need a new module too. Might be an interesting contribution though. I'll think about it. But right now I'm drowning in work, so it'll take some time till I can make it.

A lot of coding? The model is already there, just add an extra column for the display.

 

in catalog\categories.php change:

			  <tr class="dataTableHeadingRow">
			<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORIES_PRODUCTS; ?></td>
			<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>
			<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
		  </tr>

to

 

			  <tr class="dataTableHeadingRow">
			<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORIES_PRODUCTS; ?></td>
			<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_MODEL; ?></td>
			<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>
			<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
		  </tr>

 

change:

	if (isset($HTTP_GET_VARS['search'])) {
  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");
} else {
  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");
}

to

	if (isset($HTTP_GET_VARS['search'])) {
  $products_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");
} else {
  $products_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");
}

 

find this line

				<td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $products['products_name']; ?></td>

 

add below

				<td class="dataTableContent"><?php echo $products['products_model']; ?></td>

[getabc]

WOW just what I've been looking for !! Thanks!!

[darkgrove]

Don't forget to go to admin/includes/languages/english/categories and add

 

define('TABLE_HEADING_MODEL', 'Model Number');

 

See example below:

 

define('TABLE_HEADING_ID', 'ID');

define('TABLE_HEADING_CATEGORIES_PRODUCTS', 'Categories / Products');

define('TABLE_HEADING_MODEL', 'Model Number');

define('TABLE_HEADING_ACTION', 'Action');

define('TABLE_HEADING_STATUS', 'Status');

[thecustomshop]

This worked out great for me!!