Notices
2017 - 2022 Super Duty The 2017-2022 Ford F250, F350, F450, F550 & F600 Super Duty Pickup and Chassis Cab
Sponsored by:
Sponsored by: CARiD

2022 Tracking Spreadsheet

Thread Tools
 
Search this Thread
 
Old Nov 23, 2021 | 10:48 AM
  #2521  
47Ford - 1.5Ton's Avatar
47Ford - 1.5Ton
Freshman User
Joined: Jun 2008
Posts: 48
Likes: 4
Anyone else have issues with their new entries not making the spreadsheet? entered my info last week and still haven't populated
 
Reply
Old Nov 23, 2021 | 10:51 AM
  #2522  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by bsmith993
@Phoenixfla This is interesting... My truck went In Production on 11/15. I estimated an 11/23 build day. In all the Mach-E, my own tracker, etc... nothing has updated. But in the Ford order tracking system it now shows the "In Production" DATE of 11/22 where before that date was blank. It also shows an estimated delivery of 12/12.

Clearly there is some delay on information making out to the externally facing servers. Anyway, you may have already seen the timings of data flow, and I'll capture exactly (within 5 mins) when it shows in the public facing json data. But for people wanting up to the minute, or even up to the day data, it seems the Ford Vehicle Order Tracking has an inside track.
Auto updates are no longer working. I'm having to manually kick off updates several times a day. The Spreadsheet therefore will have old data each morning until the refresh starts and finishes.

I need to look more into why auto updates are not working. Or an alternative to my Json importer.
 
Reply
Old Nov 23, 2021 | 10:53 AM
  #2523  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by 47Ford - 1.5Ton
Anyone else have issues with their new entries not making the spreadsheet? entered my info last week and still haven't populated
Your on there and data populated. Around line 343 of Production tab.
 
Reply
Old Nov 23, 2021 | 11:03 AM
  #2524  
Poncho450's Avatar
Poncho450
Lead Driver
10 Year Member
Community Builder
Liked
Loved
Joined: Oct 2014
Posts: 5,945
Likes: 1,359
From: NY/Canada border
Originally Posted by doyall
Is the number circled in red the "Customer's Order Number" that is used to populate the shop.ford.com/vehicleordertracking website and the 2022 Tracking Spreadsheet data submission form?

If not, what specifically do I tell the dealer to look for. I asked them for the "Customer's Order Number" to use on the Vehicle Order Tracking site and this is what they gave me. Doesn't work. I also got an error on the Tracking Spreadsheet with direction to resubmit. I suspect the Order Number to be the culprit as well.
The number circled in your attachment showed 4 numbers. Mine starts with a letter and then 3 numbers. I have not seen anyone else's order number so I have no idea if they're all set up the same way or not.
If yours is correct, it may just be Ford's tracking site not being updated or just plain not functioning at all at the time you tried. I've experienced that several times. So have others. Pretty crappy internet presence for a mulit billion dollar company, to include FordPass in my opinion.
 
Reply
Old Nov 23, 2021 | 11:07 AM
  #2525  
bsmith993's Avatar
bsmith993
Junior User
Joined: Sep 2019
Posts: 52
Likes: 21
From: Maryland
Originally Posted by doyall
Is the number circled in red the "Customer's Order Number" that is used to populate the shop.ford.com/vehicleordertracking website and the 2022 Tracking Spreadsheet data submission form?
And to add on... yes, that is your order number, but you also need your VIN. If you didn't get an email from Ford then your dealer would give you the VIN. Although I think you can go on the unscheduled list prior to the VIN.
 
Reply
Old Nov 23, 2021 | 11:14 AM
  #2526  
Poncho450's Avatar
Poncho450
Lead Driver
10 Year Member
Community Builder
Liked
Loved
Joined: Oct 2014
Posts: 5,945
Likes: 1,359
From: NY/Canada border
Originally Posted by bsmith993
And to add on... yes, that is your order number, but you also need your VIN. If you didn't get an email from Ford then your dealer would give you the VIN. Although I think you can go on the unscheduled list prior to the VIN.
Nice call. I didn't even look his attachment over close enough to notice there was no VIN!
 
Reply
Old Nov 23, 2021 | 12:49 PM
  #2527  
cromedome's Avatar
cromedome
Freshman User
Joined: Nov 2021
Posts: 38
Likes: 25
Info went missing

All of my information on the spreadsheet from column B to Q went missing except for build week and sent to plant date. Now I'm at the bottom of the spread sheet should I be worried about this

Thanks
 
Reply
Old Nov 23, 2021 | 01:28 PM
  #2528  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by cromedome
All of my information on the spreadsheet from column B to Q went missing except for build week and sent to plant date. Now I'm at the bottom of the spread sheet should I be worried about this

Thanks
Usually a 1 time error in data retrieval. Should correct with next update.
 
Reply
FTE Stories

Ford Trucks for Ford Truck Enthusiasts

story-0

This Hennessey Takes the Expedition Tremor's Off-Roading Capability to the Next Level

 Verdad Gallardo
story-1

Top 10 Fords at 2026 Carlisle Ford Nationals

 Joe Kucinski
story-2

3 Best / 3 Worst Parts of Modern Ford Ownership

 Brett Foote
story-3

10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches

 Pouria Savadkouei
story-4

Every 2026 Ford Engine Explained

 Brett Foote
story-5

10 Ugly Ford Trucks That We Still Kinda Love

 Joe Kucinski
story-6

10 Things Every Truck Owner NEEDS (2026 Edition)

 Michael S. Palmer
story-7

Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath

 Verdad Gallardo
story-8

Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer

 Joe Kucinski
story-9

2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)

 Brett Foote
Old Nov 23, 2021 | 01:31 PM
  #2529  
cromedome's Avatar
cromedome
Freshman User
Joined: Nov 2021
Posts: 38
Likes: 25
Thanks for in info I appreciate all the work you do.
 
Reply
Old Nov 23, 2021 | 01:51 PM
  #2530  
TW720HVY's Avatar
TW720HVY
Senior User
Joined: Dec 2010
Posts: 123
Likes: 28
From: North Texas
Originally Posted by Phoenixfla
Auto updates are no longer working. I'm having to manually kick off updates several times a day. The Spreadsheet therefore will have old data each morning until the refresh starts and finishes.

I need to look more into why auto updates are not working. Or an alternative to my Json importer.
Thank you for all the work you're putting into this spreed sheet!
 
Reply
Old Nov 23, 2021 | 02:09 PM
  #2531  
doyall's Avatar
doyall
Mountain Pass
20 Year Member
Liked
Joined: Aug 2003
Posts: 211
Likes: 55
From: Montgomery, AL
Originally Posted by bsmith993
And to add on... yes, that is your order number, but you also need your VIN. If you didn't get an email from Ford then your dealer would give you the VIN. Although I think you can go on the unscheduled list prior to the VIN.
Originally Posted by Poncho450
Nice call. I didn't even look his attachment over close enough to notice there was no VIN!
Got a VIN last week from Ford via email so I am beginning to wonder about the order number.

Just clicked on the "Track My Order" button in my "Scheduled For Production" email and the fields were populated. Order number on the dealer build sheet was not what Ford used. Build sheet had 1109, which was the date the document was created. Ford used 1110, which corresponds with the date the order was placed.
 

Last edited by doyall; Nov 25, 2021 at 06:43 AM. Reason: Update with new information. 11/25/2021
Reply
Old Nov 23, 2021 | 02:14 PM
  #2532  
bsmith993's Avatar
bsmith993
Junior User
Joined: Sep 2019
Posts: 52
Likes: 21
From: Maryland
Yeah, that's strange. I thought most order numbers were letter - number - number - letter. X##X format. So that does look strange. But that field is definitely where my order number is. I'd suppose you would need to tell your dealer you are having a hard time tracking it and have them help you out.
 
