Shopify app · Catalog automation
Every variant gets a clean, collision-free SKU and barcode — automatically.
- Shopify
- Automation
- Catalog
- 0
- duplicates — guaranteed by a unique registry
- 1
- GraphQL bulk op backfills a whole catalog
- 100%
- of new variants stamped via webhooks
The problem
Manual SKU and barcode entry is slow, inconsistent, and error-prone at catalog scale — and one duplicate quietly breaks counts, scanners, and reconciliation downstream. Catalogs accumulate blank identifier fields faster than anyone cleans them up.
The approach
Autopilot watches the catalog and fills the gaps: new and updated variants get identifiers the moment they appear, the existing catalog gets backfilled in one resumable pass, and a registry makes duplicates structurally impossible rather than merely unlikely.
What it does
- Fills missing SKUs and barcodes in real time on products/create and products/update webhooks.
- Whole-catalog backfill through a single GraphQL bulk operation, resumable per variant.
- Guaranteed no duplicates: a DB-unique identifier registry, atomic per-shop counters, store seeding, and pre-write verification.
- A durable per-shop work queue with HMAC-verified acks, single-writer locking, and retry-with-backoff recovery.
Stack & links
- TypeScript
- React Router 7
- Shopify GraphQL
- Prisma
- Polaris
- Docker
Want a system like this for your business?
No discovery-call theater. Send us the problem, and we'll send back how we'd attack it.