• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Quick question for the Toyota Guys in the Room.

Rick Buffkin

Sausage King of Chicago
Oct 29, 2009
729
830
Awards
8
First Name
Rick
I'm trying to figure out a way how to auto populate a V-SPEC (Basically a Window Sticker) onto each one of our new Toyotas on my Toyota website. Kind-of like GM and Chrysler dealers can do on their websites. I know I can manually download and apply them but I want to accomplish this in my lifetime. Any ideas?? Do you guys know of any other Toyota dealers that are doing this or have seen this on any other Toyota websites? Please let me know if you have.

As always, any help is greatly appreciated.
 
  • Like
Reactions: 1 person
This sounds like an interesting idea. Here's how I'd approach it.

1. How can we automate the retrieval of the VSPEC PDFs from Dealer Daily?
a. Build the correct URLs for each of your dealership's vehicle's VSPEC PDFs. The format is like this, but you'll need to insert an accurate VIN & UID:

http://dealer.toyota.com/VehicleSystem/New/VSpec/VSpecDetail.aspx?VIN=JTDKN3DU1C0000000&SelectedDlrCode=&UID=0000000000&Category=G

b. Automate the downloading of all the URLs you generated in step a, save the PDFs with meaningful names like VIN or Stock#.

2. Now we've got all the VSPEC PDFs, gotta get them to the VDP
a. Convert the PDF to an image and upload it to the VDP along with your vehicle photographs.
b. If you have someone doing your inventory photos in-house you could add this to their workflow.
 
Do you guys know of any other Toyota dealers that are doing this or have seen this on any other Toyota websites? Please let me know if you have.

Not that I know of, but a great idea none the less.

Any ideas??

Maybe we could find enough Toyota dealers that use the same website provider, and then synchronously send that provider the request to automate this [a petition of sorts]. They would probably make it if enough dealers ask for it. Is this wishful thinking?

I use Cobalt... anyone else?
 
  • Like
Reactions: 1 person
Thanks for the reply's guys. After digging around in Dealer Daily yesterday evening and today, from what I can gather, the PDF's are created on the fly. They are not already created setting on a sever somewhere. I've tried numerous times to find a URL to see if they actually do sit on a server but I haven't had any luck. You do have the option to create up to 10 at the time. What I may do is download and upload them to my server and then structure a path for them to get to my primary website. That is a last resort that I want to turn to though because it is extremely time consuming. Especially when your talking about 500-600 cars.

BZ- I don't think that its the website providers issues. I think it is more of Toyota that anything. I'm currently using Dealer.com with my sites with the exception of 2. My Toyota site is DDC. I know that DDC is set up with Chrysler and all the window stickers are built into links on the VDP and they link to Chrysler's servers to retrieve the PDF. Same thing goes for GM and Cobalt.

I'm sure that DDC or Cobalt can populate the VDP with a link to the VSPEC using the VIN. once it is created and sitting on a server somewhere in the correct format.

I will keep playing around with this and figure out a way.
 
@Rick: Do you realize that your customers cannot reach dealer.toyota.com from their home internet connections? So even if the VSPECs were static PDFs you still wouldn't be able to directly link to them. That is why you must download all of them and store them on your own server, or convert the PDFs to an image and place the images in with your vehicle photos (and let DDC store them).

Check out the AutoIt script I have attached to this post, I just used it to download VSPECs for approximately 200 of my new Toyota vehicles and it took about 30 minutes. So, if let the script run unattended on a PC once a week then you can get all 600 of your VSPECs in under 2 hours.

If you want to put these VSPECs in with the vehicle photos you could modify the script to convert the PDFs to images after they have been downloaded. You could probably use PDFTK for that.
 

Attachments

  • VSPEC_Downloader.txt
    7.5 KB · Views: 23
  • Like
Reactions: 1 person
Rick, I've been waiting for this functionality for years and like you, I believe the issue resides on Toyota's end. We have the window sticker functionality on our Chrysler DDC website and it's an extremely helpful tool for online shoppers and the store's ISM (can help clear up vehicle pricing and equipment questions). Maybe someone from Toyota or a website vendor could chime in with some insight?
 
  • Like
Reactions: 1 person
@ Art - I just took a look at the script and I'm SUPER, SUPER excited to get this into play this coming week. I used AutoIT for a couple of other functions that I use on my PC and it works great. Thank you for sharing the script.

@ BZ - To render multiple VSPEC's all you have to do is hold down the control key, select your vehicles( your selected vehicles will populate towards the top to the page in a yellow window), once your vehicles are selected then just click on the VSPEC icon. It will render upto 10.

@ MBissett - The script that Art provided is the answer!!

Once I get the VSPECS downloaded and uploaded, it's then just a matter of the proper link structuring for DDC to grab the links and link it to the VDP. I will keep everyone updated on my progress.
 
Nice work guys. Keep us abreast on how it turns out.

You would think the manufacturers would provide their dealers with more valuable assets and content we can use on our websites. In stead they would rather use their resources to knock us for not being compliance issues over a "stress" word used in the title tag for a page.

This is a feature that Toyota should and could be providing each dealer website service provider.
 
  • Like
Reactions: 2 people
@ Art - The script works great. Thank you for sharing that with me / us. I just downloaded all of our VSPECS in about 1hr an 1/5. I actually had to slow the script down a little. It works perfect. I put the call into DDC and I'm waiting to get a response back from those guys. Hopefully, I will have everything set up by Thursday or Friday of this week.