WooCommerce – How to Edit Variation Descriptions Quickly

If you’ve ever tried to edit product variations, you may have realized that it’s very difficult.

WooCommerce forces you to edit one by one in the product editor. It’s very tedious and repetitive.

Another option is to use some strange code snippet/programming skills. If not, editing thousands of variations is virtually impossible.

Now, what if we told you that there’s a way of doing it that doesn’t require any codes and that will take you only some seconds?

Yes! We’re talking about the WP Sheet Editor Products Spreadsheet plugin. With this plugin, you’ll save time and be able to edit thousands of variation descriptions with just a few clicks.

Install WP Sheet Editor

This plugin allows you to see and edit all your products’ information in a beautiful spreadsheet. It helps you save time because you don’t have to open and edit your products one by one.

Skip this step if you have the plugin installed and activated.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

When you open the plugin, you’ll see a spreadsheet with all your products’ information.

If you want to edit variation descriptions on all products containing a keyword, you need to take these simple steps:

Open the “Bulk Edit” tool

This tool helps you apply changes to hundreds of products at once. Open it by clicking it on the plugin’s toolbar.

Select the products you’ll update

In order to filter your products, you need to select I want to search rows to update in the Select the rows that you want to update field.

Filter the product variations by keyword

To filter all product variations containing a specific keyword:

  • Write the keyword in the “Contains keyword” field.
  • Check the “Search on product variations” checkbox.
  • Hit the “Run search” button and it will filter your products and take you back to the Bulk Edit tool.

Add the variation description

After filtering the products, set these values to add the variation description to all variations filtered:

  • What field do you want to edit: Variation description
  • Select type of edit: Set value
  • Write the description in Replace existing value with this value
  • Hit the “Execute now” button.

Now your variations will have new descriptions.

If you want to edit variation descriptions by category, attribute or tag, please follow these steps:

Open the “Bulk Edit” tool

This tool helps you apply changes to hundreds of products at once. Open it by clicking it on the plugin’s toolbar.

Hit the “Select rows” button

In order to filter your products, you need to select I want to search rows to update in the Select the rows that you want to update field.

Filter the product variations by category, attribute or tag

To filter all product variations by category, attribute, or tag:

  • Write the category, attribute or tag in the “Enter product category…” field. This same field works for those three searches.
  • Check the “Search on product variations” checkbox.
  • Hit the “Run search” button and it will filter your products and take you back to the Bulk Edit tool.

Add the variation description

After filtering the products, set these values to add the variation description to all variations filtered:

  • What field do you want to edit: Variation description
  • Select type of edit: Set value
  • Write the description in Replace existing value with this value
  • Hit the “Execute now” button.

Now your variations will have their descriptions.

If you have variable downloadable products and you want to edit their variation descriptions, please follow these steps:

Open the “Bulk Edit” tool

This tool helps you apply changes to hundreds of products at once. Open it by clicking it on the plugin’s toolbar.

Hit the “Select rows” button

In order to filter your products, you need to select I want to search rows to update in the Select the rows that you want to update field.

Filter the downloadable products

To filter them, you need to take these simple steps:

  • Check the “Search on product variations” checkbox
  • Check the “Enable advanced filters” checkbox, which will open the fields you need to search for the downloadable producs.
  • Write “_downloadable” in Field key.
  • Select “=” in the Operator field.
  • Check the “Value” checkbox

After filtering the products, set these values to add the variation description to all variations filtered:

  • What field do you want to edit: Variation description
  • Select type of edit: Set value
  • Write the description in Replace existing value with this value
  • Hit the “Execute now” button.

Now your variations will have their descriptions.

How easy!

It’s really easy to make this and other changes using WP Sheet Editor.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu