Woocommerce, get products by category with wp query

Question

I tried many methods, but I can't show products with category name or id

                  $args = array(
                       'post_type'             => 'product',
                       'post_status'           => 'publish',
                       'ignore_sticky_posts'   => 1,
                       'cat'                   => 40,
                       'posts_per_page'        => '12',
                   );

                  $loop = new WP_Query( $args );

score 9 · Accepted Answer · answered Dec 05 '17 at 09:35

Try this example,

So given a category with ID 26, the following code would return it's products (WooCommerce 3+):

 $args = array(
    'post_type'             => 'product',
    'post_status'           => 'publish',
    'ignore_sticky_posts'   => 1,
    'posts_per_page'        => '12',
    'tax_query'             => array(
        array(
            'taxonomy'      => 'product_cat',
            'field' => 'term_id', //This is optional, as it defaults to 'term_id'
            'terms'         => 26,
            'operator'      => 'IN' // Possible values are 'IN', 'NOT IN', 'AND'.
        ),
        array(
            'taxonomy'      => 'product_visibility',
            'field'         => 'slug',
            'terms'         => 'exclude-from-catalog', // Possibly 'exclude-from-search' too
            'operator'      => 'NOT IN'
        )
    )
);
$products = new WP_Query($args);
var_dump($products);

dipak_pusti · Answer 2 · 2020-07-09T04:48:58.050

2

Try tax_query

$args = array(
   'post_type'             => 'product',
   'post_status'           => 'publish',
   'ignore_sticky_posts'   => 1,
   'posts_per_page'        => '12',
   'tax_query'             => array(
        array(
            'taxonomy'  => 'product_cat',
            'field'     => 'term_id',
            'terms'     => array('40'),
            'operator'  => 'IN',
        )
   )
);

$loop = new WP_Query( $args );

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

edited Jul 09 '20 at 04:48

answered Dec 05 '17 at 09:23

dipak_pusti

1,645
2
23
42

1

Use ```product_cat``` instead of ```product_category``` – Joci93 Jun 30 '20 at 07:53

score 0 · Answer 3 · answered Dec 05 '17 at 09:32

0

Try this,

<?php
  $args     = array( 'post_type' => 'product', 'post_status' => 'publish','category' => 34, 'ignore_sticky_posts' => 1, 'posts_per_page' => '12',);
  $products = get_posts( $args ); 
?>

Hope this will helps you. for more info.

answered Dec 05 '17 at 09:32

Sunil Dora

1,407
1
13
26

score -1 · Answer 4 · answered Dec 05 '17 at 09:59

-1

I suggest used >> wc_get_product_terms( $vars->ID, 'pa_brand_category' )

please check this screenshot >> http://prntscr.com/hjawu5

answered Dec 05 '17 at 09:59

felix manzanas

119
6

Woocommerce, get products by category with wp query

4 Answers4