Use case · Retail & e-commerce
Keeping product options, swatches and SKUs accurate across every channel
Microservices for product options, color swatches and SKUs, with bulk upload, approval workflow and Kafka sync from PIM, pricing and inventory systems.
Client details are kept confidential. This use case describes the problem and what we built.
The brief
The client is a home-furnishings retailer with a large catalog of configurable products sold online and in stores, supported by an established enterprise commerce storefront.
MultiGenesys engineers built and maintained the services behind its product-option and SKU data: the tools merchandisers use to manage options and swatches, and the integrations that keep that data in step with product, pricing and inventory systems.
The challenge
What needed solving
Highly configurable products
Furniture and home products come in many sizes, finishes, fabrics and colors. Each combination needs its own item number, options and swatch so customers order the right thing.
Manual, error-prone updates
Merchandising teams maintained option and SKU data in spreadsheets, which made bulk changes slow and mistakes hard to catch before they reached the storefront.
Many systems of record
Product information, pricing, inventory and content each came from a different system, and the storefront needed all of them to agree.
The solution
What we built
Option and SKU services
Spring Boot microservices with an OpenAPI-first contract manage item-number options, option types, size options, color-code swatches, product groups, regions, departments, SKU attributes and stocked SKUs.
Bulk upload and download
CSV and Excel bulk upload, download and bulk delete with sample templates, file metadata on Amazon S3 and processing through Amazon SQS.
Configurable approval workflow
A workflow engine with configurable transitions moves changes through review states, with user activity logs and reports.
Real-time sync service
A Kafka consumer service listens to product-information, pricing, inventory and content events and keeps MongoDB up to date, using ShedLock for safe scheduled jobs.
Catalog and colorization APIs
A catalog service exposes products, SKUs, swatches and restrictions to other channels, and a ClickHouse-backed service serves high-volume colorization data.
Kubernetes delivery
Each service ships as a Docker image to Kubernetes with per-environment manifests, built through Jenkins with JaCoCo coverage and Prometheus metrics.
The outcome
What changed
Bulk changes without spreadsheets
Merchandisers update options and SKUs through validated uploads and an approval flow instead of hand-edited files.
One consistent product picture
Event-driven sync keeps options, prices, stock and content aligned with the systems that own them.
Independent, deployable services
Separate services for options, sync, catalog and colorization can be scaled and released on their own.
Technology used
- Java 17
- Spring Boot
- OpenAPI
- MongoDB
- Mongock
- Apache Kafka
- ClickHouse
- Amazon S3
- Amazon SQS
- Resilience4j
- MapStruct
- Docker
- Kubernetes
- Jenkins
- Prometheus
Related use cases
Extending one SAP Commerce platform to serve many retail brands and countries
Custom SAP Commerce Cloud extensions for local payments, couriers, loyalty, vouchers, search and data integrations, deployed with Helm across environments.
Read the use caseProduct-level carbon accounting and CBAM reporting for industrial exporters
A multi-tenant SaaS that maps plants, processes and product routes, calculates emissions and product footprints, and generates CBAM workbooks and ESG reports.
Read the use caseManaging multi-site store build-outs: projects, RFIs, change orders and punch lists
A construction project management platform for brands rolling out stores, with Gantt schedules, RFIs, change orders, punch lists, approvals and fine-grained access.
Read the use caseHave a similar problem to solve?
Share a few lines about your project. A senior engineer — not a salesperson — replies within one business day.