matteo.lavaggi

I don't think use "first" word. Instead it Match all result that contain any word. Duplicate entry weigh up result of unwanted product.this is unusuable. You have 3 option 1) go away of prestashop. An ecommerce with not usable search has no need of more word to spent on it 2) install elastich search module of you can install elastich search on your server 3) try to use old search class query from 1.7.1 https://www.prestashop.com/forums/topic/646232-prestashop-1724-search-results-issue/

Another BUG never fixed. Prestashop waste your time. Move away . An ecommerce that has not an usable search .... What else Wich version of ps you use ? For 1.7 I found this https://www.prestashop.com/forums/topic/646232-prestashop-1724-search-results-issue/ If you have your own server and you can install software (ex Ubuntu) you can reach your goal installing the elastich search module and elastich in your server. I have on 60k product and work great. I need to have a simple search working on hosting that dont allow to install elastich and for small site (<10k product). Today I will try to use the 1.7.1 search class or copy the query .

Prestashop 1.7 é pieno di bug. Se dite il contrario avete al massimo uno store con 100 prodotti. Fa pena. Ci sono bug non risolti dalla 1.7.1 alla 1.7.4 ... La ricerca fa schifo la cache non funziona

Hi dear, the search of ps 1.7.4 is still as bad as you find in 1.7.3,1.7.2 , completely unusable. Your search.php can work on 1.7.4? The goal is simply to use a AND LOGIC instead OR in the query result. If you have server when can install package you must consider install elastich searche module. I use that and it work GREAT. I've found another trick to tune up 1.7.4 search. The big problem on the defaul class is that it use an OR operator,so you get lot of result but also you get higher rank on products that has duplicated word in their field. Using or instead and your result don't match the query you are searching. If you try to find "Z H" you will have a higher result for entry with "Z Z Z" than one with "Z H A" And this is Creasy. To mitigate this function we have installed a module "auto keyword generator" and we configure it for generate tags from short desc. The module REMOVE duplicate entry and we teach search to use title and tags instead short desc . In title is hard to find duplicated words, instead in short desc it can happen frequently.

The buggy default ps import can't work for you. You can use a module for import , like advance import from CSV excel . We use this: https://addons.prestashop.com/it/data-import-export/190[spam-filter]product-catalog-csv-excel-import.html Ps if you need to start a new project think 2/3 times before go on prestashop... You need a module for almost all the function a store must have, and there is a list of unresolved bug that was crazy long ... i've one store with 60k product and we fight over bug from about 12 month ... Next time I'll go another time over Magento , there is no developer community under prestashop today , also fi it cost about 2000$/3000$ in third parts module.

Hi dear, default prestashop search is quite horrible. In some server setup I can't use external search engine like spinx or elastich, in this scenario is quite impossible to have a working search for a store with more than 100 products. The big problem is that there is no simple setup AND/OR logic . If you have a store with similar product, it's impossible to get the one you are searching for in the best result. Example Product a: Name: pippo pluto Short description: pluto home pluto best Product b: Name: pippo pluto top Short description: pluto home best Search for 50%/50% name and short desc : Query:"pluto top" will ever get the product a higher score than b also if "top" is not a terms in the product a, beacuse it occurrs 2 time in the product a short description. There is a way to force ps tho only show product that meat all the search terms?