Automated Overstock Decor Markdown Alerts
Every Monday, WebRun opens Artisan POS, finds decor and everyday party stock sitting unsold for 90 days or more, checks the cash tied up in each using QuickBooks, logs the full list to Google Sheets, and alerts Slack with the slowest movers and a suggested markdown.
How do I find overstocked party decor that needs a markdown?
WebRun catches decor stock before it quietly eats into your cash flow. Every Monday it checks Artisan POS for items unsold for 90 days or more, calculates the cash tied up using QuickBooks cost data, logs the full list to Google Sheets, and alerts Slack with the slowest movers and a suggested markdown to clear them.
- Slow moving decor gets flagged before it ties up cash for months
- Managers see a ranked markdown list every Monday, not a manual audit
- Seasonal and everyday overstock are tracked separately
Built for party supply retailers · decor and party goods stores · inventory 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
certek.comin a real browser with your saved login - no setup, no API keys. -
1
Artisan POS - find decor sitting past 90 days
certek.com
WebRun opens Artisan POS to find decor sitting past 90 days. - Open Artisan POS and pull non-seasonal decor with no sale in 90 days or more
- Note units on hand and days since last sale for each
- Exclude anything already flagged as discontinued
Done when Every slow-moving decor SKU is listed with units on hand and days unsold.
-
2
QuickBooks - calculate cash tied up and margin
- Look up unit cost for each slow-moving SKU
- Calculate total cash tied up (units on hand times cost)
- Suggest a markdown percentage that clears cost at a small margin
Done when Every slow-moving SKU has a cash-tied-up figure and a suggested markdown.
-
3
Google Sheets - log the full overstock list
google.com
WebRun opens Google Sheets to log the full overstock list. - Log the full overstock list with cash tied up and suggested markdowns
- Sort by cash tied up, highest first
- Keep a column for the manager to mark items as cleared
Done when The full ranked overstock list is logged and ready to work.
-
4
Slack - alert the slowest movers
slack.com
WebRun opens Slack to alert the slowest movers. - Post the top 10 slowest movers by cash tied up
- Include the suggested markdown percentage for each
- Link to the full list in Google Sheets
Done when The team has this week's top overstock alerts in Slack.
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 mark down the prices itself?
No. It only suggests a markdown percentage in Google Sheets and Slack. Applying any price change in Artisan POS is still a manager's call.
What counts as overstocked?
Non-seasonal decor with no sale in 90 days or more, ranked by how much cash is tied up in the units still on hand.
Does it flag seasonal costumes, too?
No, seasonal and holiday stock is handled by the post-holiday clearance workflow. This one focuses on everyday decor that's stopped moving.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.