Fedex, UPS and DHL Tracking Updates -- 2
Budget: $250 – $750 USD
Need an app to provide tracking updates to Fedex, UPS and DHL tracking numbers. The developer needs to have previously developed this exact type of application for a quick and easy deployment at a minimal cost.
The application needs to grab the tracking number from an Microsoft SQL table, fetch the tracking information using applicable APIs and update the following information in the same table:
[PickupDate]
[DeliveredDate]
[DeliveredCity]
[DeliveredState]
[DeliveredPostCode]
[DeliveredCountry]
[PODAccountNumber]
[PODPhoneNumber]
[PODPostCode]
[CurrentStatus] - This is a code provided by the application to indicate the current status of the shipment.
[Notes] [nvarchar](400) - This is a full text copy of the data output provided by shipping company's API.
[Processed] [bit] - This field will be updated by the application once the tracking information has been updated.
[CurrentStatus]
These are the various codes the application should provide as an update to the status of the shipment
1 Shipment is Moving normally
300 -Out for Delivery
400 - Delivered
-1 Shipment Exception. Delivery Exception (can be due to the recipient not being available or premises closed)
-2 Shipment Exception . Customs exception
-3 Shipment Exception. Shipment Delay caused by eg. weather.
-8 Tracking Number doesn't exist or can't be found.
[Notes]
This field will be used to store the full text message provided by the shipper's API that might be useful to us in further analyzing a shipment exception. Some examples would be "Customs Exception. Missing Commercial invoice to be provided by Shipper or Receiver. Location Anchorage, AK" or "Delivery Exception. Customer denied receipt of package. Please contact customer service. Location: Los Angeles, CA "
The application needs to grab the tracking number from an Microsoft SQL table, fetch the tracking information using applicable APIs and update the following information in the same table:
[PickupDate]
[DeliveredDate]
[DeliveredCity]
[DeliveredState]
[DeliveredPostCode]
[DeliveredCountry]
[PODAccountNumber]
[PODPhoneNumber]
[PODPostCode]
[CurrentStatus] - This is a code provided by the application to indicate the current status of the shipment.
[Notes] [nvarchar](400) - This is a full text copy of the data output provided by shipping company's API.
[Processed] [bit] - This field will be updated by the application once the tracking information has been updated.
[CurrentStatus]
These are the various codes the application should provide as an update to the status of the shipment
1 Shipment is Moving normally
300 -Out for Delivery
400 - Delivered
-1 Shipment Exception. Delivery Exception (can be due to the recipient not being available or premises closed)
-2 Shipment Exception . Customs exception
-3 Shipment Exception. Shipment Delay caused by eg. weather.
-8 Tracking Number doesn't exist or can't be found.
[Notes]
This field will be used to store the full text message provided by the shipper's API that might be useful to us in further analyzing a shipment exception. Some examples would be "Customs Exception. Missing Commercial invoice to be provided by Shipper or Receiver. Location Anchorage, AK" or "Delivery Exception. Customer denied receipt of package. Please contact customer service. Location: Los Angeles, CA "