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
    Quick Links: Viair 300P ......price drop Amazon Prime Day *The Never-Ending Sale Thread*-Post Up Those Deals! $5.00 JLAB GRAB BAG!!! (OUT OF STOCK) Viper 4806V 2-Way LED Vehicle Remote Starter Kit w/ Installation. DeMello off-road joining the party late for the LD Sale Amazon Prime Day July 12 & 13, 2022-Post Up Those Deals!

Computer programmers, lend me your ear... (deal related)

Discussion in 'Deals & Coupons' started by TheDevilYouLove, Jun 28, 2020.

Page 4 of 7
  1. Jun 30, 2020 at 11:11 AM
    #61
    Fargo Taco

    #61
    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,746
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Messing around making sure things are working and trying out different parts, I selected the 2019 bed lights, which are $140 on Toyota's site. The cheapest in my list of dealerships (which still only includes the original list plus Alabama, Alaska and Arizona) is $114.80, the same price AND the same dealership as the cheapest Google result.

    Pretty pleased with my dumb little file!
     
    Fargo Taco, Jun 30, 2020
    #61
    po35042 likes this.
  2. Jun 30, 2020 at 11:16 AM
    #62
    TheDevilYouLove

    #62
    TheDevilYouLove [OP] You can’t polish a turd, but you can polish a TRD

    Joined:
    May 26, 2016
    Member:
    #187953
    Messages:
    2,818
    Gender:
    Male
    First Name:
    Steve
    Marylandistan
    Vehicle:
    2010 Tacoma TRD Sport Access cab 4x4 silver streak
    How are you scraping the web for the data? Power Query?
     
    TheDevilYouLove, Jun 30, 2020
    #62
  3. Jun 30, 2020 at 11:18 AM
    #63
    Fargo Taco

    #63
    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,746
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Yes, sir.
     
    Fargo Taco, Jun 30, 2020
    #63
  4. Jun 30, 2020 at 11:20 AM
    #64
    TheDevilYouLove

    #64
    TheDevilYouLove [OP] You can’t polish a turd, but you can polish a TRD

    Joined:
    May 26, 2016
    Member:
    #187953
    Messages:
    2,818
    Gender:
    Male
    First Name:
    Steve
    Marylandistan
    Vehicle:
    2010 Tacoma TRD Sport Access cab 4x4 silver streak
    Cool, can’t wait to see it. I’m taking an Udemy course on Power Query and DAX Right now. I’m very familiar with old school excel, but PQ is newish for me.
     
    TheDevilYouLove, Jun 30, 2020
    #64
    Fargo Taco likes this.
  5. Jun 30, 2020 at 11:25 AM
    #65
    DarthPow

    #65
    DarthPow Well-Known Member

    Joined:
    Feb 27, 2018
    Member:
    #245786
    Messages:
    2,571
    Vehicle:
    2012 DCLB TRD Sport 4x4
    this is a really cool idea, I'll follow this for updates!
     
    DarthPow, Jun 30, 2020
    #65
    Fargo Taco likes this.
  6. Jun 30, 2020 at 11:32 AM
    #66
    Fargo Taco

    #66
    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,746
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Fargo Taco, Jun 30, 2020
    #66
    TheDevilYouLove[OP] and DarthPow[QUOTED] like this.
  7. Jun 30, 2020 at 11:46 AM
    #67
    DarthPow

    #67
    DarthPow Well-Known Member

    Joined:
    Feb 27, 2018
    Member:
    #245786
    Messages:
    2,571
    Vehicle:
    2012 DCLB TRD Sport 4x4
    DarthPow, Jun 30, 2020
    #67
  8. Jun 30, 2020 at 11:46 AM
    #68
    TheDevilYouLove

    #68
    TheDevilYouLove [OP] You can’t polish a turd, but you can polish a TRD

    Joined:
    May 26, 2016
    Member:
    #187953
    Messages:
    2,818
    Gender:
    Male
    First Name:
    Steve
    Marylandistan
    Vehicle:
    2010 Tacoma TRD Sport Access cab 4x4 silver streak
    TheDevilYouLove, Jun 30, 2020
    #68
    Fargo Taco[QUOTED] likes this.
  9. Jun 30, 2020 at 12:00 PM
    #69
    machotaco91

    #69
    machotaco91 Well-Known Member

    Joined:
    Jul 12, 2018
    Member:
    #259160
    Messages:
    69
    Gender:
    Male
    First Name:
    Mantis
    Vehicle:
    2018 Toyota Tacoma TRD Off-road
    This might be doable given that shipping estimate doesn’t require a captcha (yet). As management would say, it’s just “SMOP” :p
     
    machotaco91, Jun 30, 2020
    #69
    senecataco[QUOTED] and Fargo Taco like this.
  10. Jun 30, 2020 at 12:08 PM
    #70
    TheDevilYouLove

    #70
    TheDevilYouLove [OP] You can’t polish a turd, but you can polish a TRD

    Joined:
    May 26, 2016
    Member:
    #187953
    Messages:
    2,818
    Gender:
    Male
    First Name:
    Steve
    Marylandistan
    Vehicle:
    2010 Tacoma TRD Sport Access cab 4x4 silver streak
    Took a quick look but it's pretty impressive. I've never seen a "function query" (GetPrice) so I'll be looking forward to leveling up my excel skills by following this! And perfect use of conditional formatting to highlight the lowest price(s).

    If excel can iterate over the list of URLs to retrieve the price, that's getting very close to being a programming language...

    ETA: I do think the URLs can be simplified to remove the reference to 2019 Tacoma. On Toyota's website, if you don't put in any info about your truck but find a part, the URL is simpler...
     
    Last edited: Jun 30, 2020
    TheDevilYouLove, Jun 30, 2020
    #70
    Fargo Taco[QUOTED] likes this.
  11. Jun 30, 2020 at 12:11 PM
    #71
    machotaco91

    #71
    machotaco91 Well-Known Member

    Joined:
    Jul 12, 2018
    Member:
    #259160
    Messages:
    69
    Gender:
    Male
    First Name:
    Mantis
    Vehicle:
    2018 Toyota Tacoma TRD Off-road
    machotaco91, Jun 30, 2020
    #71
    Fargo Taco[QUOTED] and 0xDEADBEEF like this.
  12. Jun 30, 2020 at 12:16 PM
    #72
    CAG Gonzo

    #72
    CAG Gonzo Ascendant Spaghetti

    Joined:
    Oct 25, 2018
    Member:
    #270558
    Messages:
    1,688
    Gender:
    Male
    Vehicle:
    2018 OR DCLB BarRed
    I guess someone better git on it.
     
    CAG Gonzo, Jun 30, 2020
    #72
    Fargo Taco and machotaco91[QUOTED] like this.
  13. Jun 30, 2020 at 12:23 PM
    #73
    0xDEADBEEF

    #73
    0xDEADBEEF Swaying to the Symphony of Destruction

    Joined:
    Mar 2, 2019
    Member:
    #285037
    Messages:
    19,644
    Vehicle:
    2000 reg cab 4x4 flatbed MT
    I keep wanting to build a TW Wiki. But, my masochist tendencies are already fulfilled.
     
    0xDEADBEEF, Jun 30, 2020
    #73
    Fargo Taco likes this.
  14. Jun 30, 2020 at 12:30 PM
    #74
    machotaco91

    #74
    machotaco91 Well-Known Member

    Joined:
    Jul 12, 2018
    Member:
    #259160
    Messages:
    69
    Gender:
    Male
    First Name:
    Mantis
    Vehicle:
    2018 Toyota Tacoma TRD Off-road
    In the name of the wise Shia Labeouf, “just do it.”
     
    machotaco91, Jun 30, 2020
    #74
    0xDEADBEEF[QUOTED] and Fargo Taco like this.
  15. Jun 30, 2020 at 12:39 PM
    #75
    Fargo Taco

    #75
    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,746
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Unfortunately once it's converted to (I think) a function, it loses all the history that went in to create it but that was the only way I could find to use numerous URLs. The code behind it is:

    let GetResults=(URL) =>
    let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents(URL))})
    in
    Source
    in GetResults

    That (URL) part is what is pulled from the dealership tab on the Excel file. Otherwise it would only pull from one and that just won't do.
    Had to be done. Manually looking through a list of prices trying to find the lowest makes my eyes water. :p
    You are absolutely correct.

    Going from:
    https://parts.toyota.com/p/Toyota_2019_Tacoma/TRD-Front-Skid-Plate/75489794/PTR6035190.html
    To:
    https://parts.toyota.com/p/TRD-Front-Skid-Plate/75489794/PTR6035190.html

    Gets to the same page. I'll correct and update. I have another change I'd like to throw in, too. Stay tuned. ;)
     
    Fargo Taco, Jun 30, 2020
    #75
    TheDevilYouLove[QUOTED][OP] likes this.
  16. Jun 30, 2020 at 1:20 PM
    #76
    Fargo Taco

    #76
    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,746
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Got this simplified down a touch and with updated instructions.

    Looks like you could save $553.25 on the TRD suspension kit. :p
     

    Attached Files:

    Fargo Taco, Jun 30, 2020
    #76
    TheDevilYouLove[OP] likes this.
  17. Jul 2, 2020 at 9:33 PM
    #77
    machotaco91

    #77
    machotaco91 Well-Known Member

    Joined:
    Jul 12, 2018
    Member:
    #259160
    Messages:
    69
    Gender:
    Male
    First Name:
    Mantis
    Vehicle:
    2018 Toyota Tacoma TRD Off-road
    I tried looking into adding shipping costs, but unfortunately they don't have a function in the html source (why would they right?).
     
    machotaco91, Jul 2, 2020
    #77
    Fargo Taco likes this.
  18. Sep 29, 2020 at 6:30 PM
    #78
    crackils

    #78
    crackils Sith Lord Jar Jar

    Joined:
    Jul 30, 2017
    Member:
    #225460
    Messages:
    1,778
    Gender:
    Male
    First Name:
    Shane
    FL
    Vehicle:
    2012 TRD DCSB Off-Road - KINGS/5125s AF
    Wondering if any of you had any luck with this? Still think it's a great idea
     
    crackils, Sep 29, 2020
    #78
  19. Sep 29, 2020 at 6:41 PM
    #79
    machotaco91

    #79
    machotaco91 Well-Known Member

    Joined:
    Jul 12, 2018
    Member:
    #259160
    Messages:
    69
    Gender:
    Male
    First Name:
    Mantis
    Vehicle:
    2018 Toyota Tacoma TRD Off-road
    There’s an excel sheet pinned somewhere. Unfortunately I didn’t have much luck trying to get shipping formation.
     
    machotaco91, Sep 29, 2020
    #79
  20. Sep 30, 2020 at 4:37 AM
    #80
    crackils

    #80
    crackils Sith Lord Jar Jar

    Joined:
    Jul 30, 2017
    Member:
    #225460
    Messages:
    1,778
    Gender:
    Male
    First Name:
    Shane
    FL
    Vehicle:
    2012 TRD DCSB Off-Road - KINGS/5125s AF
    I just saw it, must have scrolled right passed it too, thank you

    hqdefault.jpg
     
    crackils, Sep 30, 2020
    #80
    machotaco91[QUOTED] likes this.
Page 4 of 7

Products Discussed in

PTR60-35190
$459.00
Toyota Genuine PT938-00140 TRD Stamped Aluminum Front Skid Plate
$403.00
To Top