[Resolved] How to add best seller products under archive pages in Woocommerce

Hi Leo,

I asked chatgpt and it gave me exactly what I want 🙂
Thanks for reply.

// Get top 5 selling products for current category or archive page
function get_top_selling_products() {
    $args = array(
        'post_type' => 'product',
        'post_status' => 'publish',
        'meta_key' => 'total_sales',
        'orderby' => 'meta_value_num',
        'posts_per_page' => 5
    );

    if (is_product_category()) {
        $product_categories = array(get_queried_object()->slug);
    } else if (is_post_type_archive('product')) {
        $product_categories = array();
    } else {
        return;
    }

    $top_selling_products = array();

    foreach ($product_categories as $category) {
        $args['tax_query'] = array(
            array(
                'taxonomy' => 'product_cat',
                'field' => 'slug',
                'terms' => $category
            )
        );

        $products = new WP_Query($args);

        if ($products->have_posts()) {
            while ($products->have_posts()) {
                $products->the_post();
                $top_selling_products[$category][] = array(
                    'title' => get_the_title(),
                    'price' => get_post_meta(get_the_ID(), '_regular_price', true),
                    'permalink' => get_permalink()
                );
            }
        }

        wp_reset_postdata();
    }

    return $top_selling_products;
}

// Display top 5 selling products for current category or archive page
function display_top_selling_products() {
    $top_selling_products = get_top_selling_products();

    if (!$top_selling_products) {
        return;
    }

    $output = '';

    foreach ($top_selling_products as $category_slug => $products) {
        $category_name = get_term_by('slug', $category_slug, 'product_cat')->name;

        $output .= '<h2>' . $category_name . '</h2>';

        foreach ($products as $product) {
            $output .= '<p><a href="' . $product['permalink'] . '">' . $product['title'] . '</a> - ' . $product['price'] . '</p>';
        }
    }

    return $output;
}

// Add shortcode to call the display_top_selling_products function
function top_selling_products_shortcode() {
    return display_top_selling_products();
}
add_shortcode('top_selling_products', 'top_selling_products_shortcode');

You can now use the [top_selling_products] shortcode anywhere in your content to display the top selling products for each category.

My next step is create accordion with these content but I couldn’t figure out how to add shortcodes to generateblocks’ new according block title.