I would like to get some advice and/or opinions on the best way to track customer orders.
I have a database table with order information including tracking number and carrier. I believe the challenge here is that we have multiple carriers.
I wrote a script already that extracts the tracking number and carrier for a customer after they enter a customer id number.
The goal is to have the tracking number appear as a link and link to the appropriate carrier and show the status of the order.
Is this possible to do? If so, how would one handle the issue of having many carriers? Where do I begin?
Any advice/opinions/comments is greatly appreciated.
Thank you in advance.