IMPORT OPTIMIZATION

11x Faster Shopware Product Import: 530k SKUs Optimized

How we reduced a 33-hour product import process to under 3 hours, handling 530,000 SKUs with parent products containing over 20,000 variants each.

The Challenge

Our client, a mid-sized fine jewelry retailer, was operating a Shopware 6 store with over 530,000 SKUs managed in their internal ERP system. The catalog included complex parent products with more than 20,000 variants each. Their existing product import process from their ERP to Shopware was a critical bottleneck:

  • 33 hours to complete a full product catalog sync
  • Frequent timeout errors causing incomplete imports
  • Stale pricing and inventory data leading to customer complaints
  • Manual intervention required to restart failed imports

The slow sync cycle meant pricing and inventory were often 24-48 hours out of date, resulting in overselling, pricing errors, and damaged customer relationships.

Our Solution

We built a custom Shopware 6 plugin that integrates with their internal API, creating an optimized import system designed to handle massive product catalogs with complex variant structures:

Parallel Processing

Implemented multi-threaded batch processing to handle thousands of products simultaneously

Smart Caching

Delta sync mechanism to update only changed products, reducing API calls by 85%

Auto-Recovery

Built-in retry logic and error handling to automatically recover from API failures

Real-Time Monitoring

Admin dashboard showing sync status, errors, and performance metrics

Results

11x
Faster Import Speed
33h → 2.8h
85%
Fewer API Calls
via delta sync
100%
Reliability
Zero failed syncs
  • Product data now updated every 3 hours instead of daily
  • 65% reduction in customer complaints about pricing/inventory
  • Eliminated manual intervention—fully automated process

Technical Stack

Shopware 6.6 → 6.7 PHP 8.2 Symfony Redis Message Queue REST API

Facing Similar Import Challenges?

We specialize in building custom Shopware import solutions and ERP/PIM integrations that handle large catalogs efficiently. Let's discuss your project.

Talk to an Engineer

Case study by

Share: