Project - Scalable Product Feed Infrastructure

Building asynchronous product import infrastructure at scale, implementing Bol.com's new Marketing API for affiliate partners, and adding full-text product search for locally stored feeds.

Client
DPG Media
Year
Service
Backend Development, Scalability

Overview

At DPG Media, I worked in a team responsible for the software that generates product widgets displayed on editorial websites such as Ouders van Nu and VT Wonen. These widgets aggregate products from multiple sources — Bol.com, Tweakers, Amazon, and product feeds from advertisers.

My work focused on simplifying the existing infrastructure by phasing out the legacy Offer Manager and Affiliate Redirect Service, and replacing them with modern, maintainable alternatives.

Key Contributions

Channable Product Adapter

DPG Media adopted the Channable platform to manage product feeds. I contributed significantly to implementing Channable as a new Product Adapter. Unlike the Bol.com or Amazon integrations — which fetch product data in real time via API — Channable products are stored locally.

One of the biggest challenges was handling the sheer volume of incoming product feeds. I designed a queue-based processing architecture, documented with detailed flowcharts, which was approved by the team and subsequently implemented collaboratively. This approach ensures large feeds are ingested reliably without overwhelming the system.

Because products are now stored locally, a search capability was needed. I built a product search feature using Postgres full-text search, enabling fast and relevant results across the locally stored catalog.

Bol.com Marketing API Migration

The existing Bol.com adapter suffered from persistent "Rate Limit Exceeded" errors that had caused production issues for a long time. I rebuilt the adapter from scratch using the new Bol.com Marketing API, which resolved the rate-limiting problems and provided smoother, more reliable product data synchronization.

Infrastructure Simplification

Contributed to phasing out two legacy services — the Offer Manager and the Affiliate Redirect Service — consolidating their responsibilities into the new architecture and reducing overall system complexity.

  • PHP 8.2 & Symfony
  • Docker
  • PostgreSQL
  • Postgres Full-Text Search
  • Channable
  • Queue-Based Architecture
Tech Stack
PHP 8.2
Full-Text Search
Postgres
Feed Processing
Queues
API Migration
Bol.com

More projects

OAuth Server & Two-Factor Authentication

Rewrote Solcon's OAuth server to align with modern specifications, added multi-provider two-factor authentication, implemented a new design, and upgraded the framework.

Read more

Reusable Authentication Infrastructure

Designing and building a Symfony bundle that unifies JWT authentication across multiple services, replacing scattered legacy code with configuration-driven context routing and role mapping.

Read more