Exclude Description from Search

[B. Szakacs]

Hi

 

I want to exclude the description from search (short description can stay).

 

I use PS 1.4.4.

 

Any ideea?

[phrasespot]

Hi

 

I want to exclude the description from search (short description can stay).

 

I use PS 1.4.4.

 

Any ideea?

Find the file installroot/classes/Search.php. Around line 389 there is an SQL SELECT statement, remove the pl.description column from the selection criteria so it becomes:

 

$products = $db->ExecuteS('
SELECT p.id_product, pl.id_lang, pl.name pname, p.reference, p.ean13, p.upc, pl.description_short, cl.name cname, m.name mname
FROM '._DB_PREFIX_.'product p
LEFT JOIN '._DB_PREFIX_.'product_lang pl ON p.id_product = pl.id_product
LEFT JOIN '._DB_PREFIX_.'category_lang cl ON (cl.id_category = p.id_category_default AND pl.id_lang = cl.id_lang)
LEFT JOIN '._DB_PREFIX_.'manufacturer m ON m.id_manufacturer = p.id_manufacturer
WHERE p.indexed = 0', false);

 

Then rebuild your index (Back Office > Preferences > Search)

 

One could override this class as well but that would require writing several hundred lines of code in the overriding class so this is the simplest option. Just remember to repeat when you update.