Posted on

How to bulk edit products

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.

product-bulk-actions

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:

bulk-edit-products

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.

13 thoughts on “How to bulk edit products

  1. […] 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. […]

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

  3. Hello,
    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?
    Thanks

    1. Hi Xavi,
      thanks!

      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

  4. Hello,
    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).

    img1:
https://immograf.com/wp-content/uploads/2015/07/1.jpg
    img2:
https://immograf.com/wp-content/uploads/2015/07/2.jpg
    img3:
https://immograf.com/wp-content/uploads/2015/07/3.jpg

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

    1. 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 WordPress.org support forum for this.

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

  5. Thank you so much. Your article saved me a lot of time !

    1. You’re welcome Benedicte!

  6. 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!

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

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

    Thanks!

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

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *