How to Bulk Edit WooCommerce Product Status

In this tutorial, we show you how to bulk edit WooCommerce product status.

When you try to change product status manually, you can spend a lot of time and find it exhausting.

Fortunately, we can show you how to bulk update product status using the WP Sheet Editor plugin.

This plugin allows you to view and manage your WooCommerce products in a spreadsheet. You can do advanced searches, bulk edit any field in thousands of products, export products to a CSV file, and import products from a CSV file.

Install the WP Sheet Editor Plugin

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

You can go to WP Sheet Editor, and you will see a spreadsheet that contains all your products with all their information.

1. How to bulk edit WooCommerce product status in the spreadsheet

Editing product status in a spreadsheet allows you to easily make changes to multiple products at once. This can save you a significant amount of time compared to editing each one individually on WooCommerce.

To modify the status individually, you just have to locate the cell Status and select the status you want to set for each product.

The best thing is that you can select the status, drag it or copy and paste it.

After setting all the product statuses, you just need to hit the Save button, and that’s it.

This is a great option if you only want to edit the status of some items, or if you want to assign different statuses to products that do not share any parameters to filter by.

2. Search for WooCommerce products by status

If you need to mass-edit all products that have the same status, you can quickly filter them using the Search tool.

Once in the Search tool, you’ll see different parameters to make your search, but in this case, you’ll enable the advanced filters and enter these parameters:

• Field: Status (post_status)
• Operator: =
• Value: Select the status you want to look for
• Click on Run search.

After filtering the products by status, you will see the results displayed in the spreadsheet.

3. Publish products in bulk

Now that the WooCommerce products you want to edit have been filtered, let’s change the status of all of them in bulk.

To do this, we need to open the Bulk Edit tool.

Now you need to enter these values in order to update the status of the products:

• Select the rows that you want to update: Edit all the rows from my current search (Even non-visible rows).
• What field do you want to update: Status
• Select type of edit: Set value
• Replace existing value with this value: Published
• Click on Execute now.

If you have changed the status of previously filtered products from draft to publish, you will see a message saying that there are no products matching the search parameters, for which you just need to remove the active filters.

Then, all products will then be loaded and there will no longer be any draft products.

4. Schedule products in bulk

Scheduling products in WooCommerce can serve multiple purposes:

• Managing seasonal or themed products that are only relevant during specific times of the year
• Coordinating new product launches with marketing activities
• Etc.

Therefore, we will show you how you can quickly schedule the publication of your products, including a specific date and time for it.

For this example, we will select some products using the selector column and then open the Bulk Edit tool.

After opening the Bulk Edit tool, you can enter these values to schedule your products:

• Select the rows that you want to update: Edit the rows that I selected manually in the spreadsheet
• What field do you want to update: Date
• Select type of edit: Set value
• Replace existing value with this value: Enter the (future) date and time in which you want the products to be published
• Click on Execute now.

Finally, you will see that the dates of your products have been changed, and the product status has been changed to “Scheduled” automatically.

5. Delete products in bulk

Another way to bulk edit WooCommerce product status is to remove products in bulk.

We have prepared a complete tutorial to show you how you can delete products in bulk.

6. Bulk import product status from a CSV file

To begin, ensure that your CSV file contains at least the product name, status, and ID (if you want to schedule some products, you will also need the Date field). Additional fields, such as categories, tags, images, or custom attributes, may also be included.

Important: Before executing any bulk imports, make a backup of your site and product.

Start the import process by going to the WP Sheet Editor interface and clicking on the Import button.

Click on Select File, choose the CSV file you want to import, and click Next.

Select columns to import. In this case, you can import all the columns.

In the Do you want to update or create new items? dropdown, select Update existing items, ignore new items.

Map the columns in your CSV file to the appropriate fields in WooCommerce by selecting the WooCommerce field name from the dropdown menu next to each CSV column header and click Next.

Review the import preview to ensure the data is mapped correctly, and click The preview is fine, start import to initiate the import process.

After the import is complete, check your WooCommerce Products section to ensure all product statuses have been imported correctly.

Keep in mind that the power of effective store management is in your hands!

With the WP Sheet Editor, you can now handle massive amounts of product statuses quickly and effectively, making your e-commerce experience less scary and much more pleasurable.