Automated Consignment Aged Inventory Report
Every Monday, WebRun opens Resaleworld Liberty, identifies consigned items that have exceeded your aging thresholds, groups them by consignor and category, logs the full aged-inventory breakdown to a Google Sheet, and posts a Slack digest to your team so floor staff can prioritize markdowns, repositioning, or consignor outreach.
How do I get an automated aged inventory report for my consignment store?
Every Monday, WebRun pulls the active inventory from Resaleworld and identifies items that have exceeded your aging thresholds, grouping them by tier and flagging those closest to expiry. The full breakdown is logged in Google Sheets and a digest is posted to your Slack channel, so floor staff can prioritize markdowns and consignor outreach before items lapse.
- Slow-moving items are surfaced weekly before they lapse and become a loss
- Staff have a prioritized list ready for the Monday floor walk
- Expiry-critical items are flagged separately so urgent action is never buried
Built for consignment shop owners · resale store floor managers · thrift and secondhand store buyers
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.resaleworld.comin a real browser with your saved login - no setup, no API keys. -
1
Resaleworld - identify items beyond aging thresholds
resaleworld.com
WebRun opens Resaleworld to identify items beyond aging thresholds. - Open Resaleworld Liberty and pull the active inventory report
- Filter for items that have been on the floor beyond each aging tier, such as 30, 60, and 90 or more days
- Capture each item's barcode, description, category, consignor, days on floor, current price, and markdown eligibility
- Sort the list by days on floor, longest first, to surface the most at-risk items at the top
Done when Every item beyond an aging threshold is captured with its consignor and pricing details, sorted by age.
-
2
Google Sheets - log aged-inventory breakdown
google.com
WebRun opens Google Sheets to log aged-inventory breakdown. - Append this week's aged-inventory data to the running Google Sheet log with today's date
- Group rows by aging tier: 30 to 59 days, 60 to 89 days, and 90 or more days
- Add a column flagging items approaching their consignment expiry within the next 7 days
- Update summary totals for item count and estimated retail value by tier
Done when This week's aged-inventory data is logged in Google Sheets with tier groupings and expiry flags.
-
3
Slack - post weekly digest to floor team
slack.com
WebRun opens Slack to post weekly digest to floor team. - Post a Slack digest to your floor team channel with a count and estimated value by aging tier
- Highlight the number of items within 7 days of consignment expiry as the top priority
- Link to the Google Sheet for the full item-level breakdown
Done when Your team has a Slack summary of this week's aged inventory with a link to the full 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 change prices or contact consignors automatically?
No. The aged-inventory report is a read-only digest for your team. All pricing decisions and consignor outreach are made by staff after reviewing the report.
Can it track multiple aging tiers at the same time?
Yes. You configure as many aging tiers as your policy requires, such as 30, 60, and 90 or more days. WebRun groups items into each tier in the Google Sheet and Slack digest.
What if an item sells between when the report runs and when staff review it?
The report reflects inventory as of the moment WebRun pulls it from Resaleworld. Staff should check the live system before acting on any flagged item to confirm it has not already sold.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.