Categories with price range

categories-with-price-range.php

$cat_args = array(
    'orderby'    => 'name',
    'order'      => 'asc',
    'hide_empty' => false,
);

$product_categories = get_terms( 'product_cat', $cat_args );

foreach ( $product_categories as $key => $category ) {
    $range = reddit_get_category_price_range( $category->term_id );
    echo $category->name . " " . $range;
}

/**
 * Returns the min and max price for a given product category.
 *
 * @param int $number
 *
 * @return string
 */
function reddit_get_category_price_range( $product_cat_id ) {
    $products = get_posts([
        'post_type'      => 'product',
        'posts_per_page' => -1,
        'fields'         => 'ids',
        'tax_query'             => array(
            array(
                'taxonomy'      => 'product_cat',
                'terms'         => $product_cat_id,
                'operator'      => 'IN'
            ),
            array(
                'taxonomy'      => 'product_visibility',
                'field'         => 'slug',
                'terms'         => 'exclude-from-catalog', // Possibly 'exclude-from-search' too
                'operator'      => 'NOT IN'
            )
        )
    ]);

    if ( ! $products ) {
        return "";
    }

    $prices = array();

    foreach ( $products as $product_id) {
        $product = wc_get_product( $product_id );
        $prices[] = $product->get_price();
    }

    if ( $prices ) {
        $min = min( $prices );
        $max = max( $prices );
        return "$min - $max";
    }

    return "";
}