TL;DR
A US office-supplies retailer selling in bulk and to individuals needed its revenue-generating ecommerce platform extended and kept reliable: quotations, orders, payments, shipping and tracking, invoices, reporting and customer self-service. Our engineer delivered new features and optimisations across that lifecycle on the existing Java/Oracle stack, with automated Jaspersoft reporting, for two and a half years with no platform migration.
Challenge
The store could not stop for a rebuild. Every change had to land on a live platform with a large Oracle database, legacy Struts controllers and jQuery front ends, while customers kept placing orders. Reporting on orders, invoices and sales was slow and partly manual, and customer self-service was limited, pushing routine questions to the support team.
Solution
Features were added incrementally across the order lifecycle on the live platform, while Oracle was tuned for the heaviest screens and reporting moved from hand-assembled to scheduled.
- Quotation flows for bulk buyers
- Order and payment handling, shipping and tracking updates
- Invoice generation
- Self-service screens so customers can see their own orders and documents
- Oracle queries, stored procedures and functions tuned for the heaviest screens
- Orders, invoices and sales reports built in Jaspersoft and scheduled
- Production issues fixed at the root and tracked through SVN
Stack and approach
Technologies
- Java
- JSP
- Struts MVC
- Hibernate ORM
- Oracle 19c
- Jaspersoft
- HTML/CSS/JavaScript
- jQuery
- AJAX
- SVN
Patterns
- Extend, not replace, on a live store
- Database-level optimisation before application changes
- Scheduled reporting
- Customer self-service to cut support load
Results
The platform kept selling throughout, with the order-to-invoice lifecycle covered by the system rather than by staff, three report families automated, and customers able to serve themselves for order status and documents.
Delivered by CodaqLabs engineers while employed at previous companies; client names withheld under confidentiality.