How to Increase all Woocommerce products prices by a percentage


If you are using Woocommerce in my website and I should need to add 24% extra to all my products prices.
Using a database Query will be the best way.

You can run the following SQL query, that will update all your product prices adding an extra 24% (and rounding prices too):

You might need to delete products transient cache going to Settings -> Status -> Tools (tab) and in “WooCommerce transients” you will “clear transients“;

Handle product variations too:

You just need to replace this line:

By this line:

Additionally you will also need to use:

Leave A Reply

Your email address will not be published.