search query returning product results from partial words

  • Posts: 96
  • Thank you received: 6
  • Hikashop Business
5 years 8 months ago #296412

-- url of the page with the problem -- : antiqueswan.com/
-- HikaShop version -- : 3.5.0
-- Joomla version -- : 3.8.10

When using the search module with the words "low table" on this page: antiqueswan.com/furniture

The search returns all kinds of products that do not have the term "low table" in their title or description. The search return is picking up on words that have "low" in their letters such as lower (see antiqueswan.com/furniture/130-large-engl...bookcase-of-mahogany ), and "table" within the word comfortable (see antiqueswan.com/furniture/136-french-leather-club-chairs )

What we were expecting in the results are items that have the words "low table" in their name or description, such as:
antiqueswan.com/furniture/363-french-rec...lar-low-table-of-oak
antiqueswan.com/furniture/369-italian-sq...smoked-glass-by-zevi
antiqueswan.com/furniture/370-large-fren...ass-and-smoked-glass

Can you help me understand how the search is configured and meant to work.

Is there a way to make it only return items that have the actual terms that a user is searching with?

Thanks,

Karen

Please Log in or Create an account to join the conversation.

  • Posts: 26004
  • Thank you received: 4004
  • MODERATOR
5 years 8 months ago #296416

Hello,

You're not using the search module but you're using an HikaShop filter.
Please provide a screenshot of that filter configuration.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 96
  • Thank you received: 6
  • Hikashop Business
5 years 8 months ago #296497

Hi Jerome,

I think this is what you are looking for: take.ms/trg0q

The filter was set to any word. I changed it to complete expression and that is working better. Low table returns the low tables.

However, using a search on the word "red" returns all kinds of products that have the letters red within the word, such as Upholstered. Is there a setting that can eliminate results that have partial letters in their words?

This is how the module is set: take.ms/Qgg3u

Thanks,

Karen

Last edit: 5 years 8 months ago by karendunne.

Please Log in or Create an account to join the conversation.

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
5 years 8 months ago #296512

Hi,

There is no setting for that.
I4ve looked a bit online, and there would be potentially some solution that could be implemented:
stackoverflow.com/questions/656951/searc...-word-match-in-mysql
But I don't really see how that would work with spaces in the search string. So I'm not even sure how it could be added properly.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum