Automated Slow-Mover Markdown Flags
Every morning, WebRun opens ShelfPerks to read each cheese's days on shelf and remaining freshness, pulls its recent sales pace from Square, and logs a ranked markdown candidate list to Google Sheets so slow movers get flagged for a discount before they lose quality.
How do I flag slow-moving cheese for markdown automatically?
WebRun spots slow-moving cheese before it turns. Each morning it reads days on shelf and freshness in ShelfPerks, checks the sales pace in Square, estimates whether each cheese will clear in time, and logs a ranked markdown candidate list to Google Sheets with a suggested tier, so you discount at the right moment rather than discarding.
- Slow movers are discounted in time instead of discarded
- Markdown timing uses real Square sell-through, not a hunch
- A ranked candidate list is ready every morning for a quick call
Built for cheese shop owners · specialty food retailers · deli buyers · grocery cheese 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
app.shelfperks.comin a real browser with your saved login - no setup, no API keys. -
1
ShelfPerks - read shelf age and freshness
shelfperks.com
WebRun opens ShelfPerks to read shelf age and freshness. - Open ShelfPerks and read the days on shelf for each cut and packaged cheese
- Capture the remaining shelf life or best-by window per item
- Note the current price and quantity on hand
- Flag any cheese past your slow-mover age threshold with stock still remaining
Done when Every cheese past its shelf-age threshold is listed with days on shelf and stock on hand.
-
2
Square - check recent sales pace
squareup.com
WebRun opens Square to check recent sales pace. - Open Square and read the units sold per day for each flagged cheese over the last two weeks
- Calculate the sales pace and estimated days to clear at that rate
- Match each Square item to its ShelfPerks record by SKU or name
- Keep only items that will not clear before their best-by window
Done when Each flagged cheese has a sales pace and an estimated days-to-clear figure.
-
3
Google Sheets - log the markdown candidates
google.com
WebRun opens Google Sheets to log the markdown candidates. - Open the Markdown Candidates sheet
- Append each slow mover with days on shelf, sales pace, days to clear, and current price
- Suggest a markdown tier based on how far it is from clearing in time
- Sort by risk so the cheeses most likely to turn sit at the top
Done when The sheet lists today's markdown candidates ranked by risk of not clearing.
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 change any prices in Square or ShelfPerks?
No. WebRun only suggests a markdown tier and writes the list to your Google Sheet. Applying any price change stays with you, so no discount goes live without a person approving it.
How does it decide a cheese is a slow mover?
It combines two signals: how many days the cheese has sat on the shelf in ShelfPerks and how fast it is selling in Square. A cheese that will not clear before its best-by window at its current pace is flagged.
How is the suggested markdown tier chosen?
By the gap between days to clear and days of freshness left. A cheese cutting it close gets a gentle tier, one likely to turn first gets a deeper one, and you always make the final call before anything is discounted.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.