Plumbers App
Introducing the Automating Innovating AI Plumbers App
Now Powered by SQL Server Express & Full SQL Server
Includes Inventory Management, Supplier Ordering, and Plumbing-Specific Workflows
The smarter way to manage plumbing jobs, payroll, materials, inventory, and field operations—built for plumbing contractors, service teams, and production crews who want real power without unnecessary complexity. A streamlined, small-business-friendly Operational CRM that keeps your workflow tight, your data accurate, and your team moving.
WHAT’S NEW IN THIS RELEASE
Role‑Based Access Control (RBAC)
All AIAI applications now include a unified, secure RBAC system designed for multi‑admin environments and professional data governance.
Global Admin
Full system access. Can configure company‑wide settings, manage other admins, control data sources, and access all modules.
Local Admin
Operational access only. Can manage day‑to‑day tasks such as employees, jobs, materials, time entries, invoices, or inventory (depending on the app). Cannot modify global settings or create new companies.
Admin‑Only Registration
Only administrators can register accounts. No employee or installer self‑registration is allowed.
Dynamic UI Permissions
Each screen automatically adapts to the user’s role. Restricted modules are hidden or blocked with clear access messages.
Centralized Permission Enforcement
All role checks are handled through a unified RBAC engine to ensure consistent security across every module and workflow.
Multi‑Admin Support
Global Admin customers can add additional administrators using the Admin Add‑on. Each admin receives their own secure login and role‑based access.
This RBAC system ensures secure, scalable, and professional‑grade access control across all AIAI applications.
• Supports SQL Server Express (free) and Full SQL Server
• Faster, more reliable data handling
• Upgraded reporting engine
• Enhanced workflow tools for plumbing operations
• Cleaner UI and smoother navigation
• New Inventory Manager
• New Supplier Ordering System (create POs directly inside the app)
• Material usage tracking per job and per employee
• Consolidated into one unified .exe for all license tiers
No SQLite. No split versions.
Just one powerful SQL-driven plumbing management system.
PLUMBING-FOCUSED FEATURES
INVENTORY MANAGER (All Plans)
• Track fittings, pipe, valves, fixtures, consumables, and truck stock
• Real-time quantity updates
• Low-stock alerts
• Supplier SKU mapping
• Multi-location inventory support (shop, warehouse, trucks)
SUPPLIER ORDERING SYSTEM (Pro and Enterprise)
• Build purchase orders directly inside the app
• Auto-fill supplier SKUs and descriptions
• Track order status (Pending, Ordered, Received)
• Export or print POs for vendors
• Log all material receipts for accurate job costing
MATERIAL USAGE TRACKING
• Assign materials to jobs
• Track usage per employee
• Auto-deduct from inventory
• Improve job costing and reduce waste
AI Assistant
The AI Assistant is a built‑in intelligence engine that analyzes your real job data to help you run your business smarter and faster. It learns automatically from your employees’ performance, job history, and weekly output to deliver instant insights — no setup, no training, no cloud services required.
It can recommend the best employee for each job, estimate job difficulty, suggest the ideal crew size, and even generate a full work schedule with a single click. As you complete more jobs, the AI becomes more accurate, giving you a powerful, always‑improving assistant that works directly inside your CRM.
WHY PLUMBING TEAMS LOVE IT
• Secure Login
Salted + hashed credentials keep your data protected.
• Flexible Payroll Input
Pay by hours, piece rate, fixture installs, or materials.
• Automatic Pay Splits
Instantly divide earnings between up to 4 employees.
• Rich Job Logs
Track builder, jobsite, lot/model, plumbing phase, materials, and product details (Pro & Enterprise).
• Hands-Off Pay Cycles
Set your pay week and let the app generate reports automatically (Pro & Enterprise).
• Monthly Excel Reports
Organized by employee, grouped by pay week.
• Clean CSV Exports
Generate lightweight, portable data files with custom filenames.
• Update-Ready
Enjoy improvements and new features with every release.
• User-Centric Design
Simple interface, guided navigation, and helpful tooltips.
DATABASE OPTIONS (User Selects During Setup)
SQL SERVER EXPRESS (Free)
• Perfect for individuals and small plumbing teams
• Easy installation
• Multi-user capable
• No licensing cost
FULL SQL SERVER (Standard/Enterprise)
• Ideal for medium and large plumbing companies
• No size, memory, or CPU limits
• High-performance, enterprise-grade reliability
• Supports many concurrent users
• Advanced features like SQL Server Agent and HA options
SYSTEM REQUIREMENTS
• Windows 10 or newer
• Microsoft Excel (for Excel exports)
• ~900 MB free space
• SQL Server Express or SQL Server Standard/Enterprise
REPORT EXPORTS
All reports save automatically to:
Documents/AIAI_PM_App/Payroll_Excels/YYYY-MM/Payroll_YYYY-MM.xlsx
Each employee gets their own sheet.
Every job gets its own entry.
Everything stays organized.
BUILT FOR
Plumbing contractors
Service plumbers
Rough-in & trim-out crews
Project managers
Field supervisors
Any plumbing team tracking payroll, jobs, materials, and production data with clarity and control.
QUICK SETUP
Launch the app → Enter your license → Choose SQL Express or SQL Server → Start managing your workflow
SUPPORT & FEEDBACK
Email: automatinginnovatingai@outlook.com
PLANS & ADD-ONS (All Included in One App)
BASIC PLAN
Essential plumbing-production tools for individuals or small teams. Includes workflow tools, task tracking, and standard reporting.
PRO PLAN
Everything in Basic plus deeper reporting, enhanced productivity tools, and more automation. Ideal for growing plumbing companies.
ENTERPRISE PLAN
Unlocks the full system: advanced features, integrations, inventory, supplier ordering, and enterprise-grade controls. Required for organizations with multiple administrators.
ADMIN ADD-ON
Adds additional administrator accounts beyond the main admin included with Enterprise. Requires an active Basic, Pro, or Enterprise plan.
INSTALLER ADD-ON
Available only to Enterprise customers. Provides installer-building and deployment tools for internal or client distribution. Cannot function alone.
TAKE CONTROL. BE EFFICIENT.
Click Buy Now and transform your plumbing workflow with the AIAI Plumbers App.