How to Add the Cheapest Products in a BOGO Sale in Your WooCommerce Store?

Offering BOGO sale in your WooCommerce store is a win-win for both store owners and customers. As a store owner, you can take this oppurtunity to clear out slow-moving stock and manage profitability by adding your cheapest products to the promotion. Let’s see how this customization gives you full control over the discount structure, helping you boost sales and attract more customers.

Solution: Add the Cheapest Products in WooCommerce Store in a BOGO Sale

The provided code snippet automatically adds the cheapest product from the WooCommerce catalog to the cart as a gift when a customer adds a product to their cart.

// Hook to add action on template redirect
add_action('template_redirect', 'ts_add_cheapest_product_as_gift');

// Function to add cheapest product as a gift to the cart
function ts_add_cheapest_product_as_gift() {
    // Check if in admin or cart is empty
    if (is_admin()) return;
    if (WC()->cart->is_empty()) return;

    // Get the cart items
    $cart_items = WC()->cart->get_cart();

    // Initialize an array to store product IDs in the cart
    $product_ids_in_cart = array();

    // Get all product IDs in the cart
    foreach ($cart_items as $cart_item) {
        $product_ids_in_cart[] = $cart_item['product_id'];
    }

    // If there are products in the cart, set $product_bought_id as the first product in the cart
    $product_bought_id = !empty($product_ids_in_cart) ? $product_ids_in_cart[0] : null;

    // Get the cheapest product from the entire catalog
    $cheapest_product = ts_get_cheapest_product();

    if ($cheapest_product) {
        $product_gifted_id = $cheapest_product->get_id();

        // See if product id is in cart
        $product_bought_cart_id = WC()->cart->generate_cart_id($product_bought_id);
        $product_bought_in_cart = WC()->cart->find_product_in_cart($product_bought_cart_id);

        // See if gift id is in cart
        $product_gifted_cart_id = WC()->cart->generate_cart_id($product_gifted_id);
        $product_gifted_in_cart = WC()->cart->find_product_in_cart($product_gifted_cart_id);

        // If not in cart, remove gift; else, add gift
        if (!$product_bought_in_cart) {
            if ($product_gifted_in_cart) WC()->cart->remove_cart_item($product_gifted_in_cart);
        } else {
            if (!$product_gifted_in_cart) WC()->cart->add_to_cart($product_gifted_id);
        }
    }
}

// Function to get the cheapest product from the entire catalog
function ts_get_cheapest_product() {
    global $wpdb;

    $query = "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = '_price' AND meta_value > 0 ORDER BY CAST(meta_value AS SIGNED) ASC LIMIT 1";

    $product_id = $wpdb->get_var($query);

    if ($product_id) {
        return wc_get_product($product_id);
    }

    return null;
}

Output

When customers adds any products to the cart, the cheapest product available in the store gets added as the free product.

To capture more customers’ attention try different strategies of BOGO deals such as  automatically adding a product to WooCommerce cart based on six distinct conditions, including cart total, categories, and on website visits, etc.