WooCommerce: Get List of Users Who Purchased a Product ID

This time around we’ll take a look at some SQL. As you know, WooCommerce orders (same as WooCommerce products) are stored in the WordPress database.

Instead of using complex PHP loops and conditionals, sometimes knowing a bit of database “reading” can help. I took some inspiration (because I don’t know everything by heart) from the wc_customer_bought_product()” WooCommerce function, which contains some SQL to check if a user has purchased a given product.

I’ve played a little with the same SQL SELECT call, and managed to return the list of user email addresses who have purchased a specific product ID. If you’re ever going to need this, enjoy!

Here’s the array containing the list of customer billing emails who have purchased a given WooCommerce product

PHP Snippet: Get List of WooCommerce Customer Emails Who Purchased a Specific Product

Usage: simply call the bbloomer_echo_product_customers( $product_id ) function somewhere in your code, and you will get the list of customers who bought a specific product!

/**
 * @snippet       Get Customers Who Purchased Product ID
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 6
 * @community     https://businessbloomer.com/club/
 */

function bbloomer_echo_product_customers( $product_id ) {
   global $wpdb;
   $statuses = array_map( 'esc_sql', wc_get_is_paid_statuses() );
   $customer_emails = $wpdb->get_col( "
	   SELECT DISTINCT pm.meta_value FROM {$wpdb->posts} AS p
	   INNER JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id
	   INNER JOIN {$wpdb->prefix}woocommerce_order_items AS i ON p.ID = i.order_id
	   INNER JOIN {$wpdb->prefix}woocommerce_order_itemmeta AS im ON i.order_item_id = im.order_item_id
	   WHERE p.post_status IN ( 'wc-" . implode( "','wc-", $statuses ) . "' )
	   AND pm.meta_key IN ( '_billing_email' )
	   AND im.meta_key IN ( '_product_id', '_variation_id' )
	   AND im.meta_value = $product_id
   " );
   if ( $customer_emails ) echo implode( ', ', $customer_emails );
}

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: Display All Products Purchased by User
    When a WooCommerce customer is logged in, you might want to show them the list of previously purchased products (maybe in a custom “My Account” tab). This is helpful when customers tend to buy the same products over and over again, and therefore you can help them “order again” without having them to search the […]
  • WooCommerce: Check If User Has Purchased Product
    If you need to detect if a logged in user has purchased a certain product ID, this snippet will do the trick. You can use this for marketing (e.g. “Buy More of This!”) or for displaying special notices on the loop or the single product page. Enjoy!
  • WooCommerce: User Can Only Purchase A Product Once
    In the era of online courses, subscriptions, custom-made products and product personalization, it may happen that you need to limit a specific WooCommerce product sales. For example – users may only purchase a trial product once in their lifetime. In this short tutorial, we will see how this is done. Clearly, the user must be […]
  • WooCommerce: Limit Daily Sales For Cheap Products (Anti-Spam)
    We could call this the “WooCommerce Anti-Spam Without a Plugin” series, while I attempt to fight against bad humans and very bad bots who love attacking the Business Bloomer checkout page with spam orders and fake user registrations. My first attempts were (1) My Account registration anti-spam honeypot, (2) Checkout anti-carding-attack honeypot, and (3) Reducing […]
  • WooCommerce: Conditionally Display Content to Customers [Shortcode]
    Today’s customization will feature a custom shortcode that you can use to display content only to logged in customers: [customers-only]content for customers here e.g. video iframe[/customers-only] This is perfect for membership sites, LMS platforms, paywalled content. In my case, only premium Club members with a ‘CLASS’ pass can watch upcoming WooCommerce masterclasses and past recordings, […]

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

15 thoughts on “WooCommerce: Get List of Users Who Purchased a Product ID

  1. This is very useful. But i wonder how i can call this dynamically via shortcode?

    1. Hello Frode, 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!

  2. Good morning, how do I specify which specific product I want to sort?

    1. Hi Bartosz, you can use the function anywhere you need, simply specify the product ID:

      bbloomer_echo_product_customers( 123 );
  3. Hello! How would I go about to find users IDs instead of emails?

    1. Hi Rafa, 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!

  4. Great – thank you. Still working with v. 4.9, Jan 2021. Super helpful.

    1. Awesome!

  5. Still works in WooCommerce 4.01

    1. Ha meant to say 4.0! not 4.01 ๐Ÿ™‚

      1. Nice!

  6. Using the Code Snippets plugin. Once the code snippet is activated, where should I look to see the results?

    1. Hi Mark! It depends where you need to display them. For example, this is how to add a new WP admin subpage: https://businessbloomer.com/woocommerce-add-new-subpage-wordpress-admin-dashboard/

  7. This is a very handy one, thanks Rodolfo

    1. Great!

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 *