Search results don’t show products

You have in your query WHERE p.post_type IN ('post', 'page'), that is why it shows only the posts and pages. Add post type product to query:
WHERE p.post_type IN ('post', 'page', 'product')

Related Posts:

  1. How to search Woo Commerce products with punctuation in title?
  2. Woocommerce wp-admin search products through custom meta value too
  3. if statement for search results
  4. Separeting product from post in search result
  5. Woocommerce custom search
  6. Change the Title Tag of Search Products Page
  7. WooCommerce orderby template disappears and not longer works on search page
  8. search customers in front end by billing data
  9. Create a shortcode for native WooCommerce search form [closed]
  10. Can’t find a product by SKU
  11. Absolute search against wordpress api
  12. override the default WooCommerce products search form
  13. Create a Search Form that only Searches with WooCommerce Sale Products
  14. Call product search from custom hook
  15. Search doesn’t return anything
  16. edit URL of search result
  17. No Results in WooCommerce Product Search
  18. Woocommerce Multisite global search how to mod ajax function?
  19. I wan redirect link post search to search product woocommerce?
  20. How to filter result set in custom metaboxes?
  21. Woocommerce: Search by custom attribute
  22. Notice: Trying to get property of non-object in
  23. How can I change my search form to bring up product results, not blog results
  24. Is it possible to hide certain products from displaying in the search results
  25. Woocommerce ajax search can’t work on mobile
  26. wc_get_template_part( ‘content’, ‘product’ ) | Where is this file located?
  27. how to get woocommerce product attribute slug
  28. How to build a plugin that supports authenticated POST requests to the REST API from external servers?
  29. New endpoint in my account gives 404 Error Woocommerce 3.6.5 and WP 5.2.2
  30. Username field is not shown in Woocommerce’s registration contact form
  31. Woocommerce Membership Expiry Date
  32. How to echo billing phone number under My Account in Woocommerce? [closed]
  33. Unknow php file in wordpress core [closed]
  34. Woocommerce SKU on ALL products page [closed]
  35. Stop WooCommerce from updating user/user meta after checkout
  36. Redirect user to cart page when add to cart button is clicked
  37. Woo API REST : product variation price is read-only?
  38. Get rid of product images mobile swipe functionality from WooCommerce single product [closed]
  39. Problems with varibel price [closed]
  40. Custom Admin Email Subject for Woocommerce (3.8.0) Orders
  41. Woocommerce custom endpoints
  42. How to override Woocommerce functionality in Reports section?
  43. how can use woocommerce add to cart popup?
  44. Do I need a different product type for WooCommerce [closed]
  45. How to change product thumbnail size in storefront theme
  46. Override static method in WC_Shortcodes class (shortcode) [closed]
  47. Show add to cart button and quantity field when no price is entered [closed]
  48. Results not being printed
  49. Remove ‘product’ & ‘product-cateogory’ from url – woocommerce [closed]
  50. Why is my WordPress login credentials missing, but work with WooCommerce?
  51. Update Customer JWT Woocommerce
  52. Is there a hook in woocommerce for when a payment fails to display a custom error message?
  53. How to show notice alert only on product dashboard page?
  54. Retrieving Tag Name in Template Part from Filtered URL
  55. ajax request in wordpress
  56. separate functions for home VS other pages
  57. WooCommerce apply shipping rates based on price
  58. Extra items added to cart on refresh, woocommerce
  59. How disable some product features on woocomerce?
  60. Woocommerce purchase date [closed]
  61. How to add a special Woocommerce “buy now” button?
  62. Woocommerce: Any way to list all products *without* a specific attribute?
  63. Filter by Price filter button not working
  64. porto theme pagination on woocommerce not working
  65. How can I show “sold out” instead of “out of stock” for some products with particular tags and categories [closed]
  66. Assign user role by text field in WordPress (Woocommerce) [closed]
  67. Urgent Validate Save-Post Hooks on Woo-commerce product entry form!
  68. Is doing a database query in Woocommerce efficient to only display posts from a certain category?
  69. How to get cookie value?
  70. My products are showing “not in stock” and I don’t know why
  71. Woocommerce change the price of products in the database
  72. Woocommerce modifying the html on the checkout page?
  73. Pseudo class :before don’t working in a specific button
  74. How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
  75. “error_message”: “Sorry, you cannot list resources.” using WooCommerce API
  76. WooCommerce product details page category display
  77. Woocommerce – Default product image by user role
  78. WooCommerce product id as permalink
  79. WooCommerce does not translate every string
  80. Woocommerce add a text field if specific option is selected
  81. Add suffix to price html does not work
  82. Get user active posts randomly
  83. SyntaxError: unterminated string literal – if WordPress Debug in wp-config is set to true
  84. How Fragile Is DB if I Upload Completely Updated Files
  85. Broken 302 redirection for product subcategory (Woocommerce, Apache)
  86. Website Tablet Check Out Field Issue
  87. WooCommerce order created via REST – sending the date_created along
  88. How to allow registration only from a certain location?
  89. Add confirmation popup on place order button
  90. Get Third Level Categories WooCommerce
  91. Change WooCommerce Checkout Button – Reverts to normal
  92. Show pop up message for specific categoryies
  93. How to search for categories instead of products in Woocommerce?
  94. How to remove content from hacked pages? [closed]
  95. Disable WooCommerce Address State Dropdown
  96. How to show detailed order history on woocommerce product page [closed]
  97. How to dublicate WC Product title to shortdescription field? [closed]
  98. Add Additional 3 buttons next to “Add to cart” button in woocommerce product page
  99. Woocommerce product and category in url [closed]
  100. Display product categories + child-categories on a single product page

Leave a Comment