Automated METRC Discrepancy Alerts
Every morning, WebRun opens METRC, pulls current package quantities for active tags, compares them against your POS records, logs every discrepancy to a Google Sheet with the variance amount, and posts a compliance alert to Slack so your team can investigate before the next scheduled audit.
How do I automatically catch METRC inventory discrepancies?
WebRun pulls METRC package quantities each morning and compares them against your POS records, logging every variance to Google Sheets with the tag ID, product, and quantity gap. Discrepancies above your threshold are posted to Slack so your compliance team can investigate and correct them before an audit.
- Catch METRC vs POS mismatches before a state audit does
- Compliance team gets a daily variance report without manual comparison
- Persistent discrepancies are trended in Sheets for root-cause analysis
Built for dispensary compliance officers · cannabis inventory managers · multi-location operators · dispensary general 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
ca.metrc.comin a real browser with your saved login - no setup, no API keys. -
1
METRC - pull package quantities
metrc.com
WebRun opens METRC to pull package quantities. - Open METRC and navigate to the Packages section
- Pull the current quantity on hand for every active package tag
- Export or capture the tag ID, product name, quantity, and unit of measure for each package
Done when All active METRC package quantities are captured for today's comparison.
-
2
Google Sheets - log discrepancies
google.com
WebRun opens Google Sheets to log discrepancies. - Open the METRC discrepancy log in Google Sheets
- Compare each METRC package quantity against the matching POS record for the same tag or SKU
- Log each mismatch with the tag ID, product name, METRC quantity, POS quantity, and variance
- Highlight rows where variance exceeds your configured tolerance threshold
Done when Every discrepancy is logged with variance details and tolerance flags in the sheet.
-
3
Slack - alert compliance team
slack.com
WebRun opens Slack to alert compliance team. - Post a summary of today's discrepancies to the compliance Slack channel
- List the top variances by quantity and flag any that exceed the tolerance threshold
- Include a link to the Google Sheet for the full detail view
Done when Compliance team has today's discrepancy summary in Slack with a link to the full log.
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
Will it correct the discrepancy in METRC automatically?
No. WebRun only surfaces the variance and logs it for review. Any adjustment to METRC package quantities must be made manually by a licensed employee following your state compliance procedures.
How does it match METRC packages to POS records?
It matches on the package tag ID that both METRC and most POS systems share. If your POS uses a different identifier, the Google Sheet maps them in a lookup table you configure once at setup.
What counts as a discrepancy worth flagging?
Any variance above the tolerance level you set, typically one gram or one unit, is flagged. Smaller rounding differences below your threshold are logged but not posted to Slack to reduce noise.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.