Fragrance Gate

Multi-Branch Stock Management System
Fragrance Gate is a stock management system built for Fragrant Gate Resources, a fragrance and perfume retailer in Lagos with several branch stores. Rexta Technologies built it as a premium, calm web application with two roles and one rule: only entries the owner has approved can change a balance. Store keepers record what their branch receives and removes, the owner approves or disapproves each entry, and the business gets numbers it can trust, live across every branch.
VISIT WEBSITE (opens in a new tab)- Client
- Fragrant Gate Resources
- Service
- Software Development
- Category
- Software
- Year
- 2026
- Location
- Nigeria
Results at a glance
2
User Roles
4 Days
Proposal to Live System
4
Fields Per Stock Entry
1
Approval Before Any Balance Changes
4
Screen Sizes Tested
1
Branded PDF Report Export
The challenge
- Stock for each branch lived in separate places, so the owner had no single live view of what was in each store.
- Store keepers could change stock numbers with no review, which made mistakes and shrinkage hard to trace.
- There was no record of who recorded an entry or who approved it.
- Nobody could see a trustworthy opening balance, stock movement and closing balance for a given period.
- The system had to stay focused on stock alone: no sales, payments, invoices, prices or currency anywhere.
Our approach
- We designed the system around two roles. Store keepers record stock received and stock removed for their own branch, and the owner approves or disapproves each entry. Only approved entries change a balance, so every number on screen can be trusted.
- Each store keeper belongs to exactly one branch and only ever sees that branch. The branch always comes from the signed in session on the server, never from the browser, so isolation does not depend on the interface.
- Approval and the balance update happen in one database transaction with a row lock. A stock out is blocked when it is entered and checked again at approval, so two people acting at once can never push a balance below zero.
- The owner is notified of every new entry by email and in the app, and can export a branded landscape PDF report with opening stock, stock in, stock out and closing balance for any period, branch or category.
- The colour system was taken from the client's own logo: brand purple, gold as an accent, black and white. The logo was extracted to a transparent image and the mark traced to SVG so it stays sharp everywhere.
- Tables become cards on phones, dialogs become bottom sheets, and the sidebar collapses on desktop and becomes a drawer on phones, so staff can work from whatever device is at hand.
The results
- Fragrant Gate Resources has a single live view of stock across all branches.
- Every entry carries a full record of who recorded it and who decided it.
- No balance changes until the owner approves the entry.
- Branded PDF reports are available for any period, on demand.
- The system went from signed-off proposal to live production on the client's own domain within days.
- The interface works from phones to desktops, with no horizontal scrolling at any size tested.
Tools and stack
Next.js 16
React 19
TypeScript
Tailwind CSS
Supabase
Prisma
Nodemailerpdfkit
Vercel
Screenshots
Stop Guessing. Start Growing.
The right technology can change how your business operates, how you serve your customers, and what's possible for your next stage of growth. Stop putting off the improvements your business needs. Let's build what moves you forward.
Get Started
