How To Bulk Edit Attributes, Products, Prices & Categories in WooCommerce

We know how painful it is to manually update or assign attributes to an exorbitant number of products on your WooCommerce store.

However, this shouldn’t stop you from selling more products. While it might sound daunting, the way forward can be made easier through a plugin that can do the heavy lifting for your business.

To make the way forward easier for you, we have compiled the most vital information about how to bulk edit attributes, product prices, categories and a lot more in WooCommerce.

Attributes vs. variations: key differences

Initially, WooCommerce for beginners could get confusing and overwhelming.

Allow us to simplify the same with an example.

Attributes are characteristics that define a product. On the other hand, variations are products created based on attributes.

For example, a red-colored, XL size T-shirt is a product variation created based on attributes ‘Color’ and ‘Size’.

You can create hundreds and thousands of product variations based on attributes. But with default WooCommerce, you can add up to 50 variations at a time.

Streamlining bulk editing with Smart Manager

As a store owner, there is a lot to do every day! To ensure that the business continues to thrive, you must ensure that everything is on track!

Besides that, we know how annoying it is to edit products one by one. Imagine the hassle of doing the same for each product.

The default WooCommerce allows bulk editing only for simple products. The bulk editing is limited to only the following aspects – price, tax, size, weight and others.

You can’t bulk edit attributes such as predefined product attributes or custom attributes. The filtering option is also not that good.

So, with the help of the Smart Manager plugin, you can easily bulk edit attributes – add, remove and overwrite them in no time.

Smart Manager provides an Excel-like spreadsheet (sheet editor) to manage your WooCommerce store.

Be it products, orders, coupons, users, or any WordPress post type, you can directly make edits.

However, the biggest USP of Smart Manager is the Bulk Edit/Batch Update feature.

How to bulk edit attributes with Smart Manager?

Let’s see how you can bulk manage and edit attributes in WooCommerce using Smart Manager:

Add/remove existing attributes in bulk

1. Suppose you ordered ten new blue-colored T-shirts for the holiday season. To set attributes for these products in one shot, go to your WordPress Admin panel > Smart Manager. Select Products dashboard from the dropdown.
2. Select the required products. If you have more than tens or hundreds of products, use advanced search to get all those products quickly. Click on the Bulk Edit option. It will open up a slide-over panel.



3. Select Add attribute > Color > Blue and click Update as shown in the image above. All these T-shirts will be assigned a Blue color.

Similarly, if you have thousands of products and want to add all of them to pre-configured attributes in one go, use the bulk edit functionality mentioned above.

Add custom attributes in bulk

Consider the same example above. But here, all the blue T-shirts are printed with Avengers’ weapons. Using the Bulk Edit option, you can add a custom attribute ‘Avengers Print’ for all products at once.

Assign multiple attributes based on search filters

You are selling a vast range of electronic items and you want to assign attributes only when the product category is a laptop, belonging to the Dell brand, each having a price above $700.

1. Go to your WordPress Admin panel > Smart Manager. Select Products from the drop-down on the Navigation Bar at the top.
2. Now click on the Advanced Search toggle. It will open up a slide-over panel. Enter the search conditions as shown in the below image and click on Search.



3. Only your required products will be listed. Now, as mentioned earlier, select these products, click on Bulk Edit and enter the conditions as shown in the image below.
4. Click on the Update button.

All your required products will be assigned the attributes you want to add. Quite easy, right?

You can also remove attributes from products or copy attribute values from products using the same steps.

Try Smart Manager live demo

How to bulk edit products with Smart Manager?

Follow the steps you read above for bulk editing attributes. Here, instead of attributes, you can bulk edit product stock, SKU, assign a category, tax status, backorders, and more.

Refer to this bulk editing products blog for more details.

How to bulk edit prices with Smart Manager?

Using Smart Manager, you can bulk edit both the regular price and sale price fields.

Increase or decrease prices by % or fixed amounts, set sale price same as regular price, edit prices based on product categories, edit sign-up fees and recurring fees for subscription products and much more.

Edit product prices based on attribute filters

Smart Manager also allows you to instantly search products based on attributes and make an edit or update price in bulk.

For example, reduce the sale price by 10% of all wristwatches having a square dial and stainless steel belt. Here, the dial and belt are attributes.

Refer to this bulk editing prices blog for more details.

How to bulk edit categories with Smart Manager?

As with other processes, editing categories in bulk with Smart Manager has also been easier than ever.

Select whether – ‘set to, add to, remove from, copy from, copy from field‘ applies to your requirement and select the appropriate category.

For example, you want to bulk set Clothing category to specific products on your store.

Refer to this bulk editing categories blog for more details.

Other powerful Smart Manager features

• Bulk edit any fields of any post type – products, orders, coupons, posts, subscriptions, bookings, etc.
• Export CSV based on search, date and column filters.
• Duplicate any post type and make edits to them.
• Add your logo to packing slips/order printing and also print the same in bulk.
• View all orders on the screen, change order statuses, add new custom orders and bulk edit them. More about order management.
• Know the lifetime value (LTV) of all your customers along with their total purchases to date and last order details.
• Smart Manager allows you to update many items at once directly from the grid. Moreover, it also helps in editing multiple column values using the auto-fill option or by using copy-paste and saving it all at once.
• Compatibility with top WooCommerce & SEO plugins – Subscriptions, Bookings, Yoast, etc.
• Bulk stock management allows you to set backorders, delete products, filter and bulk edit stock for many WooCommerce products and variations at once.
• Undo bulk edits and inline edits.

There is certainly a lot more to the plugin! Try out Smart Manager and see the difference for yourself!

Get Smart Manager plugin

Conclusion

If you have a WooCommerce store that has endless products, Smart Manager is a saving grace for each business owner.

Not just attributes, but anything you want to manage better and faster can be taken care of with just a click! Be it prices, orders, coupons, users, posts and more.

Smart Manager won’t fail you!

Until we come with another post, happy growing!