Track product margins to protect your bottom line
Every Monday, WebRun opens Dutchie, pulls the prior week's sales revenue and cost-of-goods data by SKU and category, calculates gross margin for each product, logs the full margin table to Google Sheets, and posts a digest to Slack highlighting the highest and lowest margin SKUs so your buyer can make informed decisions this week.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I get an automated weekly margin report for my dispensary?
WebRun pulls the prior week's Dutchie sales and cost data every Monday, calculates gross margin by SKU and product category, and logs the full table to Google Sheets with rolling averages. It then posts a digest to Slack highlighting the top and bottom margin performers so your buying team can act on pricing and ordering this week.
- Buying team gets a prioritised margin list every Monday without manual report-building
- Low-margin SKUs are identified before another week of sales erodes profitability
- Rolling 13-week margin trends are available in Sheets for seasonal analysis
Built for dispensary buyers · cannabis retail owners · purchasing managers · operations 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
business.dutchie.comin a real browser with your saved login - no setup, no API keys. -
1
Dutchie - pull sales and cost data
dutchie.com
WebRun opens Dutchie to pull sales and cost data. - Open Dutchie and navigate to the Sales or Cost reports section
- Pull the prior seven days of completed transactions including SKU, units sold, total revenue, and cost of goods
- Group results by SKU and by product category
- Capture any SKU with zero sales in the period for a slow-movers note
Done when Prior week's sales revenue and cost data are captured by SKU and category.
-
2
Google Sheets - calculate and log margins
google.com How to Automate Google Sheets
WebRun opens Google Sheets to calculate and log margins. - Open the margin report sheet in Google Sheets
- Calculate gross margin percentage for each SKU as revenue minus cost divided by revenue
- Append the weekly results with date range, SKU, category, units sold, revenue, cost, and margin percentage
- Update rolling 4-week and 13-week margin averages for trend comparison
Done when All SKU margins are calculated and logged with rolling averages updated in the sheet.
-
3
Slack - post margin digest
slack.com How to Automate Slack
WebRun opens Slack to post margin digest. - Post a margin digest to the buying team Slack channel
- List the top five highest-margin SKUs and the five lowest-margin SKUs for the week
- Highlight any SKU whose margin dropped more than five percentage points versus the prior week
- Include total category margins and a link to the full Google Sheet for detail
Done when Buying team has the weekly margin digest in Slack with top and bottom performers highlighted.
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
Does it change prices or remove products based on margin data?
No. WebRun only surfaces the margin data and posts it to Slack for your buyer to act on. All pricing decisions, product listings, and order changes are made by your team based on the report.
Does it need cost-of-goods data from Dutchie or another source?
It pulls cost data from Dutchie if it is recorded in your product catalogue. If costs are tracked in a separate spreadsheet, the workflow can be set up to pull from that Google Sheet instead and join on SKU.
Can it compare margins across multiple store locations?
Yes. If your Dutchie account covers multiple locations, WebRun can pull data per location and produce a single margin report that shows each site side by side, so buyers can spot location-level variances.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.