Increase price of products woocommerce

increaseWoocommerceProductsPricesByPercentage.sql

-- 10%
UPDATE wp_postmeta
SET meta_value = ROUND(meta_value * 1.10, 2)
WHERE meta_key = '_price';

UPDATE wp_postmeta
SET meta_value = ROUND(meta_value * 1.10, 2)
WHERE meta_key = '_regular_price';

UPDATE wp_postmeta
SET meta_value = ROUND(meta_value * 1.10, 2)
WHERE meta_key = '_sale_price' AND meta_value != '';

DELETE FROM `wp_options`
WHERE (`option_name` LIKE '_transient_wc_var_prices_%'
OR `option_name` LIKE '_transient_timeout_wc_var_prices_%');