A messy product catalog. Moved to Shopify, with a safety net.
How we moved a client's years-old product catalog out of spreadsheets and supplier documents and into a clean, automated Shopify store — with automatic photo sourcing, the business rules written into the software, and a one-click undo on every change.
A growing importer with a deep, supplier-driven catalog.
The business runs on a catalog built up over years — sourced from many suppliers, tracked in spreadsheets, with category rules that lived in the owner's head. They needed a real online store to grow, but the catalog couldn't move forward until it was clean enough for software to read.
Three problems to fix before Shopify could even help.
The catalog lived in spreadsheets and supplier docs
Years of product data were scattered across multiple spreadsheets, supplier PDFs, and people's memories. Every new shipment meant typing it all in again — with errors and duplicates piling up.
Most products had no photos
A large share of products had no image. Finding them by hand took hours per product, so the catalog never caught up to new inventory.
The rules lived in one person's head
Which items don't ship a certain way, which ones to never sell, which to remove — all of it lived as know-how in the owner's head, written down nowhere.
Research first. No guesses. Every risky change reversible.
Before touching code, we mapped the data, traced every edge case, and wrote down the business rules. Every change came with a snapshot, a preview, and a safety check. Nothing shipped on a guess. And we didn't reinvent what good tools already do — we built the parts you can't buy.
We made the catalog importable in the first place
Off-the-shelf import tools assume clean data. This catalog wasn't — years of conflicting spreadsheets, supplier docs, and duplicates. We reconciled it into one trustworthy master list, then built the safe sync on top.
Image sourcing you can actually trust
Apps that auto-find product photos grab whatever looks close. Ours only pulls from a trusted list of sources, keeps a record of where every image came from, and flags anything unclear for a human look.
We got the rules out of the owner's head
Automation tools can run rules — but only if someone writes them down first. The shipping rules, exceptions, and 'never sell this' lists existed nowhere. We extracted them, encoded them, and tested them.
One-click undo
Every risky change (a delete, a mass update) comes with an automatic restore. Any bulk change can be reversed with a single click.
A catalog that runs itself.
The whole catalog now runs from one source of truth, with zero manual re-typing after launch.
Photos are found automatically for most products — a weekly chore became an occasional review.
The shipping and 'don't sell' rules now live in the software, not one person's head — training a new hire dropped from days to hours.
Every catalog update is previewed and reversible, so changes ship with confidence.
Have a similar catalog, migration, or operational mess?
We look before we leap. No recommendations until we understand your data and your rules. A 30-minute call costs you nothing.