1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

Tacoma inventroy spreadsheet

Discussion in '3rd Gen. Tacomas (2016+)' started by _kmg_, Mar 28, 2021.

  1. Apr 25, 2021 at 6:15 PM
    #41
    BajaBornTaco

    BajaBornTaco Well-Known Member

    Joined:
    Mar 3, 2019
    Member:
    #285193
    Messages:
    63
    Gender:
    Male
    '19 TRD OR, Exaust Tip, TRD Shifter
    I saw that there is afield called "sold_at" with a date in it. Is the "sold_at" date when the truck was sold? Does that mean that only the ones that have a blank sold_at field are still available?
     
  2. Apr 25, 2021 at 7:04 PM
    #42
    _kmg_

    _kmg_ [OP] Member

    Joined:
    Mar 21, 2021
    Member:
    #360085
    Messages:
    15
    It's kind of my ad-hoc way to keep track of which cars are available and which aren't according to toyota.com. "sold_at" can mean 2 things. 1, the car is no longer available according to toyota.com. 2, the car could have been transferred to another dealer.
     
  3. Apr 25, 2021 at 7:37 PM
    #43
    BajaBornTaco

    BajaBornTaco Well-Known Member

    Joined:
    Mar 3, 2019
    Member:
    #285193
    Messages:
    63
    Gender:
    Male
    '19 TRD OR, Exaust Tip, TRD Shifter
    Thanks for the reply. The spreadsheet doesn't match any of my nearby dealer's VINs :confused:, as you had mentioned may be the case. Not your issue - theirs. E.g. the main Toyota site does not match some other dealers that I looked up. I think some dealers are not updating their own websites on a timely manner. Oh well, still very useful info!! Thanks again. :thumbsup:
     
  4. Apr 26, 2021 at 8:47 AM
    #44
    _kmg_

    _kmg_ [OP] Member

    Joined:
    Mar 21, 2021
    Member:
    #360085
    Messages:
    15
    Yup. I've found that to be true for my area as well. I called my local dealer asking about a vehicle and they had no idea about the VIN. Then they checked their deliveries and it was set to be delivered that week.

    From my research each dealer is responsible for setting up their own website. I initially tried to get dealer inventory by going to each dealers site and pulling the data. But it was impossible. So I went with toyota.com instead, with all the caveats and issues we've discovered along the way.
     
    tonered likes this.
  5. Apr 26, 2021 at 8:53 AM
    #45
    tonered

    tonered tacorider

    Joined:
    Sep 25, 2017
    Member:
    #231055
    Messages:
    22,207
    Gender:
    Male
    First Name:
    tony
    Lynnwood, WA
    I have noticed that some dealers will use the corporate site, but it seems that most use their own version to differentiate.

    Still, with the inaccuracies and all of that, you tool is just so much more effective. We've made our lives so overly complex.
     
  6. Apr 28, 2021 at 12:57 PM
    #46
    taylorm2

    taylorm2 Well-Known Member

    Joined:
    Dec 15, 2016
    Member:
    #204920
    Messages:
    51
    CO
    Vehicle:
    2017 Tacoma TRD Off Road DCLB A/T Black
    Would you mind sharing your method? We are currently trying to purchase a 4runner and am running into stale dealer site data...
     
  7. Apr 28, 2021 at 2:03 PM
    #47
    CSVT

    CSVT Well-Known Member

    Joined:
    May 20, 2020
    Member:
    #328686
    Messages:
    89
    Gender:
    Male
    Ohio
    Vehicle:
    2021 TRD Pro
    Really great resource if you're in the market right now.
    Thanks for doing the heavy lifting, OP!
    :benchpress:
     
  8. Apr 28, 2021 at 2:06 PM
    #48
    LongRedAndSpringy

    LongRedAndSpringy Member

    Joined:
    Jul 27, 2020
    Member:
    #335753
    Messages:
    19
    Gender:
    Male
    CA 805
    Vehicle:
    2006 Impulse Red Tacoma SR5 DCLB 4WD
    Icon Stage 1 Lift Kit 265/r70/17 KO2's 17"x9" -12/4.5" Method 312's
    Who wants to be the one who starts putting these VINs on VinWiki to start tracking all of the 2021 Tacomas in the U.S.?
     
  9. Apr 28, 2021 at 2:11 PM
    #49
    BudFriendguy

    BudFriendguy Finger Sniffer

    Joined:
    Feb 5, 2021
    Member:
    #355148
    Messages:
    478
    Gender:
    Male
    First Name:
    Zak
    Portland, Oregon
    Vehicle:
    2021 SX ACLB 4WD V6 MGM
    This probably qualifies as hearsay since my "sheet" is lacking a lot of details yours has, but I got this allocation list from a dealer last week.

    If anyone is looking for a TRD Sport access cab V6 MT in Voodoo Blue...

    [​IMG]

    I ordered mine from this list (scratched off) so can confirm some if not all are currently not promised to anyone. Picking it up middle of May.
     
  10. Apr 29, 2021 at 6:49 AM
    #50
    BrokeKayaker

    BrokeKayaker Member

    Joined:
    Jan 3, 2016
    Member:
    #173945
    Messages:
    16
    Gender:
    Male
    This is incredible. I'm actually thinking about getting a Tundra soon, is there any way this can be done on Tundras?
     
  11. Apr 30, 2021 at 2:21 AM
    #51
    car_nut

    car_nut New Member

    Joined:
    Friday
    Member:
    #364300
    Messages:
    1
    Thank you so much for putting this together. Could you share how/where you're finding the VIN and dealer info? It doesn't appear in the website page as near as I can tell. I need the ability to stalk individual VIN's daily. Inventory is moving too fast here right now for weekly updates to be useful.

    Thanks!
     
  12. Apr 30, 2021 at 8:21 AM
    #52
    japjoe7

    japjoe7 Well-Known Member

    Joined:
    Mar 2, 2020
    Member:
    #320876
    Messages:
    63
    Gender:
    Male
    First Name:
    Joey
    Pike County, PA
    Vehicle:
    Not an owner just yet
    Awesome! Thanks OP! Subd
     
  13. Apr 30, 2021 at 3:55 PM
    #53
    grandpawmoses

    grandpawmoses Dirty Old Man

    Joined:
    Apr 17, 2021
    Member:
    #362973
    Messages:
    11
    Gender:
    Male
    First Name:
    David
    Vehicle:
    2021 Tacoma Limited Nightshade
    No money
    I'd love to see a current update. Mine's suppose to have been built 2021-04-27.
     
  14. May 2, 2021 at 2:52 PM
    #54
    D. Lengua

    D. Lengua Active Member

    Joined:
    May 3, 2020
    Member:
    #326626
    Messages:
    32
    i can't find any (more or less randomly selected) truck listed in the spread sheet on any indicated dealer website. i realize the dealer websites might be routinely lagging in updates, but i'd have thought there'd be some overlap or correlation.
     
  15. May 2, 2021 at 3:19 PM
    #55
    FantasyFreak

    FantasyFreak Well-Known Member

    Joined:
    Jun 25, 2020
    Member:
    #332552
    Messages:
    106
    Gender:
    Male
    First Name:
    Brandon
    Fort Worth
    Vehicle:
    2019 Tacoma TRD Pro
    Did you use the filter for the “sold at” tab? This shows all new and sold but it has been pretty spot on. A lot are already sold and marked as so in that tab.
     
  16. May 2, 2021 at 3:58 PM
    #56
    D. Lengua

    D. Lengua Active Member

    Joined:
    May 3, 2020
    Member:
    #326626
    Messages:
    32
    yeah, i deselected ones with sell dates. within those, i tried a few at either end of the creation dates. must have followed at least a dozen listings to the indicated dealer site and never got a hit.

    just scratching my head over here, but i guess others are finding correlations. :confused:
     
  17. May 2, 2021 at 4:06 PM
    #57
    FantasyFreak

    FantasyFreak Well-Known Member

    Joined:
    Jun 25, 2020
    Member:
    #332552
    Messages:
    106
    Gender:
    Male
    First Name:
    Brandon
    Fort Worth
    Vehicle:
    2019 Tacoma TRD Pro
    I would wait and see if he updates it today or tomorrow and then take a look. I’m only looking for a Lunar Rock and in Texas and so far those are pretty scarce. The ones that do come in are usually already for a customer. There have been a few one offs but those are usually showing sold on the following weeks update. Hope you can find what your looking for but right now it’s just hectic. I went and put a deposit on one but with the way it’s been with production and lots being sold out it may be a while. Have you gone into or contacted a dealer to try and locate one for you?
     
  18. May 2, 2021 at 4:17 PM
    #58
    D. Lengua

    D. Lengua Active Member

    Joined:
    May 3, 2020
    Member:
    #326626
    Messages:
    32
    i started looking over a year ago, visited local dealers, put out quite a few emails. but that was when prices really started to spike so i've left it alone for a while, dipping back in now and again to take the temperature. seems like supply is picking up again, as is my work so i'm looking harder again.

    i've also refined what i'm looking for quite a bit and the dclb part narrows choices a lot. when i first started looking, Sports were going for what SR5's are now.
     
  19. May 2, 2021 at 4:45 PM
    #59
    MikeWa86

    MikeWa86 New Member

    Joined:
    May 26, 2020
    Member:
    #329405
    Messages:
    1
    Gender:
    Male
    First Name:
    Mike
    I hear you. This past week I’ve seen “issues” with the list. Before that it was VERY good for my area (MA/NH). I’m waiting for validation with the next update. He explained in a few posts about the dealers managing their own sites, not Toyota. This most likely is the explanation. I have same issues backwards, local dealer showing truck w VIN not on the list.

    you can also google toyota owner spec. Brings you to Toyota’s site to run the VIN. It will tell you if sold and a date. As well as all the specifics.

    Good luck! I’m just starting to look again too and can’t believe what I passed on a year ago!
     
    D. Lengua likes this.
  20. May 2, 2021 at 6:59 PM
    #60
    D. Lengua

    D. Lengua Active Member

    Joined:
    May 3, 2020
    Member:
    #326626
    Messages:
    32
    seriously.

    anyway, not meaning to gripe. i appreciate _kmg_'s work here. just trying to get a feel for it.
     

Products Discussed in

To Top