Automated Mar-Kov Freezer Inventory Aging Reports
Every Monday, WebRun opens Mar-Kov, checks every finished goods pallet in freezer storage against its code date and your FIFO rotation window, builds an aging report in Microsoft Excel ranked by days remaining, and posts a Slack alert for anything close to code date so warehouse can move it before it's written off.
How do I catch aging freezer inventory before it has to be written off?
Every Monday, WebRun checks every finished goods lot in Mar-Kov's freezer storage, capturing production date, code date, and days remaining for each. It builds a ranked aging report in Microsoft Excel and posts a Slack alert for any lot within 30 days of code date or past your FIFO rotation window, so warehouse moves product before it becomes a write-off.
- Aging lots get flagged weeks before code date instead of found during a write-off review
- FIFO violations are caught even when a lot still has time left on its code date
- Warehouse gets a ranked list instead of scanning the full freezer inventory by hand
Built for ice cream warehouse managers · frozen dessert inventory control · plant operations · distribution and logistics teams
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
mar-kov.comin a real browser with your saved login - no setup, no API keys. -
1
Mar-Kov - check finished goods age
mar-kov.com
WebRun opens Mar-Kov to check finished goods age. - Open Mar-Kov and pull every finished goods lot currently in freezer storage
- Capture the flavor, lot number, quantity, production date, and code date for each
- Calculate days remaining until code date and days in storage past the FIFO window
Done when Every stored lot has its age and days-remaining calculated.
-
2
Microsoft Excel - build the aging report
microsoft.com
WebRun opens Microsoft Excel to build the aging report. - Open the Freezer Aging Report workbook
- Add a row per lot with flavor, quantity, production date, code date, and days remaining
- Sort so the soonest code dates and oldest FIFO violations sit at the top
Done when This week's aging report is built and sorted by urgency.
-
3
Slack - alert warehouse to act
slack.com
WebRun opens Slack to alert warehouse to act. - Post a Slack alert listing every lot within 30 days of its code date
- Separately flag any lot that's sat past your FIFO rotation window regardless of code date
- Link to the full Excel report for the complete list
Done when Warehouse has a Slack alert for every at-risk lot with a link to the full aging report.
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 discard or write off any inventory itself?
No. WebRun only flags aging lots and reports them. Deciding to write off, discount, or divert product to another channel is always a decision your warehouse or plant manager makes.
What counts as a FIFO violation?
Any lot that has sat in freezer storage longer than the rotation window you've set, even if it's not yet close to its code date. Both are tracked and flagged separately.
How far ahead does it flag code dates?
It flags anything within 30 days of code date by default, with lots closer to expiry sorted to the top of the report so the most urgent product gets moved first.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.