Mastering WooCommerce bulk edit: How to bulk edit products and variations

Mastering WooCommerce bulk edit: How to bulk edit products and variations

Are you tired of manually editing products and variations in your WooCommerce store? Bulk editing can be a lifesaver. Let’s explore how to do it using the two best WooCommerce bulk editor plugins.

In the world of ecommerce, managing an online store can be a daunting task, especially when it comes to managing products and variations. This is where bulk editing comes into the picture.

A WooCommerce advanced bulk editing plugin offers many benefits to store owners, such as:

  • Saves time and effort by allowing you to edit multiple products or variations simultaneously.
  • Increases accuracy by reducing the errors that can occur when editing each product or variation individually.
  • Makes it easier to manage and update prices, stock levels, meta fields, and other product details for stores with a high volume of inventory.
  • Streamlines seasonal changes and the implementation of promotional offers across multiple products.

In this article, we'll take a look at two of the best bulk editing plugins, WooCommerce Bulk Variations and Setary. We'll also discuss which tool to use in different bulk editing situations and how to use them to improve your online store's efficiency.

Let's get started with learning how to bulk edit products in WooCommerce!

WooCommerce Bulk Variations - best plugin to bulk edit variations on specific products

The WooCommerce Bulk Variations plugin is the ultimate tool for bulk editing variations on individual products.

Normally in WooCommerce, it's a total pain to add and edit variations for each product. You have to add information such as the variation image individually, even if you want to apply the same information to multiple variations at once.

For example, imagine that you have a T-shirt product in multiple colors and sizes, and want to add the same image for all the blue variations. You can't just select all the blue variants - you have to add the blue t-shirt image to each one individually 😩.

The <a" href="https://barn2.com/wordpress-plugins/woocommerce-bulk-variations/" target="_blank" rel="noopener">WooCommerce Bulk Variations plugin provides an excellent solution to this problem.

Barn2 WooCommerce Bulk Variations

Thanks to this WooCommerce bulk edit plugin, you can easily manage multiple variations of a single product in bulk. It adds a bulk edit tool to the 'Edit Product' page in WooCommerce. You can select any or all of the variations for a particular product, and use a bulk actions dropdowns to apply changes. This is much faster than doing it manually for each individual variation 🚀.

For example, let's say you have a t-shirt product with variations such as size and color. You can use WooCommerce Bulk Variations to:

  • Select all the variations with the 'Small' attribute and set the same regular price to them all in bulk.
  • Select all the variations with a 'Blue' attribute and bulk-apply a variation image of a blue t-shirt to them all.

WooCommerce Bulk Variations also lets you display variations in a quick buying grid on the front end of your website. This is entirely optional, and in the following tutorial I'll just be focussing on its bulk edit features.

How to bulk edit variations

  1. First, install the WooCommerce Bulk Variations plugin on your WordPress site.
  2. Activate your license key in the setup wizard, and then skip the rest of the wizard.
  3. Now go to the 'Edit Product' screen for whichever product you want to bulk edit variations.
    Edit WooCommerce product
  4. Scroll down to the 'Product data' section and open the 'Variations' tab.

Use the 'Filters' section to select the attributes for the variations that you wish to bulk edit. For example, if you're adding an image to all the blue t-shirts then select 'blue' and ignore the other filters like 'size'.

filter woocommerce product variations by main attributes to bulk edit prices

Finally, use the 'Add variation' dropdown to choose a bulk action for your WooCommerce product variations.

bulk edit woocommerce variation prices with woocommerce bulk variations plugin

As you can see, WooCommerce Bulk Variations is perfect for bulk editing variations on an individual product. However, it's not suitable for bulk editing products in bulk more generally, or variations across multiple products.

That's why I'm also going to recommend a second WooCommerce bulk edit plugin to you - Setary.

Setary - best plugin to bulk edit multiple products at once

Setary WooCommerce Bulk Editor

Setary is a powerful tool designed to save you countless hours by making bulk editing of products fast, efficient, and easy. Unlike WooCommerce Bulk Variations, Setary is a hosted platform - a SAAS. This means you make changes in a spreadsheet-like environment outside of WordPress. It has a user-friendly interface and requires no prior experience to operate.

It connects your WooCommerce store via an API, so you don't have to import or export your product data in a CSV file. Edit your products and variations in Setary, click save changes and your products will be updated automatically.

What's unique about it is that its functionality allows you to bulk update multiple products and variations at once.

Now that we've discussed Setary, let's move on to another tool called WooCommerce Bulk Variations and see what it has to offer.

How to install and set up Setary

To start using Setary to bulk edit WooCommerce products and variations, you'll need to connect it to your WooCommerce store via an API key.

The first step is to visit the Setary website and select a plan that fits your needs. You can choose between a single-site license or a 5-site license, and if you have more than 5 sites, you can contact the sales team for custom pricing.

