If you’re developing custom landing pages or sections dedicated to logged in customers, knowing the quantity purchased of a certain product ID might come useful.
We already saw how to detect whether a logged in customer has purchased a given product, as well as a snippet to return all products purchased by a specific user – but this time I want to “count” how many times a current user has purchased a product ID, and return this on the screen via a shortcode.
From this snippet you can learn lots of things, for example how to create custom shortcodes, how to get customer orders, and how to set up a foreach loop in PHP. Either way, enjoy!
PHP Snippet: Count How Many Times a Product ID Was Purchased by Current User (WooCommerce Shortcode)
/**
* @snippet Count Product ID Purchases - WooCommerce Shortcode
* @how-to businessbloomer.com/woocommerce-customization
* @author Rodolfo Melogli, Business Bloomer
* @compatible WooCommerce 3.6.2
* @community https://businessbloomer.com/club/
*/
// SHORTCODE SYNTAX: [product_purchases id="123"]
add_shortcode( 'product_purchases', 'bbloomer_user_logged_in_product_bought' );
function bbloomer_user_logged_in_product_bought( $atts ) {
// GET PRODUCT ID FROM SHORTCODE
$atts = shortcode_atts( array(
'id' => '0'
), $atts );
// GET CURRENT USER ORDERS
$current_user = wp_get_current_user();
$customer_orders = wc_get_orders(
array(
'limit' => -1,
'status' => array( 'completed', 'processing'),
'customer' => get_current_user_id(),
)
);
// LOOP THROUGH ORDERS AND SUM QUANTITIES PURCHASED
$count = 0;
foreach ( $customer_orders as $customer_order ) {
$order = wc_get_order( $customer_order->get_id() );
$items = $order->get_items();
foreach ( $items as $item ) {
$product_id = $item->get_product_id();
if ( $product_id == $atts['id'] ) {
$count = $count + absint( $item['qty'] );
}
}
}
// RETURN HTML
return '<b>You purchased: ' . $count . ' items</b>';
}
How could we increase the popularity of a product?
I have a problem when we publish a new version of a software product that already existed and had sales, then the new product (new product ID) becomes “unpopular” in the popularity sorting.
I would like to keep the count of sales from the previous versions of the same product (old IDs) in the new product, to keep it higher in the popularity sorting.
Is that possible?
Rodolfo, your site is really amazing. Thanks for all the info here.
Thank you! And yes, you can increase the “total sales” field value in the edit product page: https://www.businessbloomer.com/wp-content/uploads/2023/11/woocommerce-product-total-sales-custom-field-value.png
Dear Rodolfo,
Is it possible to Count User Purchases By All Ids and not specific id? thank you
Hi Salvatore thanks so much for your comment! Yes, this is definitely possible, but I’m afraid it’s custom work. If you’d like to get a quote, feel free to contact me here. Thanks a lot for your understanding!
Thanks for sharing this code.
If the user refund 1 product, the count didn’t reduce the total that it showed. how can I change the code to show the correct count of products?
Hi Saeed, thanks so much for your comment! Yes, this is definitely possible, but I’m afraid it’s custom work. If you’d like to get a quote, feel free to contact me here. Thanks a lot for your understanding!
Hello Sir,
this is a phanastic code. Thanks a lot for sharing.
Now what i am looking for is the same shoertcode, where print out the total amount of ONE specific Item price in total.?
Can you do that an share?
greedings from Germany
Harry, thanks so much for your comment! Yes, this is definitely possible, but I’m afraid it’s custom work. If you’d like to get a quote, feel free to contact me here. Thanks a lot for your understanding!