Skip to content
  • Ecommerce & retail
  • Back-office systems
  • Backend & reporting
  • 2019–2021

Two and a half years of enhancements and production support on a live B2B and retail ecommerce store, without a rebuild

Quote → invoicefull order lifecycle covered
2.5 yearsof continuous production support
3report families automated (orders, invoices, sales)

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.

01

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.

02

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
03

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.

Free, no obligation

Have a store that works but needs its operations tightened?

Tell us where it hurts. We will look at it properly and come back with what we would change first.