Forecast back to school demand before you run short
Every Monday from July through September, WebRun opens MicroBiz, compares this year's sell-through pace for notebooks, backpacks, folders, and classroom supplies against last year's back to school season, builds a forecast in Google Sheets, and emails you a recap of what to reorder and what's on pace to sell out.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I forecast back to school demand before I run out of stock?
WebRun compares this year's MicroBiz sell-through for notebooks, backpacks, folders, and classroom supplies against the same week last back to school season, builds a forecast in Google Sheets, and emails you a Monday recap of which categories are on pace to sell out. It flags anything tracking 20 percent ahead of last year so reorders happen before shelves empty.
- Fast-moving back to school categories get flagged before they sell out
- Reorder decisions are based on last year's actual pace, not guesswork
- A Monday recap replaces manually pulling two years of sales data
Built for stationery shop owners · school supply retailers · independent stationers · seasonal gift and paper stores
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
microbiz.comin a real browser with your saved login - no setup, no API keys. -
1
MicroBiz - compare this year's pace to last year's
microbiz.com How to Automate MicroBiz
WebRun opens MicroBiz to compare this year's pace to last year's. - Open MicroBiz and pull week-to-date sell-through for notebooks, backpacks, folders, and classroom supply categories
- Pull the same calendar week from last year's back to school season for comparison
- Calculate the pace difference by category as a percentage
Done when This week's sell-through is compared against the same week last year for every back to school category.
-
2
Google Sheets - build the demand forecast
google.com How to Automate Google Sheets
WebRun opens Google Sheets to build the demand forecast. - Open the back to school forecast sheet and add this week's pace comparison
- Project which categories will sell out before the season ends at the current pace
- Highlight any category tracking more than 20 percent ahead of last year
Done when The forecast sheet shows projected sellouts and the fastest moving categories.
-
3
Gmail - email you the recap
gmail.com How to Automate Gmail
WebRun opens Gmail to email you the recap. - Draft and send yourself a recap email summarizing the categories on pace to sell out
- List suggested reorder quantities based on the gap to last year's total season sales
- Link to the full forecast sheet for the detail
Done when You have this week's back to school recap in your inbox with reorder suggestions.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
How does WebRun know what counts as back to school demand?
It compares this year's weekly sell-through for notebooks, backpacks, folders, and classroom supplies in MicroBiz against the same calendar week last season, so the categories moving faster than last year stand out automatically.
Does it place reorders for me?
No. It only emails you a recap with suggested reorder quantities based on last year's pattern. You still decide what to order and place it yourself in MicroBiz or with your supplier.
What happens outside the back to school season?
You can pause or narrow the schedule to July through September, since the year-over-year comparison is only useful while last year's season data lines up with this year's calendar.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.