Recent content by Gerg-G

Thanks for the info.

When a VIN disappears from the current spreadsheet it will immediately appear on the Sold spreadsheet (same run of the program), and if the VIN reappears on the current spreadsheet it is immediately removed from the Sold spreadsheet. I'm curious as to what the VIN was just to verify the...

The Sold files are on the Google drive, containing all Toyota model spreadsheets https://drive.google.com/drive/folders/1uOnNR7wVHN6o5rTjcMhVsNL3SKq5UJwC Just look for <model>_<model year>_Sold.csv. So for the 4runner it would be in 4runner_2026_Sold.csv for the 2026 model year Sold 4runner...

Yeah, I was curious, and you had that one post where you showed the VIN from the dealer screen shot, so thought I'd look it up to see if had moved to the Sold sheet or something.

Looks like it moved to the Sold spreadsheet on 7/3 at 9pm CDT. Delivery dates changed on 7/2 9pm CDT as follows (right before it disappeared from inventory the next day and moved to the sold spreadsheet) eta.currFromDate :: None --> 2026-07-03 || eta.currToDate :: None --> 2026-07-08 || Note...

From the Readme.txt file on that google drive "Shipping Status" - "Factory to port" - Allocated, or in production, or on the ship, or sitting at the port "Port to dealer" - Checked in at the port and in the process of moving from the port to the dealership lot...

Note that the sheets are updated daily and the last run for the 4runner was on 6/28/2026 at 9pm CDT. The next run will be on 6/29 at 9pm CDT so hopefully the dates will show up when it is uploaded to the google drive by 6/30/2026 6AM CDT then but it's any ones guess if it will have the blanks...

Based on the dealer name in the picture , trim and color, and the spreadsheets, I'm guessing you got a pretty good discount :)

If it wasn't in the spreadsheet then it was removed from the Toyota's search inventory website as that is the only place the spreadsheet gets its data from. And yes, dealers may still show the vehicle on the dealer website in that case. Also some dealers don't use the Pre-Sold field and...

See the readme.txt file on the google drive for an explanation of this. An excerpt from that file follows: "The inventory is obtained from the same place the Toyota Inventory search website (https://www.toyota.com/search-inventory/) gets its data from (which is...

Made another update to correct finding the real VIN for a temp VIN.

Ok, I updated and corrected the description for how you determine what real VIN replaced a temporary VIN. See the readme.txt file for this. A bit more involved due to having to sort several columns at first which is what was missing before.

Dang, that was a long time it was held up. Yeah, not sure if the 2 to 3 week delivery time is normal for going to Wichita, Kansas . Not sure of the main distributor hub in that area that it could go to first before it gets on a truck for delivery to your dealer. Update: Asked google and in...

Nice job of finding the real VIN number.(y)(y)(y) I'm going to need to update my description in the readme.txt file of how to find it since it has a flaw in it where I don't account for the price changes (MODED) that occur between the Added and Removed.

It means that either it was a temporary VIN (last 6 digits have an alphabetic character in them) which has now been assigned a real VIN, or the car has been sold and information is no longer available from the Toyota inventory search website for it. See the readme.txt file for more detail.