Clear shelf-warmers
Every Monday, WebRun scans your Square inventory for products with no sales in the past 90 days, logs the aged items to a Google Sheets report with their cost and margin details, and drafts a tiered markdown plan for staff to review and approve in Slack before any prices change.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically find and report aged inventory in my hobby shop?
WebRun scans your Square inventory every Monday for products with no sales in 90 days, logs each item to a Google Sheets report with cost and margin details, and drafts a tiered markdown plan in Slack for staff to review. No prices change in Square until a staff member approves and applies the reductions.
- Shelf-warmers identified every week without manually reviewing Square reports
- Cost and margin data in Google Sheets shows the true financial impact of aged stock
- Markdown plan drafted and ready for staff approval so action happens fast
Built for game store owners · hobby shop managers · retail buyers · card game shop operators
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
squareup.com/dashboardin a real browser with your saved login - no setup, no API keys. -
1
Square - identify items with no sales in 90 days
squareup.com How to Automate Square
WebRun opens Square to identify items with no sales in 90 days. - Open Square and pull the sales history for the past 90 days
- Identify items with zero units sold in that period that still have stock on hand
- Capture each item's name, SKU, current price, cost, quantity on hand, and last sale date
Done when All aged items with no sales in 90 days are listed with their cost and pricing details.
-
2
Google Sheets - log aged inventory with cost and margin details
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log aged inventory with cost and margin details. - Open the aged inventory report sheet
- Append or update each aged item's row with the current date, cost, current price, quantity, and margin
- Flag items aged longer than 180 days in a separate column for priority action
Done when The aged inventory sheet is updated with all current shelf-warmers and their financial details.
-
3
Slack - post markdown plan draft for staff review
slack.com How to Automate Slack
WebRun opens Slack to post markdown plan draft for staff review. - Post a Slack message to the inventory channel summarizing the aged inventory count and total retail value
- Include a draft markdown plan: suggest 10% off for 90 to 180-day items and 25% off for items over 180 days
- Flag that all price changes need staff approval before being applied in Square
Done when Staff have a Slack summary with a draft markdown plan ready to review and approve.
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 automatically apply markdowns in Square?
No. WebRun drafts the markdown plan and posts it to Slack for staff review. Price changes in Square are only made after a staff member approves the plan and applies the reductions manually.
What counts as aged inventory?
By default, any product with zero units sold in the past 90 days and stock still on hand is flagged. You can adjust this window to 60 or 120 days depending on how quickly your product categories typically turn.
Can it suggest different markdown depths for different product types?
Yes. Give WebRun a category-specific markdown policy and it will apply different discount tiers for singles, sealed product, accessories, and supplies so the plan fits your store's margin structure.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.