How to query only for products with status “in stock” in WooCommerce? [closed]

That worked great!

Just added this:

        'meta_query' => array(
        array(
            'key' => '_stock_status',
            'value' => 'instock',
            'compare' => '=',
        )
    )

Thanks!

Related Posts:

  1. Cluster WooCommerce products in each Category Archive by Tags assigned to products
  2. WP_Query Taxonomy categories filtering
  3. Hide products in uncategorized category from search results
  4. How to echo woocommerce category name
  5. What code to use in an array to call the current sub-category?
  6. Get categories within specific term
  7. Exclude or Include category ids in WP_Query
  8. WP_Query: Exclude hidden products from WooCommerce product list
  9. WP_Query to show post from a category OR custom field
  10. Display recent posts from the same category as current post in sidebar
  11. Changing a theme’s search function to only show results from woocommerce?
  12. Counting number of posts with Category B in Category A
  13. Use Transient API to cache queries for all posts in all categories?
  14. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  15. Retrieve products with specific attribute and in category – woocommerce
  16. How to combine tax_query and date_query in WordPress
  17. how to retrieve specific product attribute value in an sql query?
  18. Display featured products through custom loop in WooCommerce 3 [closed]
  19. wp_query display posts from same category of the post
  20. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  21. get complex results set according to category structure
  22. Get product list of given category
  23. How to exclude products by tag from woocommerce shop page?
  24. How to select posts from one category but exclude posts in another category?
  25. WooCommerce Only OnSale Products Loop Snippet [closed]
  26. How can you get first post, last post and post count in a category?
  27. How to get the WC_Product Object when using a WP_Query in WooCommerce
  28. merge two query arguments into one WP_Query call
  29. Woocommerce returns Product post_status as published even tho it is in status draft
  30. List of the years with posts presented
  31. Take all produts by category
  32. How to get all product attributes for filters in WooCommerce?
  33. Category applied to pages, creates multiple breadcrumb entries after a search query (On the translated site)
  34. Can we return all category (not post) with Custom Query Filter? [closed]
  35. Extend product search with meta in WooCommerce
  36. Query posts from category A, and from either category B or C
  37. Woocommerce – Changing the order of the upsell products [closed]
  38. Combining categories (Query posts with multiple taxonomy terms)
  39. Filtering out child category posts from parent category archive not working
  40. Exclude Category filter from Portfolio section
  41. Redirect to another page using contact form 7? [closed]
  42. Limiting number of related posts
  43. Category ‘pad_counts’ & ‘parent’ conflict
  44. Woocommerce – exclude only older out-of-stock items
  45. How to query woocommerce product by pricing? [closed]
  46. Include posts from some categories while excluding from others
  47. How to order WP_Query to group results?
  48. Redirect Search to Form When No Product Results Are Found
  49. Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
  50. How to load a script code only in posts?
  51. Woocommerce: order posts by meta key
  52. Slider won’t work with custom query
  53. WP_Query with one category in args shows other categories
  54. How order posts from category by date and comment count?
  55. WP_Query for products always returns empty
  56. Get the child category ID of current category
  57. Related Posts Excluding Certain Categories
  58. Unlimited Page Sitemap Link
  59. Filter sub-category from checkbox form
  60. `offset` WP_Query argument dont work via `pre_get_posts`
  61. Use get_cat_ID to retreive multiple category IDs
  62. Function the_posts_pagination() not compatible with WP_Query arguments
  63. adding pagination to a foreach loop in wordpress
  64. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  65. ElasticPress is (aparently) messing with my search filters
  66. Woocommerce Get Orders By Meta Value
  67. Save large WP_Query to transient === false
  68. 3 posts from each existing category on one page
  69. Custom Woocommerce Product Query
  70. How to display the category dropdown auto search list when key press?
  71. How to show specify category template for both parent and child category
  72. How to display Woocommerce products list by tag
  73. Exclude parent categories from recent posts list
  74. Woocommerce featured products query no longer working
  75. Ajax buttons not working properly in WooCommerce when using wc_get_template_part
  76. Check the product in the cart from which category is and show message
  77. WP_Query showing all posts, except from category X, unless it’s also in Y
  78. Not able to fetch woocommerce variation sales products for particular category products
  79. Multiple values in WP_Query : category__and
  80. How to exclude posts by ID within a category/archive loop
  81. I have 3 categories, i want to display on a loop the last 3 of every category
  82. Get posts with any value in attribute
  83. Adding Category in WP_Query Not Working
  84. WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
  85. Making Woocommerce optimized for more than 500k products
  86. display all posts from category with and without terms in chronological order
  87. Pull posts from all categories if quantity is not met?
  88. Category Archive not working for pages
  89. Using the same WP_Query for shop and widgets in WooCommerce shop
  90. Retrieving category pages from subcategory returns empty sets
  91. Display Count of posts
  92. Display post list within category list sorted by name [duplicate]
  93. query_posts problem – need help
  94. Adding arguments to WooCommerce Product Loop using AJAX
  95. Main loop querying current template’s info only in custom category archive pages, not my posts
  96. Filtering product search results using tags
  97. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  98. I need to get all categories from a WP_Query
  99. How to get post taxonomy url and name in wp_query
  100. WP_Query (or WC_Product_Query) out of memory

Leave a Comment