woocommerce variation relevancy

Home Forums Product Support Forums Ajax Search Pro for WordPress Support woocommerce variation relevancy

This topic contains 4 replies, has 2 voices, and was last updated by

 
Keymaster
2 years, 4 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #24003

    Participant

    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

    Attachments:
    You must be logged in to view attached files.
    #24005

    Participant

    screen grabs

    • This reply was modified 2 years, 4 months ago by  Rawww17.
    Attachments:
    You must be logged in to view attached files.
    #24010

    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.

    Best,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


    #24011

    Participant

    Brilliant, thanks for the explanation, Ernest.

    #24012
    You cannot access this content. Best,
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)


Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.