365 Pub Stocktaking: Mobile Stocktaking Solution

What We Did

• iOS and Android native mobile application development
• Precision partial bottle counting system
• Cloud-based stock management platform
• Real-time reporting and export functionality
• Integrated Apple App Store and Google Play subscriptions
• API development and OAuth authentication
• Push notification system

About the Project

365 Pub Stocktaking represents a significant shift in how the hospitality industry approaches inventory management. Traditionally, pub owners and managers relied on professional stocktaking services, which whilst accurate, came with recurring costs that strained already tight margins. Our client envisioned a solution that would democratise professional stocktaking, putting the power directly into the hands of publicans.

Working closely with industry experts, we developed a cross-platform hybrid application built with Framework7 that brings professional-grade stocktaking capabilities to iOS and Android devices. The app needed to match the accuracy of human stocktakers whilst being intuitive enough for busy pub staff to use during operational hours. This required sophisticated algorithms for partial bottle measurement combined with a streamlined user interface that wouldn't slow down the stocktaking process.

The project was built using an MVP approach, allowing us to validate core functionality with real publicans before expanding features. This iterative development process ensured we were solving actual problems rather than building features in isolation.

The Challenge

Core Problems We Needed to Solve

• Accuracy at Scale: Developing a reliable system for measuring partial bottles that could compete with trained human stocktakers across thousands of SKUs
• Cost Sensitivity: Creating an affordable subscription model that would generate savings compared to traditional stocktaking services
• User Adoption: Designing an interface simple enough for time-pressed pub staff whilst maintaining professional stocktaking standards
• Real-Time Valuation: Building calculations that could instantly convert stock levels into accurate financial valuations
• Cross-Platform Consistency: Ensuring identical functionality and accuracy across both iOS and Android platforms
• Data Integrity: Implementing robust syncing and backup systems to prevent loss of critical inventory data

Our Solution

Comprehensive Stock Management

Starting with an MVP that focused on core stocktaking functionality, we built a complete stock control ecosystem that goes beyond simple counting. This MVP development approach allowed us to validate the partial bottle measurement system with real publicans before expanding to advanced features. The app tracks goods received, monitors stock movements, and maintains historical data for trend analysis. Publicans can conduct both full venue stocktakes and targeted counts of specific areas or product categories. The system automatically flags discrepancies and unusual variances, helping identify potential issues before they impact profitability.

Professional Reporting and Insights

The reporting module transforms raw inventory data into actionable business intelligence. Users can generate detailed reports showing stock values, variance analysis, and usage trends. All reports are exportable, allowing integration with existing accounting and management systems. The real-time nature of the reporting means publicans can make immediate decisions about ordering, pricing, and loss prevention.

Seamless Subscription Integration

We implemented native subscription management through both Apple App Store and Google Play billing systems. This provides users with a frictionless sign-up experience whilst giving the business reliable recurring revenue. The subscription architecture was designed to scale, supporting different tiers and promotional offerings as the product evolves.

Robust Technical Foundation

Built on Framework7 for consistent cross-platform performance, the app communicates with a secure PHP backend running on ExpressionEngine CMS. MySQL databases ensure reliable data storage, whilst a RESTful API architecture enables smooth communication between mobile clients and the server. OAuth authentication provides enterprise-grade security, and push notifications keep users informed of important updates and reminders.

The Results

Measurable Business Impact

• Cost Reduction: Publicans save hundreds of pounds monthly by replacing professional stocktaking contracts with affordable self-service subscriptions
• Accuracy Improvement: Partial bottle system achieves accuracy rates comparable to trained stocktakers, with some venues reporting improved consistency
• Time Savings: Streamlined interface reduces stocktake duration by approximately 30% compared to manual paper-based methods
• Better Decision Making: Real-time reporting enables proactive stock management and faster response to variances
• Operational Efficiency: Integrated goods-in tracking creates a complete inventory management workflow within a single application
• Scalability: Cloud-based architecture supports venues of all sizes, from single-site operators to managed pub groups

Technical Highlights

• Frontend Framework: Framework7 for cross-platform mobile development
• Backend: PHP with ExpressionEngine CMS
• Database: MySQL for reliable data storage and retrieval
• API Architecture: RESTful API design with OAuth 2.0 authentication
• Payment Processing: Native Apple and Google subscription integration
• Infrastructure: Cloud-hosted with automated backups and redundancy
• Notifications: Push notification system for reminders and updates
• Data Export: Multi-format report generation 

Ready to Build Your Business Application?

365 Pub Stocktaking demonstrates how mobile technology can transform traditional business processes. If you're looking to develop a business application that solves real problems for your industry, Tinderhouse can help. Our team specialises in building practical, user-focused solutions that deliver measurable results.

Contact us today to discuss your project.