Modernizing Partner Billing for AureusDrive

Summary
To ensure that partner billing doesn't stand in the way of further growth, iosys set up a cloud solution for Swiss E-Bike pioneer AureusDrive. The automated approach to matching test ride and sales data uses an Azure Storage solution and Databricks, delivering solid data for calculating commissions per partner. Compared to the old solution, the new approach enables 90% time savings.
Introduction
With affordable, powerful, and stylish E-Bikes, AureusDrive aims to get commuters out of their cars and onto electric bicycles. Since 2017, the Lucerne-based startup has been developing, designing, configuring, and assembling solutions for environmentally friendly mobility. More than 4,000 AureusDrive E-Bikes are already on Swiss roads – saving over 450,000 kg of CO2. For distribution, the team of around 30 relies on a rapidly growing network of retail and service partners throughout Switzerland.
"Historically grown, established processes are often overtaken by growth, including our partner billing system. iosys showed us various solutions tailored to our operations – and quickly implemented the most promising one. For startups and SMEs, it's crucial to build on partners who truly understand the specifics of manufacturing SMEs when it comes to digitalization."
How to overcome growth bottlenecks?
For calculating partner commissions, AureusDrive long relied on a manual, Excel-based process. To keep up with the company's rapid growth, this approach posed several challenges:
- An increasing number of partners increases the time required for commission calculations
- Only long-term employees master the process
- The use of non-integrated systems promotes the formation of data silos
As a digitalization expert for manufacturing SMEs like AureusDrive, iosys set out to eliminate these growth barriers in late summer 2024. The goal was to automatically match partner test ride and sales data for commission calculations. To achieve this, iosys combined Cloud Computing and Data Engineering expertise.
"The old process worked quite well up to a certain number of partners. But the partner network has now grown so much that we needed an automated solution. The approach developed by iosys convinces through simplicity and efficiency – and has seamlessly integrated into our process landscape. All our sales and service partners receive their commissions calculated and paid out regularly and reliably."
Pairing test ride and sales data
Previously, the so-called "matching" of data from online-bookable test rides at partners and their sales data occurred in many error-prone manual steps. Using the Infrastructure as Code (IaC) tool Bicep, iosys set up a new cloud-based solution. Input data from WooCommerce (test rides) and the ERP (sales) come together in an Azure Storage solution. Processing and analysis take place in Databricks:
Data SourcesWooCommerceTest RidesERP SystemSales DataAzure Storage Blob ContainerCSV Collection PointDatabricks PlatformBronze LayerRaw DataSilver LayerFiltered/CleansedGold LayerAggregated CommissionsMedallion ArchitecturePartner Commission Calculations DashboardData flowWooCommerce Azure Storage Blob Container (CSV Files)ERP System Azure Storage Blob Container (CSV Files)Azure Storage Blob Container Bronze Layer (Ingest & Stage)Bronze Layer Silver Layer (ETL / Processing)Silver Layer Gold Layer (Aggregation / Enrichment)Gold Layer Partner Commission Calculations Dashboard (Serve Data)
The input data (CSV format) collected in the Azure Storage solution from the source systems WooCommerce and the ERP automatically flow into the Data Intelligence Platform Databricks. This is where the processing and analysis of target data takes place, i.e., the automated calculation of dealer commissions. iosys used the IaC tool Bicep to set up the new cloud-based solution.
By connecting the storage environment with Databricks, AureusDrive's partner billing experiences an automation boost. According to the so-called Medallion Architecture, the automatically fed data in Databricks passes through various stages (layers) – from integration through filtering and cleansing to aggregation. The result of this staged process is continuously updated data ready for further processing, for example for applications in Business Intelligence (BI) or generative AI (genAI). In AureusDrive's case, the monthly calculation of partner commissions based on matched test ride and sales data is the focus.
"The 90% time savings compared to the old solution translates into lower costs and higher productivity. Furthermore, by eliminating sources of error, we obtain more solid data that also benefits our partners. Our employees appreciate the simple handling. The whole team looks forward to the next projects with iosys to accompany our growth strategy with targeted digitalization projects."
Clear path for expanding the partner network
As before, AureusDrive's sales and service partners receive a monthly statement and payout of commissions generated through test rides. Compared to the previous manual approach, the new automated process excels in many ways:
- Monthly calculation of commissions per partner takes 90% less time
- The cloud-based, automated approach works independently of specifically trained personnel
- The modularly built, scalable solution delivers solid data suitable for further processing (BI, AI, etc.)
With the solution developed by iosys, partner billing no longer stands in the way of flexible and efficient expansion of the partner network. AureusDrive can thus use more financial and human resources for further growth. iosys stands ready to support the E-Bike pioneer in optimizing further processes. The foundation is laid.