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. How come Featured Image isn’t showing up in my Custom Post Type?
  38. Search that will look in custom field, post title and post content
  39. clients list using wordpress
  40. How to replicate some of Drupal Views functionality in WordPress?
  41. Seperating Custom Post Search Results
  42. Date archives for custom post type
  43. How can I add dropdown widget/box to admin post page?
  44. Debug output during filter execution doesn’t work
  45. No results searching custom post type in admin panel
  46. Display only custom post type count for current author on the “At a Glance” dashboard widget
  47. Building an Advanced Search (text, tags, category, custom fields) – Getting the wrong SQL query
  48. error in Advanced Search Form for Custom Post Types in WordPress array_key_exists() expects parameter 2to be array, string given
  49. Custom Taxonomy breaking pages permalinks
  50. Custom Post Type | Fatal Error on register_post_type()
  51. Update menu when saving settings
  52. Append date to custom post type url slug
  53. Change custom post type slug from plugin options
  54. How can I made custom taxonomies relationship?
  55. WooCommerce sort products by the actual product width(not the shipping width)
  56. Tracking changes in admin-page so user gets warning when leaving the page
  57. How to Add multiple instance of meta box to custom post type
  58. Create new custom post and post category of same name
  59. Check if variable is set in filter
  60. PHP question: how to combine syntax?
  61. Passing stored variables to add_filter
  62. post_parent in custom post type
  63. Add custom attributes to a post
  64. Custom Taxonomy Search result page
  65. How do I add custom HTML to the content of an archive page’s posts?
  66. Only show posts with a specific term of an associated taxonomy in a custom post type archive
  67. Get image from external URL
  68. Getting only one post per category
  69. Update Post Status On Woocommerce Payment Complete
  70. Modify Posts from Custom_Post_Type within the plugin
  71. Filtering the_content, but still need to display the unfiltered content inside filter
  72. Custom meta box in custom post type not working
  73. Function to add custom HTML into head in custom post-type list page
  74. Need help with Custom Post Types and Taxonomies
  75. How to Implement Search Functionality?
  76. custom filtering admin columns
  77. Query filter by value in meta_value array
  78. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  79. Unpublished Pages Failing To Appear On Custom Path
  80. How to add specific terms in a custom post type?
  81. Limit custom post type to the authors only on front-end!
  82. Post Click Redirect to Custom URL instead of Single Post Page
  83. Plugin function in child theme
  84. Reading Custom Post data so I can have user update Manually
  85. Disable ‘Add New’ in custom post that is made from CPT UI
  86. Work and Display a Custom Post Type as a normal Post
  87. Custom Field to post_title
  88. Post Custom & Taxonomy 404 error
  89. How To Display Category list from Portfolio post type plugin?
  90. Adding CPT changes entire layout of my site except for the archive of that CPT
  91. Create 2-layered dropdown menus for custom taxonomy and custom post type
  92. Search form to find custom meta box generated data
  93. multiple custom post type category selection search
  94. Search box background on a different page template
  95. Allow authors to create article image
  96. Customising wordpress search and using $_GET[“s”]
  97. Remove plugin’s custom post type archive page and single pages [closed]
  98. Rewrite a filter as shortcode (or something like that) to use anywhere in CPT
  99. How to delete unnecessary custom post types in the UI
  100. Group search results by post type, but having a unique heading for each section?