- September 17, 2019 at 12:48 pm #24003
I’m sending this again as I am not clear that my previous submission came through.
401 auth access is rawww / electric29
My client has woocommerce products with the following SKU’s
Search term ‘PB630’ turns up all variation results above
However They want search term ‘630’ to turn up all variation results also.
Search term ‘630’ only turns up product PB630.
Attached is the code of my settings, is there anything we can tweak for this behaviour to work?
Attachments:You must be logged in to view attached files.September 17, 2019 at 12:49 pm #24005September 17, 2019 at 12:58 pm #24010
The problem is, that the index table engine is used, which does not support mid-word matches. Mid-word random matching triggers the non-indexed queries in MySQL as well as MariaDB (it’s a limitation of the database engines, not the plugin), thus the only way to make this work is to use the regular engine instead.Best,
If you like my products, don't forget to rate them on codecanyon :)
September 17, 2019 at 1:35 pm #24011
Brilliant, thanks for the explanation, Ernest.September 17, 2019 at 1:37 pm #24012
You must be logged in to reply to this topic.