Keep online and in-store sales in sync
Every night, WebRun reads the day's in-store sales from StoreHub and online orders from Shopify, combines them into one revenue and units view in Google Sheets, and flags any product whose stock or sales look off between the two channels.
- No credit card
- Under $0.01 per run
- Cancel anytime
Shopify
read online orders
How do I keep my online and in-store sales reconciled?
Every night WebRun reads in-store sales from StoreHub and online orders from Shopify, then combines them into one reconciled view in Google Sheets. It flags any product selling online while StoreHub shows no stock, and any revenue that looks missing or double-counted, so overselling and reporting gaps surface the same night.
- One reconciled view of online and in-store sales each night
- Overselling caught when online sells out-of-stock items
- Channel revenue gaps and double-counts flagged automatically
Built for omnichannel retailers · F&B operators · online sellers · multi-outlet businesses
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
backoffice.storehub.comin a real browser with your saved login - no setup, no API keys. -
1
StoreHub - read in-store sales
storehub.com How to Automate StoreHub
WebRun opens StoreHub to read in-store sales. - Open StoreHub BackOffice and go to Reports, then Sales
- Capture today's in-store units and revenue by product
- Note current stock on hand for the shared catalogue
Done when Today's in-store sales and stock are captured by product.
-
2
Shopify - read online orders
WebRun opens Shopify to read online orders. - Open the Shopify admin and go to Orders
- Capture today's online units and revenue by product
- Note any online order still unfulfilled that will draw down store stock
Done when Today's online orders are captured by product.
-
3
Google Sheets - reconcile and flag gaps
google.com How to Automate Google Sheets
WebRun opens Google Sheets to reconcile and flag gaps. - Combine in-store and online sales into one dated row per product
- Flag any product selling online while showing zero stock in StoreHub
- Flag revenue that looks double-counted or missing between channels
Done when The combined view reconciles both channels and flags any gap.
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 change stock or orders in either system?
No. WebRun only reads sales and stock from StoreHub and Shopify and writes a reconciled view to Sheets. It never edits inventory or orders, so both systems stay untouched.
What mismatches does it catch?
WebRun flags products selling online while StoreHub shows zero stock, plus revenue that looks missing or double-counted between channels, so overselling and reporting gaps surface the same night.
Can it handle a shared product catalogue?
Yes. WebRun matches items across StoreHub and Shopify by product, combines their units and revenue, and reports one clean daily total, so you stop tallying two systems by hand.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.