After you've purchased a plan, follow the steps below to set it up on your website.

  1. From your Setary account, download the Setary Helper plugin and head over to your WordPress dashboard.
  2. Navigate to Plugins → Add New, upload the zip file and then install and activate the plugin.
  3. Go back to the Setary website, click Stores from the main navigation, and then click the Add Store button.
    Add stores to your Setary account
  4. Enter the URL of your store into the Store URL field and then click the Add button.
    Add store URL to connect Setary app
  5. As soon as you click the button, you'll be redirected to your website and prompted to accept the connection. Click Approve.
    Approve to connect Setary to your WooCommerce store via API
  6. You will now be redirected back to the app where you can click the Manage products or Products button to access the excel like view of all of your products.
Click Manage Products to view your product catalog in spreadsheet

Now that your WooCommerce store is connected to the Setary app, let's look at how to use it to bulk edit multiple WooCommerce products at once.

How to bulk edit products and prices in WooCommerce

Let's say you want to filter all products with the 'Small' attribute and bulk-assign the same product price to all.

Setary displays all kinds of product data in different columns. You can use the filter options to hide the extra columns and display relevant data only. This enables you to have precise control over your product catalog.

To hide extra columns, click the Columns button at the top bar and deselect checkboxes from the dropdown.

Hide unnecesary columns from Setary

Now, to filter the products, you've two options. You can either:

  • Use the top search box to filter products by keyword or phrase. This will search for products that contain the keyword or phrase in any of their data fields.
    Use the search bar at top to filter products
  • Click the filter icon in the header cell of a column to open the filter menu and select the desired filter.
    Filter columns to find the specific products

After filtering your data, you can use inline editing to modify the values of individual cells by double-clicking on them. Setary offers the flexibility to modify cells using both text and numerical data. Additionally, you can also upload product images directly from the spreadsheet view, further simplifying the bulk editing process.

What can I bulk edit with Setary?

You can modify different product fields, ranging from basic data like Product Title, Regular Price, and Sale Price to more advanced inventory fields such as Stock Quantity and Stock Status. This makes it easy to manage stock and your store inventory from a single screen. For example, you can quickly select any number of items and mark them as In Stock, Out of Stock or On Backorder, or add the exact stock level.

In our example, let's edit the regular price of all colored t-shirts that have a small size.

Changes highlighted with a blue dot

When you modify a cell, Setary highlights it with a blue dot, making it easy to see all the modifications you've made during your current editing session.

Once you're satisfied with the changes, just click Save Changes at the top, and Setary will update the prices on your website. It's that simple!

Product price updated successfully

How to bulk edit product categories in WooCommerce

Categories in WooCommerce help organize products, making it easier for customers to browse and purchase what they need.

When you have a large number of items, managing categories of individual products can take a lot of time and effort. With Setary, you can quickly bulk edit your WooCommerce product categories. Let's look at how to do this.

Start by filtering the products whose category you want to change or update. You can filter columns such as the Type and SKU to narrow the list of products.

Next, scroll horizontally to the Categories column and start typing the category names. If a category does not exist, Setary will create it for you. So, make sure to spell check before you hit Enter.

If you want to add multiple or nested categories, there are 2 rules to take note of:

  • Categories are separated by the “pipe” character: |
  • Nested categories are separated by the “chevron” character: >

For example, if you want to assign the t-shirt category under clothing, it would look like this: Clothing | Clothing > Tshirts.

Product category changes in Setary

Once you've assigned categories to all the products, hit Save Changes at the top to reflect the same on your website.

Product category successfully bulk edited

Can I bulk edit product descriptions in WooCommerce?

Bulk editing product descriptions is a commonly requested feature for WooCommerce. While Setary can be used for bulk editing product categories, pricing, and other things, it currently does not support bulk editing of product descriptions. However, according to their website, this feature is on the roadmap and expected to release soon.

Which is the best WooCommerce bulk edit plugin?

Mastering bulk editing in WooCommerce can save you time and streamline your workflow. With the help of WooCommerce bulk edit plugins like Bulk Variations and Setary, you can easily modify your product catalog with a few clicks.

  • Want to bulk-edit variations for a specific product from the WordPress Dashboard? <a" href="https://barn2.com/wordpress-plugins/woocommerce-bulk-variations/" target="_blank" rel="noopener">WooCommerce Bulk Variations is a great plugin for this. It lets you modify or add attribute values to multiple variable products at once, upload the same image to multiple variations in one click, and optionally display variations on the product page in an easy-to-navigate grid layout. Additionally, it comes with a 30-day money back guarantee, so you can try it out risk-free.
  • Want to bulk edit multiple products at once? <a" href="https://barn2.com/go/setary" target="_blank" rel="noopener">Setary is hosted solution that works in a spreadsheet-like view, making it easy to make changes to multiple products and variations.

Overall, the benefits of bulk editing in WooCommerce cannot be overstated. It can save you time and effort by letting you change multiple products or variations at once. It can also improve accuracy and efficiency by reducing the errors that may occur when updating product information.

We hope this tutorial has helped you understand the benefits of bulk editing in WooCommerce and how to use it effectively. Happy selling! 😊

Please share your thoughts...

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