Compare in-store versus online margins in Shopify every week
Every Monday, WebRun opens Shopify Analytics, reads last week's revenue and cost of goods sold by channel (online store and POS), calculates gross margin per channel, and posts a clear comparison to Slack so your team can spot where profitability differs and make informed channel decisions.
- No credit card
- Under $0.01 per run
- Cancel anytime
Shopify
pull revenue and cost of goods by channel
How do I automatically compare Shopify in-store versus online gross margins each week?
WebRun opens Shopify Analytics every Monday and pulls last week's revenue and cost of goods sold for your online store and POS channel. It calculates gross margin per channel, highlights where profitability differs, and posts the comparison to Slack so your team can make informed decisions about pricing and channel mix.
- Weekly gross margin comparison available every Monday with no manual reporting
- Channel profitability gaps spotted so pricing and product mix decisions are data-driven
- Top margin products per channel visible so buyers can optimize stock allocation
Built for Shopify store owners · omnichannel retailers · retail finance teams · buying and merchandising managers
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
admin.shopify.com/reportsin a real browser with your saved login - no setup, no API keys. -
1
Shopify - pull revenue and cost of goods by channel
WebRun opens Shopify to pull revenue and cost of goods by channel. - Open Shopify Admin and go to Analytics, then Reports
- Open the Sales report filtered to last week, broken down by channel: Online Store versus Point of Sale
- For each channel, capture total revenue, total cost of goods sold, and gross margin percentage
- Note the top 3 products by margin for each channel and any product where margins differ significantly between channels
Done when Gross margin figures and top margin products are captured for each channel for last week.
-
2
Slack - post the weekly margin comparison
slack.com How to Automate Slack
WebRun opens Slack to post the weekly margin comparison. - Format a compact margin comparison showing online versus in-store revenue, COGS, and gross margin percentage side by side
- Highlight the channel with the higher margin and call out any products with a large margin gap between channels
- Post to the owner or buying channel for review
Done when The weekly margin comparison is posted to Slack.
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 Shopify have cost of goods data needed for margin calculations?
Yes, if you have entered the cost per item in each product variant. WebRun reads that cost field from Shopify to calculate gross margin. If cost is not entered, it can still report revenue by channel and note where cost data is missing.
Why do in-store and online margins often differ?
Common causes include different pricing, discounts, channel fees, and product mix. The report surfaces the gap so your team can investigate and decide whether to adjust pricing or product allocation per channel.
Can I get this for individual POS locations rather than all POS combined?
Yes. Ask WebRun to break the POS data down by location during setup and the report will show margin per store alongside the online channel.
Related templates
Shopify›Shopify›Shopify›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.