Back to all case studies

Making Inventory Visible: How a Monitoring Layer Stabilised 80-Store Data Collection

Snapshot

Delivery model: Principal-led engagement (Stefan, Founder & Principal Consultant) Client: Nordlicht Retail (German fashion retailer) Trigger: Daily inventory and sales data from stores frequently failed to arrive at headquarters, disrupting stock planning and replenishment Engagement Type: Infrastructure rollout support + custom monitoring solution Timeline: Multi-phase (VPN deployment -> monitoring implementation -> failover capability)

The Challenge

The client daily operations depended on reliable overnight transmission of inventory levels and sales figures from each store point-of-sale (POS) system to the central warehouse. In practice, data frequently did not arrive.

The root causes were diverse and unpredictable:

• Fragile legacy POS software (visual object-based architecture, not developed by Vionix) that initiated transfers unreliably
• Inconsistent telecoms infrastructure: DSL outages, phone line failures, physical disconnections (cables unplugged or damaged)
• No visibility into failures: headquarters only discovered missing data the following morning, when planning decisions were already delayed

The result was a cascade of operational friction: unplanned stock shortages, inefficient replenishment scheduling, and mounting frustration across the business.

Constraints

• No ability to replace the POS software: The legacy system had to remain in place
• Decentralised failure modes: 80 geographically distributed points of failure with no unified monitoring
• Reactive posture: No tooling existed to detect or diagnose connectivity issues in real time

Approach

The client independently decided to deploy a nationwide corporate VPN with dedicated hardware via Deutsche Telekom to stabilise connectivity. Telekom required a competent technical partner on the client side, and Vionix was brought in to execute the rollout.

What Vionix Did:

1. Joint planning with Deutsche Telekom to map deployment logistics across 80 stores
2. Received training on IPsec VPN configuration and certificate-based authentication from Telekom
3. Deployed and configured VPN hardware and software at all store locations nationwide

Outcome of Phase 1: Stores were now addressable via a private network, but data transfer reliability did not fundamentally improve. The VPN solved network routing and security, but it could not compensate for software fragility or local infrastructure failures.

Recognising that connectivity alone was insufficient, Vionix implemented a proactive monitoring and control layer.

What Vionix Built:

1. Heartbeat monitoring via SNMP across all 80 stores to detect network disconnections in real time
2. Web-based monitoring dashboard that allowed headquarters to: View live connection status for all stores
3. Receive automatic alerts when a store dropped offline
4. Manually trigger data retrieval from any store on-demand (instead of waiting for the next scheduled sync)
5. Fallback connectivity via ISDN and analog dial-up: POS systems could automatically dial headquarters if DSL failed
6. Headquarters could establish PPP connections (ISDN or analog) to pull data from unreachable stores

Why This Worked: The solution shifted the client from reactive discovery (finding out about problems the next morning) to proactive resolution (detecting issues immediately and retrieving data manually if needed).

What Was Delivered

• 80-site VPN deployment (hardware, IPsec configuration, certificate management)
• Custom SNMP-based monitoring system with alerting
• Web application for real-time visibility and manual data retrieval
• Dual-mode fallback connectivity (ISDN + analog modem) for stores with DSL outages
• Operational handover with training for headquarters staff to diagnose and resolve connectivity issues independently

Results

• Elimination of morning surprises: Headquarters knew about connectivity issues the moment they occurred, not 12 hours later
• Faster recovery: Operators could contact stores immediately to diagnose causes (Telekom outage, physical disconnect, etc.) and escalate appropriately
• On-demand data retrieval: When DSL was restored after an outage, headquarters could pull data immediately instead of waiting for the next automated sync window
• More reliable inventory planning: With fewer data gaps, the business could plan stock replenishment and inter-store transfers with greater confidence
• Client satisfaction: The system "found its value" after initial scepticism about whether the VPN investment would pay off

Why It Worked

1. Accepted the constraints instead of fighting them The legacy POS system and unpredictable infrastructure were not going away. The monitoring layer worked around fragility rather than attempting expensive, slow replacement.

2. Gave the client self-service tools The manual retrieval capability meant headquarters was not helpless between sync windows. Operators could fix problems and recover data the same day.

3. Layered redundancy at the transport level ISDN and analog fallback ensured that even total DSL failure did not mean data loss, critical for a distributed retail operation with no on-site IT staff.

How Vionix Worked

• Partner coordination: Worked alongside Deutsche Telekom to execute the nationwide rollout, with Vionix handling on-site configuration and Telekom managing network infrastructure
• Incremental delivery: Deployed VPN first, then added monitoring and failover capabilities once the gap became clear
• Training and handover: Provided operational training so headquarters staff could independently monitor, diagnose, and trigger retrievals without escalating to Vionix