Skip to content

Uzel Mobilya Management System

For furniture maker Uzel Mobilya we migrated thousands of rows kept in Excel to a modern web ERP. Accounts, orders, collections and stock now run on an immutable, append-only accounting ledger.

Uzel Mobilya Management System - 1
Uzel Mobilya Management System - 2
Uzel Mobilya Management System - 3

Problem

Accounts, orders and collections were kept in a multi-sheet Excel file exceeding 3,000 rows. Data inconsistency, balance errors and concurrent-access problems were inevitable.

Solution

We migrated the Excel data to PostgreSQL in full and built an append-only (non-deletable, correction-logged) ledger architecture. We unified accounts, orders, collections, checks and stock with role- and branch-based permissions.

Features

Full data migration from Excel to PostgreSQL
Accounts (CRM), contact and address management
Order and kitchen-set configuration
Collections, shipping and checks on an append-only ledger
Stock movements and price history
Role- and branch-based authorization + audit log

Technologies

FastAPINext.jsPostgreSQLDocker

Results

Excel chaos moved into a single secure system

All financial movements became traceable and reversible

Running in production with 69 API endpoints and 229 automated tests