Irrelevant results are shown

  • Resolved rudolfl

    (@rudolfl)


    5 months, 3 weeks ago

    Hi

    Here is an example

    https://www.hatsfromoz.com.au/?s=1148&post_type=product&type_aws=true

    Search term is 1148, but there is nothing related to this at all in the products displayed. I only have search enabled in SKU, Title and Description. Even looking at page source for the product, there is no “1148” in any of the products

    I do have many more instances of similar problem. I cleared cache and re-indexed the table.

    Any ideas?

    Thanks,

    Rudolf

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    Hi,

    Please try the following – open plugin settings page and turn off ‘Misspelling fix’ option. After this check your search results one more time. Do you see any differences now?

    Regards

    Thread Starter rudolfl

    (@rudolfl)

    Thank you for replying.

    Problem is still there. I turned this option off, then cleared cache and re-indexed table just in case. No luck

    Plugin Author ILLID

    (@mihail-barinov)

    The best way to debug this problem is to open aws_index table and check its records for each of these three products. For example – choose all records for id = 154297. Then check the term column. Does it contain anything like 1148?

    Thread Starter rudolfl

    (@rudolfl)

    Hi,

    No. Nothing like that in the table for that ID.

    In fact, I also searched for LIKE %1148% in whole terms column for all entries. Nothing.

    Just to save me looking through the plugin code, can you tell me SQL query that is run when search is made? I will try to run it manually and see if I can figure it out

    Plugin Author ILLID

    (@mihail-barinov)

    Well, search queries can be quite complex. It is better for you to get the current sql query via?aws_search_query_string?filter hook and then run it directly.

    Hi,

    I have the same issue. It shows irrelevant results, although I disabled the “misspelling fix” option.

    https://www.surfpistols.fr/?s=ensis&post_type=product&type_aws=true&aws_id=1&aws_filter=1

    As you can see, the first 20 results are relevant, but all the other are not.
    It’s like it forced itself to go until the max results number (which is 100) by filling with irrelevant products.

    Plugin Author ILLID

    (@mihail-barinov)

    @arbremojo

    Yes, that looks strange. Please try the following – from the plugin settings page -> Search Results tab set some more number of products to display for live results. Then make a test search one more time and tell me – do you see the same irrelevant products inside live results too?

    Regards

    Thread Starter rudolfl

    (@rudolfl)

    OK,

    In my case problem is “misspelling fix” option. Yes, I tried to turn it off before. When I tried again today while watching query (yes, it is a rather complicated one!!!) I could see spelling substitutions. So, I turned option off again and I saw spelling substitution again in query!

    After clearing site caches, I no longer have wrong results.

    Thank you for your help. I will keep spelling fixes off

    Rudolf

    That’s good for me too! I set option?s% instead of %s% ??

    Thank you

Viewing 9 replies - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.