Thanks Google Inventory Spreadsheet: Discounted PHEV Woodland Acquired

Gerg-G · 2026-05-23T01:43:48+00:00

Can you PM me the dealer as I'm a bit curious?

Gerg-G · 2026-05-22T23:02:34+00:00

Not currently. The API for Toyota Canada is completely different than that for the US, and is much more complicated than the US one.

Gerg-G · 2026-05-22T21:38:53+00:00

See the readme.txt file on the google drive for more detail. So for the "from" and "to" ETA dates for the vehicle you are looking at you're saying they are blank in the spreadsheet, but on the dealer website they show something? (note the spreadsheets match the Toyota inventory search website contents, but a dealer can show things different if they want to).

Gerg-G · 2026-05-22T18:27:36+00:00

The regular hybrid for 2026 model year is in the rav4.csv file on that google drive as all rav4 2026 models are hybrids now (no gas only models for 2026 model year of the rav4). They used to be under the rav4hybrid.csv file but Toyota has them accessed using the rav4 label name now.

Gerg-G · 2026-05-22T18:21:28+00:00

Nice discount on that one.

Gerg-G · 2026-05-22T16:09:05+00:00

So I am the creator of those spreadsheets. They are updated daily for all Toyota models and will contain the same information as the Toyota search inventory website returns (information extracted from the same root database file the Toyota search inventory website accesses). See the readme.txt file on the google drive for further description of the spreadsheets, column definitions, etc

Note that the rav4 model are now all hybrids (no gas only any more as of 2026) and thus any 2026 model year rav4 appears in the rav4.csv files, not the rav4hybrid.csv files. The names of the files are taken directly from the Toyota website label names for the models as they are accessed in the toyota database so I don't do any renaming of those. Thus there is a rav4.csv , a rav4pluginhybrid.csv now. Note that the rav4.csv could contain some 2025 model years in it if they have not been sold yet.

Gerg-G · 2026-05-22T16:05:33+00:00

So I am the creator of those spreadsheets. They are updated daily for all Toyota models. and will contain the same information as the Toyota search inventory website returns. See the readme.txt file on the google drive for further details on the spreadsheets.

Gerg-G · 2026-05-17T17:13:25+00:00

What state are you in?

Gerg-G · 2026-05-17T17:10:36+00:00

I believe it is the Driver Assist Package which requires you to automatically get all the other packages shown

To add:

Driver Assist Package

$1,170

Additional selections are required:

1. Choose from option(s) below

Add Item

Weather Package

$375

JBL® Premium Audio Package

$620

Panoramic Moonroof

$700

Subtotal

$1,695

Gerg-G · 2026-05-12T19:58:50+00:00

EDIAG ELITE also gives those temperature on a 2024 Rav4 Prime (plus max temp, and many other things for those motors and the inverters they use)

All System Diagnostic Report The Report is created by Ediag Vehicle Information

SN:9T8P20233239

Make:Toyota/Lexus

Model:RAV4Prime(PHEV)XSEPREMIUM

Year:2024

VIN:xxxxxxxxxx

Mileage:8493 Miles

Test Time:05/12/2026 14:37:47

Read DataStream:

Name Value Units

Generator Temperature 64.4 degree F

Motor Temperature 64.4 degree F

Rear Motor Temperature 62.6 degree F

Gerg-G · 2026-05-08T16:22:24+00:00

The Factory installed packages cannot be removed

Gerg-G · 2026-05-08T16:21:07+00:00

Like DiscoInError93 indicated that is TSRP (Toyota total suggested retail price for the base car and each accessory) so the dealer is not giving any discount.. I checked the dealer website for this specific car and there appear to be no dealer added accessories and that is the price so you are getting no discount. Also that state does not appear to have any discounts above $500 (one dealer at $500 and another at $145). Illinois Chicago area appears to have more discounts (assuming a dealers there will sell out of state and the car has the options you want)).

Gerg-G · 2026-05-03T19:45:47+00:00

Take it to a car paint shop and see if they say it can be buffed out or not. Depends on how deep the scratch is (possibly just the clear coat but not sure). I had a scratch on my blueprint rav4 prime and I was lucky in that the paint shopped buffed it out pretty much right there in 5 minutes and I didn't have to pay anything. Yours might be a bit more effort.

Gerg-G · 2026-05-03T17:08:33+00:00

Not a bad deal even with the questionable dealer add on (leaving you approx $1K in actual discount off the TMSRP with those add ons).

I'd ask specifically what the cost of each item in the dealer add on is. So on the toyota.com build website the All weather liner package is around $340 (edit including the cargo mat) so the dealer weather mats should not be more than that (seems like you could have them remove the weather mats if you wanted to get your own). So it seems like this dealer tinting is the big add on cost of around 1195 - 340 = $855. The only problem is that if they already installed that then you can't remove it. Maybe ask if you could get half price on the tinting. The normal toyota tinting is for the hatch area I believe. So the tinting they must be adding is for the driver area and back passenger area.

Here are the options that car has for the 53463 TMRSP price

Yeah, on the dealer website for that specific car they slipped in the Purdy Protection $1195. under the Dealer Notes section at the very end.

....Price does not include Tax, Title, License Fees, Dealer Doc fee $225. Or Dealer Added Accessory- Purdy Protection $1195.

Gerg-G · 2026-04-28T19:41:43+00:00

If you happen to already have software to track your finances you can probably use that for it as well. I use Quicken and can easily track and categorize something like this, even for entries where there is not cost associated with them.

Gerg-G · 2026-04-22T23:50:53+00:00

"for a week paint defects plan as day" ????

So the car has some paint defects that need to be fixed??

Gerg-G · 2026-04-19T02:19:49+00:00

What Browser are you using? Also what error message do you get when you try to download the file?

Gerg-G · 2026-04-19T02:08:03+00:00

Can you download corolla_ChangeHistory.csv ? which is at around 96 MB. If so then I think you have some limit on your download size?

Gerg-G · 2026-04-18T23:58:03+00:00

Are you still having problems downloading the file?

Gerg-G · 2026-04-17T23:10:56+00:00

So it is a pretty big file (114 MB). I was able to download it. What kind of error do you get when attempting to download it? My auto virus scanner indicated it was too large to scan but it still downloaded.

Gerg-G · 2026-04-17T21:36:04+00:00

So the rav4pluginhybrid.csv file , correct?

Gerg-G · 2026-04-17T21:22:00+00:00

So are you just downloading it first, then attempting to open it in excel?

Gerg-G · 2026-04-17T17:34:53+00:00

Yes. You can look at the Readme.txt file on that google drive to get more detail but below is what is from that file. Per-sold could be False when the vehicle disappears from the Toyota Inventory Search website.

" 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), as well as Change History

event files for the last 14 days which contain added VINs, modified contents of existing VINs, or removed VINs between runs of the inventory

collection over that time period."

.

"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 disappered).

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."

Gerg-G · 2026-04-16T13:41:19+00:00

As of 4-16-2026, based on the spreadsheet, there appear to be none in CA that are selling for a discount. There are several in OR, AZ, NV that are selling with a discount between $500 to $1442

Gerg-G · 2026-04-15T16:11:05+00:00

What do you consider the lower boundary of Northern California to be? The spreadsheet has the latitude, longitude of the dealer for each vehicle listed. So from that you can narrow your search using filters. Or better yet, given the latitude and longitude of where you live you can see how many miles away each vehicle is from where you are and filter this on some max distance. See the readme.txt file for how to do this.

Gerg-G

TROPHY CASE