Automated Nursery Perishable Shrink Report
Every Monday, WebRun opens NCR Counterpoint, pulls the prior week's shrink and markdown transactions for perishable categories, calculates loss by department, logs the data to a Google Sheet, and posts a ranked shrink summary to your manager's Slack so problem categories are visible before the week starts.
How do I get a weekly perishable shrink report for my garden center?
WebRun pulls last week's perishable write-offs and markdowns from NCR Counterpoint every Monday, ranks every department by shrink cost, logs the data to Google Sheets with week-over-week change, and posts a concise ranked report to Slack. Managers see the worst-performing categories before the week begins.
- Managers spot high-shrink departments before they become margin problems
- Week-over-week trends are visible without any manual spreadsheet work
- Full shrink history in Google Sheets for seasonal benchmarking
Built for garden center managers · nursery department heads · retail nursery owners
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
ncrcounterpoint.comin a real browser with your saved login - no setup, no API keys. -
1
NCR Counterpoint - pull prior-week shrink and markdown transactions
ncrcounterpoint.com
WebRun opens NCR Counterpoint to pull prior-week shrink and markdown transactions. - Open NCR Counterpoint and navigate to Inventory Adjustments and Markdowns
- Filter for the prior calendar week and for perishable categories (annuals, cut flowers, herbs, etc.)
- Capture SKU, description, department, units written off, and cost value for each shrink transaction
- Note total shrink cost per department
Done when Prior week's perishable shrink transactions are captured by SKU and department.
-
2
Google Sheets - log and rank shrink by department
google.com
WebRun opens Google Sheets to log and rank shrink by department. - Open the nursery shrink tracking sheet
- Append last week's figures: department, units lost, and cost value
- Calculate week-over-week change for each department
- Rank departments from highest to lowest shrink cost
Done when Shrink data is logged, ranked, and week-over-week change is calculated.
-
3
Slack - post ranked shrink report to manager
slack.com
WebRun opens Slack to post ranked shrink report to manager. - Post a ranked shrink summary to the manager's Slack channel
- List the top loss departments with units and cost value
- Include total shrink cost and a link to the full Google Sheet
Done when Manager has the ranked perishable shrink report in Slack for Monday morning review.
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
Which product categories count as perishable?
WebRun targets the categories you flag as perishable in NCR Counterpoint, typically annuals, cut flowers, potted herbs, and seasonal colour. You can adjust the category list at setup.
Can it track shrink from both write-offs and markdowns separately?
Yes. WebRun pulls both inventory adjustment transactions and markdown transactions from Counterpoint and logs them with separate line items so you can see where the loss is coming from.
Is the data stored anywhere beyond Slack?
Yes. Every week's figures are appended to a Google Sheet, building a rolling history that lets you spot seasonal shrink patterns and set reduction targets.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.