title: MySQL query to change variable product price in WooCommerce
body: <p>I want to change the prices for variable products in woocommerce. I tried with below MySQL query to do it, </p>
  
  <pre><code>UPDATE wp_postmeta 
  SET meta_value = price_value 
  WHERE post_id = variation_id AND meta_key = '_sale_price';
  </code></pre>
  
  <p>but its updating only in backend(DB and admin area) not in front-end. Actually in front-end its not showing sale price also.
  As I'm not good at SQL, is there any code snippet or WooCommerce hook which allows me to change the price for a variable product?</p>
  
  <p>Thanks.</p>