Cut stem waste with a weekly shrink and waste report
Every Monday, WebRun reads write-off and waste records from Komet Sales, calculates total shrink cost by stem variety for the prior week, logs the results to a Google Sheet for trend tracking, and posts a ranked waste report to Slack so you can adjust your buying quantities.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track weekly flower stem shrink and waste by variety?
Every Monday, WebRun reads stem write-off records from Komet Sales, calculates the total shrink cost by variety for the prior week, logs it to a Google Sheet for trend tracking, and posts a ranked waste report to Slack. You see which stems cost you the most in write-offs and where buying quantities should change.
- Weekly stem write-off cost is visible by variety every Monday in Slack
- Four-week rolling averages in Google Sheets reveal persistent waste patterns
- Buying decisions are grounded in real shrink data, not guesswork
Built for retail florists · wholesale flower buyers · flower shop owners · floral studio 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.kometsales.comin a real browser with your saved login - no setup, no API keys. -
1
Komet Sales - read stem write-offs and waste records
kometsales.com
WebRun opens Komet Sales to read stem write-offs and waste records. - Open Komet Sales and navigate to inventory adjustment or write-off records for the prior week
- Extract the stem variety, quantity written off, unit cost, and total write-off value for each line
- Group totals by stem variety to identify the highest-cost waste items
Done when Last week's stem write-offs are totalled by variety with cost value for each.
-
2
Google Sheets - log weekly shrink totals by variety
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log weekly shrink totals by variety. - Open the weekly shrink tracking sheet
- Append a new row for each stem variety with the week ending date, quantity written off, and total cost
- Update the rolling average column so trends are visible over the past four weeks
Done when This week's shrink data is logged to the sheet with updated four-week averages.
-
3
Slack - post ranked waste report
slack.com How to Automate Slack
WebRun opens Slack to post ranked waste report. - Post a ranked waste report to Slack showing stem varieties by total write-off cost, highest first
- Include quantity, unit cost, and total loss for each variety
- Note varieties where this week's write-off is higher than the four-week average
Done when Your team has this week's waste report in Slack ranked by cost impact.
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 adjust my buying quantities automatically?
No. The report shows you the data and trends so you can make smarter buying decisions. Any order quantity changes are made by you in Komet Sales.
What if Komet Sales does not have a dedicated write-off report?
WebRun reads inventory adjustment records and marks them as write-offs based on the adjustment type. Let WebRun know which adjustment codes represent waste in your setup and it will filter accordingly.
Can it track waste from other sources like leftover event stems?
Yes. If you log those write-offs in Komet Sales or a linked sheet, WebRun can include them. Tell WebRun which records to include during setup.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.