← Work

CASE STUDYPlatform

MDM: master data for convenience-store vendors, governed by design.

A Master Data Management platform — the system that sits underneath a convenience-store operator and governs one source of truth for stores, vendors, products and inventory. Designed and built solo, end to end: domain model, information architecture, UX flows, database schema and application code.

ROLE
Product Designer & Design-Engineer (solo)
STATUS
Admin console, onboarding and vendor portal running end to end; rebuilt on SagUI
STACK
Next.js 16 · TypeScript · PostgreSQL · SagUI · Turborepo · Vercel
Apps on one Postgres database
3
Steps in vendor onboarding
8
Design system: SagUI, shared with this site’s case studies
1
Vendor writes straight to master data
0
MDM admin dashboard with store, vendor, product and inventory countsVendor portal product catalog

The problem

This started with an observation from an in-production enterprise MDM system for a large convenience-store operation. The way it worked and the way a system managing vendor and product data at that scale should work kept pulling apart in the same five places:

  1. 01

    Admins created every product

    Vendors couldn't enter or maintain their own data — every SKU, attribute and update went through an internal admin, by hand.

  2. 02

    Vendor links added after the fact

    The vendor–product relationship was admin bookkeeping, not a step in the vendor's own workflow.

  3. 03

    No onboarding or categorization

    Vendors weren't classified by what they supplied, so nothing downstream — compliance, fields, permissions — could depend on it.

  4. 04

    No approval gate

    Vendor and product data went straight into production tables with no staging, review or needs-more-info step.

  5. 05

    Design spent on polish, not process

    Screens were good-looking; the broken workflow and data governance underneath went largely unaddressed.

None of these gaps are cosmetic. No onboarding means no categorization; no categorization means no conditional compliance; no approval gate means bad data has a straight path into production.

I formed a point of view on the fix — vendors onboard and categorize themselves, every vendor- and product-facing change passes an explicit approval step, and design effort goes into the process, not just the pixels — and validated it with subject-matter experts from the operational side before building anything.

The MVP flow

  • 01 InviteMDM admins send vendor invites — a deliberate, self-service relationship instead of admin-created records.
  • 02 ApproveAdmins review and approve vendors and products — the gate the original system never had.
  • 03 Self-serviceVendors categorize themselves at onboarding and maintain their own catalog from then on.
  • 04 Design systemVisual consistency becomes infrastructure — now SagUI, built once and reused across every app.

System architecture

The domain had to be modeled before any screen was designed. I treated architecture as a design problem: every structural decision has a UX consequence downstream.

                 ┌───────────────────────── Turborepo ─────────────────────────┐
  staff  ───────►│  apps/web          apps/onboarding      apps/vendor-portal   │◄──── vendors
                 │  (MDM admin)       (invite wizard)      (approved vendors)   │
                 │      │ approves ──────── handoff ──────────►│               │
                 │      │◄──────────── reviews submissions ────┤               │
                 │      └──────── packages/db · packages/ui ───┘               │
                 └──────────────────────────┬──────────────────────────────────┘
                                            ▼
                                   PostgreSQL (shared)
  1. 01

    Different threat models

    The vendor portal faces the open internet; the admin console doesn't need to. Separate deploys keep a vendor-side issue away from internal tooling.

  2. 02

    Separate auth, no branching

    Staff and vendors use different session models, so neither app's middleware has to ask “which kind of user is this?”

  3. 03

    Independent scaling

    400 vendors syncing catalogs at 9am shouldn't queue behind internal admin work.

MDM admin dashboard: counts of stores, vendors, products and inventory records, plus store-vendor relationships and product availability
apps/web — the MDM admin console on SagUI’s AppShell, against a seeded data set.
Vendor invitations screen: a form to send a single-use, 14-day onboarding link
apps/web — an admin sends a single-use, 14-day invite. This is where the vendor journey begins.

The staging-and-approval pattern

The single most important decision: nothing a vendor submits touches master data directly. Every vendor-initiated change lands in a staging table with a status. An admin acts on it. Only then does a promotion step write to the real tables. Orders are the deliberate exception — fast and reversible enough to write straight into their own state machine.

