The Story of Oliveyoung's Online Store Settlement System Overhaul

Oliveyoung's existing online store settlement system had a structure where data from each process—orders, claims, shipping, etc.—was reprocessed for settlement and stored in separate tables. This approach had high complexity for maintaining data consistency, and as transaction volume increased, it suffered from worsening inaccuracy in settlement data and a growing operational resource burden on developers to correct it.

To solve this, Oliveyoung completely overhauled its data collection method. Order, claim, and shipping data are now stored only in their respective source tables, and the system was redesigned to directly collect source data when needed at the settlement stage to generate vouchers and transmit sales. This simplified the data flow and fundamentally resolved the settlement consistency problem by leveraging the integrity of the source data.

The key outcomes achieved through this overhaul are as follows.

• Dramatic reduction in operational work: Settlement data correction tasks, which used to occur more than 150 times per month, dropped to zero cases since April 2024.
• Secured data reliability: Adopted the BigDecimal library to improve the accuracy of decimal calculations and ensure data stability per order number.
• Improved operational efficiency and convenience: The settlement closing process was automated, allowing operations staff to handle closing on their own, and settlement screen query speed was drastically reduced to around 30 seconds.
• Optimized development workforce: Development staff, freed from repetitive data correction work, could be redeployed to new feature development and system enhancement.