Submitted by wilkins on Fri, 2015-03-27 11:18 in Price Tapestry
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.
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;
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