The update I've been discussing lately is complete: The ShipTrack add-in now returns status information to the worksheet, if the package is delivered (UPS and FedEx only). Note that it already does this for ABF.
In addition to delivery status, the function also returns
- Delivery date (if applicable)
- Who signed for the package (if applicable)
Thanks go to Aaron Rehm and Greg Hahn for providing critical support for this application.
I've decided to drop DHL support, since they don't do domestic U.S. shipping any longer. The add-in will still track DHL packages, but if anyone out there uses the add-in for this and the DHL functionality breaks, I'd be glad to hear about it, but I won't be able to fix it.
Please report any bugs or issues in the comments below.
[Update 2/14/2009]: I am actively seeking to build this application with more carriers; so far there are five, but I know there are more. If you would like your carrier added, please send me the carrier name, URL and some sample tracking numbers.
About JP
26 Comments:
Wonderful add in this is saving me untold hours tracking ups shipments. Last week however i started getting odd results on shipments with delivery status delivered. it is posting "delivered on " and the rest looks to me like the html code of the whole page. my amature guess is that the xml parsing isnt working right or ups has changed their tracking site. here is one of the numbers displaying that result 1Z2X37314499205448
thanks again
I'll take a look at it, thanks for the feedback!
same here, here is what it says in the cell…
"Delivered on DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>
<META HTTP-EQUIV=Content-Type CONTENT=text/html"
Hey JP
shipTrack broke this week. It looks like FedEx changed the way they display the delivered date (perhaps). I was looking at the source of the FedEx details page and it looks like javascript populates the delivery date in the browser. If this is the case then the XML parse won't be able to get the dates from the source, no?
Can you take a look and tell me what you think? Right now it is a blank div in the source:
So the delivery date shows as:
Thanks
Ryan
Shiptrack (I use it for fedex) doesn't work anymore. The results I receive now look like this:
Delivered on , signed for by Signature not required
Maybe fedex changed something on there end.
Thanks,
Todd
I'm posting an update in the new few minutes.
Hey JP, have you ever looked into created a web version that could be used in a Google Doc version of a spreadsheet? We are trying to do a live updated spreadsheet that would track up to 2100 shipments at one time. Crazy! Let me know!
Not really, I'm afraid that would really stretch my skill set.
There already is a ShipTrack for PHP, see http://www.supertom.com/code/shiptrack.html, I'm not sure it could be used with Google Docs however.
Alright, I appreciate the response! We are working on a way to do it in Excel then upload to a GoogleDoc every hour or so to make it feel like real time.
Is there any way to have the plugin return expected delivery date information in the cell as well?
Other than that, really like the plugin! Thanks.
I thought it already did that. Which carrier are you tracking?
Hi JP. Do you know if the Excel 2007 version of ShipTrack works with Excel 2010? I just upgraded to the latest Excel version and would love to be able to keep using this add-in.
No idea, but you can try it and let the rest of us know!
I tested the ShipTrack add-in in Excel 2010 with a recent UPS tracking number and some older FedEx tracking numbers. Everything worked well. It looks promising that this will work in Excel 2010 without any modifications. Thanks for this very useful add-in.
Great news, Mark! Thanks so much for trying it out.
I can add the fuctions to one cell only how can use all the tracking numbers?
and I would like to be able to have a URL link to the Fedex site by clicking on the tracking numbers.
Thanks
AWESOME ADD ON!!!!
I don't know what you mean. You can fill the formula down or across to accomodate multiple tracking numbers, or use the ShipTrack UI to track shipments in bulk:
http://www.jpsoftwaretech.com/blog/2008/11/shipment-tracking-userform-for-batch-processing/
If you want a clickable URL for Fedex, check out the HYPERLINK function.
I sample pic on how to do this formula filling down or across ?
Hi. I would like to add a formula to all the cells in a column without having to put the formula in one cell at a time.
This is my question.
Thanks
@Tyler,
If I understand your question correctly, select all the cells you wish to fill in first, then type your formula into the Formula Bar and finish off by pressing CTRL+ENTER (and not just Enter by itself).
That was my understanding as well. Thanks Rick!
@Tyler,
To follow up on my last posting, you can also enter your formula into a cell first, then move your cursor over the small, solid square located in the bottom right corner of the cell and click-drag down to through all the cells you want to fill in. Or, after putting your formula into the cell, you can copy it to the Clipboard (either press CTRL+C or click Edit/Copy from the menu bar), then select the rest of the cells you want to fill in and paste the formula from the Clipboard (either press CTRL+V or click Edit/Paste from the menu bar).
JP,
Starting in 2011 I am now getting an error with the ShipTrack Excel add-in for UPS shipments. Instead of bringing back the UPS status it appears to give an HTML error with a bunch of code: ex: …
Any help you could give would be great! Thanks!
Shawn
Shawn,
I am having the same issue. Has anyone found a fix?
Betsy
Several others have made me aware of the issue; I should have a fix available shortly.
Any updates on the fix? We LOVE this Add-In!
I'll have an announcement on Monday.