Let’s see how to bulk edit product weight for an entire category in WooCommerce. We will do it using an intuitive spreadsheet on WordPress.
Let’s imagine you manage a WooCommerce store for customers, and the products have changed weight or your customers need you to add the weight of the products to all the products that belong to a specific category.
If you try to do this with WooCommerce only, it will take you a lot of time because you have to find the products in a category, open them, and edit them one by one.
Luckily, the WP Sheet Editor – WooCommerce Products plugin allows you to view and edit your WooCommerce product data in a spreadsheet within WordPress.
You can save a lot of time managing thousands of products in a simplified interface that contains advanced search, bulk editor, export and import tools.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing the plugin and activating your license, you need to follow the steps below in order to bulk update product weight by category.
1- Open the WooCommerce products spreadsheet
The first thing we need to do is open the spreadsheet to view and edit our WooCommerce products.
To do this, go to WP Sheet Editor > Edit products.
You will see all the products of your WooCommerce store displayed in the spreadsheet.
2- Search for products by category
Since we want to update the product weight for all products belonging to a specific category, we must filter our products by category.
To do this, we need to open the Search tool.
Now we must select these values to search our products by category:
- Enter the product category in the Enter product categories field. In this example, we will search for all the products in the Clothing category.
- Click on Run search.
After running the search, you will see all the products belonging to the selected category displayed in the spreadsheet.
You will see the active search filters displayed above the spreadsheet.
After filtering your WooCommerce products by category, you can proceed to update the weight of the products massively.
To do this, you have at least two options, which we will consider below.
Option 1 – Edit product weight by category using the spreadsheet
The first way to edit the weight of the products is by using the spreadsheet. This is useful if you want to add a different weight to each product.
Just go to the “Weight” column and start entering the values for each product.
Once you finish editing the products you want, you should apply the changes by clicking Save.
Although this is a way to update products individually, you will save a lot of time because you don’t have to open the products and edit them one by one.
You can edit the values as if you were using Excel or Google Sheets, and save the changes once for hundreds of products.
Option 2 – Edit product weight in bulk by category
The second option to edit the weight of the products is to use the “Bulk Edit” tool. This tool allows you to edit any field in hundreds of products at once.
This is useful if you want to set the same product weight for all products in a specific category.
To do this, you have to start by opening the Bulk Edit tool.
You must now select these values to update the weight of the products in an entire category:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Weight
- Select type of edit: Set value
- Replace existing value with this value: Enter the product weight you want to set to all the products from the selected category.
- Optional – You can select any of these two options:
- Edit only parent products
- Edit only variations
- Click on Execute now.
This is how you can bulk edit product weight for an entire category with WP Sheet Editor – WooCommerce Products.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features