Fragrance Gate

Fragrance Gate website designed and built by Rexta Technologies
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
The Numbers

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 Brief

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.
How We Built It

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 Outcome

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.
What We Used

Tools and stack

  • Next.js 16Next.js 16
  • React 19React 19
  • TypeScriptTypeScript
  • Tailwind CSSTailwind CSS
  • SupabaseSupabase
  • PrismaPrisma
  • NodemailerNodemailer
  • pdfkitpdfkit
  • VercelVercel
Project Visuals

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