A complex supplier catalog. Migrated to Shopify with full rollback safety.
How we moved a Texas-based ethnic grocery importer's multi-year supplier catalog from spreadsheets and supplier documents to a clean, automated Shopify operation — with built-in image sourcing, ship/no-ship rules, and full rollback safety.
A Texas-based ethnic grocery importer with a deep, supplier-driven catalog.
The business runs on a catalog that's evolved over years — sourced from international suppliers, managed across spreadsheets, with category-specific rules that lived in the owner's head. The team needed a real e-commerce operation to grow, but the existing catalog couldn't move forward without first becoming machine-readable.
Three structural problems that had to be solved before Shopify could be useful.
Catalog scattered across spreadsheets and supplier docs
Years of product data lived across multiple Google Sheets, supplier PDFs, and tribal knowledge. Every new shipment meant manual re-entry, with errors and duplicates compounding.
Image gap for most products
A large share of SKUs had no product images. Sourcing them by hand meant hours per product — the catalog never caught up to new imports.
Ship-rules and exemptions encoded in people, not systems
Liquids and frozen items were intentionally blank-weight. Certain categories were never to be sold. Red-highlighted rows meant 'remove from catalog.' All of this lived as institutional memory — nowhere in software.
Deep research first. No guesses. Every destructive op reversible.
Before touching code, we mapped the data, traced every edge case, and codified the business rules. Every mutation was paired with a snapshot, a dry-run, and an idempotency check. Nothing shipped on a guess.
Automated catalog-to-Shopify sync
Read-only pipeline from the master sheet, normalized into Shopify's product schema, with safe-mutation guardrails (snapshot, dry-run, idempotency) on every write.
Image sourcing system
Programmatic image search via Google Programmable Search, with a domain whitelist, manifest tracking, and human review for ambiguous results. The catalog can image itself.
Encoded business rules
Ship/no-ship logic, weight exemptions, and 'don't sell' categories moved from the owner's head into versioned scripts with test coverage. New team members can read the rules, not learn them.
Rollback and restore
Every destructive operation (delete, mass update) is paired with an automated restore. Any batch operation can be reverted with one workflow click.
A catalog that runs itself.
The full supplier catalog runs on a single source of truth with zero manual data entry post-launch.
Image sourcing automated for the majority of unique products — manual sourcing hours dropped from a weekly chore to an occasional review.
Ship/no-ship rules and category exemptions now live in code, not in any one person's head — onboarding new ops staff dropped from days to hours.
Catalog updates ship with confidence: every change is dry-run reviewed and reversible.
Have a similar catalog, migration, or operational mess?
We diagnose first. No platform recommendations until we understand your data and your business rules. A 30-minute call costs you nothing.