Woocommerce Question posted in
The official Woocommerce documentation can be found here.

Woocommerce – How can I get only those categories which has products on sale?

I am trying to query woocommerce product categories but only those which have on sale products. Is there any possibilities? The result is hierarchy parent > child. I want to show both parent and its child. i.e. if child has product on sale print the parent category as well.

Here is the code I wrote so far

    <ul class="accordion list-group sub-catalog">
<?php  $terms = get_terms('product_cat', array( 'parent' => 0, 'exclude' => '15' ));
     if( $terms ): 
     $original_query = $wp_query;
     foreach ( $terms as $key => $term ):
     $child = get_terms(
              'product_cat',
               array(
                   'child_of' => $term->term_id,
                   'hide_empty' => true
               )
          );
        ?>
        <li class="accordion-card list-group-item">
                                        <div class="acc-card-title">
                                            <a href="<?php echo get_term_link($term); //echo $term->name; ?>"><?php echo $term->name; ?></a>
                         <?php if ( ! $child ){ ?>                              
<?php 
} else {
    ?>
    <span class="fa fa-plus"></span>
    <?php
}
?>
                                        </div>
          <ul class="accordion list-group sub-catalog">
          <?php
          $child_terms = get_terms(
              'product_cat',
               array(
                   'child_of' => $term->term_id,
                   'hide_empty' => true
               )
          );
          foreach ( $child_terms as $child_term  ) {
             $re_child_terms = get_terms(
                 'product_cat',
                 array(
                     'child_of' => $child_term->term_id,
                     'hide_empty' => true
                 )
             );
             if ( ! $re_child_terms ){
             ?>
                <li class="accordion-card list-group-item">
                                                <div class="acc-card-title">
                                                    <a href="<?php echo get_term_link($child_term);?>"> <?php echo $child_term->name; ?></a>
                                                </div>
                                            </li>
        <?php
        }
     }
     ?>
     </ul>
  </li>
<?php
endforeach;
$wp_query = null;
$wp_query = $original_query;
?>
</ul>
<?php endif; ?>

Thanks in advance.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
    <ul class="accordion list-group sub-catalog">
                                                                                <?php
        $args = array(
            'post_type'      => 'product',
            'posts_per_page' => -1,
            'orderby' => 'rand',
            'meta_query'     => array(
                    'relation' => 'OR',
                    array( // Simple products type
                        'key'           => '_sale_price',
                        'value'         => 0,
                        'compare'       => '>',
                        'type'          => 'numeric'
                    ),
                    array( // Variable products type
                        'key'           => '_min_variation_sale_price',
                        'value'         => 0,
                        'compare'       => '>',
                        'type'          => 'numeric'
                    )
                )
        );
        $loop = new WP_Query( $args );
        if ( $loop->have_posts() ) {
$terms = [];
            while ( $loop->have_posts() ) : $loop->the_post();

            $terms = array_diff($terms,wp_get_post_terms( get_the_id(), 'product_cat',['fields'=>'ids'] ) );
$term  = reset($terms);

            ?>
            <li class="accordion-card list-group-item">
                                        <div class="acc-card-title">
                                            <a href="<?php echo get_term_link($term);  ?>"><?php echo $term->name; ?></a>
                                        </div>
            </li>
                <?php

            endwhile;
        } else {
            echo __( '' );
        }
        wp_reset_postdata();
    ?>  </ul>

    this is how I get the on sale products and get their category name . where to use array_diff function


  2. 0

    The code below solved the problem.

    <ul class="accordion list-group sub-catalog">
                                                                                <?php
        $args = array(
            'post_type'      => 'product',
            'posts_per_page' => -1,
            'orderby' => 'rand',
            'meta_query'     => array(
                    'relation' => 'OR',
                    array( // Simple products type
                        'key'           => '_sale_price',
                        'value'         => 0,
                        'compare'       => '>',
                        'type'          => 'numeric'
                    ),
                    array( // Variable products type
                        'key'           => '_min_variation_sale_price',
                        'value'         => 0,
                        'compare'       => '>',
                        'type'          => 'numeric'
                    )
                )
        );
        $loop = new WP_Query( $args );
        if ( $loop->have_posts() ) {

$alreadyDisplayed = [];
            while ( $loop->have_posts() ) : $loop->the_post();


$term_list = wp_get_post_terms($post->ID, 'product_cat', array("all"));
foreach($term_list as $term_single) {
    if ( !in_array( $term_single->name, $alreadyDisplayed) ) {
        echo ' <li class="accordion-card list-group-item">
                                        <div class="acc-card-title"><a href="'.get_term_link($term_single).'" class="salecats">';
        echo $term_single->name;
        echo '</a><br></div>
            </li>';
        $alreadyDisplayed[] =  $term_single->name;
    }
}
            ?>
<?php

            endwhile;
        } else {
            echo __( '' );
        }
        wp_reset_postdata();
    ?>  </ul>
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search