Woocommence `update_post_meta` does not update database values

Question

I am creating a plugin that uses a function update_post_metato update the price of a product change.

If I have product x( id:5) and option y( id:400), and I run update_post_meta(400,"_regular_price",13.00);It does not update the database. This is very strange when I click Edit Product(wp-admin), the updated price 13.00appears in the options bar, and I have to click Updateto update it for viewing by customers. Is this regular behavior, and if so, how to update the database immediately after the update_post_meta function is executed?

(Image) Price after update_post_meta() Summary page

.

(Image) Price after same update. Edit Product page

Here is my code for doing bulk updates

// $attribute_value/$variation_value are set correctly!
while ($loop->have_posts() ) : $loop->the_post();
    global $product;
    $variations = new WC_Product_Variable($product->post->ID);
    $variations = $variations->get_available_variations();
    foreach ($variations as $key => $variation){
        foreach ($variation["attributes"] as $key => $attribute_value):
            if($attribute_value == $variation_value):
                update_post_meta( $variation['variation_id'], '_regular_price', $regular_price);
            endif;
        endforeach;
    }
endwhile;

, Wordpress http://wordpress.org/support/topic/update_post_meta-is-not-updating-the-actual-values?replies=1#post-5742842

Answer 1

woocommerce ( 2.1.12):

WooCommerce//--functions.php: 417

$regular_price = get_post_meta( $product_id, '_regular_price', true );

update_post_meta( $product_id, '_price', $regular_price );
update_post_meta( $product_id, '_sale_price', '' );
update_post_meta( $product_id, '_sale_price_dates_from', '' );
update_post_meta( $product_id, '_sale_price_dates_to', '' );

wc_delete_product_transients( $product_id );

, "_price" , .

:

wc_delete_product_transients( $product_id );

Answer 2

value_value . , , , update_post_meta() .

.

<?php

    $get_all_products_query = "SELECT `ID`
                FROM `". $wpdb->prefix . "posts`
                WHERE `post_type` LIKE 'product'
                AND `post_status` = 'publish'
                ORDER BY `ID` DESC";

     $get_all_products_result = $wpdb->get_results($get_all_products_query);

     $regular_price = '';

     if(!empty($get_all_products_result))
     {
     foreach($get_all_products_result as $single_product)
     {
         $product_parent_id = $single_product->ID;

        //Get all variations of single product

        $query = "SELECT `post_id`
              FROM `" . $wpdb->prefix . "postmeta`
              WHERE `meta_key` = 'attribute_pa_product'
              AND `post_id`
              IN (
              SELECT `ID`
              FROM `" . $wpdb->prefix . "posts`
              WHERE `post_parent` = " . $product_parent_id . "
              )";

        $variation_result = $wpdb->get_results($query);

        if(!empty($variation_result))
        {
            //As one product may have multiple variation

            foreach($variation_result as $single_variation)
            {
              $post_id = $single_variation->post_id;

                          update_post_meta( $post_id, '_regular_price', $regular_price);
            }
        }
     }
     }


?>

" ", $regular_price.

Answer 3

I think both of you make it a lot harder than it should be.

First of all, what is the purpose of this check:

if($attribute_value == $variation_value)

The variable is $variation_valuenot a string, therefore it is not executed, therefore the test is update_post_meta()not executed.

I have simplified your code in this (this is checked and works):

//Setup WP_Query
$args = array(
    //Set any arguments you want here to select the products
    'post_type' => 'product', //Make sure it is the correct post type
    'post__in'  => array(157, 156) //Example post IDs
);

$loop = new WP_Query($args);

//The price to set
$regular_price = 110;

//Loop through query results
while ($loop->have_posts() )
{
    //Setup post data
    $loop->the_post();

    //Instantiate the product class 
    $product = new WC_Product_Variable(get_the_ID());

    //Get all variations
    $variations = $product->get_available_variations();

    //Loop though variations and update
    foreach ($variations as $variation){
        update_post_meta( $variation['variation_id'], '_regular_price', $regular_price);
    }

}