Skip to content
Rose City Commerce

Product Data and Translation Sync Platform

Led development of a product-ingestion platform that synchronized enterprise catalog data across Fender's Shopify Plus storefronts.

Product Data and Translation Sync Platform screenshot
Completed as part of an in-house ecommerce engineering team and included here as a professional portfolio project.
Gave ecommerce teams a reliable way to manage product data, translations, and metafields without routine engineering support.

Context

Fender operated multi-brand, multi-region storefronts on Shopify Plus. Product specifications, translations, metafields, and catalog data originated in enterprise systems and needed to reach the correct stores and locales.

Ecommerce and merchandising teams needed to run targeted updates and understand their status without relying on an engineer for routine changes.

Problem

Manual updates across storefronts and locales were slow and prone to inconsistency. Specifications, localized content, and metafields also had to be transformed into Shopify's expected data shapes.

Batch operations could succeed for some products or locales and fail for others. Teams needed enough detail to resolve those failures without treating every run as all-or-nothing.

Architecture

Operator-Facing Admin Application

Built an internal React application with Vite and Shopify Polaris that turned the integration into a controlled workflow for ecommerce and merchandising teams.

  • Store and locale selection
  • Targeted SKU operations
  • Technical-spec and translation synchronization
  • Metafield and catalog update workflows
  • Status, error, and partial-success visibility

Node.js and AWS Lambda Services

Built microservice-style Node.js endpoints on AWS Lambda to separate admin actions from ingestion and Shopify writes. The services read from internal PIM APIs and sent validated, transformed data through Shopify Admin GraphQL.

Validation and Transformation

Created a boundary between upstream product data and Shopify-specific requirements. Specifications, translations, metafields, and catalog attributes were normalized before any storefront write.

Separating enterprise data from regional merchandising requirements made the integration easier to extend across stores.

Operational Reliability

Validation, monitoring, and error reporting were built into the workflow. Partial-success handling identified which products or locales completed and which required follow-up.

Broader Shopify Plus Platform Responsibilities

This application sat within broader Shopify Plus work at Fender that included checkout and customer account extensions, Shopify Flow, Admin GraphQL, and enterprise integrations. Those capabilities were platform responsibilities, not all features of the synchronization application.

Leadership and Collaboration

Technical Ownership

I led the product-ingestion platform and partnered with ecommerce, merchandising, and IT to align the architecture with operating needs.

We established reusable patterns for ingestion, transformation, Shopify writes, and status reporting instead of building one-off scripts for each storefront.

Results

Operational and Engineering Impact

  • Reduced manual catalog maintenance across storefronts and regions
  • Enabled ecommerce teams to run targeted updates without routine engineering support
  • Improved consistency for localized product data and Shopify metafields
  • Made product, store, and locale status and errors visible
  • Created reusable multi-store workflows and a maintainable Shopify Plus integration

Technical Highlights

  • Shopify Plus multi-store architecture
  • React, Vite, and Shopify Polaris admin interface
  • Node.js services on AWS Lambda
  • PIM ingestion and data transformation
  • Shopify Admin GraphQL writes
  • Validation and partial-success handling
  • Operator-facing status and error reporting
  • Cross-functional technical leadership

Stack

Shopify PlusShopify Admin GraphQLAWS LambdaNode.jsReactViteShopify PolarisPIM APIs
Product Data and Translation Sync Platform | Rose City Commerce