How to bulk edit products

, ,

I’ve seen both on the WooThemes Help Desk and on some Facebook groups that customers need to edit many of their products, or even all of them, all together.
In example, you may need to discount all the products for a special offer.

Everybody knows that there are plugins for this, like Dynamic Pricing or Bulk Stock Management, but not everybody knows about a neat feature that WooCommerce includes in its core by default, which allows you to do the same, maybe with more steps.

It’s the Bulk Actions feature, already available by default in WordPress for its default post types, and extended for Products in WooCommerce.

The Bulk Actions it’s a dropdown menu you have in the Products page, on the top left of the table.


To use it, select one or more products in the table, then choose what to do with the Bulk Actions dropdown, so choose Edit or Move to Trash. It’s obvious what would happen if you choose Move to Trash.

If you choose instead to Edit the selected products you will be able to edit a lot of options for those products.
Here is how it looks when you try to edit products in bulk:


As you can see you can choose the categories of the products, change the comments status and the products status, add tags, and change a lot of product data.

In example, if you want to discount all the products in the shop just select all of them, then click on Bulk Actions > Edit and in the PRODUCT DATA section choose how to edit the Price, increasing/decreasing it by X%. This would edit the product regular price by X%.

In the same way, you can bulk edit the stock (if the stock is the same for all products) or allow backorders and a lot of other things.

43 replies
  1. Xavi
    Xavi says:

    Very interesting post!!
    I’m using WooCommerce on my website, but I can not bulk edit the categories of products, I can only add categories but I can not change them. Do you know why this happens?

    • Nicola Mustone
      Nicola Mustone says:

      Hi Xavi,

      You can’t bulk edit categories, but only products.
      To edit a singular category instead you have to go to Products > Categories and click on its name (or the edit link that appears hovering over it).

      Have a good day

  2. Xavi
    Xavi says:

    I’m having a problem with the bulk edit feature. When I try to change the category of multiple products, it does not allow me to reassign the category of a product, rather I am only able to add an additional category to a product. The end result is that the product appears in both categories (the original category and the modified category).

    For example, I have 3 products in the table (mesas) category (seen in img 1) and I would like to be able to remove them from their current category and add them to a different category such as chairs (sillas), as seen in img 2. What’s happening is that I am only allowed to add the products to the chairs category and cannot delete them from the table category (demonstrated in img 3).


    Any suggestions to resolve this issue would be greatly appreciated. Thank you.

    • Nicola Mustone
      Nicola Mustone says:

      Hi Xavi,
      This is a limitation from WordPress because categories for multiple items can be different, therefore you can’t remove them because you may want to remove only one of the products from a category, but not the others.

      I’d suggest you to write on the support forum for this.

      You will see the same behaviour for WordPress post, it’s not limited to products from WooCommerce only.

  3. Angela
    Angela says:

    How can I bulk edit the product type? I imported hundreds of products from a csv, and although it saved all the variations and variant pricing correctly, it saved every products as a simple product. I don’t want to have to manually go through and open, edit, save each product – I don’t see a way of doing this. Help!

    • Nicola Mustone
      Nicola Mustone says:

      Hello Angela,
      The easiest way to bulk edit the product type would be to delete the imported products and import them again specifying the product type in your CSV.

      Otherwise, if the plugin you are using has a Merge feature for existing products you can specify the product type in the CSV and merge it.

  4. Jess Paul
    Jess Paul says:

    Hi! Is there a way to bulk edit the image associated with a group of products? i.e. I want to update the image for all products in a certain category. (It’s really the category image I want to update). Make sense?


  5. hayley fletcher
    hayley fletcher says:

    Hi there,
    your article says “In the same way, you can bulk edit the stock (if the stock is the same for all products) or allow backorders and a lot of other things.”

    Allow bulk orders is exactly what I am wanting to do, but I can’t find that option. I thought I had it previously but it doesn’t seem to be there anymore.


  6. Marlene
    Marlene says:

    Thank you for this information! I am however only able to decrease or increase by value and not %. How do I change this?

  7. Steve
    Steve says:

    Hey, thanks for the post. Very informative

    However, when I’m viewing the product table, and have filtered it to display only products in a specific category, then select all and use…

    bulk actions > edit > price > increase by (fixed amount or %):

    It doesn’t appear that anything happens, and no price seems to be adjusted.

    What is the acceptable format for entering a percentage increase into the price field?

    Thanks in advance for your consideration

    • Nicola Mustone
      Nicola Mustone says:

      Hello Steve,
      Make sure you are entering just the number, without any sign!

      If that still does not work, I’d suggest you to disable all plugins except WooCommerce and try again, if that still does not fix, try to open an issue on GitHub!

  8. ang
    ang says:

    Hi thanks for this great information, I was wondering, ¿How can i bulk edit product from published status to draft status? Rigth now, I have 3500 products that i need to change to draft status, but right now, I can only do 20 products at a time. Can you guide me about it? Thanks a lot!

  9. Rahul Sharma
    Rahul Sharma says:


    I want to know how do we bulk upload (add) products to start with. We have about 1500 SKUs and its very hard to upload them one by one. Is there any way we can bulk upload all the products. Thanks a lot!

  10. Dominick Nwosisi
    Dominick Nwosisi says:

    This is so useful Nicola, I have wasted days to sort this problem until I stumbled into your blog post. I can’t believe how easy it is to edit product categories. Thank you so much you are a life saver and really a wordpress surgeon.


Trackbacks & Pingbacks

  1. […] Yes. Refer to Bulk Editing Products. […]

  2. […] Yes. Refer to Bulk Editing Products. […]

  3. […] Yes. Refer to Bulk Editing Products. […]

  4. […] Yes. Refer to Bulk Editing Products. […]

  5. […] Có. Làm theo hướng dẫn này: How to Bulk-Edit Products. […]

  6. […] this week: How to move product attributes to after the “add to cart” button, and how to bulk edit products from the “Products” […]

  7. […] Certains gestionnaire de sites WordPress/WooCommerce ont recours à des extensions pour modifier plusieurs produits à la fois. Saviez-vous que ces tâches peuvent s’exécuter presque aussi efficacement avec des fonctions intégrées au noyau (Core) de WordPress ? Cet article vous explique comment. […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply