Business Management System — Inventory & Operations

Inventory, sales preparation and profit reporting for everyday retail.

Context

I am developing a business management application around the everyday needs of a retail business in Sierra Leone. The current UMS Apex Ventures workspace covers inventory, point-of-sale workflows, financial reporting and stock history. It is in early testing with a first real user.

My contribution

Application development and ongoing improvements informed by feedback from a first real user.

The approach

Using feedback from day-to-day retail work to improve the application. The focus is on finding products, checking stock, preparing a sale and understanding product profitability.

Tools & focus

React / TypeScript / Vite / Supabase / PostgreSQL

The technical structure

A React and TypeScript application built with Vite. The frontend uses the Supabase client for authentication and data access, with a PostgreSQL schema connecting products, variants, stock movements, sales, purchases, expenses and user profiles.

Find products and check stock

The inventory catalog supports search by name, SKU, family or brand, with product variants and stock states in one workspace.

Prepare a sale

The POS workspace brings products into a cart, with quantities and payment choices. The current walkthrough demonstrates cart preparation; payment processing has not been verified.

Follow the business

Reports bring together revenue, cost, gross profit and product margins. Stock history records additions and deductions, including before-and-after quantities.

Current limits and next steps

This is an early implementation tested with one real-world user. The captured walkthrough does not verify processed payments or CSV exports. Reconciling dashboard and report stock totals, improving stock-history traceability and validating end-to-end workflows remain priorities.