Overstock has a discovery problem before it has a clearance problem. In most stores, nobody knows which SKUs are stuck until someone runs the quarterly inventory review, and by then the products have been eating storage cost and tying up cash for months. The clearance response is usually worse than the disease: a 10 percent sitewide code that discounts the bestsellers along with the dead stock, leaks to coupon sites within hours, and trains the whole list to wait for sales.
Detection: Sell Through Rate, Daily
The automated version starts with a daily scan. Every SKU's sell through rate (units sold over days in stock) is computed against its category baseline, and anything underperforming past a configured age threshold gets flagged as overstock the day it crosses the line, not the quarter after. The flag carries context: days held, current stock, product cost, and current margin, everything the next step needs.
The Offer: Calculated, Targeted, Sealed
Instead of one blanket code, the system calculates the offer per product and per customer tier. A 65 percent margin product sitting 90 days can carry an aggressive 25 to 30 percent code for high value customers. A 25 percent margin product gets free shipping instead, because there is no price room. Every code is unique, single use, and expiring, so nothing leaks to coupon aggregators and full price sales stay intact. The campaign goes only to the segment likely to want that product, and the team gets a Slack alert that it fired.
The complete decision matrix, including how margin, stock age, and customer lifetime value combine into the offer, is laid out on our inventory driven marketing engine page.