WooWeekly #272: Get Customers by Product (Plus: Get Downloadable Products)

How you doing?

It’s a lovely and warm Wednesday here in Sicily. I didn’t know I loved September this much 🙂

Also, welcome back to our WooCommerce Weekly appointment – here comes a series of WooCommerce articles put together by yours truly so that you can learn something new.

Note: I’m trialling a new newsletter software, so let me know if you notice anything different/buggy. Thank you

New: WooCommerce Tips & Tutorials

WooCommerce: Get List of Users Who Purchased a Product ID

This time around we’ll take a look at some SQL. Instead of using complex PHP loops and conditionals, sometimes knowing a bit of database “SQL SELECT” can help. I managed to return the list of user email addresses who have purchased a specific product ID. Enjoy: https://businessbloomer.com/woocommerce-get-list-of-users-who-purchased-a-product-id/

WooCommerce: Get List of Downloadable Products

When you’re doing custom PHP work, this snippet will come handy. It’s a quick way to get a sublist of product IDs based on product meta criteria – in this case we’ll get a list of products that have “_downloadable” set to “yes”. Enjoy: https://businessbloomer.com/woocommerce-get-list-of-downloadable-products/

Author

  • Rodolfo Melogli

    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.

    View all posts

Proudly supported by

Join them?