woocommerce variation relevancy

[Rawww17]

I’m sending this again as I am not clear that my previous submission came through.

https://woocommerce-95173-726718.cloudwaysapps.com/

401 auth access is rawww / electric29

My client has woocommerce products with the following SKU’s

PB630
PB630a
PB630b

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?

Regards

[Rawww17]

screen grabs

• This reply was modified 6 years, 8 months ago by Rawww17.

[Ernest Marcinko]

Hi,

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.

[Rawww17]

Brilliant, thanks for the explanation, Ernest.

[Ernest Marcinko]

You cannot access this content.

[Author]

Posts