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.
Automatic catalog-to-Shopify sync
A pipeline that reads the master list, formats it the way Shopify expects, and writes it in safely — with a snapshot, a dry-run preview, and a check that running it twice can't cause damage.
Automatic image finder
The system searches for product photos on its own, sticks to a trusted list of sources, keeps a record of what it found, and flags anything unclear for a quick human look. The catalog can fill in its own pictures.
Business rules written into the software
Shipping rules, exceptions, and 'never sell this' lists moved out of the owner's head and into the code — with tests. New team members can read the rules instead of memorizing 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.