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. Is it possible to extract all product columns except for one?
  13. WooCommerce: Can’t use wc_get_products for custom REST API endpoints
  14. How to disable Woocommerce password recovery and use the default WordPress password reset page?
  15. Limit users to one active subscription in WooCommerce Subscriptions? [closed]
  16. Display WooCommerce size product attribute on shop page
  17. WooCommerce add_to_cart() with custom price [closed]
  18. Declaring custom woocommerce product type as virtual / downloadable only [closed]
  19. How to remove_action inside class [duplicate]
  20. Redirect if current user is logged out and current page is /my-account
  21. WooCommerce HTML after short description if product is in specific category
  22. How to get total count for each star rating?
  23. Display a list subcategories under the main product category thumbnails?
  24. Unable to programmatically remove product from WooCommerce cart
  25. WooCommerce Apply Coupon to order AFTER taxes
  26. Rewriting Woocommerce Product Filters To URL Segments
  27. How to Change WooCommerce Variable product pricing by SKU or visible children id
  28. Is it possible to cache ?wc-ajax=get_variation
  29. echo product id and product_item_key in cart [closed]
  30. Redirect the single product page link to the shop page
  31. Is WooCommerce updates for WordPress necessary? [closed]
  32. How can I display *only* the child category of a product?
  33. How to implement Handling Fee like the Shipping on Cart and Checkout page on WooCommerce [closed]
  34. why featured product not updated in postmeta table in woocommerce?
  35. wooCommerce checkout page State / County (optional) validate not working
  36. How to display empty stars on products with woocommerce?
  37. WooCommerce limited role
  38. Skip WooCommerce 4.5.x onboarding with WP-CLI [closed]
  39. Automatically making a newly saved payment method default in WooCommerce
  40. WooCommerce update_shipping_method ajax call wipes shipping method set on non-checkout page [closed]
  41. Display FREE for $0 products in woocommerce ++++ [closed]
  42. How to add existing categories into a post using wp_insert_post
  43. create comment box in woo-commerce shop order [closed]
  44. Product variation attributes does not appear as it should in the cart – woocommerce [closed]
  45. Woocommerce: how to know if the customer is canceled the order or the shop owner? [closed]
  46. Add shipping address to Woocommerce order emails [closed]
  47. A function to add arguments to a taxonomy
  48. Different Templates for Woocommerce Parent and Child Sub Categories
  49. add sub subpage endpoint to woocommerce plugin my-account section
  50. how to change the “return to shop” button text? [closed]
  51. Problem while adding the variable product woocommerce
  52. How do I create a filter to hide the One Click Accessibility plugin button in WordPress?
  53. customers are not showing up in woocommerce
  54. Woocomerce Edit source code of form in wordpress
  55. Woocommerce : How to automatically input the same email for every order?
  56. Woocommerce – Change order of products in Confirmed Order
  57. echo product parent category
  58. How to edit wc_get_template_part for archive products
  59. Switch to user link shortcode
  60. Display WooCommerce product attribute on shop page
  61. How to get product category ID based on post?
  62. Jump to Footer On Scroll – Woocommerce Pages Phones Only
  63. WordPress Development Workflow
  64. Woocommerce redirection product_name -> product_cat/product_name
  65. Remove Stripe Woocommerce Credit Card Icons (and replace with image)
  66. How to add external product url to woocommerce from a metadata by function.php
  67. Unable to call woocommerce hook in my custom php file
  68. Custom account page that accepts a query parameter
  69. Custom WooCommerce template for product
  70. Checkout fr Woocommerce – load default WooCommerce checkout template on the fly
  71. Loop Through Current Woocommerce Product Categories Sub Categories
  72. How to save a Woocomerce metabox input as a metadata field
  73. populating extra field with woocommerce categories
  74. Woocommerce Shop Manager Capabilities
  75. customize src attribute in woocommerce single product image
  76. How to tell woocommerce slider to use thumbnails
  77. Add customer name to woocommerce email-header.php heading
  78. woocommerce sort by dropdown styling
  79. Mysql query – amount spent by customer
  80. Integration widget Mondial Relay Js
  81. Custom Registration Fields woocommerce
  82. How Do I Access Parameters Emitted by an Action?
  83. bulk media crop for featured images
  84. Users credentials and syncing from third party with WooCommerce
  85. WooCommerce set specific currency on site shop
  86. WooCommerce shop, my account, cart every page redirect to home page [closed]
  87. How to edit woocommerce checkout fields
  88. Include customer details in woocommerce 3rd part plugin email
  89. how to add a page to a plugin?
  90. Unable to get product category
  91. Membership website with discount on scheduled appointment
  92. Woocommerce: how to make only certain products shippable?
  93. Customer email notification upon order update in woocommerce
  94. How can i hide a specific class when cart subtotal is above a certain amount
  95. Update WooCommerce Short Description using SQL
  96. Bulk delete ‘Global Attributes’ in WooCommerce via WP-CLI?
  97. Checkout page not loading on my ecommerce website
  98. WooCommerce: expiring date for products (and on sale some days before)
  99. How to display woo commerce shipping_method on the product page
  100. Product data field for Woo Commerce is blank?