Sponsored
2025 4Runner ALLOCATIONS LIST Spreadsheet (Gas & Hybrid) -- MSRP vs List Price, VIN, ETA, Ship Status, Dealer Hold Status đź“‹
No temporary VIN. The guest.dealer.toyota.com link I was referencing was the dealer provided spec sheet for the specific 4Runner.
I just now noticed there's an entire thread of posters discussing a similar issue as mine. I'll take this discussion there so as to not clog up this thread.
- First Name
- Fred
- Joined
- Mar 28, 2025
- Threads
- 0
- Messages
- 5
- Reaction score
- 1
- Location
- South Carolina
- Vehicle(s)
- Toyota 4Runner, GMC Truck, Mercury Grand Marquis
Is this list sourced directly from Toyota? I haven’t noticed much (if any) changes since I started watching it last month.
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 https://api.search-inventory.toyota.com/graphql .
Whatever that website returns the spreadsheet will have it in it., plus that website can only return at most 10,000 vehicles per zipcode search, and so the program searches multiple zipcodes to obtain all the inventory.
Hold Status, Shipping Status, ETA from/To dates frequently change in the spreadsheets, and less often even the prices and options change. Vehicles drop off the spreadsheet as they are sold and no longer appear in inventory (those go into the Sold inventory files), and just since I added the FirstAddedDate column (added April 8th) some 555 new VINS have been added since April 8th in the 4runner.csv file., and some 268 VINs have been added to the 4runnerhybrid.csv file. Granted some may have been temp VINS being converted to real VINS.
For more details on the spreadsheets see the Readme.txt file in the google drive
https://drive.google.com/drive/folders/1uOnNR7wVHN6o5rTjcMhVsNL3SKq5UJwC?usp=sharing.
Last edited:
Hopefully in the next few days I will have a new feature added that will show change history in the last 14 days (in a file named <model>_ChangeHistory.csv)
So as each days run occurs it is compared to the result of the prior run and will show events for any additions (VINS that appeared since last run), modifications, or removals (VINS that disappeared and thus are sold) with respect to that.
Two new columns are added in this file: "RowChangeType" and "List of Changes"
RowChangeType - is either ADDED, MODED, REMOVED
"List of Changes" - is used when the RowChangeType is MODED to show all column values that changed for that VIN and their old and new values.
While for additions , and removals you can already look at the FirstAddedDate, and the Sold files, respectively, the Change history file provides an easy way to see all these in one place for the last 14 days, plus these are events, so if a car was sold then the sale fell through and the inventory was made available again, you would see a removed event, and then an added event in that file, assuming they happened within 14 days of each other (I may make how far back we keep history longer depending on how the file size is).
The modification change history is new.
If there was a modification where any column value for an existing VIN changed, then only the changes will be shown as text in a
new column "List of Changes" For example if say the eta.currFromDate changed for a VIN then you would see in the "List of Changes" column cell for that VIN a text string something like
eta.currFromDate :: 2023-01-24 --> 2024-12-15 ||.
This could be useful if your wanting to easily know any changes that have occurred to a specific VIN you are following each day (ETA, price, options, etc)
Hopefully this will be useful to someone.
So as each days run occurs it is compared to the result of the prior run and will show events for any additions (VINS that appeared since last run), modifications, or removals (VINS that disappeared and thus are sold) with respect to that.
Two new columns are added in this file: "RowChangeType" and "List of Changes"
RowChangeType - is either ADDED, MODED, REMOVED
"List of Changes" - is used when the RowChangeType is MODED to show all column values that changed for that VIN and their old and new values.
While for additions , and removals you can already look at the FirstAddedDate, and the Sold files, respectively, the Change history file provides an easy way to see all these in one place for the last 14 days, plus these are events, so if a car was sold then the sale fell through and the inventory was made available again, you would see a removed event, and then an added event in that file, assuming they happened within 14 days of each other (I may make how far back we keep history longer depending on how the file size is).
The modification change history is new.
If there was a modification where any column value for an existing VIN changed, then only the changes will be shown as text in a
new column "List of Changes" For example if say the eta.currFromDate changed for a VIN then you would see in the "List of Changes" column cell for that VIN a text string something like
eta.currFromDate :: 2023-01-24 --> 2024-12-15 ||.
This could be useful if your wanting to easily know any changes that have occurred to a specific VIN you are following each day (ETA, price, options, etc)
Hopefully this will be useful to someone.
So, some interesting data from the first run with the Change History
The first is a case where the VIN went from one dealer to another, Presold went from False to True, and
XP Terrain option was added, and TMSRP , TMSRP plus DIO, and Selling price all increasing (due to the added option)
This next one is where a single option was removed (Cargo Cover) but the Selling price stayed the same, as the Markup (diff between selling price and TMSRP ) went up to offset it.
Here is one where a single Dealer option was removed (Scott Clark Advantage Package ) but the Selling price stayed the same even though the TMSRP+DIO dropped by $3488. So the Markup was the same (diff between TMSRP and Selling price of $3488) , TMSRP the same, TMSRP+DIO dropped by $3488 due to the removed dealer option. , but that drop not reflected into the Selling Price which stayed the same ($50683).
Possibly an oversight by the dealer.
and here is what is very common to see in the change history, where the Shipping status changes and the ETAs change
The first is a case where the VIN went from one dealer to another, Presold went from False to True, and
XP Terrain option was added, and TMSRP , TMSRP plus DIO, and Selling price all increasing (due to the added option)
Code:
Dealer :: Clearwater Toyota --> Fred Anderson Toyota of Asheville || Dealer City :: Clearwater --> Asheville || Dealer Lat :: 27.970899 --> 35.53621 || Dealer Long :: -82.729362 --> -82.60152 || Dealer State :: FL --> NC || Dealer Website :: https://www.clearwatertoyota.com --> https://www.ashevilletoyota.com || Dealer Zip :: 33765 --> 28806 || Options :: :Added---> XP Terrain | :Same---> 50 State Emissions | 6-Gallons of Gas | Clear Paint Protection - Door Package | Dashcam | Phone Cable Charge Package | SET Digital Portfolio | TOYOGUARD Platinum | TRD OFF-ROAD | || Pre-Sold :: False --> True || Selling Price :: 52246.0 --> 55445.0 || TMSRP plus DIO :: 52246.0 --> 55445.0 || Total MSRP :: 52246.0 --> 55445 ||
Code:
Markup :: 0.0 --> 135.0 || Options :: :Removed---> Cargo Cover | :Same---> 50 State Emissions | All Weather Cargo Mat | All Weather Floor Liners | Badge Inserts- Rr TOYOTA Chrome | Fixed Running Boards | Mudguards | Rear Cargo Lamp | || TMSRP plus DIO :: 45678.0 --> 45543.0 || Total MSRP :: 45678.0 --> 45543 || eta.currFromDate :: 2025-04-15 --> 2025-04-16 || eta.currToDate :: 2025-04-28 --> 2025-04-24 ||Possibly an oversight by the dealer.
Code:
Options :: :Removed---> Scott Clark Advantage Package | :Same---> 17" Nitto Ridge Grappler All-Terrain Tire Upgrade | 50 State Emissions | 6-Gallons of Gas | Black Front Emblem Overlay | Clear Paint Protection - Door Package | SET Digital Portfolio | SmartLED Ambient Lighting | TOYOGUARD Platinum | || TMSRP plus DIO :: 50683.0 --> 47195.0 || eta.currFromDate :: 2025-04-24T00:00:00.000Z --> 2025-04-18T00:00:00.000Z || eta.currToDate :: 2025-04-29T00:00:00.000Z --> 2025-04-23T00:00:00.000Z ||
Code:
Shipping Status :: Factory to port --> Port to dealer || eta.currFromDate :: 2025-04-23T00:00:00.000Z --> 2025-04-18T00:00:00.000Z || eta.currToDate :: 2025-04-28T00:00:00.000Z --> 2025-04-23T00:00:00.000Z ||So this appears to be a temp VIN going to a real VIN as all the other columns match up and the one that was removed occurred on
the same inventory run as the one that was added. Interesting that more than the VIN 2 letters in the last 6 digits just don't change to make the real VIN, assuming this is in fact the Temp VIN going to a real VIN
the same inventory run as the one that was added. Interesting that more than the VIN 2 letters in the last 6 digits just don't change to make the real VIN, assuming this is in fact the Temp VIN going to a real VIN
| RowChangeType | Event DateTime | Year | Model | Color | Int Color | Base MSRP | Total MSRP | Selling Price | Selling Price Incomplete | Markup | TMSRP plus DIO | Shipping Status | Pre-Sold | Hold Status | eta.currFromDate | eta.currToDate | VIN | isTempVin | Dealer | Dealer Website | Dealer State | Dealer City | Dealer Zip | Dealer Lat | Dealer Long | CenterLat | CenterLong | DistanceFromCenter | Transmission | MPG Combined | MPG City | MPG Highway | Engine Code | Engine Name | FirstAddedDate | infoDateTime | List of Changes | Options |
| ADDED | 4/16/2025 21:10​ | 2025​ | SR5 RWD | Cutting Edge | Black Fabric | 40770​ | 44422​ | 44422​ | TRUE​ | 0​ | 44422​ | Factory to port | FALSE​ | DealerHold | 5/7/2025​ | 5/21/2025​ | JTEVA5AR2S5002931 | FALSE​ | Toyota of North Hollywood | https://www.northhollywoodtoyota.com | CA | North Hollywood | 91602​ | 34.15386​ | -118.368​ | 41.97838​ | -91.6686​ | 8-Speed Automatic Transmission | 22​ | 20​ | 26​ | IF24CTE | i-FORCE 2.4L 4-Cyl. Turbo Engine | 4/16/2025 21:04​ | 4/16/2025 21:04​ | 50 State Emissions | All Weather Floor Liners | Badge Inserts: Matte Black | Cross Bars | Predator Drop Step | Third Row Seating - SR5 |
| RowChangeType | Event DateTime | Year | Model | Color | Int Color | Base MSRP | Total MSRP | Selling Price | Selling Price Incomplete | Markup | TMSRP plus DIO | Shipping Status | Pre-Sold | Hold Status | eta.currFromDate | eta.currToDate | VIN | isTempVin | Dealer | Dealer Website | Dealer State | Dealer City | Dealer Zip | Dealer Lat | Dealer Long | CenterLat | CenterLong | DistanceFromCenter | Transmission | MPG Combined | MPG City | MPG Highway | Engine Code | Engine Name | FirstAddedDate | infoDateTime | List of Changes | Options |
| REMOVED | 4/16/2025 21:10​ | 2025​ | SR5 RWD | Cutting Edge | Black Fabric | 40770​ | 44422​ | 44422​ | TRUE​ | 0​ | 44422​ | Factory to port | FALSE​ | DealerHold | 5/7/2025​ | 5/21/2025​ | JTEVA5AR5S116BB92 | TRUE​ | Toyota of North Hollywood | https://www.northhollywoodtoyota.com | CA | North Hollywood | 91602​ | 34.15386​ | -118.368​ | 41.97838​ | -91.6686​ | 8-Speed Automatic Transmission | 22​ | 20​ | 26​ | IF24CTE | i-FORCE 2.4L 4-Cyl. Turbo Engine | - | 4/15/2025 21:04​ | - | 50 State Emissions | All Weather Floor Liners | Badge Inserts: Matte Black | Cross Bars | Predator Drop Step | Third Row Seating - SR5 |
Gerg-G, thank you for putting the time into developing these tracking sheets, it is the way I found and secured my upcoming vehicle!
Do you think it makes sense to simply roll the change column into the main spreadsheets vs new spreadsheet? I definitely see the advantage of both ways.
Again, thank you for this invaluable resource!
Do you think it makes sense to simply roll the change column into the main spreadsheets vs new spreadsheet? I definitely see the advantage of both ways.
Again, thank you for this invaluable resource!
You're welcome
So for a single VIN there could be up to 14 event rows in the Change History file if something changed for that VIN every day.
So a VIN could be added one day, then the next day modified due to say it's Hold status changes, then the next day say its Shipping Status changes along with ETA changes, then a few days later its ETA changes then a few days later its Shipping status changes and ETAs change.
You can easily see all those by filtering on that VIN in the Change History. Plus each row has the column values for the VIN at that time just like the main spreadsheet. And removing changes that are older than 14 days is easy as it is simple python pandas filtering using the Event DateTime.
So if a person didn't check the Change History file for a few days you could still see all those changes day by day by filtering on that VIN and the one with the latest Event DateTime is the the current one (assuming events weren't older than 14 days). And if you didn't see your VIN then either nothing has changed in the last 14 days or it was removed (sold).
Adding just the List of Changes column in the main sheet wouldn't work if each row has only a unique VIN in it and it's implemented to show what changed from the last run because if you missed one day of looking at that main spreadsheet you wouldn't see all those changes (which is really the purpose of the Change History ) and it would be much more difficult if I were to try to include all changes in the last 14 days on a rolling basis for that VIN in a single cell.
If I added all the change events row by row into the main sheet then it would make it more difficult to find things and it would be very different from what people are used to seeing (a given VIN is in only one row of the spreadsheet)
Based on the above I'm keeping it in a separate Change History File. If you can come up with a few concrete examples of the behavior you want to see (like how does the main spread sheet look after a new vin is added, and then say the next day a hold status changes, then the next day the shipping status changes along with ETA changes, then the next day the options change, etc) I can take a look at it.
So it appears in the 4Runner_ChangeHistory.csv file there are currently 62 instances of where a temp VIN changes to a real VIN for a dealer where all the columns are exactly the same except the VIN, and it's not just the letters that change in the last 6 digits of the temp VIN going to a real VIN, but the entire last 6 digits from the few I looked at. That's over 4 days of inventory runs.
Similar threads
Recent Posted Photos (Random Order)
Recent Posted Photos (Random Order)