WooCommerce product search titles only

This is an 9 months question, but since I had the same issue and found a solution, I came here to post it.

On file wp-content/plugins/woocommerce/classes/class-wc-query.php, function pre_get_posts( $q ), WooCommerce defines at line 114:

add_filter( 'posts_where', array( $this, 'search_post_excerpt' ) );

This is the point when WooCommerce mess up your query!

The function search_post_excerpt is defined right down, at line 132, and you can see he adds excerpt to the search query.

So you have 2 solutions:

The bad one, is comment the line 114!

//add_filter( 'posts_where', array( $this, 'search_post_excerpt' ) );

The good one, I didn’t implement myself, but should be something like add a filter on posts_where that runs after WooCommerce and fix it. Or maybe remove the filter.

I’ll search better for the good solution, and I promisse I’ll post it here. But the bad solution do the job pretty well.

Related Posts:

  1. Media library – Limit images to custom post type
  2. Sort search results by post type
  3. Development of a WordPress Search Plugin – Best Practices
  4. echo value from ‘select’ field type into page template using cmb2?
  5. post_type_link filter causes 404 on the CPT page it’s used on
  6. Search everything (posts, pages, tags, cpt, meta)
  7. Include images from pages in wp search.php results in default wp search
  8. Separating Search Results By Post Type
  9. Used with meta_query in query_posts works slowly
  10. How to get Custom Post ID by adding filter to child theme’s function
  11. How to add the post ID (or any other post data) to a Contact Form 7 mail?
  12. GravityForm: Populate Dropdown with custom post type [closed]
  13. Filter categories of posts with checkboxes
  14. I did group my search results by post type, but how can i give each of them its own order?
  15. custom post type not showing in menu
  16. filter custom post type by meta key in dashboard
  17. WordPress sort search results by custom order
  18. search suggest – filter post type
  19. How to change permalink to include custom post type
  20. Search filter triggered & sort by custom post type
  21. Redirect to another page using contact form 7? [closed]
  22. ACF in wordpress
  23. Prevent A Specific Custom Post Type Showing In WP Search Results Page
  24. Custom post type’s posts are not showing anywere but in xml sitemap
  25. Custom post type in Custom widget – $listItem
  26. Send post changes to set email addresses (not users or subscribers)
  27. Modifying search results based on post_type
  28. Insert custom taxonomy into category query
  29. Include images from pages in wp search.php results in default wp search
  30. Post that populates itself (almost) automatically using data from imported excel file
  31. Enable shortcodes on custom post type
  32. Custom Search Template for Custom Post Types
  33. Diffrent search templates for different post types
  34. making a glossary with wordpress
  35. add_filter > posts_where works partially
  36. Simple Share Buttons Add Plugin and Custom Post Type
  37. Post the content of a specific “Custom Post Type” post within a post using a shortcode
  38. multiple search forms and search results
  39. Filter home_url for custom post type
  40. error in Advanced Search Form for Custom Post Types in WordPress array_key_exists() expects parameter 2to be array, string given
  41. Need functionality with all post list available at edit.php
  42. Add Content Exclusively to a Custom Post Type Feed
  43. Custom Taxonomy breaking pages permalinks
  44. Hide Meta Boxes for Non-Admins
  45. How do I set the link in the Custom Post Type admin menu?
  46. Search Custom Post Type Custom Fields
  47. Custom Post Type not appearing in website search
  48. Filter custom post type archive page with custom taxonomies (categories) with AJAX
  49. Issue to get wp_get_attachment_image with cmb2
  50. How to have the right design for a custom post type without accessing themes
  51. How to filter out post type meta?
  52. Best action hook to create custom post and assign taxonomy terms to it on plugin activation?
  53. Custom Fields vs Separate Table
  54. Remove default post types on all sites except primary blog. WPMU
  55. Add custom post type archives to search results?
  56. CPT Meta Searching
  57. CPT Search Form with Taxonomy filter & Or
  58. How to change the admin menu “Pages” to something else
  59. Loop through posts of a custom-post-type (event) and create .ics (iCal) file?
  60. Apply post formats to a specific post type only?
  61. How would I create a shortcode to display a custom post within a page or regular post?
  62. Custom Post Type | Fatal Error on register_post_type()
  63. Output custom post shortcode. Help spot the error.
  64. When ‘is_post_type_archive()’ return true?
  65. How to check if “is single” page
  66. Set object terms not working on plugin activation
  67. Keyword search limited to specific post type filtered by multiple custom taxonomies?
  68. Override plugin with functions.php
  69. How To Enable Block Editor (Gutenberg) for Existing Post Type via functions.php
  70. How to filter search results by post type?
  71. How to create an advanced filter search?
  72. Make a function to run only for CPTs
  73. WP Job Manager Category Drop-down; Change Placeholder Text Via Filter
  74. Custom search for custom post meta with pre_get_posts interferes with WP search
  75. How to search map address in custom post type?
  76. Modifying date filter on admin page for custom post type to link to custom field
  77. how to add extra meta box or textarea into custom post types
  78. Loading all files within a directory
  79. Add html to cpt main page / admin edit.php
  80. How to apply filter at search of woocommerce products?
  81. Modifying Custom Post Type after registration (will it affect content?)
  82. Custom Post Types relationships
  83. Custom Taxonomy Tag Search
  84. register_taxonomy and register_post_type does not work [closed]
  85. Custom search results page query, link permalink to post title while separating by post types
  86. How to retrieve category NAME instead of ID in a function with a taxonomy custom field?
  87. Create a post in custom post type using field in registration form after users submit form
  88. Pre_get_posts filter overwrites all search functionality
  89. “add_post_type_support” with Custom Post Type & ACF
  90. A good strategy to print custom posts (offer) that are checked inside the metabox of a post?
  91. Shortcode insertion in tab
  92. Custom Search for Drafts in Custom Post Type
  93. Copy custom field value to post title
  94. Can’t get order_by meta_value_num to work properly
  95. How to quickly reorder posts in the admin panel that will persist for the wp-api
  96. Pass info from functions.php to plugin
  97. Add CPT as subpage under custom page
  98. Insert HTML inside link in a walker
  99. right_now_content_table_end function not working?
  100. check if post title in a custom post type exists in page
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)