The Problem
Product data was scattered across Excel files, ERP and various systems. No single source of truth. Manual text creation for hundreds of products was time-consuming and inconsistent. Multi-channel maintenance meant: entering the same data multiple times.
- Data chaos from Excel lists
- Hours of manual text work
- Inconsistent product info
- Error-prone multi-channel maintenance
The Solution
A fully web-based PIM system with central MySQL database, RESTful API and OpenAI integration for AI-powered product descriptions. One system – all channels.
My Role
Lead Developer & System Architect
Features
Central Master Data
All product data in one place. EAN, prices, texts, images, attributes.
AI Text Generation
OpenAI generates SEO-optimized product texts at the push of a button.
Multi-Channel Export
JTL Shop, JTL Wawi, Amazon, eBay – one click.
Inventory Analysis
Stock overview, notification system, automatic order suggestions.
Import/Export
CSV, XML, Excel – data in, data out.
Users & Permissions
Role-based access control for teams.
Screenshots
Dashboard Overview
Product Editor
AI Text Generator
What I Learned
Integrating AI into existing workflows requires careful UX planning. Users must understand and be able to adjust AI results – not blindly accept them.