Furniture Agencies Management System

Overview

This system manages the day-to-day operations of furniture agencies: warehouses, products, stock movements, sales, purchases, returns, suppliers, customers, expenses and vehicles.

Everything is run from one admin dashboard with fast AJAX-driven screens, two languages, dark and light themes, and export to CSV, PDF and print in every module.

The challenge

Furniture agencies move large, valuable items between warehouses, customers and suppliers. Without one system, stock levels, payments and returns are hard to keep accurate. The agency needed real-time stock, complete sales and purchase records, and reports it could trust.

My role

I designed and built the system: its data model, modules, permissions, reporting and admin interface.

Technical challenges

• Stock you can trust. Every sale, purchase and return must create a movement so stock levels stay correct across warehouses.
• Payments on both sides. Customer order payments and supplier purchase payments are tracked separately but feed the same reports.
• Configurable settings. VAT, currency, language, theme and branding are controlled from settings, not code.
• Exports everywhere. Each module needed CSV, PDF and print output that matches what is on screen.

Outcomes

The agency manages stock, sales, purchases, returns and expenses in one place, with real-time inventory figures and reports that can be exported or printed from any module.

Lessons learned

• Record every stock change as a movement; balances should be calculated, not edited.
• Keep sales and purchase payments separate from invoices so partial payments stay simple.
• Consistent exports across modules save users more time than any single feature.