VENDOR ACTIONSTAGING TABLEON APPROVAL
Edits profilevendor_edit_requestsUpdates vendors
Submits a new productproduct_submissions + line itemsInserts into products, assigns MDM SKU
Edits an existing productproduct_edit_requestsUpdates products
This pattern isn’t incidental architecture — it is the product. Everything else is UI wrapped around one guarantee: master data stays trustworthy however much self-service the front end offers.

Stack decisions

  • Plain SQL via pgPrisma was ruled out — cross-table analytics needed hand-tunable SQL its abstraction fought against.
  • Magic-link authNo passwords for vendors in v1 — removes a whole class of credential UX; scoped, signed, httpOnly sessions kept separate from staff auth.
  • SagUIOne component library and token set for all three apps, with rules AI agents follow when they build screens.
  • Hashed invite tokensInvite tokens are stored only as hashes; the raw link is shown once, at creation.

Rebuilt on SagUI

The first version sat on shadcn/ui with its own small kit. I’ve since rebuilt all three apps on SagUI →, my design system for people and AI agents. Every screen on this page is SagUI: the AppShell and sidebar, page headings, metric cards, data tables, the stepper, chips and badges.

That changed how the product gets built. The repo carries SagUI’s rules for AI agents, and agents check the SagUI MCP server before they write UI — so new screens come out on-system without a design pass. The design effort stays where it belongs: on the workflow.

  • One shell, three appsAdmin, onboarding and vendor portal share the same AppShell, tokens and components from @sagui/ui.
  • Tokens onlySemantic colors, radius roles and elevation levels — no hard-coded values in app code.
  • Agent-ready repoAGENTS.md rules plus search → get → validate through the SagUI MCP server.
  • Docs in the monorepoSagUI docs and Storybook live alongside the three apps.
MDM admin products table with SKUs, categories, vendors and status badges
apps/web — the product master, built from SagUI’s data table, filters and badges.

Vendor onboarding

Vendor onboarding is a form problem and a trust problem at once: you’re asking a business for sensitive information before it has received any value back. Seven principles drove every decision:

  1. 01

    Progressive disclosure

    Never one 40-field form — steps small enough to feel manageable.

  2. 02

    Ask only when needed

    Compliance documents come after categories, so vendors see only what applies.

  3. 03

    Save and resume

    Every step autosaves; losing progress is the fastest way to lose a vendor.

  4. 04

    Validate inline, early

    Catch a malformed EIN on blur, not at final submit.

  5. 05

    Say what happens next

    A visible stepper and honest review timelines cut anxiety and support load.

  6. 06

    Smart defaults

    The invite pre-fills the email; the primary category pre-selects what they supply.

  7. 07

    Two-sided by design

    The admin review queue got as much design attention as the vendor wizard.

Eight steps, ordered on purpose

STEPCOLLECTSWHY HERE
1 CompanyLegal name, DBA, tax ID, primary categoryLowest friction; lets the system dedupe against existing vendors
2 ContactPrimary contact personStill low-sensitivity
3 AddressBusiness locationValidated inline (5-digit ZIP)
4 PaymentPayment terms, minimum orderCommercial context before compliance
5 CategoriesProduct categories suppliedDrives every downstream conditional requirement
6 DocumentsCompliance uploadsCategory-aware: only what applies
7 ReviewEverything, one pageA last check before committing
8 SubmitSend for approvalOne clear commit point
Onboarding step 1 of 8, Company: legal name, DBA, tax ID and primary category, with the eight-step progress list
apps/onboarding — step 1, with all eight steps visible up front.
Onboarding step 5 of 8, Categories: checkboxes for the product categories a vendor supplies, with earlier steps ticked
Step 5 — categories decide which documents and products come next.

A status machine with a third answer

draft ─submit─▶ submitted ─assign─▶ under_review
                                        │
                  ┌─────────────────────┼─────────────────────┐
                  ▼                     ▼                     ▼
             needs_info              approved              rejected
                  │                     │
                  └─resubmit─▶ under_review     ▶ promoted into live vendors

