Desktop Application

Benz Stock Manager
[Featured Project]

1. Introduction

1-1. Overview

This project was requested from the Korean official Benz dealers from one of the official Benz stores in Korea.

Benz Stock Manager is a lightweight yet powerful Windows desktop application designed specifically for Korean official Benz dealers. This GUI application automates the process of parsing, organizing, and analyzing raw stock data received from certain Benz store. It enables sales representatives and coordinators to quickly compile professional, easy-to-read vehicle stock summaries for client communication — particularly via KakaoTalk, the most widely used messenger in Korea.

Benz Stock Manager bridges the gap between the raw data and the customer-friendly, ready-to-send stock summary message with just a few clicks — an essential tool for modern Benz dealerships in Korea.

1-2. Purpose

In the high-paced world of automotive sales, time is of the essence. Dealers often receive large Excel spreadsheets containing vehicle inventory data.

Manually formatting and extracting key information — especially with specific exterior and interior color codes — is time-consuming and error-prone. Benz Stock Manager eliminates this manual bottleneck, delivering ready-to-send summaries with just a few clicks.

1-3. Built For

  • Benz sales teams
  • Inventory managers
  • Customer service agents needing quick and clear client updates

1-4. Key Features

1-4-1. Intuitive GUI

The application provides a minimal, distraction-free user interface:

  • Select Excel File: Load the raw .xlsx file containing the Benz stock data.
  • Select Color Code File: Load a .txt file listing interior and exterior color mappings used in the inventory data.
  • Parse Button: Instantly analyze, format, and output the result.
1-4-2. Dual-Panel Layout for Efficiency
  • Left Panel - Parsed Result for Copy & Paste: Displays a clear, formatted summary of the inventory by model, color combinations, and quantities. The output is optimized for KakaoTalk messages, making communication with customers seamless and professional.
  • Right Panel - Warnings & Ambiguities: If the parser detects unrecognized codes, mismatched formats, or incomplete data (e.g., undefined color codes or missing model information), it shows warnings here. This ensures the user is aware of any uncertainties that need manual attention.

1-5. Input File Format

  • 1. Excel File
    - Typically includes:
    • Vehicle model names
    • Color codes (interior/exterior)
    • Production year
    • Stock quantities
    - This file is selected using the "Select Excel File" button.
  • 2. Color Code File (TXT)
    - Must contain color code mappings in the following format:
    040, 블랙
124, 벨벳 브라운
101, 블랙
105, 베이지
    - Divided into sections like "외장색상" (exterior) and "내장시트" (interior), which the parser uses for mapping during transformation.

1-6. How It Works

  • 1. File Selection: User selects the Excel and color code files.
  • 2. Parsing: When the "Parse" button is clicked, the program:
    • Reads stock entries from the Excel file.
    • Matches color codes using the TXT file.
    • Formats the data per vehicle model.
    • Highlights any issues in the warning panel.
  • 3. Output: The formatted summary on the left is ready for copy-pasting into KakaoTalk, minimizing formatting hassles.

1-7. Use Case Example

  • Launch Benz Stock Manager.
  • Select the two input files.
  • Click "Parse" button.
  • Instantly view a customer-ready message on the left panel like:
    GLB 250 4MATIC (2025)
폴라 화이트 . 블랙 . 6대
블랙 . 블랙 . 2대
마운틴 그레이 . 블랙 . 1대
    At the same time, any ambiguities like:
    재고 S, GT,169,,,,,,홀세일 완료,홀세일 예정,
    will be shown on the right panel, helping users verify inconsistencies before sharing.

1-8. Benefits

  • Saves hours of manual formatting.
  • Reduces risk of human error.
  • Improves communication clarity.
  • Makes mass-messaging in KakaoTalk smooth and quick.
  • Transparent error handling and debugging with the warning panel.

2. Techs

  • Language / Script

  • Framework

  • Library

  • OS

  • IDE

  • VCS

  • Compiler / Transpiler / Bundler / Build Tool

  • Linter / Formatter

  • Package Manager / Dependency Manager

  • Etc.

3. Screenshots

© 2025 hansf14. All Rights Reserved.