Get all products which have both product category

Set include_children to false in the tax_query.

$args = array(
'post_type' => array( 'product', 'product_variation' ),

'tax_query' => array(
    array(
        'taxonomy'         => 'product_cat',
        'field'            => 'slug',
        'terms'            => array( 'shop', 'cat1' ),
        'include_children' => false,
        'operator'         => 'AND',
    )
)

);

See https://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters

Related Posts:

  1. Query WooCommerce orders where meta data does not exist
  2. WP_Query for WooCommerce Products
  3. how to retrieve specific product attribute value in an sql query?
  4. merge two query arguments into one WP_Query call
  5. Woocommerce Get Orders By Meta Value
  6. Create global array to compare inside a query
  7. Using the same WP_Query for shop and widgets in WooCommerce shop
  8. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  9. Wp get all the sub pages of the parent using wp query
  10. Usage of the new “posts_clauses” filter in WordPress 3.1?
  11. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  12. How to uniquely identify queries?
  13. Get posts by meta data OR title
  14. WP_Query ordered by custom field that is a date string?
  15. How to make an activities stream mixing posts and comments?
  16. Duplicate Queries
  17. How to query for a week using key => value WP_Query argument notation?
  18. SQL query equivalent to WP User Query
  19. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  20. How to count post type that has a particular term?
  21. Retrieve products with specific attribute and in category – woocommerce
  22. Foreach-generated custom tax queries, each with an ajax “Load more” button
  23. Display featured products through custom loop in WooCommerce 3 [closed]
  24. meta_query on a date range using an array of values
  25. WP_Query Performance Issues with meta_query
  26. How to detect custom query inside `posts_where` hook?
  27. Is temporarily overwriting $wp_query a bad idea?
  28. Query Set Order By Author
  29. Get product list of given category
  30. How to exclude products by tag from woocommerce shop page?
  31. How to output different posts per page?
  32. WooCommerce Only OnSale Products Loop Snippet [closed]
  33. Pass array of taxonomy terms to wp_query
  34. How to orderby meta_value_num with dollar ($) sign
  35. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  36. Query: offset post list, unless it’s a specific category
  37. How to reduce the number of queries?
  38. List of the years with posts presented
  39. Sort query by author: 1 author, then others
  40. Custom Query num_rows returns wrong amount
  41. Overwrite YoastSEO meta-tags with another page’s [closed]
  42. Take all produts by category
  43. How to orderby multiple meta fields if some fields are empty
  44. How to get all product attributes for filters in WooCommerce?
  45. How to duplicate 5 posts out of WP_Query results?
  46. WP_query sorting can’t sort danish letters (æ, ø, å)
  47. Slow queries on a huge database
  48. WP_Query with ‘rand’, but equal number of posts from the taxonomy terms given
  49. Multisite pagination issue by multi query archive 404
  50. Query with relation and one without relation using multiple taxonomies?
  51. Sort WordPress Posts Meta value by Week not Day
  52. 2 wordpress loops showing 1 post from same post type – how to avoid showing the same post?
  53. Transient api Caches confused
  54. How can I override one post and make it display content for another post?
  55. Get multiple users with meta value in one query and populate WP_User class
  56. How to order WP_Query to group results?
  57. Redirect Search to Form When No Product Results Are Found
  58. How to display SQL query that ran in WC_Order_Query?
  59. WP_Query Taxonomy categories filtering
  60. Query where ANDing slug values not working
  61. Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
  62. How to filter query loop block with a search string from the query parameters
  63. Assign a minimum result count for WooCommerce query shortcodes?
  64. Woocommerce: order posts by meta key
  65. Unlimited Page Sitemap Link
  66. How to SQL query posts IDs by categories AND authors?
  67. $wp_query->found_posts not returning correct value
  68. Post incorrectly excluded when using “category__in”?
  69. Query multiple post types, but different order for each
  70. Display posts ONLY from the current logged in user and current week/year/month Elementor posts
  71. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  72. ElasticPress is (aparently) messing with my search filters
  73. Any way to use FETCH_KEY_PAIR with $wpdb?
  74. What code to use in an array to call the current sub-category?
  75. Get categories within specific term
  76. Query against multiple locations within single custom post type post
  77. How to get_comments() ordered by date and parent?
  78. WP Query. Ordering posts by another post types meta
  79. Woocomerce – Order products by float attribute in archive pages
  80. Not able to fetch woocommerce variation sales products for particular category products
  81. How to make a search query if not found in post table then search in postmeta table?
  82. Adding Category in WP_Query Not Working
  83. WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
  84. Merge two queries and remove duplicate
  85. Woocommerce WP_Query post__not_in problem
  86. how to show more than 1 post into three columns query
  87. How can I get all the posts that are related with a specific taxonomy term?
  88. Fetch only categorized posts
  89. Custom pagination (Title, date and teaser)
  90. Pagination in custom query in a category page
  91. Get a list of the last posts grouped by author and filtered by category
  92. When should you use WP_Query vs query_posts() vs get_posts()?
  93. How to query post ids liked by the Author
  94. Modify query after meta value
  95. Showing posts from 4 categories along with all latest posts
  96. Pagination in WP query with transient API
  97. Main loop querying current template’s info only in custom category archive pages, not my posts
  98. Use meta query only 3 or more results?
  99. Search results stuck on page 1
  100. Use value from meta key array for use in WP_Query