Photographer shooting product photos on a studio table
All Case Studies

// Furniture & Home

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.

Start a Similar ProjectVisit cityfurniture.com

Automated

Data Synchronization

Real-time

Product Updates

Custom

Checkout Experience

Headless

Architecture Flexibility

// The problem · 4 pain points

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.

01

Data locked in legacy SQL

Product data was locked in legacy IBM SQL Server databases with complex schemas and relationships

02

No automated SKU sync

No automated way to sync thousands of furniture SKUs with variations, pricing, and inventory to the e-commerce platform

03

No central product hub

Akeneo PIM needed to serve as the central hub for product data normalization and enrichment

04

Standard checkout didn't fit

Required a headless e-commerce solution with custom checkout experience rather than standard Shopify checkout

// How it works

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.

Data Pipeline

Legacy product data extracted, transformed, and centralized

  1. 01

    IBM SQL Server

    Legacy catalog with complex schemas and relationships

  2. 02

    AWS Batch Jobs

    Scheduled jobs extract SKUs, variations, pricing, and inventory

  3. 03

    Data Transformation

    Furniture data normalized into a clean schema

  4. 04

    Akeneo PIM

    Single source of truth for enriched product data

E-commerce Platform

Headless storefront with a checkout built for furniture

  1. 01

    Next.js Storefront

    Headless frontend consuming product data from the PIM

  2. 02

    Product Catalog

    Thousands of SKUs with variations and live pricing

  3. 03

    Custom Checkout

    Delivery options, financing, and multi-item configurations

  4. 04

    Order Processing

    Orders flow through without Shopify constraints

Infrastructure

AWS-hosted, PIM-connected, always in sync

  1. 01

    AWS Infrastructure

    Production pipeline and hosting on AWS

  2. 02

    PIM API Integration

    Storefront and batch jobs talk to Akeneo over its API

  3. 03

    Real-time Sync

    Product updates reach the storefront as they land

  4. 04

    Headless Architecture

    Frontend and commerce engine decoupled for flexibility

// What we built

Our Solution

1

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.

2

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.

3

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.

4

Custom Checkout Experience

Developed a custom checkout experience tailored to furniture purchasing workflows, handling complex delivery options, financing, and multi-item configurations.

// Technologies used

Built With

Next.js
React
Akeneo PIM
AWS Batch
IBM SQL Server
Node.js
TypeScript

// Boca Raton, FL → nationwide

Ready for Similar Results?

Let's discuss how we can help bring your project to life.

Start Your ProjectMore Case Studies