needs_info is the key UX decision. Instead of a binary approve/reject, reviewers request changes to specific fields, and the vendor gets a targeted, resumable edit — not a full resubmission. It converts what would be a lost vendor (hard reject) or a data-integrity risk (soft approve) into a fix.

Vendor applications queue with status filters: all, submitted, under review, needs info, approved, rejected
apps/web — the review queue, filtered by every state in the machine.
Application review for Lone Star Brewing Co. with contact, address, terms and categories, and Approve, Needs info and Reject actions
The review side: approve, ask for targeted info, or reject. Data shown is a test application.

Products, once a vendor is live

  1. 01

    Bulk Excel upload

    For full catalogs. Templates are personalised per vendor with their approved categories; errors are fixed inline in a preview table instead of forcing a re-upload.

  2. 02

    Barcode

    For the single new item, looked up against barcode databases so most fields fill themselves.

  3. 03

    Manual entry

    The fallback for products with no barcode match or fields automation can't fill.

Vendor portal Add products page: approved categories notice and Bulk upload, Barcode and Manual tabs
apps/vendor-portal — three entry paths into one draft packet, limited to approved categories.
Vendor portal dashboard: live products, draft packet and settings
An approved vendor’s dashboard, scoped to their own data.
Vendor portal product catalog with SKUs, categories, wholesale prices and status
Their live catalog. New items go into a draft packet, then MDM review.

Two journeys, one trust boundary

Onboarding reads as one flow, but it’s two: a vendor moving into self-service, and an admin protecting master data at the same moments. Mapping both side by side is what surfaces the core insight — self-service and data integrity were designed together, stage by stage.

User journey map with vendor and admin journeys side by side, showing stages, emotion curves, actions and pain points
Vendor and admin journeys mapped stage by stage, with emotion curves and pain points.
VENDOR STAGEFEELINGMATCHING ADMIN STAGEDESIGN RESPONSE
InvitedCautiousSource & inviteLow-sensitivity profile step first
OnboardingEffortful, guidedReview applicationCategory-conditional docs: reviewers see only what applies
Awaiting reviewAnxious, in limboDecideneeds_info: fix only the flagged fields
ApprovedRelievedManage live vendorStaged edits, batched notifications
Ongoing useSettledOngoing oversightSame staging gate for every edit and product
  • Asymmetric low pointsThe vendor's worst moment is the wait; the admin's is the review queue one stage earlier. The progress stepper and batched, category-conditional queues were designed as a pair.
  • needs_info at the hingeIt answers the vendor's worst stage and the admin's decision in the same beat.
  • Trust changes shapeAt approval the relationship shifts from “prove you're legitimate” to “run your business here” — gatekeeping becomes enabling on both sides.

How AI fit into the work

I used Claude in two modes of roughly equal weight: as a thinking partner to pressure-test decisions, and as an accelerant to turn agreed specs into schemas and code.

Thinking partner

  • Scoping: magic-link only, images and multi-seat deferred — with second-order effects surfaced first
  • Domain modeling that led to the staging-and-approval pattern
  • Asked to argue for alternative step orders so I could stress-test my own

Engineering accelerant

  • SQL schemas drafted straight from the UX flows, keeping data and steps in lockstep
  • Grounded in the real repo, not a hypothetical one
  • Specs kept as versioned markdown documents, edited surgically rather than regenerated
  • The SagUI rebuild done with agents following SagUI's own rules and MCP server
Every architectural call, scoping tradeoff and sequencing decision was mine. AI compressed the distance between a decision and a build-ready artifact; it didn’t make the decisions.

Where it stands

WORKING

  • Admin console: dashboard, stores, vendors, products, inventory, search
  • Invite → 8-step onboarding → review queue → approve / needs info / reject
  • Vendor portal: magic-link sign-in, catalog, add products by bulk, barcode or hand
  • Vendor submissions queue in the admin console
  • All three apps rebuilt on SagUI

DEFERRED

  • Product images
  • Multi-seat vendor accounts
  • Self-service category expansion
  • AI copilot UI
NEXT CASE STUDY · BUILT ON SAGUISales Analytics →