If like me you need to list specails by model number try this, I made a change or 2 to the admin/specials_enhanced.php.

no rocket science , lines 148 and 150 just change references to TABLE_PRODUCT_DESCRIPTION so they read

TABLE_PRODUCT



and line 200 and 543 references to:

pd.products_name changed to

pd.products_model


After the above changes this line caused an error as the $languages_id variable comes from TABLE_PRODUCTS_DESRIPTION so I just commented it out:



211 $clauses[] = 'pd.language_id = '. (int)$languages_id;




This is probably not the best or cleanest way but it works. Just stick it in your admin folder and try it.


The attached file has the changes made already.

More...