Sponsored

Gerg-G

Well-known member
Joined
Mar 12, 2025
Threads
1
Messages
119
Reaction score
72
Location
Iowa
Vehicle(s)
Rav4 PlugIn Hybrid
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.
Sponsored

 

Gerg-G

Well-known member
Joined
Mar 12, 2025
Threads
1
Messages
119
Reaction score
72
Location
Iowa
Vehicle(s)
Rav4 PlugIn Hybrid
Made another update to correct finding the real VIN for a temp VIN.
 

Mr. Wolfe

TRD Off-Road Premium
Well-known member
First Name
Greg
Joined
Apr 14, 2026
Threads
8
Messages
101
Reaction score
71
Location
Pittsburgh
Vehicle(s)
Porsche Macan GTS, Porsche 911 (964), BMW M3
Thanks for everyone's help. I did contact my sales guy and he confirmed my car's VIN did change at port. All is well! :)

Mr. Wolfe
 

yotahilux

TRD Off-Road Premium
Member
First Name
Chuck
Joined
May 15, 2026
Threads
0
Messages
16
Reaction score
15
Location
Harrisonburg, VA
Vehicle(s)
2021 JLUR, 2023 Outback Wilderness (2BSold), Enroute 2026 4Runne Off Road Prem
I should pick up my ORP in Supersonic Red this afternoon. Dealer confirmed it will deliver this morning.
 

morsk

SR5
Active member
Joined
May 22, 2026
Threads
0
Messages
44
Reaction score
17
Location
NY
Vehicle(s)
2026 SR5
I should be picking my SR5 tomorrow afternoon.
Dealer called me yesterday afternoon and let me know it has arrived on the lot. My salesperson is off today, so tomorrow it is.

In my case, the ETA kept getting shifted forward, not back...almost a month earlier than initially projected!
 

Mr. Wolfe

TRD Off-Road Premium
Well-known member
First Name
Greg
Joined
Apr 14, 2026
Threads
8
Messages
101
Reaction score
71
Location
Pittsburgh
Vehicle(s)
Porsche Macan GTS, Porsche 911 (964), BMW M3
Great news for you guys! Hopefully mine moves up as well...

Mr. Wolfe
 

Blackie1

Limited
Member
First Name
Paul
Joined
Jun 9, 2026
Threads
1
Messages
11
Reaction score
11
Location
Texas
Vehicle(s)
2026 4Runner
I'm new to this forum but I wanted to say whoever setup the Excel spreadsheet just saved me a lot of money. I found my 4Runner and the PIO options on it and sent that to the Sales Manager at my dealership and he deleted all the extra nonsense Gulf States was adding to my truck. So thank you very much.
 

morsk

SR5
Active member
Joined
May 22, 2026
Threads
0
Messages
44
Reaction score
17
Location
NY
Vehicle(s)
2026 SR5
My SR5 should be coming in any day now, from earlier this week to the eond of the month.
Did my morning ritual of checking the status change spreadsheet and the estimated date has now changed to nan/blank. Still Port to Dealer as the shipping status.

Dunno what to make of this. Hoping that I get a call from the dealer once the shop opens to hear that it's been delivered but we'll see...
Morning update: changelog has added the dates back this morning, with a tighter timeframe - delivery expected some time in the next few days!
I should be picking my SR5 tomorrow afternoon.
Dealer called me yesterday afternoon and let me know it has arrived on the lot. My salesperson is off today, so tomorrow it is.

In my case, the ETA kept getting shifted forward, not back...almost a month earlier than initially projected!
Just an update for record-keeping purposes and anybody who cares (probably nobody)

Picked up my SR5 yesterday afternoon! I'm coming from a Honda Accord and with my first ride in this vehicle (not counting a test drive of a random lot car), I was expecting to really be hit in the face with a more truck-ish ride (i.e. not smooth, less responsive, and loud) and it wasn't bad at all! Maybe I'll write more about it in another post once the inital excitement wears off a bit, but first impressions were quite positive.

For the spreadsheet nerds - I noticed that earlier this week, my vehicle had been removed from the 4runner.csv spreadsheet. It got moved over to the SOLD file, even though (1) it hasn't yet been sold and (2) the "Pre Sold" column continues to state "FALSE."

And finally, I'd like to thank Costco Auto Program for getting me a great discount (~7%) without all the BS haggling. I was working with a salesman from another dealer going about the traditional route and it was the biggest pain imaginable...then I remembered about the Costco program and gave it a go, and I'm very happy that I did!

