top of page
OKR0RO1.png

Project Overview

Role: UI/UX Designer and Developer

Built using Shopify Liquid and Javascript

Stonebridge is wholesale only, and customers kept calling/emailing or two things before ordering, checking stock and lot photos. This created constant customer service interruptions, long response cycles, and easy mistakes. I designed and built a signed in "Inventory by Lot" section on the product page so approved accounts could self serve availability and variation.

Problem

Before this feature, customers couldn't confidently buy without a human in the loop. Each request took 20-30 minutes because customer service had to look up inventory by lot, find the right lot photos, send them manually, and possibly resend when emails got buried or lost.

​

Even though the business already had the data, it wasn't accessible at the moment of purchase.

Goals

Goals

  1. Make availability and lot variation self serve on the PDP

  2. Reduce back and forth without adding confusion

  3. Keep it aligned with wholesale rules (login required)

  4. Set correct expectations (inventory changes and lot variation)

Solution

  1. Inventory by Lot

    1. Displays a simple table with Lot#, sheets available, and sq.ft. available​

  2. View Lot Photos

    1. Lot photos open in a modal gallery so customers can quickly evaluate variation​

Build & Data Workflow

  • Source of truth: Quickbooks

  • Constraint: Shopify didn't have a lot level inventory natively in the way the business tracked it

  • Process: Daily manual export from QuickBooks and import into Shopify

  • Liquid renders the section. JavaScript powers the gallery

​

This kept the customer experience fast and clear while fitting real operational reality.

Results

4 weeks before vs 4 weeks after:

​

  • Requests dropped: 75 requests a week to 5-10 requests a week

  • Estimated time saved: 22-35 hours/week

  • Less manual photo sending means fewer "lost info" errors

  • Customers could answer the key questions instantly, improving trust and reducing friction

Conclusion

Inventory by Lot replaced a manual, interruption heavy process with a self serve PDP experience for approved wholesale customers. By showing lot level availability and providing a quick gallery for variation photos, customers could confirm what they needed without calling or emailing. This cut down requests from about 15/day to 1-2/day and saving hours of customer service time, while reducing mistakes from manual photo sending. I owned the project, designing and coding it in Shopify (Liquid and JavaScript) and supporting the operational constraint with daily QuickBooks to Shopify updates.

bottom of page