WooCommerce: Check if User Has Bought Product in the Last 365 Days

A few snippets ago we introduced the magic WooCommerce inbuilt function “wc_customer_bought_product” – automatically, with a single line of PHP, you can find out if the user has already purchased a product ID.

But when building my new #BloomerArmada section, I had to know if a user purchased a product ID in the last 365 days… so I rewrote the function, changed its name and added a little edit to it – easy peasy!

The original “wc_customer_bought_product” function in WooCommerce

PHP Snippet: Check if User Has Bought Product ID in the Last 365 Days

/**
 * @snippet       New version of "wc_customer_bought_product" function (last 365 days)
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 5
 * @community     https://businessbloomer.com/club/
 */

function wc_customer_bought_product_last_365( $customer_email, $user_id, $product_id ) {
   global $wpdb;

	$result = apply_filters( 'woocommerce_pre_customer_bought_product', null, $customer_email, $user_id, $product_id );

	if ( null !== $result ) {
		return $result;
	}

	$transient_name = 'wc_cbp_' . md5( $customer_email . $user_id . WC_Cache_Helper::get_transient_version( 'orders' ) );

	if ( false === ( $result = get_transient( $transient_name ) ) ) {
		$customer_data = array( $user_id );

		if ( $user_id ) {
			$user = get_user_by( 'id', $user_id );

			if ( isset( $user->user_email ) ) {
				$customer_data[] = $user->user_email;
			}
		}

		if ( is_email( $customer_email ) ) {
			$customer_data[] = $customer_email;
		}

		$customer_data = array_map( 'esc_sql', array_filter( array_unique( $customer_data ) ) );
		$statuses      = array_map( 'esc_sql', wc_get_is_paid_statuses() );

		if ( sizeof( $customer_data ) == 0 ) {
			return false;
		}

		$result = $wpdb->get_col( "
			SELECT im.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 p.post_date > '" . date('Y-m-d', strtotime('-365 days')) . "'
			AND pm.meta_key IN ( '_billing_email', '_customer_user' )
			AND im.meta_key IN ( '_product_id', '_variation_id' )
			AND im.meta_value != 0
			AND pm.meta_value IN ( '" . implode( "','", $customer_data ) . "' )
		" );
		$result = array_map( 'absint', $result );

		set_transient( $transient_name, $result, DAY_IN_SECONDS * 30 );
	}
	return in_array( absint( $product_id ), $result );
}

[/php]

Now that the “wc_customer_bought_product_last_year” exists in your functions.php, you can use it in a snippet or shortcode! The only major difference with “wc_customer_bought_product” is this line:

AND p.post_date > '" . date('Y-m-d', strtotime('-365 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: Add Column to “Users” Admin Table
    On the admin side, you might need to display WooCommerce information inside the users table (WordPress Dashboard > Users). For example, their billing country. Or their phone number. Or maybe some custom calculation e.g. the number of completed orders. Either way, this is super easy. First, we add a new column – second, we tell […]
  • WooCommerce: Update User Meta After a Successful Order
    When an order is placed in WooCommerce, you might want to change/add something in the User Meta programmatically. For example, you could “check” a custom checkbox in the User Profile. Or maybe assign the User Twitter username. And so on ๐Ÿ™‚
  • WooCommerce: Get List Of All Customers
    Today’s snippet is a helpful shortcut for getting the list of customers in your WooCommerce website. This may be necessary during customization, especially if you need tailor-made features for administrators and shop managers in the backend or frontend. How did I find out about the solution below? Well, our job is mainly copy/paste from online […]
  • WooCommerce: Get Current User Orders By Status
    This is a neat custom function that you can use in your WooCommerce customization. It can be helpful to know the list of orders placed by the current user ID, for example, if they are in their “My Account” page and you have a custom tab where you want to show e.g. only failed orders. […]
  • WooCommerce: Change Address Format For a Specific Country
    We’ve already covered a little about address formats when we added a custom House Number field to the WooCommerce Checkout page. Address formats define the way Billing and Shipping addresses are formatted for the end user. Addresses show on the order received / thank you page, on transactional emails and on some My Account pages, […]

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

14 thoughts on “WooCommerce: Check if User Has Bought Product in the Last 365 Days

  1. Hi.
    can I check how many times the user bought that product in the last 365 days?

    1. Hi David, 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. Hi,
    I don’t need the email address to be checked in this function, user id is enough to be checked.
    what should I change in your code to ignore customer email?

    1. wc_customer_bought_product_last_365( '', 123, 456 );
  3. Hello,

    Thanks for this feature!

    I just have a question because I think I found a bug. A customer connected but without purchase still sees the data. When I do a var_dump it returns true when it should be false since there was no purchase.

    1. Not sure, this would require custom troubleshooting. Function works great. Sorry

  4. Hi Rodolfo,

    How can I use that function? ( wc_customer_bought_product_last_365 )

    Thanks

    1. As a conditional, when you check that against a single product ID

  5. I do not get this to work.
    I got 3 products reflecting 365 days, 30 days and 7 days, 1 customer has bought both 365 days and 7 days, the 7 days are gone (more than 7 days since bought), yet both returns true.
    I added a parameter in the function to pass the days into the function.
    if any of the products are bought within the given days day should “give access” to certain content.
    i check first for 365 days then 30 days and then 7 days.
    shouldnt the 7 days return false?

    1. Hi there, thanks so much for your comment! Yes, this can be fixed, 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!

  6. You is better!

    1. Thanks!

  7. Thanks a bunch !!!

    1. You’re welcome Nadia!

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 *