Community Add-Ons

this is base on "search by products model". Now,
you can search products model in the admin search.

in catalog/admin/categories.php

search:
------------------------------------------
p.products_id = p2c.products_id and pd.products_name like '%" .
tep_db_input($search) . "%'

Replace with
_________________
p.products_id = p2c.products_id and ( (pd.products_name like '%" . tep_db_input($search) . "%') or (p.products_model like '%" . tep_db_input($search) . "%') )

this is base on Show Model Number v 1.00, i'm taking this out from that contribution, seems like this contribution is missing this great feature.

in catalog/admin/categories.php

search:
------------------------------------------
p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%'


replace it with:
------------------------------------------
( (pd.products_name like '%" . tep_db_input($search) . "%') || (p.products_model like '%" . tep_db_input($search) . "%') )


save and uplodate, that's it, now you can search products model in the admin search!

thanks to the original creator!

I'm having lot's of item with red (not in use)status. and i feel like having it short by the status so i can focus on the green one.

here how to do it.

in catalog/admin/categories.php

search:
-------------------------------------------------
pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");

replace with:
-------------------------------------------------
pd.products_name like '%" . tep_db_input($search) . "%' order by p.products_status");
// backup for short by status
// pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");


search:
-------------------------------------------------
(int)$current_category_id . "' order by pd.products_name");

replace with:
-------------------------------------------------
(int)$current_category_id . "' order by p.products_status");
// backup for short by status
// (int)$current_category_id . "' order by pd.products_name");

-------------------------------------------------
if you want to restore it, just replace by the backup comments...

if you currently shorted by products_model, then simply change the p.products_model to p.products_status within that sql array.


save and upload!

Added column title to neaten it up.

Support thread is at http://forums.oscommerce.com/index.php?showtopic=323637

When displaying the products in a category only the description is displayed sometimes making the identification of the product to work on difficult.

This is because the description does not always uniquely identify a product and you could update the wrong product.

This contribution displays the product model on the Category /Product administration screen and puts the products into product model sequence, thus enabling you to find the correct product to administer.