Admin: Model No on Category / Product Administration Screen

1 of 1494   Next >   Last >>   The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website. 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! 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.    Posted on: 11/11/2008     See contribution details Request Installation with Paid service