different datafeeds

Submitted by rolli1 on Tue, 2012-03-13 15:53 in Price Tapestry

Hi David,
in my datafeed I have e.g. the following products:

Enyce Men Enyce Coaches Ii Jacket BT Outerwear

Akademiks Men Conference Polo - Shirts

Drj Underground Men Backpack Speaker Bag - Accessories

Mecca Girls Girls Upgrade Ls Shirt

Is there a possibility to execute search only for the name of the brand and the item like: t-shirt or outerwear or shirt or accessories?

regards

Roland

Hi Roland, Sure - normal

Submitted by support on Tue, 2012-03-13 19:49

Hi Roland,

Sure - normal search can be limited to brand and category if you like and ignore name if you want to try that. To do this, first make sure that full text indexing is disabled by changing line 8 of config.advanced.php 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 .= "category LIKE '%".database_safe($word)."%'";

  $where .= "OR brand LIKE '%".database_safe($word)."%'";

Cheers,
David.
--
PriceTapestry.com

Thats exactly what I

Submitted by rolli1 on Thu, 2012-03-15 08:57

Thats exactly what I wanted.
Regards
Roland