How To Bulk Edit Products, Prices and Attributes on WooCommerce — Wordpress

Bulk Edit Products, Prices and Attributes

Overview

  • Bulk Edit Products: You can bulk edit/update product properties like –
  • Product title
  • Product SKU
  • Product visibility
  • Featured product
  • Change Product Type
  • Shipping class
  • Description action
  • Short description action
  • Product image
  • Product gallery images action
  • Product Visibility Status
  • Sale Price and Regular Price
  • Managing stocks
  • Stock quantity
  • Allowing backorders
  • Stock status
  • Product Length, Width, Height, and Weight
  • Global & Custom product attributes
  • Tax status & Tax class
  • Interchange Attribute Values of Product Variations
  • Create Variations from All Attributes
  • Category actions
  • Delete action
  • Product Filters: The plugin provides filters to bulk edit products by product title, product tags, product types, stock status, product categories (optional sub-categories), global product attributes, product regular price(s), and Description & Short description.
  • 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, Variable products (parent and variations), and External products for bulk edit.
  • User Role based Bulk editing: You can bulk edit prices based on user roles using the plugin.

Getting started

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

Filter the Products

  • Product Title: This allows you to filter products with the product titles that Starts with, Ends with, or Contains the text expression.
    You can also filter using a 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 syntax.
  • Product Tags: You can choose various product tag or tags for filtering products.
  • Product Types: You can select from Simple, Variable (Parent) or Variable (Variation), or external product types for filtering.
  • Stock Status: You can filter products based on their current stock status such as In Stock, Out of Stock, or On Backorder.
  • 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 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.
  • Description: It allows you to filter products with the product descriptions that Starts with, Ends with, Contains, or Regex match with the text expression.
  • Short Description: It allows you to filter products with the product short descriptions that Starts with, Ends with, Contains, or Regex match with the text expression.
  • Product Attributes: If you have created global attributes in your WooCommerce Attributes settings, they will be shown in this setting. You can use global product attributes to filter the products for editing. Once you have selected an attribute, you can select the desired Product Attribute Values for deeper filtering.
    You can group the attributes in OR and AND operations. The OR grouping with filter products that have either of the selected attribute & attribute values, whereas the AND grouping will filter products that have all the selected attribute & attribute values.
  • Custom Attributes: If you have created custom attributes in the Attributes settings on the individual product pages, they will show in this setting. You can use custom attributes to filter the products for editing.
  • Exclusions: Tick this checkbox to reveal further settings. You can exclude certain products from the filtered products, by specific their product IDs or selecting a specific category itself.

Preview the Products

Edit Products

Bulk Edit WooCommerce Product Title

  • 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.

Bulk Edit Product SKU Settings

  • 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.

Bulk Edit Product Visibility

  • Shop and Search — Filtered products will be available on both the shop page and the store’s search results.
  • Shop — Available only on the shop page.
  • Search — Available only in the store’s search results.
  • Hidden — Filtered products will be hidden from the shop completely.

Bulk Edit Featured Product Option

Bulk Edit Product Type

Bulk Edit Product Shipping Class

Bulk Edit Product Description & Short Description

Bulk Edit Product Image

Bulk Edit Product Gallery Images

Bulk Edit Product Visibility Status

Bulk Edit Product Price Properties

  • 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
  • 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

Bulk Edit Product 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 increasing, decreasing, or replacing the stock value.
  • 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, Out of stock, or On Backorder.

Bulk Edit Product Weight & Dimensions

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

Bulk Edit Global Attributes

  • Attribute Action — Select desired action from Add New Values, Remove Existing Values, and Overwrite Existing Values to make changes.
  • Attributes to Update — Once an action is selected in the previous setting, global product attributes will be shown here. Tick the desired attribute checkbox to apply changes.
  • Attributes Values (Existing) — The values of the respective attributes chosen in the previous setting will be 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 overwriting values to all the filtered products.
  • Attributes Values (New) — If you wish to add new global 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 Visible on the product page — You can enable or disable the option for determining whether the selected attribute values should be used for variations.
  • Used for Variation — You can choose to enable or disable whether the newly added attributes should be used for variation or not.

Bulk Edit Custom Attributes

Bulk Edit Product Tax Status & Tax Class

Bulk Edit Product Variations

Create Variations from All Attributes

Bulk Edit Product Categories

Bulk Delete WooCommerce Products

Schedule Bulk Edit Jobs

  • Actions
  • Enter Name (Optional): Enter a suitable name to identify the jobs. By default, jobs will start from “job_1”.
  • Create a Log File: Tick this setting to create a log file of the settings. The log file will contain information related to all the product fields that are updated. This log file can be downloaded from the Jobs dashboard.

Apply Bulk Edit to Products

Undo the Last Update

  • To undo the last update, go to the first screen used for filtering the products and click on the Undo Last Update button, as shown in the below screenshot.
  • 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.
  • If the undo operation is successful, you will see a pop-up window showing the success message, as shown in the screenshot below.

Settings

Custom Meta-Field Settings

Manage Jobs

--

--

Automate Your Marketing

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store