SEDA Order Tracking Portal
An order tracking portal for SEDA Collection, built in PHP and connected to the company's existing legacy SQL Server database so customers and staff can follow orders in real time without migrating data.
The challenge
SEDA stored order data in an old SQL Server database with no customer-facing way to check order status, leading to constant manual status enquiries.
Our solution
Built a PHP web portal that reads directly from the legacy SQL Server database, exposing real-time order tracking to customers while leaving existing systems intact.
Key features
- Real-time order status tracking
- Integration with legacy SQL Server
- Customer-facing tracking portal
- Order search and history
- No migration of existing data
- Responsive web access
Results & impact
Gave SEDA customers self-service order tracking against their existing database, cutting manual status enquiries and improving transparency.
Customers stopped calling to ask "where's my order" the week this portal went live, and it plugged straight into our existing database with no migration headaches.
SEDA Collection