[RESOLVED] How does Track number works to check the status of shipment in Courier services?

[webn]

Hi all,

I need a help.

Courier services like FedEx states, "You can use Track to check the status of your shipment at any time during and after delivery. With just a few clicks, you can check status of up to 30 FedEx shipments at a time. You can enter tracking numbers for up to 30 shipments at a time. Please ensure that you enter only one tracking number per line. The Summary Results screen shows status, destination, and date and time delivery information by tracking number."

I need to know how does it works? Can you suggest me any code? Thank you.

[bpat1434]

each package gets a unique barcode number (ID) that is stored in a database. When it's scanned (at sort facility, at loading facility, out for delivery, at destination, etc.) then an entry is made into the database (or info is appended to a row) about the current status.

So when the user "tracks" their package, a query is called to the database to see what current information it has to give. Obviously, if the fields are blank, it won't show it.

Basically, the databases would look something like:

packages
ID_PCKG
sender
senddate
weight
size
type
destination
address
zipcode
state
service
est_delivery
signature
delivered

tracking
ID_TRACKER
ID_PCKG
facility
type
tracktime

So then each "scan" would insert into the tracking database something like:
1 | 1 | Null | Pickup Scheduled | 01/01/01 01:01

Hope you understand that 😉

[webn]

bpat1434, thanks for your responsible help.

[bpat1434]

Remember to purge your databases regularly..... otherwise they would get huge and slow down....