• Resolved gerisoft

    (@gerisoft)


    Hi, we have a woocommerce store (using bookshop, child theme of storefront), and has 13.000 items in store, predicted about 20.000 items.

    We use fibosearch for the frontend, that search engine is perfect there.

    Problem is in the backend (admin) search, where the default search engine is searching in (at least) product ID, title, sku and content field. As of the products are books, the content field contains so many text, if we look for a book in admin, the results contains too many irrelevant items. For example “batman begins” search terms will contain all result of books where batman and begins words are there.

    I would like to exclude the search for content field, and I searched for hours on stackoverflow, tested dozens of solutions, and none of them working. WP6.2 all plugins and core is always up-to-date.

    How to modify the wp_query to exclude the column post_content from it?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi @gerisoft

    Thanks for reaching out!

    I understand that you are facing issues with the back-end search functionality in your WooCommerce store with a large number of products and you would like to exclude the search for content field, correct?

    Kindly be informed that this is the default behavior of the search function which includes the entire description, excerpt, title, SKU, etc.

    I did some research and found this comment on this bug report could be a good starting point.

    Hope this helps!

    Thread Starter gerisoft

    (@gerisoft)

    Thank you, the suggestion in bugreport helped

    Have a nice day!, Peter

    Roxy

    (@beautyofcode)

    Hi Peter,

    Glad to hear that the suggestion in the bug report helped with this!

    I will go ahead and mark this as resolved then. Feel free to create a new topic if you need further help 🙂

    Also, if you have a few minutes, we’d love it if you could leave us a review: 

    https://wordpress.org/support/plugin/woocommerce/reviews/

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Exclude product_content from backend search fields’ is closed to new replies.