How to set up ELEX Bulk Edit Products, Prices & Attributes for WooCommerce plugin? (with Video)

This article explains the step-by-step tutorial to set up ELEX Bulk Edit Products, Prices & Attribute for WooCommerce. For more information on the plugin, refer the product page.

If you have a large number of products, it becomes difficult to edit, update or even manage those products. For example, if you have products with lots of variations, it is a tough job to update all the attributes and variations to the products. Hence you need a solution (or plugin in WordPress terminology) that saves you time and trouble. The ELEX Bulk Edit Products, Prices & Attributes for WooCommerce is just the right plugin for the job.

 

Overview

Here are some of the major highlights of this plugin:

  • Bulk Edit Products: You can bulk edit/update product properties like –
    • Product title
    • Product SKU
    • Product visibility
    • Shipping class
    • Sale Price and Regular Price
    • Managing stocks
    • Stock quantity
    • Allowing backorders
    • Stock status
    • Product Length, Width, Height, and Weight
    • Global product attributes
  • Product Filters: The plugin provides filters to bulk edit products by product title, product types, product categories (optional sub-categories), global product attributes, and product regular price(s).
  • Undo Update: You can revert the update back to its initial state with just a single click. Enable this setting to be able to undo settings update.
  • Product type: The plugin supports Simple and Variable products (parent and variations) for bulk edit.
  • User Role based Bulk editing: You can bulk edit prices based on user roles using the ELEX WooCommerce Catalog Mode, Wholesale & Role Based Pricing plugin along with ELEX Bulk Edit Products, Prices & Attributes for WooCommerce plugin.

All the above features (and many more!) are bundled to serve you to bulk edit WooCommerce products on your store.

Getting started with ELEX Bulk Edit Products, Prices & Attributes for WooCommerce

You can access the plugin settings in either of the following two ways:

  1. WordPress Dashboard > WooCommerce > Bulk Edit Products.
  2. WordPress Dashboard > Plugins > Installed Plugins > ELEX Bulk Edit Products, Prices & Attributes for WooCommerce > Bulk Edit Products.

The bulk edit process comprises of 4 simple stages, as explained below.

1. Filtering the Products

The first step is to filter the products that you want to edit in bulk. The plugin provides the following filters to do the job.

WooCommerce Bulk Edit Products | Filtering the Products

Filtering the Products

  • Product Title: Allows you to filter products with the product titles that Starts with, Ends with or Contains the text expression.
    You can also filter using Regular Expression match. The syntax for regular expression match is [regularexpression]. For example, if you have to search for product titles containing numbers, then your search pattern should be [0-9]. Read the PHP Regular Replace Manual for more patterns and their syntax.
  • Product Type: You can select from Simple, Variable (Parent) or Variable (Variation) product types for filtering.
  • Product Categories: Select the desired product categories that you have created in your WooCommerce store. Additionally, you can tick the Include Subcategories option to include sub-categories of the selected product categories.
  • Product Attributes: If you have created global attributes in your WooCommerce Attributes settings, they will be shown in this setting. You can use the global product attributes to filter the products for editing. Once you have selected an attribute, you can select desired Product Attribute Values for deeper filtering.
    Remember, only the global product attributes (if created) will be displayed in this setting. If no global attributes are created, this setting will not show any options.
  • Product Regular Price: Filter products with Product regular price using the following conditions –
    • All – Includes all products.
    • >= – Includes products with value, greater than or equal to the entered price.
    • <= – Includes products with value, lesser than or equal to the entered price.
    • == – Includes products with the value exactly equal to the entered price.
    • || Between – Enter the minimum and maximum regular price value to filter the products.

Once the above filters are configured, click on Preview Filtered Products button.

[Tip: Click on Reset Filters button on the bottom left corner to reset filters to its initial state.]

2. Previewing the Products

The preview stage is necessary to examine whether the filtered products are the ones to be edited.

WooCommerce Bulk Edit Products | Previewing the Products

Previewing the Products

If you are not satisfied with the filtered result, you can click on the Back button, to go back and apply new filters. Else, click Continue to proceed to the next step.

3. Editing the Products

In this panel, you can update several properties of the products filtered in the previous steps.

The product properties and its values that can be updated are:

WooCommerce Bulk Edit Products | Editing the Products

Editing the Products

