Skip to content
createwithlogic

US fine-jewelry retailer · 23 years in business

E-commerce operations suite

delivered · multiple systems in daily use

A fine-jewelry retailer with 23 years of history and a founder on a mission to automate his operations. We built a series of systems that replaced hours of skilled manual checking with pipelines that don’t get tired.

100%
of casting invoices checked, not sampled
live
spot-price verification on every metal rate
dozens
of correct variants from one style row

The starting point

  • Scanned supplier casting invoices checked by hand: order numbers, weights, and rates typed into sheets, with real money lost to unnoticed weight discrepancies.
  • Product listing was combinatorial pain: one ring design means dozens of Shopify variants across metals, stones, and sizes, each with its own weight, cost, and margin math.
  • Internal processes (returns, shipping, casting) lived in tribal knowledge.
architecture
Inbound
  • Scanned invoices
    supplier casting PDFs
  • Live metal prices
    gold/platinum spot APIs
Pipeline
  • OCR
    Google Cloud Vision
  • Parse & match
    orders · weights · rates
  • Discrepancy gate
    flags > 0.03 DWT
Out
  • Sheets updated
    two systems, automatically
  • Email report
    human decides only on flags
  • Shopify variants
    rule-book CSV generator
A pipeline that reads scanned paper better than a tired human, and checks the market price of gold while it’s at it.

What got built

01

Invoice OCR pipeline

Scanned PDFs go through Google Cloud Vision OCR, get parsed into orders/weights/rates, flag any weight discrepancy over 0.03 DWT, cross-check billed metal rates against live gold/platinum spot-price APIs, update the company’s sheets, and email a report. A human decision only happens where a discrepancy is found.

02

Internal platform of mini-apps

One login, modular apps gated per user: casting received, returns processing, items shipped, sales-tax handling. Roughly 25k lines of code and 14 service modules, on the same Supabase-backed architecture as everything else I build.

03

CSV→Shopify variant generator

Rule books for natural, lab-grown, and no-stone lines expand a single style row into complete Shopify parent/child CSVs: carat weights, gram weights per metal, cost, labor, markup, and margin computed per variant.

Stack

  • React + TypeScript
  • Supabase
  • Google Cloud Vision OCR
  • Metals spot-price APIs
  • Shopify + Magento
  • Vercel

Got a system like this waiting to exist?

Start with the free teardown: I’ll map your three biggest automation leaks and what they cost you monthly. In your inbox within 72 hours.

Get your free systems teardown