You are here:  » Category mapping search in admin


Category mapping search in admin

Submitted by wilkins on Fri, 2015-03-27 11:18 in

Hi David

Is there any way to increase the search results for category and product mapping, when I search I only get a few results and I need to get all the results for the keyword I use.

Regards

Brent

Submitted by support on Fri, 2015-03-27 11:20

Hello Brent,

Sure - since 14/06A there is a single script that supports all admin area search results - if you open admin/helper.php and look for the following code at line 18:

$sql = "SELECT DISTINCT(".$field.") FROM `".$config_databaseTablePrefix."products` WHERE ".$field." LIKE '%".database_safe($q)."%' ORDER BY ".$field." LIMIT 6";

...and simply edit the LIMIT value as required. Alternatively for no limit, you can REPLACE with:

$sql = "SELECT DISTINCT(".$field.") FROM `".$config_databaseTablePrefix."products` WHERE ".$field." LIKE '%".database_safe($q)."%' ORDER BY ".$field;

Cheers,
David.
--
PriceTapestry.com