WooCommerce – Replace Old Year References in Product Descriptions

Let’s see how to replace old year references on WooCommerce product descriptions.

Keeping your WooCommerce product descriptions updated with the current year ensures your site appears fresh and actively managed. This is crucial for items tied to specific years, like calendars or annual editions.

Updating year references also improves your website’s SEO, making your products more discoverable in search results for customers looking for the latest versions. It enhances your store’s credibility by avoiding the impression of neglect that outdated information can give to customers.

Accurate year references are vital for products updated annually, such as software or textbooks, ensuring customers receive the correct information. Besides, aligning product descriptions with current promotional campaigns creates a cohesive and compelling marketing message, boosting the effectiveness of your sales efforts.

Of course, checking and editing products individually is hard. That’s why we will show you how to bulk replace year references on WooCommerce product descriptions, using the WP Sheet Editor – WooCommerce Products plugin.

It allows you to manage your products using a spreadsheet on WordPress. You can run advanced searches and bulk edit thousands of products at once. You can also export/import product data using CSV files.

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

Once you install the plugin and activate your license, you need to follow the steps below in order to replace old year references on WooCommerce product descriptions.

1- Open the spreadsheet

You can open the plugin by going to WP Sheet Editor > Edit products.

When you open the plugin, you will see a spreadsheet with all your products and their complete data.

2- Search for the products you want to edit

The first step to replace old year references in your product descriptions is to search for the products you want to edit.

In this example, it may be useful to search for products containing a specific year reference in the product description. For example, you can search for all products containing “2020” in the description or short description.

You need to start by opening the Search tool.

Now you need to select these values:

• Tick the Enable advanced filters checkbox and select these values:
  • Field: If you want to search the year reference in the Product description field, select “Content”. If you want to search the year reference in the Short description field, select “Short description”.
  • Operator: CONTAINS
  • Value: 2020, or any other year reference you want to search for.
• Click on Run search.

Once you run the search, you’ll see all the products matching the search filters displayed in the spreadsheet.

3- Bulk replace old year references in product descriptions

The Bulk Edit tool allows you to edit any field on hundreds of products. In this case, it will allow us to replace values in the product descriptions.

Once you’re on the Bulk Edit tool, you need to select these values in order to bulk change year references on product descriptions:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Select “Content” content to edit the product description field, or select “Short description” to update the short description.
• Select type of edit: Replace
• Replace this: Enter the old year reference here.
• With this: Add the new year reference here.
• Select the Edit only parent products option.
• Click on Execute Now.

WP Sheet Editor allows you to bulk replace values on any field on hundreds or thousands of WooCommerce products.