Automated Mercari Stale Listing Tracker
Every Monday, WebRun opens Mercari, checks every active listing's age, flags anything unsold for 30 days or more, logs each with a suggested price drop to a Google Sheet, and emails the seller a reminder sorted by longest listed first.
How do I find and relist stale Mercari listings?
WebRun checks every active Mercari listing weekly, flags anything unsold for 30 days or more, logs each stale item with a suggested price drop to a Google Sheet, and emails the seller a reminder ranked by longest listed first. This keeps inventory from sitting stale without a periodic nudge to act.
- Stale listings get a price-drop nudge instead of sitting forgotten
- A ranked reminder lands every Monday morning
- Sold items drop off the tracker automatically
Built for Mercari sellers · resale side hustlers · closet cleanout sellers · part-time marketplace sellers
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
mercari.comin a real browser with your saved login - no setup, no API keys. -
1
Mercari - check listing age
mercari.com
WebRun opens Mercari to check listing age. - Open Mercari and go to the seller's active listings
- Check how long each listing has been active without selling
- Flag anything active for more than 30 days
Done when Every listing older than 30 days is captured with its current price.
-
2
Google Sheets - log the stale listing tracker
google.com
WebRun opens Google Sheets to log the stale listing tracker. - Open the Mercari Listings sheet
- Add a row for each stale listing with its age and current price
- Suggest a price drop percentage based on how long it has been listed
Done when The tracker sheet lists every stale item with an age and a suggested price drop.
-
3
Gmail - send the relist reminder
gmail.com
WebRun opens Gmail to send the relist reminder. - Draft a reminder email listing which items are stale and the suggested price drop
- Send it to the seller's own inbox
- Sort the list by longest listed first
Done when The seller has a relist and price-drop reminder in their inbox.
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 change my listing prices automatically?
No. WebRun only suggests a price drop and logs it. Editing the actual listing price on Mercari is left for the seller to do.
How is the suggested price drop calculated?
It scales with how long the item has sat unsold, so a listing at 90 days gets a larger suggested drop than one just past the 30-day mark.
What happens once an item sells?
It only reads currently active listings each week, so anything sold since the last check drops off the tracker on its own.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.