ConceptWeb appRetail operations

StockFlow

A custom dashboard that replaces the spreadsheet chaos.

app.stockflow.io/dashboard
Overview

Dashboard

New order
Total stock value
₱1.84M
+6.2% this month
Low-stock items
12
Needs reorder
Pending orders
28
9 ship today
Revenue (Aug)
₱642K
+11% vs Jul

Stock movement

Last 7 months
Feb
Mar
Apr
May
Jun
Jul
Aug

Low-stock alerts

Reorder
📦
Kraft Boxes — M
SKU PK-021
4 left
🏷️
Thermal Labels
SKU PK-008
7 left
🧴
Bottle Pumps
SKU HW-114
0 left

Recent orders

Filter Export
OrderCustomerItemsTotalStatus
#10428Aria Home Goods6 items₱4,820Pending
#10427M. Reyes2 items₱1,560Shipped
#10426Cafe Verde14 items₱9,240Fulfilled
Type
ConceptSelf-initiated
Industry
Retail operations
Scope
Web application
Stack
Hand-codedReact / Next.js · API · role-based auth
Timeline
Illustrative
This is a concept piece created to demonstrate Rozalix's approach — StockFlow is a fictional product. All data shown is sample data; there are no real users or usage figures, and any targets are clearly labelled as such.
Overview
Spreadsheets don't scale. We designed a custom, hand-coded web appthat pulls stock, orders, and suppliers into one live view — the kind of bespoke application logic a page builder simply can't produce.
Concept & design by Rozalix — design & development, end to end.
The brief

Drowning in spreadsheets.

The imagined scenario behind the concept — a growing business outrunning the tools that got it started.

A small retail business tracks everything in a tangle of spreadsheets — stock on one tab, orders on another, supplier contacts in a third. Two people edit the same file, numbers drift out of sync, and nobody can answer “what's actually in stock right now?” with confidence.

They don't need a bloated enterprise ERP. They need a focused, custom tool that fits how they actually work — and that more than one person can use at once, safely.

Manual spreadsheets

Stock, orders and suppliers live in separate files that constantly fall out of sync.

No real-time view

No single screen shows current stock, so reorders are guesswork and stockouts surprise everyone.

No multi-user access

One shared file, no roles — anyone can overwrite anything, with no accountability.

Approach

What we designed.

A focused, custom application — every screen built around the questions the team asks all day.

01

A dashboard that answers “how are we doing?”

Key metrics up top — stock value, low-stock count, pending orders, revenue — with a movement chart and a live low-stock alert list, so the day starts with answers, not digging.

Metric cardsChartAlerts
02

Inventory you can actually search

A fast, responsive data table with search, filters and clear status pills — in stock, low, out — so the right item is one query away, not one scroll-marathon away.

Data tableSearch & filterStatus states
03

Orders & suppliers in one place

Every order opens to a clean detail view — line items, customer, totals, fulfilment status — with supplier records linked, so reordering is a couple of clicks.

Order detailSuppliersFulfilment
04

Role-based access, by design

Custom-coded auth separates staff from admin — staff fulfil orders, admins manage pricing and exports — so the right people see the right things.

Roles & permissionsCustom authAudit-friendly
Key features

The pieces that replace the spreadsheet.

Four parts of the design carry most of the operational weight.

Real-time stock overview

One live screen for stock value, counts and movement — no more reconciling tabs.

Low-stock alerts

Automatic flags when items dip below threshold, so reorders happen before stockouts.

Role-based permissions

Staff and admin see and do different things — safe multi-user by design.

Exportable reports

Stock and sales exported to CSV for accounting in a click — no copy-paste.

What this demonstrates

The hand-coded difference.

A dashboard is exactly what page builders can't do. No invented user numbers — here's the capability on show.

Complex state & data UI

Live metrics, charts and tables that stay in sync — real application state, not static pages.

Custom hand-coded logic

Bespoke application behaviour built in code — the opposite of a drag-and-drop template.

Role-based access

Authentication and permissions that separate staff from admin, built properly.

Responsive data tables

Dense, sortable, filterable tables that stay usable from desktop down to tablet.

ApproachHand-codedDesign targetRole-basedDesign targetReal-timeDesign targetResponsive

Outgrown your spreadsheets?

This is a concept — but the craft is real. Tell us what you need to track and we'll get back within one business day.

More work

More concepts in the series.

Part of a series of concept pieces exploring different kinds of build.