WooCommerce – How to Edit Product Weight for an Entire Category

posted in: Guides | 0

If you have hundreds of products within a category, maybe you’re having trouble with the idea of editing product weight in all those products. For example, your client has asked you to edit product weight on all the products within the Technology category, but you have two hundred different products in that category. That will take several hours to complete, and you’ll have to open product by product to edit its weight.

However, in this article we’ll show you how you can edit product weight on products within an entire category. We’ll show you how to edit individual products quickly and how to apply the same weight to thousands of products at once.

1- Install the Sheet Editor Plugin

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and you can edit freely.

You can skip this step if you already have the plugin installed and activated.

You can download the plugin here:

- or - Read more about it

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes.

Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

Once you open the plugin, you’ll see a spreadsheet with all your products and their detailed information.

4- Open the “Apply changes in bulk” tool

Whenever you want to edit hundreds of products at once, you need to use the “Apply changes in bulk” tool. So you need to open it by clicking the button above the spreadsheet.

5. Edit weight for an entire category in simple products

If you want to edit product weight for all the products within the Technology category, you need to filter your products.

a) Open the Select rows tool to filter your products

To filter the products you need to use the “Select rows” button after opening the “Apply changes in bulk” tool. This button will help you search for the products you need to modify.

b) Look for the product category

Once you open the “Select rows” button, you need to write the product category you want to edit.

Do it by writing the category in the “Enter technology category” field. For example if you have a Technology category, just write Technology in the “Enter product category” field.

Then just hit the “Run search” button.

c) Set the new values

After filtering the products by category, you need to set these values in order to edit your products’ weight:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select Weight as the field you want to edit.
  • Select “Set value” in the Type of edit.
  • Write the new Weight  (0.5 for example).
  • Hit the “Execute now” button.

After that, you’ll see that all your chosen products will be modified.

6- Edit product weight for an entire category in variable products

If you want to edit weight for an entire category of variable products, you first need to open the “Apply changes in bulk”.

a) Open the Select rows tool to filter your products

To filter the products you need to use the “Select rows” button after opening the “Apply changes in bulk” tool. This button will help you search for the products you need to modify.

b) Look for the product category

To look for your product category, just write it in the “Enter product category field.”

For example, you can write “Technology” to select all the products within that category.

After filtering the products by category, you need to set these values in order to edit your products’ weight:

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select Weight as the field you want to edit.
  • Select “Set value” in the Type of edit.
  • Write the new wright (0.5 for example).
  • Check the “Execute formula only on product variations” checkbox.
  • Hit the “Execute now” button.

After that, you’ll see that all the product variations matching the search were modified, now they have the same weight. You can do this for thousands of variations quickly.

How simple!

With WP Sheet Editor, it’s really simple to edit weight for an entire category of products or variations.

You can download the plugin here:

- or - Read more about it

Leave a Reply