VIN Numbers Data Updating?

[JP#]

Where does the data for the Google Sheets - create and edit spreadsheets online, for free. come from? Is there a website to pull this information?

 

[Nas4atu10]

So that google tool, I believe, scrapes VINs from another tool created by another member on here, @Michelw. I didn’t know this until a day or two ago myself, but he created this tool in his free time, as he works a full time job and all. He stated that it stopped working and that he just recently got it updated. Someone else stated that he only is able to update the site 1 to 2 times a week due to how labor intensive it is to do so. Here’s the original thread, with some of the last posts going into more detail at the end about why it hasn’t been updating as much lately. Also, keep in mind, the plant was down last week, so there were no VINs created then.

Kia Telluride US production stats. by trim and colors

If you look at the sales mix - a larger percentage of Tellurides have been SX models - and many of those with the Prestige package. If anyone had said two years ago that KIA would have trouble filling orders for a $50K vehicle...they would have been laughed out of the room. Did KIA...

tellurideforum.org

 

[JP#]

Yes I have seen the posts which is why I am wondering where the original data is sourced from to create these VIN lookups. Just curious.

 

[Nas4atu10]

Yes I have seen the posts which is why I am wondering where the original data is sourced from to create these VIN lookups. Just curious.

Ahhh, gotcha, that I’m not sure of, that would be a good question for @Michelw then

______________________________

 

[Michelw]

Where does the data for the Google Sheets - create and edit spreadsheets online, for free. come from? Is there a website to pull this information?

This is the way I do it with a Windows computer application:

1- Everyday, I generate a bunch of Telluride VINs starting with the previous day serial number.

2- For each of those generated VINs, I call the the following URL. For example: https://www.kia.com/us/services/en/windowsticker/load/5XYP5DHC2LG057837

3- If the URL returns me a VIN window sticker PDF file, then I know this is a valid VIN and I add it to my database with all of the information from the PDF file. If for a serial number no VIN window sticker PDF is found, then it is a VIN for Canada or the Middle East.


Of course, I don't do this manually. I have written a computer application that does all of this data scraping.


Here is my full Google Sheets with all the VINs since 2019.

Here is a partial Google Sheets with the VINs since February 2020.

Here is a link to my official thread.

 

[JP#]

This is the way I do it with a Windows computer application:

1- Everyday, I generate a bunch of Telluride VINs starting with the previous day serial number.

2- For each of those generated VINs, I call the the following URL. For example: https://www.kia.com/us/services/en/windowsticker/load/5XYP5DHC2LG057837

3- If the URL returns me a VIN window sticker PDF file, then I know this is a valid VIN and I add it to my database with all of the information from the PDF file. If for a serial number no VIN window sticker PDF is found, then it is a VIN for Canada or the Middle East.


Of course, I don't do this manually. I have written a computer application that does all of this data scraping.


Here is my full Google Sheets with all the VINs since 2019.

Here is a partial Google Sheets with the VINs since February 2020.

Here is a link to my official thread.

Thank you for the information and thank you for taking the time to gather this data for all of us to use. Unfortunately, this is above my head to generate this information like you can.