Generic properties

  • Product Title: You can update Product titles with the following options –
    • Set New – Set a new product title for the products.
    • Append – Add custom text at the end of the existing product title.
    • Prepend – Add custom text at the beginning of the existing product title.
    • Replace – Replace certain words or full product title with the entered text.
    • RegEx Replace – Replace the entered regular expression pattern with the entered replacement value. More on the regular expression pattern in the respective PHP manual.

For example, I’ll prepend the text “My ” to the title of all the T-Shirts.

WooCommerce Bulk Edit Products | Updating Product Title

Updating Product Title

Here’s what it will result in after I click Update Products.

WooCommerce Bulk Edit Products | Product Title Updated

Product Title Updated

  • SKU: Update Product SKU information with the following options –
    • Set New – Set a new product SKU for the products.
    • Append – Add custom value at the end of the existing product SKU.
    • Prepend – Add custom value at the beginning of the existing product SKU.
    • Replace – Replace certain words or full product SKU with the entered value.
    • RegEx Replace – Replace the entered regular expression pattern with the entered replacement value.

For example, I’ll replace the letter “A” in the product SKU “A201” to “B”.

WooCommerce Bulk Edit Products | Updating Product SKU

Updating Product SKU

This will result in product SKU value as “B201”.

WooCommerce Bulk Edit Products | Product SKU updated

Product SKU updated

  • Product Visibility: Select from the following visibility options for the filtered products, on the Catalog/Search page.
    • Shop and Search – Filtered products will be available in both the shop page and store’s search results.
    • Shop – Available only on the shop page.
    • Search – Available only in store’s search results.
    • Hidden – The filtered products will be hidden from the shop completely.

For example, I’ll change the visibility of all the T-Shirts to Catalog only.

WooCommerce Bulk Edit Products | Updating Product Visibility

Updating Product Visibility

The below screenshot shows the product is visible in Shop page.

WooCommerce Bulk Edit Products | Products Available on the Shop page

Products Available on the Shop page

But when I search for the product in the search bar, the product is not found, as shown in the screenshot below.

WooCommerce Bulk Edit Products | Products not available in Search results

Products not available in Search results

  • Shipping Class: Select the desired shipping class for the filtered products. If a shipping class is already assigned to a product, it will be replaced. Remember, if you have not created any Shipping class in your WooCommerce setting, no value will be shown in this dropdown list.

For example, I’ll apply the T-Shirt Class to the filtered T-Shirt products.

WooCommerce Bulk Edit Products | Updating Shipping Class

Updating Shipping Class

The result will be as shown in the screenshot below.

WooCommerce Bulk Edit Products | Shipping Class Updated

Shipping Class Updated

Price properties

  • Sale Price: You can adjust the sale price with the following values –
    • Increase by Percentage (+ %)
    • Decrease by Percentage (- %)
    • Increase by Price (+ $)
    • Decrease by Price (- %)
    • A Flat Price for All the products

For example, I’ll increase the Sale price of the T-Shirts by $3.

WooCommerce Bulk Edit Products | Updating Sale Price

Updating Sale Price

The updated sale price is as shown in the below screenshot.

WooCommerce Bulk Edit Products | Sale Price Updated

Sale Price Updated

  • Regular Price: You can adjust the regular price with –
    • Increase by Percentage (+ %)
    • Decrease by Percentage (- %)
    • Increase by Price (+ $)
    • Decrease by Price (- %)
    • A Flat Price for All the products

For example, I’ll apply a flat price of $20 for all the T-Shirts in my store.

WooCommerce Bulk Edit Products | Updating Regular Price

Updating Regular Price

The updated regular price for all T-Shirts is shown in the screenshot below.

WooCommerce Bulk Edit Products | Regular Price Updated

Regular Price Updated

For the range values (increase and decrease) you can choose to round up, round down or apply no rounding at all.

Stock properties

  • Manage Stock: You can choose to enable or disable stock management for all the filtered products and variations.
  • Stock Quantity: You can bulk update the stock by either adding, subtracting or replacing the stock value.

For example, I’ll increase the stock quantity of T-Shirts to 20.

WooCommerce Bulk Edit Products | Updating Stock Quantity

Updating Stock Quantity

The updated stock quantity is as shown in the below screenshot.

WooCommerce Bulk Edit Products | Stock Quantity Updated

Stock Quantity Updated

  • Allow Backorders: You can choose from the following options for backorders processing –
    • Do not Allow
    • Allow, but notify the Customer
    • Allow
  • Stock Status: Update the stock status for the filtered products as In stock or Out of stock.

