Community Add-Ons

This release Added to edit the Part No. Field

ATTACHED FILE IS NOT A FULL PACKAGE

This release puts changes into various files so that this Contribution has a menu item underneath 'Catalog' in the Admin section.

This extremely simple modification answers a problem I encountered with this extremely useful application.

The entire product list can load fairly slowly if your inventory includes thousands of products. After adding several fields for editing, including some custom fields for my heavily modified store, I found the wait time for full loading to become interminable - and impractical when the main objective was to edit fields like stock levels quickly. Even if I waited for the full inventory to load, I'd still almost immediately initiate a search anyway to get to the items in which I was interested.

The easiest solution for me was simply to bypass the full product listing, and go directly to the search page. Though a full alternative package might entail a re-named files and re-configured and -formatted pages, with extraneous code removed, I found a simple hack to be satisfactory.

If you just go to line 22 of the product_list.php, you can replace

$product_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, p.products_format, p.products_condition, p.products_price, p.products_quantity, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

with

$product_query = 0;

You can also of course comment out the tep_db_query statement if you wish to preserve the snipped for possible future re-use or re-installation. As in

$product_query = 0 //tep_db_query("select p.products_id, p.products_model, pd.products_name, p.products_format, p.products_condition, p.products_price, p.products_quantity, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'")
;

Note that if you comment out in the above manner, you need to keep the semi-colon to terminate the statement, so you'll have to give it its own line, as above.

You'll be fine. Clicking on Product List in admin/catalog will take you immediately to a page whose main area is blank, but with the search box readily available. Searches will execute quickly, and you can then perform whatever desired edits or stock adjustments on the products and fields that are found.

At some point I may produce a full Product Search and Edit alternative that could be uploaded instead of or alongside Product Inventory Editor, but I'm still researching issues related to Search itself in mysql (upgrading to the latest versions in order to deal with apostrophes is a primary issue).

--note: ATTACHED FILE IS NOT A FULL PACKAGE - it's just a copy of this text

The original code only searched the first word of the product_name. The code below searches for all occurances of the search word within product_name.

Change line 18 from

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pd.products_name like '".$_REQUEST['prod_search']."%'");

to

$product_query = tep_db_query("select pd.products_name, p.products_id, p.products_price, p.products_quantity, p.products_model, p.products_weight from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pd.products_name like '"."%".$_REQUEST['prod_search']."%'");

The original issue v1.0 was just what I was waiting for. I must congratulate Rodney Sparks, RS Autosport - http://www.rs-autosport.com

But I needed it to include the price as well.

There are only 2 files required in this mod
catalog/admin/product_list.php
catalog/admin/includes/languages/product_list.php

but you must follow the installation instructions
as in Product Inventory Editor, v1.0 (final release).

It works OK on my site www.gb-online.co.uk but there could be more refinements.

Product Inventory Editor, v1.0 (final release)
Rodney Sparks, RS Autosport - http://www.rs-autosport.com

This mod adds an item to the catalog menu of the admin panel. It consists of an interface that works with your "products" and "products_description" tables. It provides a listing of part number and product name for all items in the database, and has an editable field (containing the current value) both for that product's weight and its inventory level. This way, weights and stock levels can be updated much more quickly than with Easy Populate. Additionally, there is a search box into which a substring can be entered in order to narrow down the listing of products on the page. I had this mod done to my site in order to allow me to quickly update inventory levels when I receive product, and it has proven to be most helpful.

I paid to have this mod done on getafreelancer.com. It was done by "rajinfosolu", a freelancer who works from that site, and I recommend his work. If you want a modification done to this, please contact him on getafreelancer.com, because I can't help you!

One limitation that I know of is this: When you open the inventory editor page, the stock level form fields are all populated with the current stock levels. When the "update" button is pressed, it updates the database with all of those values, not just the ones that have changed. If a purchase has gone through on the site while you're editing this page, any change to stock levels will be overwritten when the "update" button is pressed. In other words, work quickly!

Installation instructions and a screenshot are included in the zip file.