Reply
Old Nov 23, 2021 | 03:13 PM
  #2533  
StevenD19's Avatar
StevenD19
Senior User
Joined: Oct 2021
Posts: 100
Likes: 37
My order # is 1026. I ordered the truck on 10/26.

I thought at first maybe dealer just uses date but then I wondered what if someone else placed order that same day with them.
 
Reply
Old Nov 23, 2021 | 03:30 PM
  #2534  
47Ford - 1.5Ton's Avatar
47Ford - 1.5Ton
Freshman User
Joined: Jun 2008
Posts: 48
Likes: 4
Originally Posted by Phoenixfla
Your on there and data populated. Around line 343 of Production tab.
Thanks again for all your hard work Phoenix! I'm not sure what's going on. Maybe I need to clear my browser cache to be honest. I see myself on there originally via 'production date... but when use the "sort by order date" tab.. I lose a large chunk of trucks and no longer show up via my 10/8 order date. (372 lines of info on product date, only 325 lines of info on order date)

Such a useful tool when researching commodities (musts vs wants) etc. Kudos to you
 
Reply
Old Nov 23, 2021 | 04:18 PM
  #2535  
jowee01's Avatar
jowee01
New User
Joined: Nov 2021
Posts: 3
Likes: 1
From: McHenry, IL
Originally Posted by cromedome
All of my information on the spreadsheet from column B to Q went missing except for build week and sent to plant date. Now I'm at the bottom of the spread sheet should I be worried about this

Thanks
Same as mine. Mine was shipped and dealer tracked the rail car to the yard near me last thursday. truck still has not made it to the dealer(60mi trip) and now all the info disappeared on the spreadsheet.
 
Reply



All times are GMT -5. The time now is 12:15 AM.

story-0
This Hennessey Takes the Expedition Tremor's Off-Roading Capability to the Next Level

Slideshow: The VelociRaptor Expedition gains a lift, upgraded suspension, Brembo brakes, and trail-ready equipment while retaining the stock 440-horsepower EcoBoost V6.

By Verdad Gallardo | 2026-06-12 11:01:55


VIEW MORE
story-1
Top 10 Fords at 2026 Carlisle Ford Nationals

Slideshow: Top 10 Fords at 2026 Ford Nationals

By Joe Kucinski | 2026-06-09 11:10:08


VIEW MORE
story-2
3 Best / 3 Worst Parts of Modern Ford Ownership

Based on years of owning multiple modern Ford products.

By Brett Foote | 2026-06-09 10:53:36


VIEW MORE
story-3
10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches

SPONSORED: From muddy boots to rain-soaked cargo, these upgrades address some of the most common frustrations Ford truck owners face every day.

By Pouria Savadkouei | 2026-06-08 18:50:34


VIEW MORE
story-4
Every 2026 Ford Engine Explained

Here's everything you need to know about every Ford engine available for the 2026 model year.

By Brett Foote | 2026-06-05 12:58:01


VIEW MORE
story-5
10 Ugly Ford Trucks That We Still Kinda Love

Slideshow: 10 ugly Ford trucks that we still kinda love.

By Joe Kucinski | 2026-06-03 09:51:16


VIEW MORE
story-6
10 Things Every Truck Owner NEEDS (2026 Edition)

Slideshow: the best gifts for dads & grads

By Michael S. Palmer | 2026-06-03 15:43:58


VIEW MORE
story-7
Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath

Slideshow: Called the Fortress, the 850-horsepower pickup combines Raptor underpinnings with military-inspired features, survival equipment, and a starting price of $285,000.

By Verdad Gallardo | 2026-06-03 11:38:36


VIEW MORE
story-8
Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer

Slideshow: 10 most expensive Ford trucks ever sold on Bring a Trailer.

By Joe Kucinski | 2026-05-27 16:24:34


VIEW MORE
story-9
2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)

Here's everything that has changed for the latest model year.

By Brett Foote | 2026-05-27 16:17:28


VIEW MORE