Muzamil ShirazINDEPENDENT PRODUCT ENGINEERDiscuss Your Project
Menu

Business Systems · Finance & Stock ERP

Sufi Glass

Centralized wholesale glass management system handling commercial transactions, inventory, quotation workflows, and payment collection tracking.

StatusProduction System · Private Internal
My RoleLead Product Engineer
Core StackNext.js · React · MongoDB
Timeline2024 – Present
sufi-glass-erp / production interfacePrivate System
Sufi Glass application interface

Operational Context & The Problem

A wholesale glass fabrication business managed orders, inventory cutting specifications, and credit collections across disparate paper ledgers and manual calculations. Price variations based on glass thickness, dimensions, and customer credit terms created calculation errors, delayed invoicing, and made cash collection auditing difficult.

Scope & System Boundaries

Roles & Key Operations

  • Calculate multi-variable glass rates (sqft, thickness, polishing)
  • Generate itemized quotations and convert to tax invoices
  • Log customer payments, credit balances, and aged receipts
  • Track raw sheet inventory and cutting deductions

Boundaries & Design Focus

  • Internal company network and authenticated dashboard
  • Excludes external public customer self-checkout
  • Single-tenant deployment tailored specifically to Sufi Glass operational rules and pricing matrices.

Operational Workflow

01

Rate Catalog & Specification

Staff configure dimensional rates by glass thickness, edge polishing type, and volume discount tiers.

02

Quotation to Invoice Flow

Customer requirements are entered; system calculates square footage, charges, taxes, and outputs branded PDF quotations with one-click conversion to invoices.

03

Stock & Inventory Movement

Issued invoices automatically decrement sheet inventory and alert staff when specific sizes fall below reorder thresholds.

04

Collection & Receivables Ledger

Partial payments, cash receipts, and customer ledger balances update instantly in the collection dashboard.

Key Engineering Decisions

Decision 01Complex dimensional pricing with custom cuts and edge finishing caused frequent manual quote errors.
Alternative Considered

Generic spreadsheet templates or standard off-the-shelf POS software.

Architecture Chosen

Custom rate engine integrated into the quotation generator with automated area math and pre-set finish multipliers.

Technical Rationale

Wholesale glass requires custom unit calculation (width × height × thickness) that standard retail software does not support natively.

Trade-off Accepted

Required developing a bespoke formula builder rather than using standard e-commerce SKU math.

Decision 02Managing partial payments and outstanding customer credit balances required continuous auditing.
Alternative Considered

Third-party accounting SaaS integration.

Architecture Chosen

Native transactional ledger inside the core MongoDB database with chronological receipt logging.

Technical Rationale

Single source of truth eliminated double-entry errors between operational invoices and financial accounting.

Trade-off Accepted

Audit history must be maintained strictly with immutable ledger records.

Data & Workflow Architecture

Order EntrySales Staff

Input dimensions & finish

Real-time calculation

Document GenSystem Engine

Generate quotation / invoice

Formatted PDF record

Stock SyncInventory DB

Deduct raw glass sheets

Updated stock levels

AccountsFinance / Owner

Record payment & reconcile

Customer balance update

Delivery & Verification

A dedicated financial and stock administration application. No public login is shared.

Verified System Outcome

Replaced fragmented manual ledgers with a unified operational ERP. Quotations and invoices calculate accurately in seconds, inventory deductions sync automatically upon dispatch, and executive management has real-time visibility into outstanding receivables.

Planning custom business software or an internal ERP system?

Let's discuss your workflow, technical constraints, and how we can engineer a tailored solution from start to finish.

Discuss Your Project

Other selected builds

More systems in production.

Explore all work
Vibe Living DXB — Real Estate · Custom CMS Platform interface

Real Estate · Custom CMS Platform

Vibe Living DXB

Bring property discovery and an editable brand presence together in one real-estate platform.

Property discovery & filteringEditable listings and areasAgent profiles
Bun — Restaurant · Ordering & Staff POS interface

Restaurant · Ordering & Staff POS

Bun

Connect an expressive restaurant storefront with the practical work of taking and managing orders.

Live order queuesRole-based accessMenu management