WooCommerce – How to Discontinue Products from your Catalog

posted in: Guides | 0

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.

1- 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:

- or - Read more about it

2- Open the Spreadsheet

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

The first obstacle the normal WP editor presents to you is finding all the products you want to discontinue because you need to edit them one by one.

However, with WP Sheet Editor it’s super easy to find all the products you want. For example you can find them by keyword, category and attribute.

To filter your products you can use the “Search” tool.

a) Find products by keyword

To find all products containing a specific keyword you need to write the keyword in the “Contains keyword” field. Then just hit the “Run search” tool.

b) Find products by category

If you want to find all products within a category, you just need to write the category name in the “Enter Product category” field and hit the “Run search” button.

c) Find products by attribute

If you want to find all the products containing an attribute (Color, Size, etc.), you need to write the attribute in the “Enter Product attribute” field. For example you can find all white products or all the small products.

After you’ve found your products, you need to proceed to discontinue them from the catalog. In this case you need to set the stock to zero.

a) Open the “Apply changes in bulk” tool

It’s the tool that helps you apply changes to thousands of products at once with just some clicks.

b) Remove product stock

To remove product stock you need to set these values:

  • Check the “I understand it will update the posts from my field” checkbox
  • Choose “Stock” as the field you’ll edit
  • Select “Set value” as the type of edit you’ll apply
  • Write 0 in the “Replace existing value with this value” field
  • Hit the “Execute now” button

It’s always good to let your clients know when the products aren’t available anymore. So you can add a message to their titles. That message may say something like this: ” – Discontinued product”

So you need to do this:

a) Open the “Apply changes in bulk” tool

It helps you apply changes to thousands of products at once.

b) Add the message to the product title

To append a message to your product titles you need to set these values:

  • Check the “I understand it will update the posts from my field” checkbox
  • Choose “Title” as the field you’ll edit
  • Select “Append” as the type of edit you’ll apply
  • Write the message you’ll add in the “Replace existing value with this value” field.
  • Hit the “Execute now” button.

Another way to help your clients know when your products are discontinued is to add a message at the beginning of their description. For example you can add a message like this: “<h2>Discontinued products</h2>”.

For this you need to take these simple steps:

a) Open the “Apply changes in bulk” tool

This tool helps you apply changes to thousands of products at once.

b) Append/add the message to the product description

To append a message to your product titles you need to set these values:

  • Check the “I understand it will update the posts from my field” checkbox
  • Choose “Excerpt” as the field you’ll edit
  • Select “Append” as the type of edit you’ll apply
  • Write the message you’ll add in the “Replace existing value with this value” field.
  • Hit the “Execute now” button

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:

- or - Read more about it

Leave a Reply