See store and web sales side by side every week
Every Monday, WebRun opens MicroBiz for the past week's in-store register sales and Shopify for the past week's online orders, matches revenue and units by product across both channels, and builds a side-by-side Google Sheets recap so you can see whether the floor or the website is driving each category.
- No credit card
- Under $0.01 per run
- Cancel anytime
Shopify
pull the week's online orders
How do I compare my store and web sales every week?
WebRun pulls the past week's in-store sales from MicroBiz and online orders from Shopify, matches revenue and units by product category, and builds a side-by-side Google Sheets recap every Monday. It flags any category where the web's share of revenue moved more than 10 points from the week before, so a real channel shift never gets missed.
- Channel shifts of 10 points or more get flagged the week they happen
- Store and web are compared apples to apples by category
- No order gets double-counted between pickup in store and online
Built for stationery shop owners · omnichannel retailers · independent stationery stores with online sales · multi-channel gift shops
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 - pull the week's in-store sales
microbiz.com How to Automate MicroBiz
WebRun opens MicroBiz to pull the week's in-store sales. - Open MicroBiz and pull the past week's in-store register sales by product category
- Capture revenue, units sold, and transaction count for the store channel
- Exclude any online orders MicroBiz shows as fulfilled from the store, so they are not double-counted
Done when The past week's in-store sales are pulled by category with revenue and units.
-
2
Shopify - pull the week's online orders
WebRun opens Shopify to pull the week's online orders. - Open Shopify and pull the past week's online orders by product category
- Capture revenue, units sold, and order count for the web channel
- Match product categories to the same naming MicroBiz uses
Done when The past week's online orders are pulled by category with revenue and units.
-
3
Google Sheets - build the side-by-side recap
google.com How to Automate Google Sheets
WebRun opens Google Sheets to build the side-by-side recap. - Add this week's row to the channel comparison sheet, store versus web, by category
- Calculate each category's web share of total revenue
- Flag any category where the web share moved more than 10 points from last week
Done when The comparison sheet shows store versus web revenue and units for every category, with web share flagged.
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.
Shopify
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Does it double-count orders placed online but picked up in store?
No. It excludes anything MicroBiz already shows as fulfilled from the store side, so an order only counts once even if a customer buys online and picks up in person.
Can I see which categories sell better online versus in the store?
Yes. Every category gets a web share of total revenue in the comparison, so you can see at a glance whether notebooks sell better on the floor and gift wrap sells better online, or the reverse.
How far back can I compare?
Each Monday adds a new row to the same running sheet, so you can look back over any stretch of weeks to see whether the shift toward web or store is a trend or a one-off.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.