The Customer
Hansesgården is a family-run e-commerce business in Hälsingland, Sweden, selling home textiles and gifts. With over 15 years of operations on the Swedish e-commerce platform Abicart, they had accumulated a vast database of sales history, customer information, and product data — but lacked the tools to analyze it.
All decisions about purchasing, product range, and marketing were based on gut feeling and manual review of individual reports. The data existed — but was locked away in export files, hard-to-access spreadsheets, and the platform's limited reporting features.
The Challenge
Hansesgården faced several concrete problems typical of small and medium-sized e-commerce businesses:
- ●No overview of which products were actually profitable — 15 years of data existed but was unstructured
- ●Inventory value tied up in non-selling products — dead stock grew without anyone noticing
- ●Purchasing decisions were based on intuition instead of seasonal patterns and historical data
- ●No customer segmentation — all customers were treated equally regardless of purchase history and value
- ●Actual campaign ROI was unknown — marketing budget was allocated without follow-up
The Solution: Abicart Dashboard
CargoBeacon built a custom analytics solution — the Abicart Dashboard — that connects directly to the Abicart e-commerce platform API. The dashboard fetches, transforms, and visualizes all sales, inventory, and customer data in real time.
The solution is open source and available on GitHub, making it reusable for other Abicart merchants facing the same challenges.
Sales Analytics
Revenue trends spanning 15 years with drill-down by product, category, and time period. Automatic comparison against previous year, quarter, and month.
- • Seasonal patterns and trend lines
- • Top products and underperformers
- • Geographic sales distribution
Inventory Intelligence
Stock levels analyzed against sales velocity. Automatic reorder point recommendations and dead stock identification.
- • Seasonal demand forecasting
- • Dead stock identification and liquidation suggestions
- • Capital tie-up analysis
Customer Insights
In-depth analysis of customer behavior — from repeat purchase patterns and lifetime value to acquisition channels and regional distribution.
- • Customer segmentation (RFM analysis)
- • Regional heatmaps
- • Repeat purchase frequency and churn risk
Decision Support
Visual dashboards replacing gut feeling with data-driven evidence for purchasing, marketing, and inventory management.
- • Campaign ROI and impact measurement
- • Purchase recommendations based on history
- • Product range optimization
Technical Implementation
The Abicart Dashboard is built as a standalone web application that communicates with the Abicart REST API. Data is synchronized automatically and transformed into analysis-ready datasets.
Data Source
Abicart REST API
Data History
15+ years
License
Open Source
Results
Hansesgården went from gut feeling to data-driven decisions in just a few weeks. The dashboard immediately provided insights that changed how the business was managed.
~20%
Dead stock identified
15+
Years of data analyzed
Q1
ROI positive within first quarter
100%
Data-driven decision basis
Concrete Changes
- ✓Approximately 20% of the product range was identified as dead stock and could be liquidated, freeing up tied-up capital
- ✓Seasonal purchasing was optimized based on 15 years of pattern data — the right products were ordered at the right time
- ✓The marketing budget was reallocated to the products that actually drove revenue
- ✓The investment paid for itself within the first quarter — ROI positive from the start
Beyond IoT
The Hansesgården project demonstrates CargoBeacon's ability to deliver value beyond IoT sensors and hardware. The same expertise in data analytics, visualization, and system integration that powers our IoT solutions can be applied to pure business analytics and decision support.
For small and medium businesses sitting on years of unanalyzed data, a custom dashboard solution can be as transformative as new technology. Sometimes digital transformation isn't about introducing something new — it's about finally understanding what you already have.
Funding
The project was funded through Propell/T-ReX (Transformation Region X) — an EU-funded innovation program via the European Regional Development Fund, administered by Region Gävleborg through IUC Gävleborg and RISE. The program supports digitalization and innovation in small and medium-sized enterprises in Gävleborg County.
Read the full case study on Propell.se →Open Source
The Abicart Dashboard solution is open source and available on GitHub. Other Abicart merchants or developers can use the code as a starting point for their own analytics solutions.
cargobeacon/Abicart_Dashboard