Submitted by mikecdprice on Tue, 2013-07-30 06:47 in Price Tapestry
Hello,
I am looking to add the merchant logo (if there) or merchant text to the search results. I found bunch of old posts that don't seem to work with the current version.
The current version doesn't include `merchant` in the search results query by default but it can be added easily. In search.php look for the following code at line 374:
$sql2 = "SELECT id,name,normalised_name,image_url,description,price,rating FROM `".$config_databaseTablePrefix."products` WHERE id IN (".$in.")";
...and REPLACE with:
$sql2 = "SELECT id,name,merchant,normalised_name,image_url,description,price,rating FROM `".$config_databaseTablePrefix."products` WHERE id IN (".$in.")";
Code from other threads on this subject should then work fine...
Hi Michael,
The current version doesn't include `merchant` in the search results query by default but it can be added easily. In search.php look for the following code at line 374:
$sql2 = "SELECT id,name,normalised_name,image_url,description,price,rating FROM `".$config_databaseTablePrefix."products` WHERE id IN (".$in.")";...and REPLACE with:
$sql2 = "SELECT id,name,merchant,normalised_name,image_url,description,price,rating FROM `".$config_databaseTablePrefix."products` WHERE id IN (".$in.")";Code from other threads on this subject should then work fine...
Cheers,
David.
--
PriceTapestry.com