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!
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')) . "'
Hi.
can I check how many times the user bought that product in the last 365 days?
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!
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?
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.
Not sure, this would require custom troubleshooting. Function works great. Sorry
Hi Rodolfo,
How can I use that function? ( wc_customer_bought_product_last_365 )
Thanks
As a conditional, when you check that against a single product ID
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?
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!
You is better!
Thanks!
Thanks a bunch !!!
You’re welcome Nadia!