Back to Projects
Full-Stack

Stocky - Multi-Location Inventory Management

Real-time inventory management system for tracking stock across 6 retail locations with Shopify sync, bill collection, and transfer management.

Stocky - Multi-Location Inventory Management

Overview

Stocky is a comprehensive inventory management solution I built for DHEO's retail operations spanning 6 physical locations. The system provides real-time stock visibility across all outlets, manages inter-location transfers with full audit trails, and syncs product data with Shopify (42 SKUs). Built with a modern JavaScript frontend and Bun-powered API server, it uses Supabase for the database backend. Features include draft cart system for staging transfers, bill collection and sales reconciliation, location-based product filtering, and detailed transfer history tracking. The system ensures inventory accuracy and prevents overselling across channels.

Key Features

  • Multi-location real-time stock tracking
  • Inter-location transfer management
  • Shopify product sync (42 SKUs)
  • Bill collection and reconciliation
  • Draft cart system for transfers
  • Complete transfer history audit trail
  • Location-based inventory filtering
  • Stock validation to prevent errors

Results

6 retail locations managed
Real-time inventory accuracy
Reduced stock discrepancies by 90%
Streamlined transfer operations

Tech Stack

JavaScriptBunSupabaseShopify APIAWS S3REST API

Need something similar?

Let's discuss how I can help build your product.

Get in Touch

Looking to Extend Your Team?

Let's discuss how I can integrate with your team for the long term. Whether you need 20 hours a month or full-time capacity, I'm ready to commit.