Black Friday & Cyber Monday SUPER SALE ALL WEEK:
Grab 40% OFF on plugins
Days
Hours
Minutes
Seconds

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

bogo sale

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;
}
flexi bogo cta banner image


This to the shop owners who are running or planning to run BOGO offers on their WooCommerce store…

BOGO deals are great for increasing your sales, but have you thought about which offers are bringing you more revenue and which offers are not performing that great?

Don’t just set a BOGO deal, track the revenue generated by your deals in real-time with the Flexi BOGO for WooCommerce plugin.

Output

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

bogo sale

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.

Browse more in: Code Snippets, WooCommerce How Tos, WooCommerce Tutorials

Share It:

Subscribe
Notify of
0 Comments
Newest
Oldest
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x