I have almost 1800 products in my website. I want to increase to price of all products by adding 200 in all products regular price. As I have 1700 products I cannot edit them 1 by 1. I need a MYSQL Query for this work
Question posted in Woocommerce
The official Woocommerce documentation can be found here.
The official Woocommerce documentation can be found here.
2
Answers
Brothers Thanks alot. I was in a rush and could not think properly. Actually the solution was quite simple. This is the simplest answer to my Question that I solved and tested.
Running MySQL query for these works is not recommended. There are easy methods to do this. If anything goes wrong, this might crash your website. Make sure you take a backup before executing SQL queries.
Option1:
There are few free WordPress plugins which can do this job.
https://wordpress.org/plugins/pw-bulk-edit/
https://wordpress.org/plugins/woo-bulk-editor/
Option2:
Product Price Bulk Editing (WordPress Dashboard):
This is the easiest solution. You can just do this from the “Products” admin page of your WordPress dashboard.
Go to the “Products” admin page
Tick all the products you want to edit the sale price for
Click on Bulk Actions > Edit
Select “Change Price to:”
Choose “Increase Existing Price by Fixed Amount”
Enter e.g. 200
Update