FaktioraStock – Offline Multi-Site Inventory Management Software

Designed and developed FaktioraStock, a 100 % offline desktop inventory management software for a multi-site Malagasy SME operating across Antananarivo (TNR) and Moramanga (MRG), where unreliable internet connectivity makes cloud-based tools impractical.

Built with Electron and an embedded SQLite database (via better-sqlite3), the application runs entirely on the local machine with a secure multi-process architecture: sandbox and contextIsolation enabled, no nodeIntegration in the renderer, and a typed IPC bridge exposed through contextBridge.

Implemented full stock accounting logic including weighted average cost (CMUP) with historical valuation, percentage-based allocation of freight, customs and transit costs, atomic stock movements (in/out, deliveries, transfers, receptions, adjustments, physical inventories), per-site sequential numbering (e.g. BL-TNR YYMM###), and full client credit / payment / allocation workflows.

Delivered native PDF generation for delivery notes, transfer notes and invoices, Excel exports via SheetJS, a real-time KPI dashboard (active products, stock value, movements, min/max alerts), and a schema-agnostic backup and restore system resilient to future database migrations.