Case study / 01

Inventory Management

Turning a moving personal database into a searchable, visual system.

RoleProduct Designer & BuilderDuration5 daysToolsFlask · Notion API · CSV · Gemini
Overview

I identified a recurring inventory-management problem, then independently designed, built, and iterated a working website in five days. The product turns CSV and Notion data into a clearer workflow for tracking items while moving between locations and selling them.

The problem

A raw database could hold the information, but it could not make it easy to act on.

I needed a practical way to find clothing and shoes, see where an item was stored, and keep a clearer record of what was available or being sold. I built the complete product independently: two days for the first version, followed by three days refining tabs, subcategories, and the details I needed day to day.

Starting point

A detailed database, but not an everyday interface.

The original source was a structured inventory database with categories, subcategories, quantities, brands, locations, and measurements. It held the right information, but made browsing and acting on it slow.

Original inventory database with clothing categories, quantities, brands, and locations
Original inventory database
What I built
01

Browse by category

Top-level categories and subcategories make clothing and shoes easier to scan than a single, dense table.

02

Filter the working data

Search and location filters help retrieve an item by name, brand, or where it is currently stored.

03

Keep the source flexible

The interface accepts a CSV while also supporting a live Notion database, so the source data stays maintainable.

Delivered interface

A database turned into an everyday operating system.

The final website gives me a visual view of inventory records, category tabs, location filters, and a random outfit selector without requiring a new database workflow.

Inventory website overview using a sanitized CSV
Outcome

A shipped personal tool that makes it easier to keep track of stock, storage, and sale items from a structured CSV database.