Get Free Audit

How to Improve Prestashop Search Results

May 5, 2014

1135 Alex Simonchik

How to Improve Prestashop Search Results

I found out a problem. If your store has a product with an article ABC12345, you can find it inserting in search field ABC12345, ABC123, ABC1 and so on. But if you write there 12345 or 123, there’s going to be no results. Regular phrases like * do not work. Is there any other way to find product with 12345?

I have a solution. We need to redefine method find of Search class. In sql-request that does the search process you need to add %-symbol at the beginning of the line, that we are searching for. Find in file classes/Search.php this code:

Igor Dragun
Partner With Us Let's discuss how to grow your business. Get a Free Quote.
Talk to Igor

And change it for that:

It’s better to override the file  classes/Search.php.

I have this part of the code from 209th line.

Post on the forum.

Igor Dragun
Partner With Us Looking for a partner to grow your business? We are the right company to bring your webstore to success. Talk to Igor


  1. Hi, Luca!
    It is impossible to improve search in such a way you are talking about through the admin panel of PrestaShop. It can be done by code changing.
    Please, contact our support team [email protected]. They will help you with this problem.

  2. I’ve a problem with 1.6

    Search engine is a disaster. If you search for “woman orange shirt” it shows a lot of irrelevant results because it will find any product that contains just one single word: woman, orange, shirt.

    It’s a OR and not an AND search.

    Is there any way to improve search and let it show ONLY the exact phrase?

    Hope you can help me


  3. I’m followed your guide but it seems that nothing happened on PS1.6.0.9.
    I also tried to empty the cache. There’s something else that i should do?

  4. чуть ниже тоже желательно поправить

    if ($word[0] != ‘-‘)
    $score_array[] = ‘sw.word LIKE \’%’.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).’%\”;

Post a new comment

BelVG Newsletter
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.
Email *