Article Database Synchronisation

Stolle Industries GmbH maintained two separate article (product) databases–one for accounting and one for technicians in the field.

Critical issues:

• Product pricing discrepancies between accounting and field systems
• Inconsistent product descriptions causing confusion
• Manual update processes prone to human error
• Inefficiencies in order processing and service delivery
• Data inconsistency impacting customer satisfaction

The company needed a reliable solution to synchronise the databases and ensure data consistency across both platforms whilst replacing manual update processes.

We developed an automated synchronisation process that regularly compared and updated records between the two article databases.

Key features implemented:

• Automated Synchronisation: Regular scheduled updates between databases to maintain consistency
• Data Validation: Built-in checks to identify and flag discrepancies before they propagate
• Conflict Resolution: Intelligent algorithms to resolve data conflicts based on business rules
• Monitoring Interface: User-friendly dashboard for tracking synchronisation status in real-time
• Manual Override: Capability for staff to manage exceptions and conflicts when needed

We provided comprehensive training to Stolle Industries GmbH staff on using the new system effectively, ensuring smooth adoption and ongoing maintenance.

The synchronisation workflow created a more reliable product data foundation across accounting and field operations.

Business impact:

• Reduced product data discrepancies between operational systems
• Improved confidence in pricing and product descriptions used by technicians
• Replaced manual update work with a repeatable automated process
• Gave staff clearer visibility into synchronisation status and exceptions