Want to auto reset WooCommerce stock weekly or monthly in WooCommerce? In this guide, we will show you how to schedule recurring bulk stock resets so you don’t have to manually reset the stock levels. We will use the recurring intervals schedule type to bulk update stock automatically. This method is perfect for flash sales, rentals, food prep services, and more.
When to schedule automatic WooCommerce stock reset?
Here are some use cases where you may need to schedule auto stock resets for your WooCommerce products:
- Flash sales and limited drops: If you run flash sales or weekly product drops, auto reset stock can help you restock items at the start of each sale period. This builds hype and keeps your store looking fresh with limited-time offers.
- Meal prep and food delivery: For businesses that sell meals or weekly food boxes, auto resetting stock every week ensures you only sell what you can make. It helps manage orders based on your cooking schedule and ingredient supply.
- Baked goods or home kitchen sales: If you bake at home or run a small kitchen business, resetting stock weekly helps avoid overbooking. You can limit how many items are available based on how much you can make each week.
- Fitness classes and bookings: When selling class passes or booking slots, you can auto reset inventory weekly or monthly. This makes sure your store only shows available spots for the next session or period.
- Rental items with return cycles: If you rent out products or gear, your availability might change every week. Auto reset stock makes sure your listings are accurate based on what’s coming back.
- Manual inventory updates: If you don’t use a POS system or track inventory outside of WooCommerce, auto stock reset can simplify your workflow. It lets you clear or restock inventory on a regular schedule without editing each product manually.
What you need to automatically reset stock
Here’s what you need in order to bulk reset WooCommerce product stock automatically:
WP Sheet Editor – WooCommerce Products
This plugin allows you to view and manage your WooCommerce products in a spreadsheet. You can bulk edit any product field, run advanced searches, export, and import WooCommerce products and variations, and much more!
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
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.
In this case, it allows you to schedule a bulk edit to reset the stock levels to a specific number every a certain number of weeks or months.
You can get the add-on here:
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 in order to bulk reset WooCommerce stock automatically.
1- Open the spreadsheet
To open the products’ spreadsheet, you need to go to WP Sheet Editor > Edit products. You will see all your WooCommerce products displayed in the spreadsheet.
2- Open the Bulk Edit tool
The Bulk Edit tool allows you to update any field on thousands of products at once. If you use our Automations add-on, you can schedule bulk actions to run at a specific date and time in the future.
3- Schedule WooCommerce stock to auto reset weekly or monthly
Once you’re in the Bulk Edit tool, select these values to bulk set stock levels weekly or monthly:
- 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: Enter the stock you want to set.
- Tick the Run this in the future checkbox.
- Select the date and time: Use this to choose when you want to run the first stock reset.
- Notify this email address when the process finishes: Enter an email address here and you’ll get an email notification whenever the stock is reset.
- Since we will reset WooCommerce stock weekly or monthly, you need to select Run in recurring intervals option.
- Run every: Select the number and the time unit. For example, you can reset product stock every 1 week, 1 month, etc.
- You can Edit only parent products or Edit only variations.
- Click on Execute Now.
Once you have scheduled the bulk stock reset, you can click on the View scheduled bulk edits link.
And here you can see all the details of the scheduled bulk stock reset.
With these simple steps, we have scheduled a weekly or monthly bulk edit that resets the stock of your WooCommerce products automatically. Besides, just as you can return the stock to the same number every week or month, you can schedule any other bulk edit, as well as changes applied to the products in the spreadsheet, export, and import automatically.
Frequently Asked Questions
Can WooCommerce reset product stock automatically?
Yes, using WP Sheet Editor’s Automations add-on, you can schedule recurring stock resets weekly or monthly.
Do I need coding to automate WooCommerce stock updates?
No, the plugin provides a spreadsheet UI and simple scheduling options. No technical skills required.
Can I reset stock for product variations?
Yes, you can choose to apply resets to parent products or variations.