title: Updating product prices cache issue using a SQL query in Woocommerce
body: <p>I have a SQL script that is supposed to synchronize and adjust regular price comparing the text document uploaded daily on server.</p>
  <p>New prices are written to database, and I see them when looking at database. They show in <code>_regular_price</code> field properly. Problem is that frontend shows old prices .. until I manually just re-update each product in backend. Since i have thousands of products it is ineffective and tedious.</p>
  <p>What am I missing?</p>