I have a shop on Prestashop 1.7 with books. Some of them have two authors. Authors are stored as a manufacturers. I made a plugin to allow user to assign more than one manufacturer to single product, but now I must fix products search to use my custom table of assignments in search process. The problem is that I can't find where is the sql code which is looking for manufacturer name. I already spend whole day for this without results. Any help?
After deep digging: it is not so easy as I thought... Prestashop keeps keywords in table called search_word which is connected by id_word with table search_index where all words are assigned to id_product, so now my job is to assign manufacturer name as a search words to updated product - sounds complicated, but it shouldn't be so hard
Look into the file classes/Search.php method find. In my case, it is line 331. you need to modify this query to change a search approach