For example, I’ll update the stock status of all my T-Shirt products to Out of Stock.

WooCommerce Bulk Edit Products | Updating Stock Quantity

Updating Stock Quantity

Here’s how the stock status will be updated.

WooCommerce Bulk Edit Products | Stock Quantity Updated

Stock Quantity Updated

Weight & Dimensions properties

  • Length/Width/Height: You can add, subtract or replace the existing length/width/height of the filtered products in bulk.

For example, I’ll replace the existing length of all my T-Shirt products to 24 inches.

WooCommerce Bulk Edit Products | Updating Product Length

Updating Product Length

The updated length size of T-Shirts will be as shown in the below screenshot.

WooCommerce Bulk Edit Products | Product Length Updated

Product Length Updated

  • Weight: Add, subtract or replace the existing weight of the filtered products in bulk.

Attributes

If you have created custom global attributes, you can add, remove or replace them with the existing ones to all the filtered products in bulk.

  • Attribute Action – Select desired action from Add. Remove or Replace to make changes.
  • Attributes – Once an action is selected in the previous setting, global product attributes will be shown here. Tick the desired attribute checkbox to apply changes.
  • Product Attributes Values – The values of the respective attributes chosen in the previous setting is listed in this setting. For example, if you have an attribute called ‘Color’, then its values can be different colors like red, blue, yellow, green and so on.
    This setting helps in choosing only a specific attribute value for adding, removing or replacing values to all the filtered products.
  • New Attributes Values – If you wish to add new attribute values for your products, you do not need to go to your WooCommerce Attributes settings. However, if you need to add a new Product attribute, you should use the default WooCommerce Attributes settings.
    With this setting, you can add or replace new attribute values. You can add or replace multiple values by entering one value in each row.
  • Used for Variation –  You can choose to enable or disable whether the newly added attributes should be used for variation or not.

For example, I’ll add the new product attribute ”Size” (which I created in WooCommerce Attributes settings) to all my products. In addition to this, I’ll create new Size attributes values like Small, Medium, and Large, and apply the same, and use the same attributes for variation purpose as well.

WooCommerce Bulk Edit Products | Adding Attributes & Values to Products in Bulk

Adding Attributes & Values to Products in Bulk

The updated product page with new attributes will be as shown in the screenshot below.

WooCommerce Bulk Edit Products | New Attribute & Values added to Product

New Attribute & Values added to Product

[Tip: Click on Reset Values button located on the bottom to reset field values to its initial state.]

Once all your settings are configured, click Update Products.

4. Reaching the Finish line

Once all your filtered products are updated, you’ll see a success message indicating that all the products are updated.

WooCommerce Bulk Edit Products | Products updated successfully

Products updated successfully

How to Undo the Last Update?

If you are not happy with the last update to your products, you can revert back the changes easily.

To do this, read the instructions below:

  • Tick the Enable Undo Update check box in the product editing stage. This checkbox is present on the top right corner of the editing screen as shown in the screenshot below.
WooCommerce Bulk Edit Products | Enable Undo Update

Enable Undo Update

Remember, you can only undo the last update if you had updated the products with the checkbox being enabled.

  • To undo the last update, go to the first screen used for filtering the products and click on Undo Last Update button, as shown in the below screenshot.
WooCommerce Bulk Edit Products | Undo the Last Update

Undo the Last Update

  • In the next step, you’ll be shown all the changes that you have made in your last update. If you have made multiple updates, tick the respective checkbox of the setting you want to revert back to its previous state.

In the below screenshot, my last update was applying a new attribute ‘Size’ to all the filtered products.

WooCommerce Bulk Edit Products | Last updated Product property

Last updated Product property – Attributes

Click Continue and confirm your action to proceed further.

  • If the undo operation is successful, you will see a pop-up window showing the success message, as shown in the screenshot below.
WooCommerce Bulk Edit Products | Proceed with Undo Update

Proceed with Undo Update

The ‘Size’ attribute will no longer be available for the products.

WooCommerce Bulk Edit Products | Size attribute is no longer available

Size attribute is no longer available for the product(s)

 


To explore more details about the plugin, go check out ELEX Bulk Edit Products, Prices & Attributes for WooCommerce.

You can also check out other WooCommerce and WordPress plugins in ELEX.

    Leave a Reply