Checking if customer has already bought something in WooCommerce

by

2021 UPDATE – Handling guests “billing email” – Improved and secured SQL query

Here is a much light and faster conditional function that will return true if a customer has already made a purchase.

It handles registered users guest from their user ID and guests from their billing email:

  • For registered users: If the optional argument is not set with a user ID, the current user id will be used.
  • For guests: the billing email will be required as an argument in the function.

This lighter and improved function (based partially on wc_customer_bought_product() function source code) will return a boolean value based on orders count (false for O orders and true when there is at least one paid order):

function has_bought( $value = 0 ) {
    if ( ! is_user_logged_in() && $value === 0 ) {
        return false;
    }

    global $wpdb;
    
    // Based on user ID (registered users)
    if ( is_numeric( $value) ) { 
        $meta_key   = '_customer_user';
        $meta_value = $value == 0 ? (int) get_current_user_id() : (int) $value;
    } 
    // Based on billing email (Guest users)
    else { 
        $meta_key   = '_billing_email';
        $meta_value = sanitize_email( $value );
    }
    
    $paid_order_statuses = array_map( 'esc_sql', wc_get_is_paid_statuses() );

    $count = $wpdb->get_var( $wpdb->prepare("
        SELECT COUNT(p.ID) FROM {$wpdb->prefix}posts AS p
        INNER JOIN {$wpdb->prefix}postmeta AS pm ON p.ID = pm.post_id
        WHERE p.post_status IN ( 'wc-" . implode( "','wc-", $paid_order_statuses ) . "' )
        AND p.post_type LIKE 'shop_order'
        AND pm.meta_key = '%s'
        AND pm.meta_value = %s
        LIMIT 1
    ", $meta_key, $meta_value ) );

    // Return a boolean value based on orders count
    return $count > 0;
}

Code goes in functions.php file of your active child theme (or theme) or also in any plugin file.

This code is tested on Woocommerce 3+ and works (It should work on previous versions too).

For multiple products: Check if a user has purchased specific products in WooCommerce

Usage example 1 (logged in customer)

if( has_bought() )
    echo '<p>You have already made a purchase</p>';
else
    echo '<p>Welcome, for your first purchase you will get a discount of 10%</p>';

Usage example 2 (setting the user ID)

// Define the user ID
$user_id = 85;

if( has_bought( $user_id ) )
        echo '<p>customer have already made a purchase</p>';
    else
        echo '<p>Customer with 0 purchases</p>';

If the $user_id is not defined and the current user is not logged in, this function will return false.

Usage example 3 – For guests (setting the billing email)

// Define the billing email (string)
$email="[email protected]";

if( has_bought( $email ) )
        echo '<p>customer have already made a purchase</p>';
    else
        echo '<p>Customer with 0 purchases</p>'

The code of this function is partially based on the built in WooCommerce function wc_customer_bought_product() source code.

More Related Contents:

  1. Get Order items and WC_Order_Item_Product in WooCommerce 3
  2. Check if a user/guest has purchased specific products in WooCommerce
  3. Get all Orders IDs from a product ID in Woocommerce
  4. Display in stock data in short description [closed]
  5. How to get WooCommerce order details
  6. WooCommerce: Auto complete paid orders
  7. Change cart item prices in Woocommerce 3
  8. Create programmatically a WooCommerce product variation with new attribute values
  9. Change product prices via a hook in WooCommerce 3+
  10. Woocommerce: Which hook to replace deprecated “woocommerce_add_order_item_meta”
  11. Add extra meta for orders in Woocommerce
  12. Add columns to admin orders list in WooCommerce
  13. Create an order programmatically with line items in Woocommerce 3+
  14. WooCommerce: Check if items are already in cart
  15. Updating product stock programmatically in Woocommerce 3
  16. Disable add to cart button for an array of products IDs in WooCommerce
  17. Send an Email notification to the admin for pending order status in WooCommerce
  18. Change sender name and email address for specific WooCommerce email notifications
  19. Custom order status background button color in Woocommerce 3.3 admin order list
  20. Set product sale price programmatically in WooCommerce 3
  21. Create new product attribute programmatically in Woocommerce
  22. Get refunded orders and refunded order items details in Woocommerce 3
  23. Adding multiple tabs to WooCommerce single product pages
  24. Add a line break in Woocommerce Product Titles
  25. Get orders total purchases amount for the day in Woocommerce
  26. Get the metadata of an order item in woocommerce 3
  27. Accessing Order Items protected data in Woocommerce 3
  28. Create programmatically a product using CRUD methods in Woocommerce 3
  29. Add a fee to an order programmatically in Woocommerce 3
  30. Replace woocommerce_add_order_item_meta hook in Woocommerce 3.4

Leave a Comment