Update product variations prices in Woocommerce with WPDB query

Question

I am using WordPress 4.7.4 and WooCommerce 3.0.5.

I updated _sale_price, _price, _regular_price using meta_id with code below:

   $meta_tbl = $wpdb->prefix.'postmeta';
   foreach ($_POST['loop'] as $loop_k => $loop_v) {
        $wpdb->update(
            $meta_tbl,
                array( 'meta_value' => $loop_v['price'] ),
                array( 'meta_id' => $loop_v['price_meta_id'] ),
                array( '%d' )
            );
        $wpdb->update(
            $meta_tbl,
                array( 'meta_value' => $loop_v['regular_price'] ),
                array( 'meta_id' => $loop_v['regular_price_meta_id'] ),
                array( '%d' )
            );
        $wpdb->update(
            $meta_tbl,
                array( 'meta_value' => $loop_v['sale_price'] ),
                array( 'meta_id' => $loop_v['sale_price_meta_id'] ),
                array( '%d' )
            );
  }

But still the shop page is displaying the old price of products! How can I do it properly?

score 2 · Accepted Answer · answered May 05 '17 at 16:22

2

Try by adding this line after your code.

wc_delete_product_transients( $post_id );

// $post_id replace with product ID

answered May 05 '17 at 16:22

mujuonly

11,370
5
45
75

Didnt workd for me. Still shows the wrong price everywhere, except in the cart. – Karl Johan Vallner Feb 02 '18 at 07:32
@KarlJohanVallner Are you using any price adjustment plugins? Also try deleting transient cache under WooCoommerce -> Status -> Tools – mujuonly Feb 02 '18 at 11:39
No plugins. For some odd reason, clearing cache doesnt do anything either. But when I manually update the price under "Products", it works out swell. – Karl Johan Vallner Feb 03 '18 at 19:33

Update product variations prices in Woocommerce with WPDB query

1 Answers1

Linked