Context
- Established retailer of tools and industrial products with portfolio of 15+ brands and 20,000+ SKU
- Multi-channel operations including online e-shop (stahlmann.sk), network of physical stores, and B2B distribution
- Expansion to Czech market (stahlmanntool.cz) during engagement
- Used ERP Pohoda with good basic processes in place
- Contacted Onetribe based on references seeking higher-level analytical solution
- 3-year partnership duration
Challenge
- Operations had outgrown basic reporting capabilities despite quality ERP system
- Manual calculations and consolidations required for deeper analysis
- Fragmented view across multiple sales channels and geographic areas
- Expanding to Czech market and growing portfolio complexity required more sophisticated analytical approach
- Management recognized potential for more systematic approach to trend analysis and profitability across 15+ brands and 20,000+ SKU
- Need for unified view across online, retail, and B2B channels
What Was Implemented
- Direct integration with ERP Pohoda with automated data extraction
- Preservation of all existing processes and workflows with no operational disruption
- Real-time data access across all channels without migration
- Proprietary Sales Mix Analytics module providing detailed analysis at product, category, and brand levels
- Multi-channel view combining online, retail, and B2B in single consolidated view
- Trend tracking with visualization across time periods
- Detailed drill-down capability from total overview to individual SKU level
- Scalable solution handling 20,000+ SKU and 15+ brands
- Advanced profitability analysis automating previously manual margin calculations
- Automatic product margin calculation directly from inventory movements
- Real-time profitability tracking at product, category, and channel levels
- High-margin opportunity identification within large portfolio
- SEO performance integration with automated daily performance data
- Sales analytics linked to website performance for data-driven product placement decisions
- Continuous conversion improvement based on analytical insights
Outcomes
- 25% growth in revenue and gross profit over 3-year period with stable margins maintained
- Elimination of manual margin calculations completely
- Single unified analytics across 15+ brands, 20,000+ SKU, and all sales channels
- Real-time profitability view across entire portfolio replacing fragmented analysis
- Automated trend tracking eliminating manual work
- Data-driven tools supporting expansion and portfolio optimization
- Integrated SEO performance management
- Product category with low volume but high margin and growing trend identified through analytics
- Strategic increase in SEO focus and store visibility for identified category
- 40% growth achieved in targeted category while maintaining premium pricing and improving overall product mix
- Infrastructure scaled seamlessly to Czech market providing same tools, insights, and unified view across geographies