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
 * @donate $9     https://businessbloomer.com/bloomer-armada/
 */

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 PHP snippets at the bottom of your child theme functions.php file and CSS at the bottom of its style.css file. Make sure you know what you are doing when editing such files - if you need more guidance, please take a look at my guide "Should I Add Custom Code Via WP Editor, FTP or Code Snippets?" and my video tutorial "Where to Place WooCommerce Customization?"

Does this snippet (still) work?

Please let me know in the comments if everything went as expected. I would be happy to revise the snippet if you report otherwise (please provide screenshots). I have tested this code with Storefront theme, the WooCommerce version listed above and a WordPress-friendly hosting.

If you think this code saved you time & money, feel free to join 17,000+ WooCommerce Weekly subscribers for blog post updates and 250+ Business Bloomer supporters for 365 days of WooCommerce benefits. Thank you in advance!

Need Help with WooCommerce?

Check out these free video tutorials. You can learn how to customize WooCommerce without unnecessary plugins, how to properly configure the WooCommerce plugin settings and even how to master WooCommerce troubleshooting in case of a bug!

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.

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? Support? Leave your Comment Now!
_____

If you are writing code, please wrap it between shortcodes: [php]code_here[/php]. Failure to complying with this (as well as going off topic, not writing in English, etc.) will result in comment deletion. 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 BloomerArmada to get blog comment reply priority, ask me 1-to-1 WooCommerce questions and enjoy many more perks. Thank you :)

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