WooCommerce – How to Discontinue Products from your Catalog

Sometimes your clients ask you to stop showing some products on the catalog because they’re not selling them anymore.

Now that can be a pain in the neck if you have hundreds of products to discontinue.

However, in this article we’ll show you how you can discontinue products from the catalog by filtering them by keyword, category, and attribute. We’re also going to show you how to add a message to their titles and descriptions.

Install WP Sheet Editor

This plugin allows you to apply changes to thousands of products with just some clicks. It includes powerful tools such as the “Apply changes in bulk” and the “Search” tool.

You can 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

Open the Spreadsheet

When you open the plugin you’ll see a spreadsheet with all your products and their info.

You can quickly remove your products stock. Therefore, you need to follow these simple steps.

a) Open the Bulk Edit tool

This tool allows you to apply changes to thousands of products. It’s located on the toolbar, so just click on it.

b) Filter your products

To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Once you open the Search tool, you’ll find these fields to search for your products:

  • Contains keyword – Enter a specific keyword to filter all products containing it.
  • Enter Tags: Categories, attributes, tags.

Once you decide how you want to search your products, click on Run search to filter your products.

c) Remove your filtered products’ stock

Use these values to remove your filtered products’ stock

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: Stock
  • Select type of edit: Set value
  • Replace existing value with this value: 0
  • Click on Execute now

Also, you can let your customers know about your discontinued products by adding a message to their titles. For this, follow these simple steps:

a) Open the Bulk Edit tool

This tool allows you to apply changes to thousands of products. It’s located on the toolbar, so just click on it.

b) Filter your products

To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Once you open the Search tool, you’ll find these fields to search for your products:

  • Contains keyword – Enter a specific keyword to filter all products containing it.
  • Enter Tags: Categories, attributes, tags.

Once you decide how you want to search your products, click on Run search to filter your products.

c) Add the message to your product titles

Use these values to add a message to your product titles

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: Title
  • Select type of edit: Append
  • Enter the value to append to the existing value: – Discontinued product
  • Click on Execute now

You can quickly add a message to thousands of your discontinued products’ descriptions. Just follow these simple steps:

a) Open the Bulk Edit tool

This tool allows you to apply changes to thousands of products. It’s located on the toolbar, so just click on it.

b) Filter your products

To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Once you open the Search tool, you’ll find these fields to search for your products:

  • Contains keyword – Enter a specific keyword to filter all products containing it.
  • Enter Tags: Categories, attributes, tags.

Once you decide how you want to search your products, click on Run search to filter your products.

c) Add the message to your product descriptions

Use these values to add the message to your product descriptions

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: Short description
  • Select type of edit: Prepend
  • Enter the value to append to the existing value: <h2>Discontinued product </h2>
  • Click on Execute now

Your customers will be thankful!

Now your customers won’t get mad at you when they try to buy a product that you have discontinued. It’s important to let them know about it and with WP Sheet Editor it’s really easy.

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