2025 2026 4runner 6th gen 2025 / 2026 4Runner Search: Available Inventory Allocations List - MSRP vs List Price, VIN, ETA, Ship Status, Dealers, Hold Status IMG_9456
 

Mr. Wolfe

TRD Off-Road Premium
Well-known member
First Name
Greg
Joined
Apr 14, 2026
Threads
8
Messages
101
Reaction score
71
Location
Pittsburgh
Vehicle(s)
Porsche Macan GTS, Porsche 911 (964), BMW M3
Found out my truck is on the Aegean Highway ship and has an ETA of 6/26 at the Portland Port.

Mr. Wolfe
 

bobholthaus

Well-known member
First Name
Bob
Joined
Apr 10, 2024
Threads
6
Messages
76
Reaction score
23
Location
St. Louis MO
Vehicle(s)
Jeep JL-370 AEV Diesel
I wish I would've known about the Costco program!! lucky you.

My dates on the spreadsheet are still both blank even though I know for certain my car is on a train. I'll check again today to see if it's updated.
 

Mr. Wolfe

TRD Off-Road Premium
Well-known member
First Name
Greg
Joined
Apr 14, 2026
Threads
8
Messages
101
Reaction score
71
Location
Pittsburgh
Vehicle(s)
Porsche Macan GTS, Porsche 911 (964), BMW M3
I wish I would've known about the Costco program!! lucky you.

My dates on the spreadsheet are still both blank even though I know for certain my car is on a train. I'll check again today to see if it's updated.
You could probably call your dealership - they should have that info if you really want to know. They will have something similar to this:

2025 2026 4runner 6th gen 2025 / 2026 4Runner Search: Available Inventory Allocations List - MSRP vs List Price, VIN, ETA, Ship Status, Dealers, Hold Status Screenshot 2026-06-18 at 10.30.15 AM
 

bobholthaus

Well-known member
First Name
Bob
Joined
Apr 10, 2024
Threads
6
Messages
76
Reaction score
23
Location
St. Louis MO
Vehicle(s)
Jeep JL-370 AEV Diesel
You could probably call your dealership - they should have that info if you really want to know. They will have something similar to this:

Screenshot 2026-06-18 at 10.30.15 AM.webp
Thank you my friend. That's how I know, because he sent me that screenshot on Monday and it showed that it was on the train!
 

Gerg-G

Well-known member
Joined
Mar 12, 2025
Threads
1
Messages
119
Reaction score
72
Location
Iowa
Vehicle(s)
Rav4 PlugIn Hybrid
For the spreadsheet nerds - I noticed that earlier this week, my vehicle had been removed from the 4runner.csv spreadsheet. It got moved over to the SOLD file, even though (1) it hasn't yet been sold and (2) the "Pre Sold" column continues to state "FALSE."
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 https://api.search-inventory.toyota.com/graphql ). The folder also contains the sold inventory
(defined as inventory that appeared at one time in a run, but no longer appears in the inventory obtained from the website),
.
.
.
The sold inventory files are for VINs that no longer appear in the current inventory (were seen at one time
by the inventory run but have since disappeared).
These files are named <model>_<year>_Sold.csv with the associated raw parquet in <model>_<year>_Sold_raw.parquet
Also note that currently if a temp VIN is turned into a real VIN, and thus the temp VIN disappears,
the temp VIN is treated as Sold, because it disappeared from current inventory, and is placed in the associated Sold file.
This currently allows temp VINs to still be seen for a period of time and a user to
know when it was turned into a real VIN by the infoDateTime field (not necessarily what the real VIN is).
A user can determine the real VIN that has replaced a temp VIN by using the Change History file (see below).
Once a temp VIN in the sold file is older than 16 weeks it is assumed it has been replaced with a real VIN
and/or the user no longer needs use of the temp VIN, and it is removed from the sold files. This period of
time also allows some statistics to be run on the day of the month allocations appear.
Older model year sold files will be archived at some point, when it appears there is no longer any inventory of that year left.

Note that the contents of the VIN entries in the sold inventory files do not update after being placed in that file because there is no data
to update them with from the Toyota search inventory website anymore. I.E, the website no longer returns that VIN and contents for it,
and that is the only website that the vehicle information is obtained from by the program."

Also a dealer will sometimes have the vehicle removed from the Toyota inventory website search results if they consider it to be sold for all practical purposes and or don't want to get calls about it from other potential buyers. Some dealers do not use the PreSold field.
Sponsored

 



Top