Loading
Merwin S

I’m not just a video editor

I build intelligent creative workflows

that make brands scale faster

Merwin S

I’m not just a video editor

I build intelligent creative workflows

that make brands scale faster

Modular and Responsive All-in-One Inventory System

  • Created By: WinmerFX
  • Year: 2025
  • Client: Merwin Marketing
  • Categories: 3D Models
  • Role: Solo Developer — Full-stack design & development
  • Stack: React · TypeScript · Firebase · Airtable API · Tailwind CSS
  • Platform: Web App (Mobile-responsive)
  • Categories: Web App · Inventory System · Business Tool

🖥️ All-in-One Inventory & Operations Platform

A fully custom business management system built for a motorcycle spare parts retail store — covering point of sale, inventory control, purchase orders, supplier management, customer tracking, and real-time reporting. Designed and developed entirely from scratch using React, TypeScript, and Firebase, with a live two-way integration to Airtable.

⚠️ The Problem

Running a brick-and-mortar motorcycle parts store on manual processes is a daily grind. Pricing inconsistencies, misplaced inventory, lost sales data, and zero visibility into business performance were slowing operations and making scalability impossible.

This app was built to replace all of that — a custom, centralized platform purpose-built for Merwin Marketing that handles every core operation of the store, from scanning a product at the counter to generating profit reports at the end of the month. No off-the-shelf software, no workarounds — just a system designed exactly to how the business works.

⚙️ What the System Does

🛠️ Built With

📈 What It Changed for the Business

Eliminated manual stock counting with real-time quantity tracking per SKU
Enabled the store to measure revenue, cost, and profit margin for the first time
Made pricing consistent across all staff with locked multi-tier price levels
Centralized all supplier, brand, and model data synced from the Airtable base the family already used — zero migration friction
Gave the store owner clear visibility into best-selling items
Reduced checkout errors through barcode scanning and automatic change calculation
Turned label printing from a manual handwriting task into a 10-second browser print job

👨‍🔧 Built End-to-End by One Developer

This system was designed, architected, and coded entirely by me — from the Firebase database schema and security rules to the Tailwind UI, Airtable sync engine, and printable label system. Every screen, every modal, every edge case was handled solo.

If you need a custom internal tool, inventory system, POS solution, or operational dashboard built for your business — this is exactly the kind of work I do.