Case Study · E-commerce Operations

Choshmish Inventory Management System

One screen to run a multi-channel sunglasses brand — website and DM orders, live inventory, courier dispatch, and analytics, finally in one place.

Role
Founder & Developer
Timeline
2026
Domain
Shopify D2C · Bangladesh
Build
Solo
Overview

Where it started

Choshmish is my Shopify sunglasses brand in Bangladesh. Orders arrive two ways — through the website, and through DMs on Facebook and Instagram. Website orders flowed straight to Steadfast, our courier; DM orders had to be keyed into Steadfast by hand. Inventory lived in a separate Google Sheet, updated manually.

Three disconnected systems, one person holding them together — and every handoff was a chance to oversell, mis-ship, or lose an order. The goal was simple: bring everything into one space.

Choshmish dashboard
Dashboard · overviewadd choshmish-dashboard.jpg
The hub — one screen for orders, inventory, and dispatch.
The problem

Three tools, no single truth

Before

  • Website orders synced to Steadfast automatically
  • Facebook / Instagram DM orders re-typed into Steadfast by hand
  • Inventory tracked in a separate Google Sheet, updated manually
  • No shared view of stock, dispatch, or performance

After

  • Every order — web or DM — captured in one pipeline
  • Stock as a single source of truth, synced with Shopify
  • One-action dispatch and live delivery status
  • Orders, inventory, purchase orders, and analytics on one dashboard
The system

Shopify as the source of truth, everything else orbiting it

Rather than bolt on another tool, I built the hub around one decision: Shopify owns the stock. DM orders get captured into the same pipeline as website orders, so from that point on every order is identical — one flow to dispatch, track, and reconcile.

Channels
Shopify Website
Facebook / Instagram DMs
→
Core Engine · Apps Script + Sheets
Orders
Inventory
Purchase Orders
Analytics
→
Fulfilment & Comms
Steadfast Courier
WhatsApp · GREEN-API
→
Control
PWA Dashboard + Push
Shopify order & cancellation webhooks feed the engine · stock stays in sync both ways
Modules

What lives inside the hub

01 · Orders

One queue for every channel

Website orders arrive via Shopify's webhook; DM orders go in through a fast entry form. Everything lands in a single queue, dispatched with one action.

02 · Inventory

Stock that can't lie

Shopify-synced stock as the single source of truth — auto-decremented on sale, auto-restocked on cancellation, reliable across every path that touches a count.

03 · Purchase Orders

Restocks, tracked

Incoming inventory and supplier restocks logged against the same stock, so counts stay honest as new product comes in.

04 · Analytics

The business at a glance

Sales, stock movement, and fulfilment performance surfaced in one view — no more piecing the picture together from three places.

05 · Courier

Steadfast, wired in

Orders push to Steadfast in one action, and live delivery statuses flow back into the dashboard automatically.

06 · Dashboard & Alerts

A screen you live in

Installable PWA with push notifications, so a new order or a status change reaches you the moment it happens.

Screens

Inside the hub

Orders view
Ordersadd choshmish-orders.jpg
The order queue
Inventory view
Inventoryadd choshmish-inventory.jpg
Stock & low-stock alerts
Analytics view
Analyticsadd choshmish-analytics.jpg
Sales & performance
How it works

The life of an order

1
Placed
A customer checks out on the website, or a DM order is keyed into the hub in seconds.
2
Captured
Shopify's order webhook pulls it into one pipeline — website and DM orders become identical from here.
3
Stock adjusted
Inventory decrements against the single source of truth, with the change synced back to Shopify.
4
Dispatched
The order is pushed to Steadfast in one action — no re-typing, no second system.
5
Tracked
Live delivery status flows back to the dashboard; WhatsApp keeps the customer updated.
6
Reconciled
Cancellations auto-restock inventory, and analytics stay current — no phantom stock, no manual cleanup.
Stack

Built lean, on tools that fit the business

Shopify
Storefront + order & cancellation webhooks
Google Apps Script
Backend logic & automation
Google Sheets
Data store for orders, stock & POs
Steadfast API
Last-mile courier dispatch & tracking
GREEN-API · WhatsApp
Order-stage notifications
PWA + Push
The installable control surface
Impact

From three tabs to one hub

Killed the manual DM → Steadfast → Sheet loop — the biggest source of lost time and errors.
Every channel now flows through one order pipeline with one-action dispatch.
Reliable Shopify stock sync across every path that touches inventory.
Cancellations restock automatically — no more phantom stock or overselling.
A single push-enabled dashboard to run the whole operation.
A foundation clean enough to build marketing and try-on features on top of.
Real numbers (orders/month, hours saved, oversell rate) can drop straight into this section.
More case studies

More work

01
Logistics Software · OperationsEasy Global Logistics Tracker
↗ 02
E-commerce · Computer visionAI Mirror — Sunglasses Recommendation
↗ 03
Software · Language learningBUNGUMAN — German Learning
↗ 04
Hardware · Machine learningSmart Trash Sorting Device
↗ 05
Hardware · LeadershipFormula Student EV
↗

See the rest of the work.

← Back to portfolio Get in touch →