← Back to Portfolio
Ecommerce / Internal Tools
Roswell Pro Audio Storefront & Fulfillment
Roswell Pro Audio15 internal tools · 7 sales channels
ShopifyJavaScriptHTML5 CanvasPHPMySQLShipStation APIREST APIs
Visit Site →
An ongoing solo engagement for a professional microphone manufacturer, in two halves — both in production, and connected to each other.
The storefront. A custom microphone builder that lets customers design their own mic and see it as they go: real-time Canvas image composition merges layers at full resolution as options change, with live pricing that handles add-ons, modifications, and matched pairs. It plugs straight into Shopify for cart and checkout, and encodes the whole configuration in the URL so a customer can share or come back to a build. 6 models, 50+ options, 10+ colors each. Plus an interactive video browser covering 31 episodes across 23 artists and 39 pedals.
The back office. When I started, staff were handwriting serial numbers at fulfillment and transcribing them into spreadsheets — at exactly the point where an error is most expensive, because a wrong serial breaks warranty lookup for the life of the microphone. I replaced that with a suite of 15 internal tools (~7,900 lines of PHP against a 20+ table MySQL schema) that pulls the live order from ShipStation across 7 sales channels — Shopify, Amazon, eBay, Reverb, and more — identifies which line items are actually mics, prompts for serials, and writes a full lifecycle record.
Most of the real work was the long tail of messy order data that separates a demo from a tool people use every day: Reverb never returns a customer email and the database required one; merged orders delete the number you searched for; cancelled shipping labels zero out a line's quantity so nothing renders; matched pairs arrive as two line items for the same two physical mics. Each one now has a visible, reversible prompt rather than a silent guess — the governing rule is suggest, never silently expand.
Non-developers can now manage the entire Custom Shop catalog themselves and publish to the live storefront, behind a field-level diff that shows exactly what will change before anything overwrites production.
The storefront. A custom microphone builder that lets customers design their own mic and see it as they go: real-time Canvas image composition merges layers at full resolution as options change, with live pricing that handles add-ons, modifications, and matched pairs. It plugs straight into Shopify for cart and checkout, and encodes the whole configuration in the URL so a customer can share or come back to a build. 6 models, 50+ options, 10+ colors each. Plus an interactive video browser covering 31 episodes across 23 artists and 39 pedals.
The back office. When I started, staff were handwriting serial numbers at fulfillment and transcribing them into spreadsheets — at exactly the point where an error is most expensive, because a wrong serial breaks warranty lookup for the life of the microphone. I replaced that with a suite of 15 internal tools (~7,900 lines of PHP against a 20+ table MySQL schema) that pulls the live order from ShipStation across 7 sales channels — Shopify, Amazon, eBay, Reverb, and more — identifies which line items are actually mics, prompts for serials, and writes a full lifecycle record.
Most of the real work was the long tail of messy order data that separates a demo from a tool people use every day: Reverb never returns a customer email and the database required one; merged orders delete the number you searched for; cancelled shipping labels zero out a line's quantity so nothing renders; matched pairs arrive as two line items for the same two physical mics. Each one now has a visible, reversible prompt rather than a silent guess — the governing rule is suggest, never silently expand.
Non-developers can now manage the entire Custom Shop catalog themselves and publish to the live storefront, behind a field-level diff that shows exactly what will change before anything overwrites production.
Screenshots
