Automated Lightspeed Dead Stock Markdown Flags
Every Monday, WebRun opens Lightspeed Retail, identifies items with no sales in 60 or more days, calculates the tied-up inventory value, and writes a ranked markdown-candidate list to Google Sheets so your team can decide which items to discount or return.
How do I automatically identify dead stock in Lightspeed Retail?
WebRun checks Lightspeed Retail every Monday for items with no sales in 60 or more days, calculates each item's tied-up inventory value, and writes a ranked markdown-candidate list with suggested discount percentages to Google Sheets. Your team reviews the list and decides which items to discount or return to vendor.
- Dead-stock items surface weekly before they tie up cash any longer
- Suggested markdown percentages cut the time needed to plan promotions
- Ranked by value so the biggest cash-release opportunities come first
Built for retail store owners · retail buyers · inventory managers · boutique shops
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
retail.lightspeedhq.comin a real browser with your saved login - no setup, no API keys. -
1
Lightspeed - identify zero-sales items over 60 days
lightspeedhq.com
WebRun opens Lightspeed to identify zero-sales items over 60 days. - Open Lightspeed Retail and navigate to Reports then Inventory
- Filter for items with no sales in the last 60 days and stock on hand greater than zero
- Capture item name, SKU, quantity on hand, cost, retail price, and days since last sale
- Calculate total tied-up cost value for each item
- Sort by total value descending so highest-cost dead stock appears first
Done when Every dead-stock item is listed with its value and days-without-sale count.
-
2
Google Sheets - log ranked markdown-candidate list
google.com
WebRun opens Google Sheets to log ranked markdown-candidate list. - Open the designated Markdown Candidates sheet
- Append this week's dead-stock items with a date stamp
- Add a suggested markdown percentage column based on days without sale (60 to 89 days: 20%, 90-plus days: 40%)
- Highlight rows where tied-up value exceeds a set threshold
Done when The markdown-candidate list is updated in Google Sheets with suggested discounts and value flags.
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 apply the markdowns in Lightspeed automatically?
No. WebRun builds the candidate list and suggested discounts in Google Sheets for your team to review and approve. Price changes in Lightspeed are a manual step you control, so no prices are changed automatically.
Can I change the 60-day threshold?
Yes. Tell WebRun your preferred window, such as 30 days for fast-fashion or 90 days for seasonal goods, and it will use that cutoff every run.
What if an item has been on promotion recently?
WebRun reads actual sales transactions in Lightspeed, so any item that sold during a promotion is counted and will not appear on the dead-stock list for that period.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.