---
title: "Walter Schork – Online Shop for Car Accessories with 200,000 Products"
description: "Case Study: Migration to Shopware 6, Sage b7 ERP integration via web service, automated SEO generation and performance optimization for a car accessories shop."
canonical_url: "https://kickbyte.de/en/references/schork"
last_updated: "2026-08-24T18:46:56.007Z"
---

# Walter Schork GmbH

## Online Shop for Car Accessories with 200,000 Products

Walter Schork is a retailer for car accessories – roof boxes, rear carriers, bike racks and transport solutions for
passenger vehicles. The company is part of the Carat Group, one of the largest purchasing cooperatives in the automotive
aftermarket.

We took over the shop as an existing Shopware 5 installation. The system was running, but the integrations were
outdated, performance was hitting its limits with 200,000 products and search engine visibility had room for
improvement. Our brief: modernize, stabilize and increase visibility.

---

![System Architecture: Shopware 6, Sage b7 Web Service, CSV Import and SEO Workflows](/references/schork/architecture_en.svg)

---

## 🔄 Migration from Shopware 5 to Shopware 6

As with many Shopware 5 projects, the switch to Shopware 6 was not simply a data migration but a rebuild of the
technical foundation. Shopware 5 was reaching its limits with the product volume and integration architecture. Learn
more about [system modernization and migration](/en/services/system-modernization-migration).

![Migration: From Shopware 5 with CSV import to Shopware 6 with web service and automated SEO](/references/schork/migration_en.svg)

The migration included transferring 200,000 products with all master data, categories, customer accounts and order
histories. At the same time, the entire integration architecture was rebuilt – moving away from file-based imports
toward real-time web service connections.

---

## 🔗 Sage b7 ERP Integration: From CSV to Web Service

The existing [ERP integration](/en/services/erp-integration) with Sage b7 was entirely based on CSV file exchange.
Product data, prices and stock levels were exported and imported at regular intervals as CSV files. This was
error-prone, slow and difficult to debug. Changes in Sage took minutes to hours to appear in the shop, depending on the
import cycle.

During the migration, the critical interfaces were moved to the Sage b7 web service:

**Prices** – Prices are now queried in real time via the web service instead of being periodically imported – without
delays from import cycles.

**Stock Levels** – Inventory is queried live instead of periodically imported. The shop displays the current state, not
the state from the last import.

**Orders** – Incoming orders are transferred directly to Sage. Order status and shipping information flow back to the
shop.

CSV-based synchronization was retained for product master data, where batch imports are more efficient than individual
queries for 200,000 products. The combination of real-time web service for business-critical data and batch import for
master data is a pragmatic approach that balances performance and data freshness.

---

## 📈 Automated SEO Generation for 200,000 Products

Manual SEO maintenance for 200,000 products is not economically viable. At the same time, many product pages lacked
meaningful titles, descriptions and meta information – a significant disadvantage for organic visibility.

We implemented workflows that automatically generate SEO-optimized information:

**Titles** – Product titles are composed rule-based from product attributes: manufacturer, product type, vehicle
compatibility, key features. No generic titles, but specific descriptions that work for both customers and search
engines.

**Descriptions** – Meta descriptions and product descriptions are automatically generated from existing product data.
The texts follow a consistent structure, contain relevant keywords and are optimized for search result pages.

**SEO URLs** – Human-readable URLs are automatically generated from product information, replacing cryptic IDs or
article numbers.

The SEO efforts were carried out in collaboration
with [Dennis Ommer](https://www.linkedin.com/in/dennisommer/), who is responsible for
strategic SEO and SEA management.

---

## ⚡ Performance Optimization of Product Interfaces

200,000 products with real-time price queries and stock checks are a challenge for
any [e-commerce](/en/services/ecommerce) platform. The product interfaces between Shopware and Sage were the bottleneck.

We fundamentally optimized the interfaces:

**Import Performance** – The master data import for 200,000 products was optimized to complete updates within an
acceptable time window without impacting live shop operations.

**Caching Strategy** – Intelligent caching for prices and stock levels drastically reduces the number of web service
calls without showing customers stale data.

**Listing Performance** – Category and search result pages with hundreds of products load performantly.

---

## 📊 Project at a Glance

<table>
<thead>
  <tr>
    <th>
      
    </th>
    
    <th>
      
    </th>
  </tr>
</thead>

<tbody>
  <tr>
    <td>
      <strong>
        Industry
      </strong>
    </td>
    
    <td>
      Car Accessories (Roof Boxes, Carriers, Transport)
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Company
      </strong>
    </td>
    
    <td>
      Part of Carat Group
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Platform
      </strong>
    </td>
    
    <td>
      Shopware 6 (migrated from Shopware 5)
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Products
      </strong>
    </td>
    
    <td>
      approx. 200,000
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        ERP
      </strong>
    </td>
    
    <td>
      Sage b7 (Web Service + CSV)
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        SEO/SEA
      </strong>
    </td>
    
    <td>
      Automated generation + strategic management
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Business Model
      </strong>
    </td>
    
    <td>
      B2C
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Engagement
      </strong>
    </td>
    
    <td>
      Long-term, ongoing
    </td>
  </tr>
  
  <tr>
    <td>
      <strong>
        Hosting
      </strong>
    </td>
    
    <td>
      Managed Hosting
    </td>
  </tr>
</tbody>
</table>

---

<nuxt-link to="/en/contact" className="not-prose,mx-auto,table,text-white,px-4,py-1.5,text-base,font-semibold,leading-7,shadow-sm,ring-1,duration-300,ease,rounded-lg,bg-primary,ring-primary,hover:bg-secondary,hover:ring-secondary">

👉 Talk to us about your project

</nuxt-link>