How to Bulk Reset WooCommerce Stock Daily

If you’re running a WooCommerce store, keeping your product stock updated is essential. However, if you need to daily reset stock, you may have a heavy workload. That’s why, in this tutorial, you’ll learn how to bulk reset WooCommerce stock daily, using a simple and efficient method that helps you save time and effort.

Important: This method will show you how to set a specific stock quantity for all your products every day. If you want to manage stock from Google Sheets and set different stock for different products every day, you can follow this tutorial.

When to daily reset WooCommerce stock?

Here are some situations where resetting WooCommerce stock daily can be useful:

1. Daily limited stock for flash sales: Useful when you run daily flash sales and want to limit sales to a fixed quantity (e.g., 10 units per product). Resetting stock daily ensures consistent inventory limits.
2. Rental or booking-based products: For products like rentals or bookings, you may need to reset stock daily to reflect availability (e.g., set stock to 1 each day for each item).
3. Digital products with limited licenses: When selling limited licenses or downloads per day, resetting stock helps enforce download or license limits automatically.
4. Dropshipping or print-on-demand inventory control: If your supplier updates stock manually or via email, resetting stock to 0 helps prevent overselling until confirmed stock levels are imported.
5. Subscription boxes or pre-orders: Useful for controlling how many units are sold per day or week, especially for limited-edition or seasonal products.

The problem: Resetting stock daily is hard!

Manually resetting stock for each product in WooCommerce is a slow and frustrating process. You’d have to open each product one by one, update the Stock field, save the changes, and repeat, dozens or even hundreds of times. This kind of task is boring, kills productivity, and takes hours out of your day, especially if you have a large catalog of products.

Fortunately, there’s a faster and smarter way. Here are the two tools you will need besides WooCommerce:

1- WP Sheet Editor – WooCommerce Products. This plugin gives you a full spreadsheet interface to edit your products, saving you tons of manual work and helping you be more productive.

2- WP Sheet Editor – Automations. This add-on for WP Sheet Editor allows you to schedule actions like bulk edits, add new rows, save changes, export product data, import products, etc.

Click here to read a guide on how to install and set up the Automations add-on.

After installing the plugins and activating the licenses, you need to follow the steps below to bulk reset WooCommerce stock daily.

Open the Products spreadsheet

You need to open the spreadsheet for the product post type. Go to WP Sheet Editor > Edit Products.

You will now see all your WooCommerce products displayed in a familiar spreadsheet interface. This makes it extremely easy to view, filter, and edit your products in bulk, all in one place.

Option 1: Use the spreadsheet to set daily stock

The first option we want to show you to reset the stock of WooCommerce products on a daily basis is using the spreadsheet. This can be useful if you want to set a different stock for each product, but you want all products to be reset to their specific stock at the same time each day.

You just need to find the Stock column in the spreadsheet and start updating the stock values as needed. The spreadsheet columns behave like the fields in the standard WordPress editor. You can type directly, copy values, or drag the small square in the cell corner to autofill values just like in Excel.

After you’re done editing, hover the mouse over the Save button and select Save later.

Select these values to schedule a recurring save that runs every day at the same time and resets the stock of products automatically:

• Select the date and time: You need to use the date and time selector to choose when you want the first stock reset to run. Then, the stock reset will run at the same time every day.
• Notify this email address when the process finishes: Add your email address here.
• Select the Run in recurring intervals option.
• Run every: Add the number 1 in this case.
• Select Days.
• Name: Add a descriptive name for this recurring task.
• Click on Schedule the changes.

Click on View scheduled changes.

And here’s the scheduled recurring stock reset that will restore the stock levels daily.

Option 2: Bulk reset WooCommerce stock daily

Now we will show you how to put the same amount of stock on hundreds or thousands of products every day. This is useful if all your products, or the products of an entire category share the same stock and you want to reset or recover the stock daily.

Optional: Search for the products you’ll edit.

If you do not want to edit all the products in your store, but only the products that contain a specific category, a specific tag, etc., you can use the Search tool.

In this example, we will search for all the products within the Limited category, so we need to enter the category and run the search.

After running the search, we need to open the Bulk Edit tool, which allows you to edit multiple WooCommerce products at once, whether you’re working with a few dozen or thousands of items.

Now, configure the tool with the following settings to bulk reset WooCommerce stock daily:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Stock
• Select type of edit: Set value
• Replace existing value with this value: Add the stock quantity here.
• Tick the Run this in the future checkbox.
• Select the date and time: You need to use the date and time selector to choose when you want the first stock reset to run. Then, the stock reset will run at the same time every day.
• Notify this email address when the process finishes: Add your email address here.
• Select the Run in recurring intervals option.
• Run every: Add the number 1 in this case.
• Select Days.
• Name: Add a descriptive name for this recurring task.
• Click on Execute Now.

Click on View scheduled bulk edits.

And here’s the scheduled recurring stock reset that will restore the stock levels daily.

Great! In just a few clicks, you can schedule a recurring, daily stock resets. With WP Sheet Editor and Automations, you can easily schedule recurring bulk changes for your WooCommerce products.