← Back to Our Work
Automation
Shopify Product Enrichment with External Data
Automated product enrichment for Shopify using external nutrition and allergen data.
The Challenge
The team needed accurate nutrition and allergen data inside Shopify to meet compliance and improve product detail pages. That data lived in a supplier database and had to be mapped to Shopify metafields reliably.
Manual updates were slow and error‑prone, and the store lacked a dependable way to keep product enrichment in sync as items changed.
Our Solution
We built a serverless enrichment pipeline that keeps Shopify products aligned with PSINFOOD data.
**Data Ingestion**
- Shopify product webhooks capture changes
- PSINFOOD data fetched by ArticleNumber (SKU match)
- Payloads mapped into Shopify metafields
**Sync Orchestration**
- SQS queues handle updates and retries
- DynamoDB tracks sync state and errors
- Scheduled sweeps re‑enqueue stale updates
**Operational Alerts**
- DLQ handling for unresolved items
- Slack notifications for failures