The Challenge

A German e-commerce client with over 530,000 SKUs was trapped in an operational nightmare. Their product import process took 33 hours to complete, creating a cascading series of problems that threatened their business growth.

Critical Pain Points

  • Catalog updates could only run once a week due to duration
  • Out-of-date pricing and inventory information
  • Customer complaints about stock availability errors
  • Lost sales due to inability to quickly update product offerings

The client needed a solution that could handle their massive product catalog while enabling near-real-time synchronization with their ERP system via the Rubin API. The existing approach was fundamentally flawed and couldn't scale.

The Solution

We delivered a complete import system overhaul that transforms how your catalog stays synchronized with your ERP, turning a business-limiting bottleneck into a competitive advantage.

From Weekly to Daily Catalog Updates

Your catalog now syncs multiple times per day instead of once per week. Price changes, stock updates, and new products reach customers within hours, not days.

Handle Half a Million Products Without Breaking a Sweat

Whether you have 50,000 or 500,000 SKUs, the system scales seamlessly. No more worrying about import jobs crashing or timing out as your catalog grows.

Run Imports Without Disrupting Your Store

Background processing means your webshop stays fast for customers while imports run. No more scheduling updates at 2 AM or dealing with slowdowns during business hours.

Only Sync What Changed

Smart change detection means only modified products get updated, not your entire catalog every time. This dramatically reduces server load and keeps your infrastructure costs predictable.

Results & Business Impact

Import Speed Increased 11x

Product synchronization time plummeted from 33 hours down to just 2.8 hours, transforming weekly catalog updates into multiple daily refreshes.

Dramatic Customer Satisfaction Improvement

Support tickets related to pricing errors and stock availability decreased by over 60%, significantly improving customer trust and retention.

Massive Infrastructure Cost Savings

Optimized delta synchronization reduced unnecessary API calls by 85%, cutting server infrastructure costs by approximately 40% while improving system stability.

Operational Flexibility

Business can now respond to market changes and promotional opportunities in hours, not weeks.

Technologies Used

Shopware 6 PHP 8 Symfony REST API MySQL Redis Messenger Doctrine

Project Details

Industry
E-commerce / Retail
Location
Germany
Project Type
Performance Optimization
Duration
6 weeks

Facing Similar Challenges?

Struggling with slow imports, complex integrations, or performance issues? Our team specializes in solving exactly these kinds of technical challenges.

Get Expert Help from Elixent Digital

Share this case study

Found this interesting? Share it with your network