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!

PHP Snippet: Get WooCommerce Best Sellers From Last N Days

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 “$trending, 0, 10” line to define the number of products you want e.g. “$trending, 0, 3” to get only 3

/**
 * @snippet       Get Best Sellers Last week
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 8
 * @community     https://businessbloomer.com/club/
 */

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',
		)
	);
	$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 array_keys( array_slice( $trending, 0, 10, true ) );
}

/* 

Once you have the function active, you can then use a WooCommerce shortcode to display products e.g.:

echo do_shortcode( '[products ids="' . bbloomer_product_sold_last_n_days() . '"]' );

*/

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

• WooCommerce: Calculate Sales by State
  You’re filing your tax returns and need to know how much you earned in each state… but then find out WooCommerce doesn’t give you this calculation by default within its reports! Don’t worry – today I’ll share a quick snippet so that you can calculate the amount you need in a second. Feel free to […]
• WooCommerce: Limit Sales Of A Product Per Day
  Yes, “manage stock” is a nice feature to make sure you don’t oversell a given product based on the stock you have in your warehouse. However, what if you also need to have a “daily sales limit” – say you can’t sell more than 3 of a given product ID in a given day? This […]
• WooCommerce: Count Variation Sales (Shortcode)
  We’ve already studied how to display the number of sales for a given product ID via a shortcode – however that solution won’t work for a variation ID, because WooCommerce only counts the “parent product” sales. We need a different workaround in this case. This will require we either query the orders that contain such […]
• WooCommerce: Decrease Product ‘Total Sales’ Upon Refund
  Every time an order is placed on your WooCommerce website, the purchased products’ total_sales counter increases thanks to a core function. It’s then easy to retrieve the value and maybe show the number of sales on the single product page, which is great for social proof and sales conversion rate optimization. The big problem – […]

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