WooCommerce: Get “Trending” Products

There is a way to display the WooCommerce bestsellers via shortcode / block, but there is no way to calculate the bestsellers – say – from the last 7 days i.e. a list of “trending” products over the last N days.

The function below gives you a way to loop through the latest orders and fill an array with the top 10 products – you can then pass this list of IDs to a shortcode to display them wherever you wish. Enjoy!

After calculating the best sellers from the last 7 days, I’ve used the shortcode below to display them on a custom page! Neat!

PHP Snippet: Get WooCommerce Best Sellers From Last N Days

Usage

The function below can be customized as follows:

  1. change ‘-7 days‘ to whatever time length you require e.g. ‘-2 weeks‘, ‘-3 months‘, etc.
  2. change the “array_slice( $trending, 0, 10, true )” line to define the number of products you want e.g. “array_slice( $trending, 0, 3, true )” to get only 3

Then, place the shortcode [trending] wherever you like.

Code

/**
 * @snippet       Get Best Sellers Last week
 * @how-to        businessbloomer.com/woocommerce-customization
 * @author        Rodolfo Melogli, Business Bloomer
 * @compatible    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */

add_shortcode( 'trending', 'bbloomer_product_sold_last_n_days' );

function bbloomer_product_sold_last_n_days() {
	$all_orders = wc_get_orders(
		array(
			'limit' => -1,
			'status' => array_map( 'wc_get_order_status_name', wc_get_is_paid_statuses() ),
			'date_after' => date( 'Y-m-d', strtotime( '-7 days' ) ),
			'return' => 'ids',
		)
	);
	if ( ! $all_orders ) return;
	$trending = array();
	foreach ( $all_orders as $all_order ) {
		$order = wc_get_order( $all_order );
		$items = $order->get_items();
		foreach ( $items as $item ) {
			$product_id = $item->get_product_id();
			if ( ! $product_id ) continue;
			$trending[$product_id] = $trending[$product_id] ? (int) $trending[$product_id] + $item['qty'] : $item['qty'];
		}
	}
	arsort( $trending, SORT_NUMERIC ); 
	return do_shortcode( '[products ids="' . array_keys( array_slice( $trending, 0, 10, true ) ) . '"]' );
}

Where to add custom code?

You should place custom PHP in functions.php and custom CSS in style.css of your child theme: where to place WooCommerce customization?

This code still works, unless you report otherwise. To exclude conflicts, temporarily switch to the Storefront theme, disable all plugins except WooCommerce, and test the snippet again: WooCommerce troubleshooting 101

Related content

Rodolfo Melogli

Business Bloomer Founder

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza. Follow @rmelogli

2 thoughts on “WooCommerce: Get “Trending” Products

  1. Hi there, i have copied and paste the whole code in the wordpress code snippet and activate it. And paste the shortcode : [products ids="' . bbloomer_product_sold_last_n_days() . '"] in the page using Elementor shortcode block. A list of product displayed but it is not the best seller in last 7 days.

    I am not sure what went wrong and i have tried but still can’t get this code works. I hope with your assistance i can use this fantastic code! thank you!

    1. I agree, the tutorial was confusing! I’ve now refactored the code, and you can use the [trending] shortcode to get the best sellers from the last 7 days. Feel free to edit the snippet in case you wish to change the date range or the number of products that are returned

Questions? Feedback? Customization? Leave your comment now!
_____

If you are writing code, please wrap it like so: [php]code_here[/php]. Failure to complying with this, as well as going off topic or not using the English language will result in comment disapproval. You should expect a reply in about 2 weeks - this is a popular blog but I need to get paid work done first. Please consider joining the Business Bloomer Club to get quick WooCommerce support. Thank you!

Your email address will not be published. Required fields are marked *