WooCommerce – Bulk Edit Short Descriptions Quickly

When you create a WooCommerce store for a client, it’s normal to create products without having all the information. Maybe the client only gave you the product title, price, and images.

So later, when you receive all the product information, you have to edit every product to edit every field.

In this tutorial, we’ll show you how to bulk edit the product description quickly using a spreadsheet. We’ll edit individual descriptions quickly and we’ll use a tool to edit all descriptions at once.

Install the WP Sheet Editor Plugin

You can skip this step if you already have the plugin installed and activated.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

When you open the tool, you will see a spreadsheet that contains all your products with all their information…

Adding short descriptions to individual products is really easy.

Locate the Excerpt column.

To locate the cell just move the horizontal bar to the right and look for the column.

a) Choose the products you want to edit.

b) Write a short description of the product’s excerpt cell.

In this case, we’re going to add a short description to the books and e-books.

As you can see, there are four products with that parameter. So, we just have to write the excerpt.

After writing all the excerpts, you just need to hit the Save button, and that’s it.

In this example we’ll show you how you can add short descriptions to products containing the keyword Jeans.

a) Open the Apply changes in bulk tool.

This option is the one that helps you apply changes to hundreds or even thousands of products at once, and that way save lots of hours.

b) Open the search tool.

For this, select the “I want to search rows to update” option in the “Select the rows that you want to update” dropdown.

c) Look for the keyword

For this, you need to enter the keyword in the Contains keyword field. Then, you just hit the Run search button.

After that you need to set these values to add a short description

  • Choose the “Short description” column to edit
  • Select “Set value” in the “type of edit” field.
  • Write a short description of your products.
  • Hit the “Execute now” button.

As you can see the products with the keyword Jeans have been updated and now all of them have a short description.

If you want to add, for example, a short description to all the products within the Technology category, you just need to follow some simple steps. Remember that, even though we’re filtering the products by category, you can look for the attribute or the tag.

a) Open the “Bulk Edit” tool.

This tool helps you apply changes to thousands of products with just a few clicks, so you need to open it by clicking it on the toolbar that is above the spreadsheet.

b) Open the Search tool

Select the “I want to search rows to update” option in the “Select the rows that you want to update” dropdown.

c) Look for the category, attribute or tag of the product you want to edit.

You can do this by writing the product category in the “Enter Product category…” field.

d) Add the short description to these products.

After running the search, you need to set the following values to add short descriptions to your products:

  • Choose the “Short Description” column to edit
  • Select “Set value”
  • Write a short description of your products.
  • Hit the Execute now button.

After that, you will see that all the products in the Technology category will have short descriptions.

If you want to add a short description to all downloadable products, you need to follow these simple steps:

Open the “Bulk Edit” tool.
This tool will help you apply changes to thousands of products at once.

Filter the products

Select the “I want to search rows to update” option in the “Select the rows that you want to update” dropdown.

Look for the downloadable products

Once you open the “Select rows” tool, you need to enable the advanced filters by checking their checkbox and then set these values:

  • Write “_downloadable” in “Field key”.
  • Select the “Equal” sign in Operator.
  • Check the “Value” checkbox.
  • Hit the “Run search” button.

d) Add the short description to these products.

After running the search, you need to set the following values to add short descriptions to your products:

  • Choose the “Short Description” column to edit
  • Select “Set value”
  • Write a short description of your products.
  • Hit the “Execute now” button.

Start editing thousands of products!

Get the Sheet Editor plugin and start editing thousands of products with just a few clicks.

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