Query for posts from any post type but only add instock products

You can check status instock only if meta key _stock_status exists.

Something like:

'meta_query' => array(
            array(
                'key' => '_stock_status',
                'value' => 'instock',
                'compare' => '=',
            ),
            'relation' => 'OR',
            array(
                'key' => '_stock_status',
                'value' => '',
                'compare' => 'NOT EXISTS'
            ),
        )

Note: Code is not tried or tested, so check for any syntax errors

Related Posts:

  1. Query all posts where a meta key does not exist
  2. Meta query with boolean true/false value
  3. Get post with multiple meta keys and value
  4. How Do I Use WP_Query to Run This Database Query as Search Result?
  5. Can’t sort order of wp_query with 2 meta keys
  6. Woocommerce query specific product from specific category
  7. WordPress Orderby Numeric Value Not Working
  8. orderby in custom WP Query does not work
  9. Display custom post type from dynamic custom field
  10. changing meta value and meta key of price field
  11. Woocommerce search pagination not working
  12. WordPress request fiter order by related post’s post_title
  13. Sort posts in loop by the WooCommerce Membership of the author
  14. Displaying a div from an assigned meta_value when on a page
  15. How to get specific post meta by title or id
  16. $post->post_meta not pulling any post in wordpress/php
  17. WP_Query of custom post type sorted by meta_key has unexpected results
  18. Returning a custom content types with meta values
  19. Get all post from a post type
  20. WP_Meta_Query object with conditionals
  21. How to retrive Custom Post Type Meta Fields in Custom WP_Query
  22. After inserting new post with wp_insert_post() the post is not visble to WP_Query, but the same WP_Query works for post inserted from wp-admin panel
  23. Use WP_query to match post types based on custom field values
  24. How to sort by multiple values in a nested WP_Query
  25. Custom meta fields not showing up in WP_Response Object via custom endpoint
  26. How to get post by meta value
  27. How do I get all authors posts of a custom post type outside loop
  28. add action save post type and update post meta woocommerce
  29. Linking posts together with Advanced Custom Fields “both ways”
  30. How to get Current week and current date record wp query
  31. How to get post meta for custom post type and taxonomy
  32. get_post_meta for Custom Post Type ( CPT )
  33. CPT or Custom Table for Repository of Serial Numbers
  34. Complex strcuture as CPT or taxonomy for use in woocommerce product variations [closed]
  35. WordPress custom post type
  36. Custom Post Type meta oembed html output resulting in WSoD
  37. Values inside a custom field to determine which category posts to display
  38. Querying meta values within an array
  39. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  40. Pre defined checkbox / radio button state based on value stored in ACF fields in checkout form WooCommerce
  41. I am having a problem with fetching product data in the Gutenberg block editor
  42. Quering a post object based on another related post object
  43. Combining sorted and random CPT
  44. How to add post_type=value when editing that post type in the WordPress admin?
  45. Insert Multiple Post with Same Publish Button
  46. Display CPT posts based on specific taxonomy
  47. how to get URL of media uploaded to WordPress via media_handle_sideload()
  48. Update CPT post meta with update_post_meta and cron job
  49. Can’t query tag and post_type at the same time
  50. Setting proper query for multiple custom admin filters
  51. Custom meta box data array: foreach not working correctly?
  52. Undefined Variable – Custom Post Type Meta
  53. shortcode to show custom post types by category
  54. Unable to retrieve any posts of CPT in wp-admin
  55. WP_Query: include custom post type only with specific meta value
  56. Pagination on a custom post type loop
  57. How to display product subcategories into my custom post type single page
  58. Ordering posts in Search & taxonomy by post_meta
  59. showing custom post types of a certain category only
  60. Insert post metadata for all posts in CPT at once if metadata no existent
  61. WP_Query orderby modified to include custom meta changes
  62. WordPress custom loop filter by meta_key and value with serialize data
  63. Returning a list of custom post types excluding those without a specific meta_value
  64. query private custom post type
  65. Query/list all terms and their custom post count
  66. Linking to the most recent post in a Custom Post Type
  67. Show the same Article Available in Other Categories
  68. how to delete all users and posts based on ‘user_meta’?
  69. How to make sure content doesn’t display if selection is empty
  70. Filtering WP_Query Dynamically on the Front-End
  71. Populate dropdown from one custom post type inside another custom post type
  72. Show one item per category of a custom post type
  73. Why get_posts() not returning only selected category posts from Custom Post Type?
  74. Storing posts from query and accessing later via AJAX call
  75. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  76. Meta Key Value in current-user-only loop
  77. Archive for custom taxonomy lists all posts instead of current taxonomy
  78. Genesis filterable portfolio isotope [closed]
  79. Get post from custom post type order by two taxonomies
  80. Query custom post type with tags
  81. How to check if user meta field is empty in conditional else statement
  82. wp_query check if integer exists in custom field’s array
  83. How to set YouTube video as featured image?
  84. convert custom query to wp_query
  85. Wrong request query on cpt and tax
  86. Notice: Undefined index: error and understanding wordpress
  87. Previous/Next Link by Meta Value in CPT
  88. Show custom post type filtered by category
  89. Randomize Posts. Skip the first post in ascending order
  90. Creating a navigation menu of all posts of a custom post type and their children posts?
  91. Get custom taxonomies from multiple posts
  92. Custom Post Types. Are there any disadvantages/advantages in using a plugin to develop them?
  93. Pagination for Custom Taxonomy Page [duplicate]
  94. Filtering WP_Query
  95. Get posts between custom dates
  96. Search / Filter posts on Title/Content OR Tags
  97. Pagination on with query_posts in custom post type template
  98. Wp_query: sort by PHP variable
  99. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  100. Custom-Posttype & Custom Taxonomy WP_Query

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)