Rating 0 stars - 0 votes

Bulk WooCommerce Product Update via Mass Changer: Detailed Tutorial

One of the most important things you can do in terms of catalog management is bulk WooCommerce product update. Perhaps you are planning a sale with 25% off all the merchandise, or suppliers have changed base product cost and you need to synchronize with them, or descriptions are not complete and you have to renew them. Whatever the case is, single product editing will not be a way out. WooCommerce Mass Product Changer will do all the manipulations massively.


WooCommerce Mass Product Changer: Overview

Mass Product Changer has been developed to simplify WooCommerce bulk product updates. It is one of the many tools provided by Store Manager for WooCommerce.


Store Manager for WooCommerce is a downloadable application that enhances the default WooCommerce functionality with tools for bulk edits, advanced import/export, database backup, data generation, and others.

If you don’t have Store Manager yet, download a free trial and install it on your computer. Connect the application to your store database and enjoy the simplicity of your store administration.


How to make bulk updates with the Mass Changer tool:

  1. Specify what entities to update - those you've selected or all products in the catalog.

  2. Select a field that you want to update.

  3. Select an action to be applied to the selected field.



  4. Preview and apply the changes.

woocommerce-mass-changer-steps


woocommerce-mass-changer-steps


Here is a list of the fields that can be updated with Mass Changer:

  • Back orders
  • Product description/Short description
  • Product Reviews (Enable/Disable)
  • Featured Image
  • Height/Length/Weight/Width
  • Manage Stock
  • Name
  • Purchase Note
  • Regular Price
  • Sale Price/Sale price period
  • SKU
  • Stock/Stock Status
  • Tax Class/Tax Status
  • Sold Individually
  • Shipping Class

Now when you know how WooCommerce Mass Product Changer works, let's try to update various fields and apply mass actions to them.


Set Stock for Multiple WooCommerce Products

To set product quantity for multiple products, follow these steps:

  1. Select products and run Mass Product Changer.
  2. Select the "Stock" field in the dropdown.
  3. Select the "Set to" action.
  4. Apply the changes and check results.

WooCommerce Store Manager Mass Changer Quantity Update
Set Product Stock (Quantity) for Multiple Products


Massively Enable and Disable Backorders for WooCommerce Products

When WooCommerce products run out of stock, you can enable backorders for customers to be able to buy these products. Mass Product Changer handles backorders so you can enable, disable backorders or allow backorders with parallel customer notifying.

  1. Select products and run Mass Product Changer.
  2. Select the "Backorders" field in the dropdown.
  3. Select an action (only "Set to" is available as you have noticed) and then a field option: "Allow", "Do not allow" or "Allow but notify customer".
  4. Apply the changes and check results.

Backorders Change via WooCommerce Mass Changer Tool
Backorders Change via WooCommerce Mass Changer Tool


Bulk Update WooCommerce Price

WooCommerce product price update is probably one of the most typical tasks in WooCommerce. And Mass Product Changer is highly flexible in terms of WooCommerce bulk price update. It allows you to increase/decrease prices by value or percentage, set a fixed price for the selected products.


For example, to increase prices by a certain percentage, we need to do the following:

  1. Select products and launch WooCommerce Mass Product Changer.
  2. In the dropdown, select the Regular Price field.
  3. Select the action "Increase by %" and enter a value (in our example, it's 10%).

  4. The Increase Price Value in WooCommerce Mass Changer
    The Increase Price Value in WooCommerce Mass Changer

  5. Preview the new price and click OK to apply it.

  6. Preview Changed Price via WooCommerce Mass Changer
    Preview Changed Price via WooCommerce Mass Changer

Massively Add Product Short Description Text

If your products are missing short description and you want to add it, the Mass Product Changer tool offers several options. A simpler way is to massively add the same short description text to all products.

  1. Select products and run Mass Product Changer.
  2. Select the Short Description field in the list.
  3. Select the option Set to and enter text in the next field. You can use the HTML editor to format the text.

  4. WooCommerce Store Manager Mass Add Short Description
    WooCommerce Store Manager Mass Add Short Description

  5. Apply changes.

Massively Generate Product Short Description Based on Product Name and SKU

At times there is a necessity to provide short description to products missing it. Mass Product Changer allows to compose short description via an expression - special SQL statement. For example, unique short description will be created if we join product name, SKU and add “WooCommerce” word. Here is the scheme:

  1. Choose necessary items and run Mass Product Changer.
  2. Select Short Description as the field to be changed.
  3. Move to "Actions" dropdown and select Expression option.
  4. Press Expression Editor button and build formula applying which will return necessary value for Short Description field.

  5. Expression Formula for WooCommerce Short Description Mass Update
    Expression Formula for WooCommerce Short Description Mass Update

  6. Apply changes.

Find more tips on how to put WooCommerce products on sale.


Bulk Update Product SKU

This example demonstrates how to use the "Replace" action. Some listings in our catalog have "_yyy_" symbols in SKU. Our aim is to substitute these symbols with "_test_" for example. See, what we proceed with:

  1. Open Mass Product Changer.
  2. Check "Update All Items in Store" radio button, since there are lots of products and we do not know which exactly items have "VEND" in SKU.
  3. Select "Replace Value" action in the following dropdown.
  4. Paste text to be replaced in the following field.
  5. Specify new text, the one that will appear in SKUs after bulk WooCommerce product update.

  6. Modify SKU via WooCommerce Mass Changer
    Modify SKU via WooCommerce Mass Changer

  7. Accomplish update pressing OK button below in WooCommerce Mass Product Changer.

Read more on how to bulk replace data in WooCommerce via Store Manager


Set Sale Price for Multiple Products

Whenever sale season is around the corner, you are usually getting ready with discounts. This sample is just for you. Sale price configuring takes seconds with WooCommerce Mass Product Changer.


  1. Select the items to assign sale price to and open Mass Product Changer.
  2. Choose "Sale Price" field from the dropdown.
  3. Choose "Use Expression" in the action dropdown.
  4. Insert expression to fill sale price for selected WooCommerce products.

  5. Set Sale Price With WooCommerce Mass Changer
    Set Sale Price With WooCommerce Mass Changer

  6. Save changes to get sale price applied in Mass Product Changer.

Mass Product Changer makes bulk updates more approachable and convenient, since it allows to update any product related fields or even customize changes creating expressions.


Update WooCommerce Products via Mass Product Changer FREE

Get It Now

Related Articles:
Card image
How to Bulk Replace Data in WooCommerce

Learn how to bulk replace data in WooCommerce (WordPress) – text, images, slug andother fields. Read More...

Card image
Bulk Change WooCommerce Image Alt Text

How to bulk change image Alt text and Other image attributes in WooCommerce. Read More...

Card image
How to Bulk Add WooCommerce Variations

Learn how to add and generate variations via Store Manager for WooCommerce. Read More...

Card image
Update WooCommerce Product Tags In Bulk

How to update WooCommerce product tags in bulk using WooCommerce Product Tags Mass Changer.Read More...

COMMENTS
Be the first to comment.
COMMENTS
Be the first to comment.