Case Study • Automation
Sierra E-Bike
Master Catalog Builder
How one repeatable tool replaced hours of copy-and-paste every time a new bike brand came in.
One workflow.
Every brand.
Client
Sierra E-Bike Superstore, Penn Valley CA
Industry
E-bike retail
Services
Automation, Shopify development
Built With
Python, Streamlit, Shopify
The Challenge
Every brand speaks a different spec language.
Each manufacturer sends product specs in its own format — different column names, units and layouts. Getting them into the Shopify store meant matching everything up by hand, product by product, before any of it could be used for filters, comparisons or SEO.


What I Built
A tool that does the matching for you.
A simple desktop app that takes the store’s product export plus a manufacturer’s spec sheet and outputs one master file with every product in the same structure, ready to go back into Shopify.
- Merges store exports with manufacturer specs
- Maps every brand into one consistent schema
- Repeatable: same steps for each new brand
- Feeds structured specs into Shopify for filters and SEO
The Results
What changed
4
brands processed through the same workflow so far
1
consistent spec format across the whole catalog
Hours → Minutes
EDIT: replace with the real time saved per brand




Brian took the time to understand our business and built systems that actually make sense for how we work. It’s already saving us time and helping us stay connected with our customers.
