Skip to content

Case study, Orbit Electronic

Orbit System

An internal platform I designed and built on my own to run purchasing, inventory and operations at Orbit Electronic.

13,000+active products, managed in it every day by colleagues from purchasing to customer service.

Role
Design, data model, logic and code
Stack
Next.js, Supabase, PostgreSQL
Timeline
July 2025 to now
Users
About 10 colleagues, every day
The Orbit System purchasing view. A dark table of products sorted by priority, with sales, stock, a coverage bar, turnover and an adjustable order quantity per row.

The purchasing view. Reorder advice per product, sorted by priority.

The problem

Before Orbit System

  1. 01Every marketplace had its own analytics, and none of them talked to each other.
  2. 02Product data came in through manual CSV uploads.
  3. 03Purchasing ran on Google Sheets.
  4. 04Most reorder decisions came down to gut feeling.

How it works

Built for the person doing the buying.

The purchasing view is where most of the work happens. Four details that show how I think about it. The interface is in Dutch, because that is what the team speaks.

Close-up of the priority and product name columns, ranked one to six.

01Priority

A priority list, not a spreadsheet.

Every product gets a reorder advice and a rank. The team starts at the top and works down, instead of scanning thousands of rows.

A tooltip on a coverage bar. Current 57 days, target 97 days, advice adds 40 days, 97 days after ordering.

02Coverage

Numbers that explain themselves.

Coverage shows how many days of stock are left. Hover it and you see the math, what we have, what we aim for and what the advice adds. People only follow advice they can check, so I made it checkable.

Close-up of sales, stock, coverage bars and colour coded turnover for four products.

03Context

Context to overrule the system.

Sales over the last year and the last 90 days sit next to a trend icon, with turnover in colour. The advice is a starting point, and this is how a buyer sees when they know better.

Quantity steppers with bookmark icons, and a floating bar with confirm and picklist buttons.

04Confirm

Adjust, then confirm in one go.

Change quantities with plus and minus, bookmark what matters, confirm once. The order syncs to the warehouse system, and a browser extension I built fills the carts on 14 supplier webshops.

Also in the platform

My role

I own it from the first sketch to production.

  1. July 2025

    First version, a JavaScript dashboard fed by CSV uploads.

  2. October 2025

    Rebuilt in Next.js on a new data model.

  3. April 2026

    My role changes from Visual Designer to Automation Engineer.

  4. Today

    In production, used every day by purchasing, sales, support and the warehouse.

Results

From spreadsheets to a system people rely on.

  • 13,000+active products managed in one place
  • 14supplier webshops filled automatically
  • 10colleagues, give or take, use it every day
  • 1person designed and built it
  • Data inJuly 2025Manual CSV uploadsTodayAutomatic syncs with marketplaces, warehouse and shipping
  • PurchasingJuly 2025Google Sheets and gut feelingTodayForecasts, reorder advice and supplier carts filled automatically
  • UsersJuly 2025Just meTodayPurchasing, sales, support and the warehouse
  • BuiltJuly 2025Alone, a JavaScript dashboardTodayAlone with AI, a Next.js platform in production

What's next

What I'd build next

  1. 01

    Seasonal forecasts

    Forecasts that account for seasons and promotions, not just recent sales.

  2. 02

    Real lead times

    Supplier lead times learned from actual delivery dates, so the advice orders earlier when a supplier runs late.

  3. 03

    Draft orders from Karen

    The assistant drafts purchase orders, and a buyer reviews and approves them.

All work