Context
Fender brands and regions depended on consistent product information across multiple Shopify storefronts, languages, and merchandising contexts, with source data managed outside Shopify in a PIM.
Product Data and Translation Sync Platform
Built an internal synchronization platform for product specifications, translations, metafields, and catalog data between a PIM system and multiple Shopify storefronts.
Completed as part of an in-house ecommerce engineering team and included here as a professional portfolio project.
This project turned recurring catalog maintenance into a more reliable self-service workflow for merchandising and ecommerce teams.
Problem
Manual updates across stores and languages created operational overhead, increased the risk of inconsistent product data, and limited how quickly merchandising teams could make controlled catalog changes without engineering support.
Solution
- Built AWS Lambda services to integrate with internal PIM APIs and Shopify Admin GraphQL APIs
- Created a transformation layer for product specifications, translations, metafields, and catalog data before writes reached Shopify
- Implemented catalog ingestion and sync workflows that supported multiple storefronts and localization requirements
- Built a Vite admin application using Shopify Polaris for store selection, SKU targeting, sync monitoring, and error reporting
- Supported partial-success handling so teams could see which products or locales completed and which needed follow-up
- Enabled self-service workflows for tech spec synchronization, translation synchronization, metafield management, and multi-store catalog updates
Results
- Reduced manual catalog maintenance across storefronts and regions
- Improved consistency for localized product data and Shopify metafields
- Enabled non-technical teams to execute targeted catalog updates through an internal admin tool
- Increased reliability of product data deployments by making sync status and errors visible
- Created a more maintainable integration layer between PIM data and Shopify storefront requirements
Stack
AWS LambdaNode.jsShopify Admin APIGraphQLVitePolarisPIM APIs