WP Query – Get WooCommerce Products with variation that is in stock

You will have to change your tax_query. The xs is not the term_id but the slug

So your tax_query will end up being like

'tax_query' => array(
    array(
       'taxonomy' => 'pa_sizes',
       'field' => 'slug',
       'terms' => 'xs'
    )
 )

I would love to help with the “instock” problem too, but I’m stuck with that question too.

Related Posts:

  1. Query WooCommerce orders where meta data does not exist
  2. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  3. Extending woocommerce admin product search
  4. Extend product search with meta in WooCommerce
  5. Multiple meta_key ordering with pre_get_posts
  6. How to echo woocommerce category name
  7. ElasticPress is (aparently) messing with my search filters
  8. Woocommerce Get Orders By Meta Value
  9. WooCommerce WP_Query using tax_query returns no results (0 = 1)
  10. compare meta_query in get_posts arguments
  11. Display products from specific category in shop page
  12. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  13. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  14. Query by meta_key and order by meta_value_num return orderby date
  15. Wp_query order by multiple custom fields?
  16. WordPress altering my custom query, How to fix it?
  17. Order by meta_key in custom post type doesn’t affect the query
  18. How to create/modfiy WP_Query to search in post title OR custom field?
  19. Display featured products through custom loop in WooCommerce 3 [closed]
  20. Advanced WP Query hogs the SQL server
  21. How to get user_id from wordpress database inside ajax function?
  22. Meta query with order by another custom field
  23. WP_Query with multiple meta fields filter?
  24. How to combine meta_query and post__in in WP_Query
  25. How to orderby meta_value_num with dollar ($) sign
  26. Output an array of terms for a ‘tax_query’ => array()
  27. Meta Query Array Error 500
  28. showing all search result in one template
  29. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  30. Take all produts by category
  31. How to get all product attributes for filters in WooCommerce?
  32. Fetch Record based on meta key dates
  33. Suggestions on making this query/code more performant
  34. WP Query Args – Title or Taxonomy Value
  35. Large AND OR query timing out
  36. meta_query not working as expected
  37. Slow WP_Query with ‘OR’ on meta_query
  38. How to filter a query by multiple meta keys and order by other meta keys
  39. Redirect to another page using contact form 7? [closed]
  40. Query posts with “non set” meta value
  41. Custom taxonomy.php not working
  42. Ordering a mysql style datetime stamp with meta_query
  43. Wp_query with 2 meta keys and array of meta values
  44. Advanced WP_Query with meta_query, orderby?
  45. meta_query: check if number exists
  46. How to order WP_Query to group results?
  47. Event with multiple dates, display events chronologically
  48. Get Child Category only
  49. WP_Query Taxonomy categories filtering
  50. Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
  51. WP_Query: apply an SQL function to meta fileld value
  52. Assign a minimum result count for WooCommerce query shortcodes?
  53. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  54. How to create dynamic value in WP_Query meta_query
  55. WP Query / Meta Query [duplicate]
  56. Query posts by searching for a string in a meta field
  57. $wp_query->found_posts not returning correct value
  58. Can’t get term id for category archive
  59. How to make a post with certain taxonomy term display first before other post with only one query?
  60. Query multiple post types, but different order for each
  61. How to add date_query to meta_query array
  62. Order by the first array within a meta_query
  63. Query ACF relationship field – Comparator IN – Value array
  64. Use get_cat_ID to retreive multiple category IDs
  65. Combine query in WP_User_Query()
  66. Multiple nested meta queries
  67. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  68. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  69. How can I modify the query by adding to the existing query?
  70. Meta query ignores multiple values of the key
  71. WordPress Query custom ordering by temporary variable
  72. Check for not NULL not working in meta query
  73. Comparing Meta Field date in WPQuery using Meta_Query?
  74. What code to use in an array to call the current sub-category?
  75. Get categories within specific term
  76. WP_Query paginate with one term per page?
  77. How to create better WP_Query to look for date time which is anywhere between two meta values?
  78. Query against multiple locations within single custom post type post
  79. Filtering WP_Query based on wp_postmeta keys values
  80. Complex Meta Query
  81. Not able to fetch woocommerce variation sales products for particular category products
  82. Multiple meta_query not working
  83. compare for multiple meta values for same key in wp_query
  84. datetime picker, timestamps and meta queries
  85. WP_Query with meta_query won’t orderby
  86. meta_query only check if both value are set
  87. Taxonomy Terms That Don’t Exist Display Results
  88. Woocommerce WP_Query post__not_in problem
  89. WP Query with sticky posts and tax_query
  90. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  91. Using custom field as ‘orderby’ value causing post grouping by publish date
  92. Looking for a way to exclude frontpage and nav menu from query filter
  93. Creating Custom Query
  94. tax_query not working properly with get_posts
  95. Get posts by meta value except one post [closed]
  96. WP_Query by meta key not returning any posts
  97. How to get all post_id and meta_value using meta_key in wp_postmeta table
  98. WP Query – Show custom posts only if user contain some user meta
  99. How do I subquery with custom meta fields?
  100. How can I get taxonomy term name using term slug & post ID using build in WordPress function or class?