Automated Restock vs Scrap Report for Returned Products
Every Monday, WebRun opens ReverseLogix, aggregates the past week's return inspection grades by SKU, computes the restock versus scrap ratio for each, and drafts an email report for your merchandising team highlighting the worst-performing products.
How do I automatically report which returned SKUs should be restocked versus scrapped?
WebRun aggregates every return inspection in ReverseLogix each Monday, computes the restock-versus-scrap ratio for each SKU, and drafts a ranked report in Gmail for your merchandising team. High-scrap products are flagged automatically so quality issues are caught and acted on within hours of the week starting.
- High-scrap SKUs are identified every Monday before they drain warehouse space and capital
- Merchandising team gets a ranked action list, not a raw data export
- Report arrives as a reviewable draft, not an automated send
Built for merchandising teams · returns operations managers · e-commerce brands · consumer goods companies
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
app.reverselogix.comin a real browser with your saved login - no setup, no API keys. -
1
ReverseLogix - aggregate inspection grades by SKU
reverselogix.com
WebRun opens ReverseLogix to aggregate inspection grades by SKU. - Open ReverseLogix and go to the inspection reports for the past 7 days
- Group inspected returns by SKU and grade (A/B restock-eligible, C/scrap)
- Calculate the restock rate and scrap rate for each SKU
- Rank SKUs by highest scrap rate and flag any above your defined threshold
Done when Every SKU with returns in the past week has a restock rate, scrap rate, and unit count.
-
2
Gmail - draft weekly restock-vs-scrap report
gmail.com
WebRun opens Gmail to draft weekly restock-vs-scrap report. - Draft a weekly restock-vs-scrap report email addressed to the merchandising team
- Include a table of SKUs ranked by scrap rate with unit counts
- Leave the email as a draft in Gmail for your review before sending
Done when A draft report email is ready in Gmail, waiting for review and send approval.
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 send the report email without me reviewing it?
No. WebRun drafts the email and leaves it in Gmail for your review. You decide when to send it and who else to copy. Nothing goes out automatically.
How does it define a SKU as a scrap risk?
It flags SKUs where the scrap rate exceeds a threshold you set, such as 20% of returns graded C or below. You configure that threshold once during setup.
Can it include cost data alongside the unit counts?
Yes, if your ReverseLogix account has estimated scrap and resale values per grade. WebRun reads those values and adds a recovered-value column to the report.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.