Advancement of Lock & Lock Product Information System

IT7 successfully launched the new product information system for Lock&Lock Co., Ltd. This project, initiated at the headquarters in Korea, was expanded to include overseas subsidiaries in China and Vietnam. Furthermore, the project continued to meet the demand for system enhancement.

Key Improvements and Features

Global Integration Expansion:

The scope of information linked with the SAP (ERP) system was expanded from domestic to global subsidiaries. This allowed authorized personnel to map global material information and financial information together, enabling a comprehensive view of these data points.

Information Synchronization:

The system was enhanced to link with the internal file archive server, allowing users to view the latest information at a glance. As a result, the final work files in the internal system are synchronized by material, facilitating smooth communication between workers, planners, and salespeople. Additionally, the product information system was integrated, strengthening its role as a product information portal.

Data Search and Extraction Features:

The system was designed to collect more data and add various search conditions, allowing users to easily extract data according to their desired criteria.

Excel Download Functionality:

A feature was implemented to download data, including images, in Excel format in a single operation. This was designed and developed to enable practitioners to download the desired data format quickly.

Multilingual Support:

The system was configured to support four languages: Korean, Chinese, Vietnamese, and English.

Asynchronous Call Method:

The backend API was designed with an asynchronous call method to fetch data quickly and concisely.

Development in AWS EC2 Environment:

The system was developed in the AWS EC2 environment, ensuring stability and scalability.

Scope of Work

• Requirement Collection: Collected and analyzed the detailed requirements of the client.
• Storyboard Creation: Visualized and documented the overall flow and functions of the system.
• Design: Conducted UI/UX design to optimize user experience.
• Publishing: Implemented the design into actual web pages adhering to web standards.
• Front/Backend Development: Utilized the latest technologies for front-end and back-end development.
• Unit Testing and Third-party Testing: Performed unit testing and external testing to verify the accuracy of all functions.
• User Testing: Tested the system in the actual user environment and incorporated feedback.
• Release: Ultimately deployed the system into operation.

Key Features

• Multilingual Support: Optimized the system for global users by supporting multiple languages.
• Batch Job for Large-scale Image Crawling and Classification: Designed and developed batch jobs to crawl, classify, and register large-scale images in AWS S3.
• Large-scale Excel Download Support: Provided functionality to download data, including images, in Excel format.

Technologies Used

1. Server Configuration: AWS EC2 (Windows), IIS, AWS S3, AWS RDS
2. Backend: PHP
3. Database: MariaDB
4. Frontend: HTML5, CSS3, JavaScript, jQuery

This project aimed at data integration and efficient information management in a global environment. Leveraging IT7's technical expertise and experience, the project was successfully completed. As a result, Lock&Lock Co., Ltd. can operate a more competitive system in the global market.