Automated Hardware Store Weekly Margin Report
Every Monday, WebRun opens Epicor Eagle, pulls the prior week's sales and gross margin by department, logs the figures in a Google Sheet, and posts a ranked Slack report highlighting which departments beat target and which fell short so you can act before margins slip further.
How do I get a weekly gross margin report by department from my hardware store POS?
WebRun opens Epicor Eagle every Monday, pulls the prior week's gross margin by department, logs the figures in a Google Sheet with four-week trend calculations, and posts a ranked Slack report highlighting underperforming departments. Store owners get a clear picture of where margin is slipping each week without logging into the POS themselves.
- Weekly margin report delivered to Slack before the store opens on Monday
- Underperforming departments flagged against their four-week average for fast action
- Rolling historical data in Google Sheets for quarterly and seasonal analysis
Built for hardware store owners · store managers · purchasing 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
www.epicor.comin a real browser with your saved login - no setup, no API keys. -
1
Epicor Eagle - pull weekly sales and margin by department
epicor.com
WebRun opens Epicor Eagle to pull weekly sales and margin by department. - Open Epicor Eagle and run the department sales and margin report for the prior week
- Capture net sales, cost of goods sold, gross margin dollars, and gross margin percentage for each department
- Note the variance versus the prior week's margin percentage for each department
Done when All department margin figures for the prior week are captured with week-over-week variance.
-
2
Google Sheets - log figures and calculate week-over-week trends
google.com
WebRun opens Google Sheets to log figures and calculate week-over-week trends. - Log the weekly figures into the running margin tracking sheet
- Calculate the four-week rolling average margin percentage for each department
- Flag any department whose margin fell more than 2 percentage points below its four-week average
- Calculate the overall store gross margin for the week
Done when All figures are logged, trends calculated, and underperforming departments flagged in the sheet.
-
3
Slack - post ranked margin report with flagged underperformers
slack.com
WebRun opens Slack to post ranked margin report with flagged underperformers. - Post a Slack message with the overall store gross margin percentage for the week
- List all departments ranked by gross margin percentage, highest first
- Highlight departments flagged as below their four-week average in bold
- Include a link to the Google Sheet for the full trending view
Done when You have this week's margin report in Slack with underperforming departments clearly 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.
Every action is checked against this policy before it runs.
Questions, answered
Does it post the report automatically or wait for approval?
It posts the internal Slack report automatically. No customer-facing content is involved, so there is no approval step needed for this digest.
What counts as an underperforming department?
By default, any department whose gross margin percentage fell more than 2 percentage points below its four-week rolling average is flagged. You can adjust this threshold in your WebRun settings.
Does it store historical margin data?
Yes. Every week's figures are logged to a Google Sheet, giving you a rolling record you can use for quarterly reviews or to spot seasonal margin patterns over time.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.