To bulk edit WooCommerce shipping classes, you can use WP Sheet Editor to find products assigned to a specific shipping class and replace it with another one. This allows you to update multiple products at once instead of editing them individually.
For example, you can change the shipping class of all products assigned to “Mailbox” to “Bulky” or “Heavy”. You can also update shipping classes for specific product variations or remove existing shipping class assignments.
1. Install WP Sheet Editor for WooCommerce Products
We’ll use WP Sheet Editor for WooCommerce Products to search for products and bulk update their shipping classes.
The plugin displays your WooCommerce products in a spreadsheet and includes a Bulk Edit tool for changing product fields, including shipping classes.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing and activating the plugin, go to WP Sheet Editor > Edit Products to open the spreadsheet.
2. Find the WooCommerce Products You Want to Update
Click Search on the spreadsheet toolbar to find the products whose shipping classes you want to change.
In this example, we’ll find all products assigned to the Heavy shipping class.
- Find the Enter Brands… Shipping classes field.
- Select Heavy.
- Click Run search.
You can combine the shipping class filter with other search criteria, including product categories, keywords, tags, and attributes.
Once you run the search, the spreadsheet will display the products matching your filters.
How to Find Specific WooCommerce Product Variations
If you want to change shipping classes for product variations, enable the Search on variations checkbox in the Search tool.
You can combine this option with filters such as Contains keyword, Status, and Enter tags to find specific variations.
For example, you can search for variations containing a particular size or color instead of editing all variations of a variable product.
3. Bulk Change WooCommerce Shipping Classes
After filtering the products, click Bulk Edit on the spreadsheet toolbar.
Configure the Bulk Edit tool using these values:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Shipping class.
- Select type of edit: Set value.
- Replace existing value with this value: Select the new shipping class, such as Bulky.
- Select Edit only parent products or Edit only variations, depending on the products you searched for.
- Click Execute now.
WP Sheet Editor will update the shipping class of the matching products.
In our example, products previously assigned to the Heavy shipping class will now use the new class selected in the Bulk Edit tool.
How to Bulk Remove Shipping Classes from WooCommerce Products
You can also use WP Sheet Editor to remove shipping class assignments from multiple products.
- Use the Search tool to find the products you want to update.
- Open Bulk Edit.
- Select Edit all the rows from my current search.
- Choose Shipping class as the field to edit.
- Select Clear value as the edit type.
- Choose whether to edit parent products or variations.
- Click Execute now.
This removes the shipping class assignment from the matching products without deleting the shipping class itself from WooCommerce.
Bulk Edit WooCommerce Shipping Classes with WP Sheet Editor
WP Sheet Editor allows you to bulk change or remove WooCommerce shipping classes using product filters and the Bulk Edit tool. You can update parent products or specific product variations without opening each product individually.
Use WP Sheet Editor for WooCommerce Products to manage shipping class assignments across your product catalog.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features