Jump to content
phll

Some products are not showing on the search result.

Recommended Posts

Hello Prestashop people.
This is my first post here, I hope I will be clear enough.

 

Some products are not showing in the search result even if they use the same words in the product description.
 

My shop is a vinyl record store.

My catalog (more than 7000 products) is updated every morning via CRON

 

My daily cron task:

  • all the products are set at quantity = 0 via sql query in the database 
  • all the quantity = 0 are disabled via sql query in the database
  • all the image are erased from the server (/p/*)
  • the catalog is updated from a csv file via the module "Prestashop Importer - import product from csv, xls, xlsx v1.0.35"
  • the image folder is checked and cleaned via the module "elegant image cleaner".
  • the search index is updated completely
  • then I have eBay synchro crons

Everything's work smoothly, except that I have recently found a problem with the search result.

 

For exemple, the research of "replica" show up only 4 results, and should at least show up 18 records.

e.g. this album 

https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id230460014)_atoll-l-araignee-mal-vinyl

containing the word "replica" show up in the result when this one:
https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id340702941)_atoll-musiciens-magiciens-vinyl
or this one
https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id356270959)_pazop-pazop-vinyl
doesn't appear.

 

They have the same description "Replica Records (4)".



Of course I tried to re-build the indexation, I tried also to empty the table xx_search_index and xx_search_word, and re-index after, but I have the same bad result every times.
I also tried to switch off the languages (only FR is activated now, EN is still there but deactivated), and tried to re-build the index after switching off the search option (Search within word, etc).

 

BUT, when I open and save a missing product, it then appears on the search result.

 

 

I have really no idea what to do, where to search.

Does someone have an idea?


Server info:
PrestaShop version: 1.6.1.7 
Server software version: Apache

PHP version: 7.0.19
Memory limit: 1024M
Max execution time: 25200 
MySQL version: 5.6.35
MySQL engine: InnoDB
MySQL driver: DbPDO 

website url:
https://www.la-face-cachee.com



Note : I have a mirror of the website for professionals only, all the system is the same, theme, server etc, only the catalog is different (760 products manually added) and the search result work as expected (showing all the "replica" products).

Note2 : I've found a weird "word" on the ​xx_search_word : "replicarpccd012", that seems to be a mix of the name "replica" and the "rpccd012" of this product:
https://www.la-face-cachee.com/cd/rock/(id355917635)_etron-fou-leloublan-live-at-the-rock-in-opposition-festival-1978-new-london-theatre-cd
The fun part is that this product appears also with the "replica" query, as expected with the "Search within word" enabled.

 

 


Thank you for reading!

Phil
 

 





 

Share this post


Link to post
Share on other sites

Hi Phil,

 

Same problem. I fixes it rebuilding the index but I imagine that it shouldn't be necessary. Just adding new products to index.

 

Looking forward to hearing some ideas.

 

Regards,

Share this post


Link to post
Share on other sites

I have the same issue but on Prestashop 1.7.2.4. 

I found that, if a product has 0 quantities, it doesnt show up in the search results. It can be found in the correct category but not in search.

Share this post


Link to post
Share on other sites

Same issue here with 1.6.1.20, very similar case as you Phil.

Did some of you find a fix ?

Share this post


Link to post
Share on other sites

Hello,

i have the same problem and a solution

The keywords for the product exists at database , eg for product 23750 , exists  23750 keyword

The temporaly solution for me is to change default category for the product to another category, then change back to correct category!

Strange but it is working!

///edit Apr 17 2020 //

It only needs to add product to another category and remove it again. no need to change product default category

Edited by siomosp (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites
On 6/2/2017 at 12:47 PM, phll said:

BUT, when I open and save a missing product, it then appears on the search result.

2019 year and still i have this error, but i add products via script, all database querys are ok and added, but in search not appear. When i edit product and save = product showing in search results.

Someone fix this sh*t error?

prestashop 1.6.1.20

Share this post


Link to post
Share on other sites
On 8/19/2019 at 11:06 AM, siomosp said:

Hello,

i have the same problem and a solution

The keywords for the product exists at database , eg for product 23750 , exists  23750 keyword

The temporaly solution for me is to change default category for the product to another category, then change back to correct category!

Strange but it is working!

this worked for us.. 

PS 1.6.1.24

Share this post


Link to post
Share on other sites
On 8/19/2019 at 12:06 PM, siomosp said:

Hello,

i have the same problem and a solution

The keywords for the product exists at database , eg for product 23750 , exists  23750 keyword

The temporaly solution for me is to change default category for the product to another category, then change back to correct category!

Strange but it is working!

Correct, it is working but is dificult all product no index.

i have 4000 products no index and prestashop 1.7.6.4 and the problem exist.

Share this post


Link to post
Share on other sites

I am on Prestashop 1.7.6.5. and same error. Just clicking edit, no changes to product and save makes it ok. I have now more than 100 products and growing, I am wondering what will I do with 1000+ products.

Also,  is there by any chance system which can separate products showing and products not showing so I dont have to click them all?

Any updates on the issue?

Best regards to all,

Leo

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More