skip to Main Content

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

2

Answers


  1. Chosen as BEST ANSWER

    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.

    update table_name set col_name = (col_name+200)


  2. 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

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search