Hello
Is there an option to use a custom field as the qualifier to match up items.
Example: every item that has the same "SKU" will be shown with the compare pricing option?
Thank You for your help.
Bobby
Hello David
Thank you, exactly what I wanted. Can you also help me with a search option. I want to be able to have a custom field searchable, such as "SKU".
Most of my feeds have the a SKU Value - but when doing a search they do not show up by searching the sku value. I have already created the custom field and it is displayed on the product page under the description.
Also wanted to let you know that your support system is the main reason I purchased the product, thank you for all of the detailed replies, I have already made many changes using your other posts.
Thank You
Bobby
Hi Bobby,
Thank you for your comments!
The simplest way to add sku to the search is first to disable the full text indexing in config.advanced.php by changing line 8 as follows:
$config_useFullText = FALSE;Then in search.php look for the following code at line 229:
$where .= "search_name LIKE '%".database_safe($word)."%'";...and REPLACE with:
$where .= "search_name LIKE '%".database_safe($word)."%'";
$where .= " OR sku = '".database_safe($word)."'";However, if your niche does benefit from full text indexing then you would need to create a FULLTEXT index on (name,sku). You can create this index with the following dbmod.php script - create in and run once from the Price Tapestry installation folder:
<?php
require("includes/common.php");
$sql = "CREATE FULLTEXT INDEX name_sku ON `".$config_databaseTablePrefix."products` (name,sku)";
database_queryModify($sql,$result);
print "Done.";
?>
...and finally in search.php (in addition to the above mods) look for the following code at line 212:
$matchFields = "name";...and REPLACE with:
$matchFields = "name,sku";Hope this helps!
Cheers,
David.
--
PriceTapestry.com
Hi Bobby and welcome to the forum!
There's a detailed guide on conversion to comparison by sky in this thread which should help!
Cheers,
David.
--
PriceTapestry.com