Get custom field value and max price from variation product in WooCommerce

user_8360353 0
Viewed 845

I'm trying to show variation custom price-span from X-X.

  • The lowest price comes from (multiple) custom field values, I need to use the lowest value.
  • The highest price should be variation max price.

I only want this if the variation has the bulk_price value, and only show it in archives pages. I need to get the custom field value, and the price max.

I'm working from:

"How can I get Min and Max price of a woocommerce variable product in Custom loop?"

and

"WooCommerce: Get custom field from product variations and display it as a suffix to variation prices"

This is what I have:

function change_product_price_display( $price) {
    $bulk_price = get_post_meta([ 'variation_id' ], 'bulk_price', true);
    $priceMax        = $product->get_variation_price('max'); // Max price

    //only show in archives 
    if (is_product_category()) {

        //only if there is a bulk price
        if ( $bulk_price ) {
            return ' <span class="price-suffix">' . ' From ' . get_woocommerce_currency_symbol() .__( $bulk_price , "woocommerce") . ' - ' . $priceMax   . '</span>';   
        }
    }
    //don't affect other products
    else {
        return $price;
    }   
}
add_filter( 'woocommerce_get_price_html', 'change_product_price_display');
add_filter( 'woocommerce_cart_item_price', 'change_product_price_display');
woocommerce custom-fields product wordpress php
1 Answers

Display on product category archive lowest value (custom field) to max price. Comment with explanation added to the code

// Display on product category archive lowest value to max price
function change_product_price_display( $price, $product ) {
    // Returns true when viewing a product category archive.
    if ( is_product_category() ) {
        // Set array
        $bulk_prices = array();

        // Loop for variations IDs
        foreach( $product->get_children() as $variation_id ) {
            // Get post meta
            $bulk_price = get_post_meta($variation_id, 'bulk_price', true);

            // True
            if( $bulk_price ) {
                // Push
                $bulk_prices[] = $bulk_price;   
            }
        }

        // NOT empty
        if( sizeof($bulk_prices) > 0 ) {
            // Sort: low to high
            sort($bulk_prices);

            // First value
            $lowest_value = reset( $bulk_prices );

            // Get max price
            $price_max = $product->get_variation_price('max');

            // Output
            $price = '<span class="price-suffix">From ' . get_woocommerce_currency_symbol() . $lowest_value . ' - ' . wc_price($price_max) . '</span>';
        }
    }

    return $price;
}
add_filter( 'woocommerce_variable_price_html', 'change_product_price_display', 10, 2 );

For clarity, the code for creating and saving the custom fields

// Add custom field input product variations
function action_woocommerce_variation_options_pricing( $loop, $variation_data, $variation ) {  
    woocommerce_wp_text_input( array(
        'id'          => 'bulk_price[' . $loop . ']',
        'desc_tip'    => 'true',
        'description' => __( 'Enter the Bulk price here.', 'woocommerce' ),
        'label'       => __( 'Custom Field', 'woocommerce' ),
        'value'       => get_post_meta( $variation->ID, 'bulk_price', true )
    ));
}
add_action( 'woocommerce_variation_options_pricing', 'action_woocommerce_variation_options_pricing', 10, 3 );

// Save custom field on product variation save
function action_woocommerce_save_product_variation( $variation_id, $i ) {
    $bulk_price = $_POST['bulk_price'][$i];
    if ( isset( $bulk_price ) ) {
        update_post_meta( $variation_id, 'bulk_price', esc_attr( $bulk_price ) );
    }
}
add_action( 'woocommerce_save_product_variation', 'action_woocommerce_save_product_variation', 10, 2 );
user_119875380
Related