City Furniture
Data Pipeline & Headless E-commerce Integration
Built the data synchronization pipeline for City Furniture's e-commerce platform — connecting IBM SQL databases through AWS batch jobs to Akeneo PIM, feeding a headless Next.js storefront with custom checkout experience.
Automated
Data Synchronization
Real-time
Product Updates
Custom
Checkout Experience
Headless
Architecture Flexibility
The Challenge
City Furniture needed a robust data pipeline to synchronize product information from their legacy IBM SQL databases to a modern e-commerce platform through Akeneo PIM.
Product data was locked in legacy IBM SQL Server databases with complex schemas and relationships
No automated way to sync thousands of furniture SKUs with variations, pricing, and inventory to the e-commerce platform
Akeneo PIM needed to serve as the central hub for product data normalization and enrichment
Required a headless e-commerce solution with custom checkout experience rather than standard Shopify checkout
How It Works
Data flows from IBM SQL databases through AWS batch jobs to Akeneo PIM, then feeds the headless Next.js e-commerce platform.
IBM SQL Server
AWS Batch Jobs
Data Transformation
Akeneo PIM
IBM SQL Server
AWS Batch Jobs
Data Transformation
Akeneo PIM
Next.js Storefront
Product Catalog
Custom Checkout
Order Processing
Next.js Storefront
Product Catalog
Custom Checkout
Order Processing
AWS Infrastructure
PIM API Integration
Real-time Sync
Headless Architecture
AWS Infrastructure
PIM API Integration
Real-time Sync
Headless Architecture
Our Solution
IBM SQL to AWS Batch Pipeline
Built AWS batch jobs to extract product data from legacy IBM SQL Server databases, transforming complex furniture catalog information including SKUs, variations, pricing, and inventory levels.
Akeneo PIM Integration
Implemented Akeneo PIM as the central product information hub, receiving normalized data from AWS batch jobs and serving as the single source of truth for all product information.
Headless Next.js E-commerce
Built a headless Next.js storefront consuming product data from Akeneo PIM, providing full control over the customer experience and checkout flow without Shopify constraints.
Custom Checkout Experience
Developed a custom checkout experience tailored to furniture purchasing workflows, handling complex delivery options, financing, and multi-item configurations.
Technologies Used
Ready for Similar Results?
Let's discuss how we can help bring your project to life.