How to Bulk Edit Stock Status on WooCommerce Products

In this tutorial, we will show you how to bulk edit stock status on WooCommerce products using the WP Sheet Editor plugin.

Managing a WooCommerce store often involves numerous products, and keeping track of their stock status can be a daunting task.

However, when it comes to bulk editing stock status, the default WooCommerce features are limited because you cannot search and bulk update products easily.

This is where the WP Sheet Editor – WooCommerce Products plugin comes into play. It allows you to view and manage your WooCommerce products using a spreadsheet interface on the WordPress admin dashboard.

You can skip installing the plugin if you already have it.

After installing the plugin and activating your license, you need to follow the steps below in order to bulk edit the products’ stock status.

1- Open the products spreadsheet

Once you have installed and activated the plugin, go to WP Sheet Editor > Edit products.

2- Search for the products you will edit

The search tool allows you to find products using any field as search criteria.

For example, you can search for products by keyword in the product title, product category, product attribute, product price, product stock status, etc.

You need to open the tool by clicking on Search.

In this example, we will search for products that match this criteria:

• Keyword in title: t-shirt
• Product category: Clothing
• Stock status: In stock

To do this, you need to select these values in the search tool:

• Contains keyword: Enter the keyword here.
• Enter product categories: Enter the category here.
• Tick the Enable advanced filters checkbox and select these values:
  • Field: Stock status
  • Operator: =
  • Value: In stock
• Click on Run search.

After running the search, you will see all the products matching the search criteria displayed on the spreadsheet.

You’ll also see the active filters above the products’ data.

3- Bulk edit the stock status on all the filtered products

The Bulk Edit tool allows you to bulk update any field on hundreds or thousands of WooCommerce products. In this case, it will help you bulk update the stock status on all the selected products.

a) Set products out of stock

If you want to set the selected products as out of stock, you need to select these values in the Bulk Edit tool:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Stock status
• Select type of edit: Set value
• Replace existing value with this value: Out of stock
• Select the Edit only parent products option.
• Click on Execute Now.

b) Set products in stock

If you want to set the selected products as in stock, you need to select these values in the Bulk Edit tool:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Stock status
• Select type of edit: Set value
• Replace existing value with this value: In stock
• Select the Edit only parent products option.
• Click on Execute Now.

a) Set products out of stock

If you want to set the selected products as on backorder, you need to select these values in the Bulk Edit tool:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Stock status
• Select type of edit: Set value
• Replace existing value with this value: On backorder
• Select the Edit only parent products option.
• Click on Execute Now.

Additionally, learn how to change the stock status for product variations by clicking here!

What was supposed to take you hours will only take you some minutes with WP Sheet Editor.