How a dealer can screen an auction run list in ten minutes
A sale sheet is 200 cars. Most dealers walk the lane blind on the drivetrain. Here is a ten-minute routine that ranks the whole list by owner-complaint pattern the night before.
A wholesale run list is two hundred lines of year, make, model, VIN and lane number. You cannot inspect two hundred cars. You will inspect the twenty you were already interested in, take a look at a few more that catch your eye, and bid on the rest by price, light and gut.
The drivetrain is where that goes wrong. A transmission that shudders is not visible in a photo, does not show on a history report, and is not always audible in a lane. But the model year it belongs to has a record, in the complaints owners filed with NHTSA, and that record is public. The point of this routine is to have read it for every car on the sheet before you arrive.
What the run list does
Paste the sheet, up to 200 VINs at a time, into the tool. It pulls the year, make and model from each VIN, scores every distinct model year on its drivetrain complaint share, and hands the list back sorted worst-first, with a summary line at the top: how many of the scored cars show an elevated pattern, and how many of those are high or very high.
A sheet of 200 cars is usually only around 80 distinct model years, and the lookups are cached, so a full list comes back in a couple of minutes.
The score is the share of all NHTSA owner complaints about that model year that concern the engine, the transmission or the fuel and propulsion system. It is a base rate for the model year, not a verdict on the individual car. How it is calculated.
The ten minutes
Minute 1: get the VINs in. Copy the run list from the auction's PDF, spreadsheet or web page and paste the whole thing. The tool finds the 17-character VINs in whatever else is on the page, so there is no need to clean it up first. If the VINs are run together with no separators, it splits them.
Minutes 2 to 4: let it run. Decoding happens 50 VINs at a time, and each distinct model year is scored once. Do something else.
Minutes 5 to 8: read from the top. The cars with a very high or high drivetrain complaint signal are at the top of the list, in order. For each one, the question is not "is this car bad" but "do I want to be the one finding out". Three ways to answer:
- Skip it. On a sheet with plenty of stock, the simplest answer to a 2016 Focus is to let someone else buy it.
- Bid with an allowance. If the car is right for your lot at the right money, open the single-VIN report for it, look at the years either side and the auction light, and use the risk allowance to decide how much to take off your number. The allowance is experimental and yours to adjust; it is a starting point, not an instruction.
- Inspect it in the lane. Some cars on the top of the list are worth the money even with the pattern, because the fix is known and cheap or the pattern is engine-side and the car has had the recall. The report tells you what owners reported, so you know what to listen for when it drives through.
Minute 9: mark the sheet. Copy the ranked list as text and paste it into your notes, or mark the lane numbers of the flagged cars on the printed sheet. Whatever you do at the auction, you want the flag next to the car when the bidding starts, not on your phone in your pocket.
Minute 10: check the ones you were going to buy anyway. The cars you were already interested in are somewhere in the list. Find them. If one of them is near the top, you have just saved yourself a conversation with a customer in six months.
What the list will not do
It will not tell you that a particular car is bad. A 2014 Nissan Altima with a 45% share is a model year where owners complained heavily about the CVT; the one in lane 14 may have had the transmission replaced under an extended warranty last year and be the best car on the sheet. The report gives you the base rate and the symptom to check. The lane and the light give you the rest.
It will not score every car. Model years with fewer than about 25 complaints on file, which includes most cars from the last two model years, come back unscored, and that is not a clean bill of health. Exotic and low-volume cars may not decode to a model we track.
And it will not tell you what to bid. The risk allowance is a user-adjustable estimate based on the auction light. It exists so that "this model year has a pattern" turns into a number you can act on, and you set the number.
Comparing two
When you are choosing between two similar cars on the same sheet, the compare view puts them side by side: share, component breakdown, trend across the years either side. It is quicker than reading two reports and it tends to make the decision for you.
Cost
The subscription is $19.99 a month, with no per-car charge, the run list, compare, the model-year trend and the risk allowance. It is locked at that price for the first 25 dealers. There is no contract and it cancels any time.
Three reports are free on the dealer page before you subscribe, so the honest way to evaluate this is to pick the three cars from your last sale you wish you had not bought, run them, and see what the report would have told you.
Check the actual car, free.Paste the VIN. One report is free, no card, and it shows the complaint pattern for that year, make and model.
Check a VIN