Woocommerce change the price of products in the database

So after a few attempts, I managed to change the price for variable products.
If someone needs to send my code:

UPDATE wp_postmeta
LEFT JOIN wp_posts ON wp_posts.id = wp_postmeta.post_id
LEFT JOIN wp_term_relationships ON wp_posts.post_parent = wp_term_relationships.object_id
SET
  wp_postmeta.meta_value = wp_postmeta.meta_value*1.05
WHERE wp_posts.post_type="product_variation"
    AND wp_postmeta.meta_key = '_regular_price'
    AND wp_term_relationships.term_taxonomy_id = '2396'

Related Posts:

  1. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  2. How to get all products from an order including variations via SQL query?
  3. How to Order by random on a SQL query
  4. get woocommerce product image url and price from database [closed]
  5. Update WooCommerce stock status with SQL query if stock value is greater than 0
  6. How to get products without tag?
  7. Query product’s image path by category WooCommerce database?
  8. How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
  9. Alter the cost of products using phpmyadmin sql query
  10. Woocommerce order_complete email dont send after changing order status via sql
  11. Use a woocommerce hook to create a table and populate it with a query
  12. Getting the gallery images from products in woocommerce?
  13. Get product details by url key in WordPress woocommerce
  14. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  15. Which WooCommerce hook do I need to use to place the coupon field after the checkout sidebar
  16. Reverse engineering of WooCommerce Storefront filters
  17. Use WooCommerce function in other WordPress plugin
  18. WooCommerce Cart – Group Products By Category
  19. WooCommerce – update order item price and recalculate totals
  20. Add product description (content) to WooCommerce customer processing order email
  21. woocommerce – get_image_size() deprecated [closed]
  22. Woocommerce: How to remove page title from storefront theme homepage
  23. Remove checkout fields with Woocommerce depending on one of several shipping methods
  24. Replace one coupon to another after coupon added
  25. WooCommerce Multi-Currency shortcode not working
  26. Avada & WooCommerce Customization – Replacing product_title in woo-config.php [closed]
  27. How to unset fields in woocommerce product quick edit?
  28. WooCommerce template page for category
  29. Custom PLU field in woocommerce email
  30. How to get the webshop page in 2:nd language, with Polylang and Hyyan
  31. Subcategories not working when using shared base with custom taxonomy
  32. Change how the Subtotal Price in cart being calculated [closed]
  33. Display Advanced Custom Fields value in Woocommerce admin order details
  34. Some images aren’t shown on wordpress after installation on host
  35. Woocommerce Shortcode custom orderby not working
  36. Show only one variaton in catalog on meta key
  37. WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
  38. PayPal Express on product page in WooCommerce – doesn’t seem to work on product page?
  39. Woocommerce – Want to block a user agent from accessing specific product pages
  40. Reset all stock status in woocommerce
  41. Overwrite ‘require’ in child-theme
  42. Additional fields on Woocommerce’s rating system
  43. Best Practice – Customise a WooCommerce+WordPress Templates
  44. Woocommerce product image [closed]
  45. Question on WooCommerce Syntax
  46. Tax are not showing on order while placing order with REST API
  47. woocommerce_new_product action doesn’t fire
  48. Change The Woocommerce Product Categories Dropdown Widget Placeholder Text
  49. WooCommerce adding product to cart programatically [closed]
  50. minimum order item for certain products exempting 2 other products (in bulk)
  51. Is it possible to checkout with 2 different shipping options on a single order? [closed]
  52. How can I reference external attachments without breaking core WordPress files?
  53. Hide prices from certain category in woocommerce
  54. Undo WooCommerce CSV import
  55. Check if a WooCommerce Order Item has a specific meta data key
  56. Simple Product not displaying in frontend
  57. Woocommerce Advanced Shipping (WAS) condition is not being called when selecting “Ship to different address” [closed]
  58. Strip string from $_product->get_title() to get a cleaner mini-cart
  59. Broken link additional images after moving server
  60. WooCommerce Meta
  61. WooCommerce Product Table Conditional styling
  62. Product page attributes dropdown show price
  63. Smart Design for Blog + Woocommerce + LearnDash + Forum/Bodyboss
  64. Ajax add to cart not updating Elementor mini cart totals
  65. How to hide “Shipping” label from Woocommerce cart page
  66. What is the problem with these lines of code?
  67. Dynamic product total add to cart amount
  68. How can I make a thumbnail slider
  69. WooCommerce – 500k Jump in Order Number?
  70. How to access product’s meta data when deleting a WooCommerce product?
  71. How to show specific admin menu to specific user role?
  72. Need help with woocommerce roles
  73. Change WooCommerce product and variation prices programatically without affecting performance
  74. Help to locate a woocommerce hook method
  75. Format number to 2 decimal places
  76. Two e-commerce in two different folders of the same domain
  77. Random 503 and 504 errors
  78. Woocommerce language isn’t default language
  79. How set variation after filter in WooCommerce?
  80. Does anyone know a crowdsourcing plugin that can support the following use case?
  81. I can’t add pictures to the product attribute item in woocommerce
  82. Can I use taxonomies to make a multistore with woocommerce?
  83. How do you reactive related products on WooCommerce when it has been disabled?
  84. Display product variations in shop page
  85. How can I locate where the actions are defined? [duplicate]
  86. Shortcodes in billing fields doesn’t work
  87. Update a user meta key based on WooCommerce product purchase
  88. How to fix spacing in address tab in my account page
  89. Adding time of order to Admin email for new order
  90. show multiple product photos on WooCommerce single page
  91. Hide add to cart when product variation has no price or is unavailable
  92. How to get the WooCommercer product variation image
  93. how add css class to product boxes li, for img, add cart button, decs, price… [closed]
  94. How can I hide the entire “Shipping Details” block on the admin side of Woocommerce? [closed]
  95. How do I put woocommerce cart page to my checkout page? [closed]
  96. CSS url rules not relative to css path in account endpoint areas. IE. subscriptions
  97. Create WordPress account on different domain when WooCommerce order completed
  98. Creating a woocommerce order when a user creates an account
  99. I want to update shipping charge $0 for all Woocommeerce Subscription auto-renewal orders
  100. Conflict between Woocommerce Booking + Woocommerce Product Options [closed]