# App Store & Integrationen Documentation

**Last Updated:** 2026-01-09

**Note:** This documentation has been enhanced with workflows from comprehensive helpdesk analysis. See `docs/content/helpdesk/MASTER_ANALYSIS_SUMMARY.md` for details.

## Basic Information

- **Feature Name:** App Store & Integrationen (Mobile Apps)
- **Slug:** mobile-apps
- **Status:** Available
- **Related Product Pages:**
  - `v2/pages/product_appstore.php`
  - Product page: https://www.ordio.com/appstore

## Overview

Der Ordio App Store ermöglicht dir deinen Workspace mit Funktionen und Schnittstellen zu Partnern zu erweitern. Verbinde Ordio mit Kassenlösungen, Exporten, Reservierungen und mehr. Alle Schnittstellen im Überblick für maximale Effizienz und flexible Workflows im Team. Mit 50+ Integrationen sparst du 15 Stunden/Woche bei der Datenübertragung.

## Use Cases

### POS System Integration

**Scenario:** A restaurant chain uses Lightspeed POS and needs to automatically sync employee schedules and time tracking data with Ordio.

**Process:**

1. Restaurant manager connects Lightspeed POS to Ordio via App Store
2. OAuth 2.0 authentication establishes secure connection
3. System automatically syncs employee data
4. Shift schedules automatically transferred to POS system
5. Time tracking data synced back to Ordio
6. Sales data integrated for reporting
7. Real-time synchronization ensures data consistency
8. Reports combine scheduling, time tracking, and sales data

**Benefits:** Eliminates manual data entry, ensures data consistency, saves 10+ hours/week, real-time synchronization, comprehensive reporting.

### Payroll System Integration (DATEV)

**Scenario:** A business needs to export payroll data from Ordio to DATEV for payroll processing.

**Process:**

1. HR manager connects DATEV to Ordio via App Store
2. Configures automatic export schedule (e.g., monthly)
3. System automatically exports employee time data
4. Payroll data formatted for DATEV compatibility
5. Export triggered automatically or manually
6. DATEV receives formatted data ready for processing
7. Confirmation sent when export completes
8. Audit trail maintained for all exports

**Benefits:** Seamless payroll integration, automatic exports, DATEV compatibility, reduced manual work, audit trail.

### HR System Integration (Personio)

**Scenario:** A company uses Personio for HR management and needs to sync employee data with Ordio.

**Process:**

1. HR manager connects Personio to Ordio
2. Employee master data automatically synced
3. New employees automatically added to Ordio
4. Employee status changes reflected in real-time
5. Organizational structure synced
6. Two-way synchronization ensures consistency
7. Automatic updates reduce manual work
8. Single source of truth maintained

**Benefits:** Automatic employee data sync, real-time updates, reduced manual work, data consistency, single source of truth.

### Reservation System Integration

**Scenario:** A restaurant uses a reservation system and needs to sync reservation data with Ordio for staffing decisions.

**Process:**

1. Restaurant manager connects reservation system to Ordio
2. Reservation data automatically synced
3. System analyzes reservation patterns
4. Staffing recommendations generated based on reservations
5. Shift schedules automatically adjusted
6. Real-time updates ensure optimal staffing
7. Reports combine reservations and staffing data

**Benefits:** Data-driven staffing decisions, automatic schedule adjustments, optimal staffing levels, comprehensive reporting.

### Custom Export Integration

**Scenario:** A business needs to export data to custom systems or Excel for analysis.

**Process:**

1. Manager configures custom export in App Store
2. Defines data fields and format (CSV, Excel, JSON)
3. Sets export schedule (daily, weekly, monthly)
4. System automatically generates exports
5. Exports delivered via email or API
6. Custom formatting ensures compatibility
7. Scheduled exports run automatically
8. Export history maintained

**Benefits:** Flexible export options, automatic scheduling, custom formatting, multiple formats, export history.

## Target Audience

### Primary Users

**IT Administrators:**

- Daily responsibility for system integrations
- Need seamless API connections
- Require secure authentication
- Benefit from OAuth 2.0 and RESTful APIs

**Operations Managers:**

- Coordinate multiple systems
- Need data synchronization
- Require real-time updates
- Benefit from automated workflows

**HR Managers:**

- Manage employee data across systems
- Need payroll integrations
- Require data consistency
- Benefit from automatic synchronization

**Business Owners:**

- Need comprehensive reporting
- Require system flexibility
- Benefit from time savings
- Need scalability

### Secondary Users

**Developers:**

- Build custom integrations
- Use RESTful APIs
- Implement webhooks
- Create custom exports

**Analysts:**

- Access integrated data
- Generate comprehensive reports
- Analyze cross-system data
- Export data for analysis

### Industries

**Gastronomie & Hotellerie:**

- POS system integrations (Lightspeed, 3POS)
- Reservation system integrations
- Payment system integrations

**Einzelhandel:**

- POS system integrations
- Inventory system integrations
- E-commerce platform integrations

**All Industries:**

- Payroll system integrations (DATEV, Addison)
- HR system integrations (Personio, Workday)
- Accounting system integrations
- Custom system integrations

## Key Functionality

### Core Capabilities

- **50+ Integrationen:** Pre-built integrations with popular business tools
- **RESTful API:** Standard API for custom integrations
- **Webhooks:** Real-time event notifications
- **OAuth 2.0:** Secure authentication for integrations
- **Automatische Datenübertragung:** Scheduled and real-time data sync
- **Export-Funktionen:** Flexible export options (CSV, Excel, JSON, PDF)
- **Schnittstellen-Management:** Centralized integration management
- **Partner-Programm:** Become a partner and integrate your solution

### Advanced Features

**Pre-built Integrations:**

- **DATEV:** Payroll and accounting integration
- **Personio:** HR management integration
- **Lightspeed:** POS system integration
- **3POS:** POS system integration
- **Workday:** HR management integration
- **Addison:** Payroll integration
- **Mein Business:** Business management integration
- **50+ more integrations available**

**Custom Integration Tools:**

- **RESTful API:** Standard REST API for custom integrations
- **Webhooks:** Real-time event notifications
- **OAuth 2.0:** Secure authentication
- **API Documentation:** Comprehensive API documentation
- **Developer Support:** Technical support for developers

**Data Synchronization:**

- **Real-time Sync:** Instant data synchronization
- **Scheduled Sync:** Automated scheduled synchronization
- **Bidirectional Sync:** Two-way data synchronization
- **Conflict Resolution:** Automatic conflict resolution
- **Data Validation:** Automatic data validation

**Export Capabilities:**

- **Multiple Formats:** CSV, Excel, JSON, PDF
- **Custom Formatting:** Customizable export formats
- **Scheduled Exports:** Automated export scheduling
- **API Exports:** Programmatic export access
- **Export History:** Complete export audit trail

## Technical Implementation

### Files

**Frontend Files:**

- **PHP:** `v2/pages/product_appstore.php` (~535 lines)
  - Product page with hero section, integration showcase, partner logos, FAQ section, and CTAs
  - Alpine.js integration for interactive elements
  - AOS (Animate On Scroll) for animations
  - Schema markup for SEO (SoftwareApplication, Service, BreadcrumbList)
  - Responsive design with Tailwind CSS

**JavaScript:**

- `/v2/js/lead-capture-triggers.min.js` - Lead capture and form tracking
- Alpine.js components for interactive UI
- Custom integration components

**CSS:**

- `/v2/css/product-pages.min.css` - Shared product pages stylesheet
- Tailwind CSS utility classes
- Custom app store styles

**Dependencies:**

**Backend Systems:**

- Integration management system
- API gateway
- OAuth 2.0 authentication service
- Webhook service
- Data synchronization engine
- Export service
- Partner management system

**External Integrations:**

- Third-party API connections (DATEV, Personio, Lightspeed, etc.)
- OAuth providers
- Webhook endpoints
- Export destinations

**Frontend Libraries:**

- Alpine.js for reactive UI components
- Tailwind CSS for styling
- AOS (Animate On Scroll) for animations

### API Endpoints

**Integration Management:**

- `GET /api/integrations` - List all integrations
- `POST /api/integrations` - Create new integration
- `GET /api/integrations/{id}` - Get integration details
- `PUT /api/integrations/{id}` - Update integration
- `DELETE /api/integrations/{id}` - Delete integration
- `POST /api/integrations/{id}/connect` - Connect integration
- `POST /api/integrations/{id}/disconnect` - Disconnect integration

**OAuth Authentication:**

- `GET /api/oauth/authorize` - OAuth authorization endpoint
- `POST /api/oauth/token` - OAuth token endpoint
- `GET /api/oauth/callback` - OAuth callback endpoint

**Data Synchronization:**

- `POST /api/integrations/{id}/sync` - Trigger manual sync
- `GET /api/integrations/{id}/sync/status` - Get sync status
- `GET /api/integrations/{id}/sync/history` - Get sync history

**Webhooks:**

- `POST /api/webhooks` - Create webhook
- `GET /api/webhooks` - List webhooks
- `PUT /api/webhooks/{id}` - Update webhook
- `DELETE /api/webhooks/{id}` - Delete webhook
- `POST /api/webhooks/{id}/test` - Test webhook

**Exports:**

- `POST /api/exports` - Create export
- `GET /api/exports` - List exports
- `GET /api/exports/{id}` - Get export details
- `GET /api/exports/{id}/download` - Download export
- `GET /api/exports/history` - Get export history

**Partner Program:**

- `GET /api/partners` - List partners
- `POST /api/partners/apply` - Apply to become partner
- `GET /api/partners/{id}` - Get partner details

## User Experience

### Detailed User Flow

#### Flow 1: Connecting an Integration

1. **Access App Store:**

   - Manager logs into Ordio
   - Navigates to "App Store" or "Integrationen"
   - Views available integrations

2. **Select Integration:**

   - Browses available integrations
   - Clicks on desired integration (e.g., DATEV)
   - Views integration details and requirements

3. **Connect Integration:**

   - Clicks "Connect" or "Install"
   - OAuth authentication flow begins
   - Redirected to third-party system for authentication
   - Grants permissions
   - Redirected back to Ordio

4. **Configure Integration:**

   - Sets up sync preferences
   - Configures data mapping
   - Sets sync schedule
   - Saves configuration

5. **Integration Active:**
   - Integration appears as "Connected"
   - Data synchronization begins
   - Status dashboard shows sync status

#### Flow 2: Setting Up Custom Export

1. **Access Export Settings:**

   - Manager navigates to "Exports" section
   - Clicks "Create Export"

2. **Configure Export:**

   - Selects data fields to export
   - Chooses export format (CSV, Excel, JSON)
   - Sets export schedule (one-time, daily, weekly, monthly)
   - Configures delivery method (email, API, download)

3. **Save Export:**

   - Saves export configuration
   - Export appears in export list
   - Scheduled exports run automatically

4. **Monitor Exports:**
   - Views export history
   - Downloads completed exports
   - Reviews export status

### Detailed Workflows from Helpdesk

The following workflows are based on helpdesk documentation for the Mitarbeiter-App (Employee Mobile App).

#### Mitarbeiter-App Core Features

**Basic Functions:**

1. **Shift Viewing:**

   - **Tagesaktuelle Schichten:** Current day shifts visible immediately
   - **Zukünftige Schichten:** Upcoming shifts displayed in calendar
   - Calendar view with shift details
   - Shift details include: time, location, work area, notes

2. **Calendar Navigation:**

   - Monthly calendar view
   - Daily, weekly, monthly views
   - Easy navigation between dates
   - Color-coded shifts

3. **Absences & Vacation:**

   - View vacation requests
   - Submit new vacation requests
   - Track vacation balance
   - View approved/rejected requests

4. **Menu Navigation:**

   - Access to all app features
   - Profile settings
   - Time tracking
   - Shift applications
   - Change requests

5. **Change Requests:**

   - Submit shift time change requests
   - Request shift swaps
   - View request status
   - Receive notifications

6. **Profile Management:**
   - View and edit personal data (Stammdaten)
   - Change login credentials
   - Update contact information
   - Manage app settings

**Additional Functions:**

1. **Time Tracking:**

   - Clock in/out
   - Break tracking
   - View time entries
   - Submit time corrections
   - GPS location tracking (optional)

2. **Shift Applications:**

   - Browse open shifts
   - Apply for shifts
   - View application status
   - Receive notifications

3. **Checklists:**

   - View assigned checklists
   - Complete checklist items
   - Submit checklist responses
   - Track completion status

4. **Documents:**

   - View required documents
   - Upload documents
   - Track document status
   - Receive reminders

5. **Notifications:**
   - Push notifications for:
     - Shift assignments
     - Schedule changes
     - Application approvals
     - Document requests
     - System updates

#### Workflow: Integrating Lightspeed POS System

**Purpose:** Connect Lightspeed point-of-sale system with Ordio workspace for revenue data integration

**Benefits:**

- **Real-time Revenue Monitoring:** View total revenue (Gesamtumsatz) in real-time using Lightspeed sales data
- **Labor Cost Ratio Tracking:** Monitor personnel cost ratio (Personaleinsatzquote) - percentage of revenue spent on labor costs
- **Efficiency Insights:** Additional insights into business efficiency through integrated reporting

**Setup Process:**

1. **Connect Lightspeed:**

   - Go to Einstellungen > Appstore
   - Find Lightspeed integration
   - Click to connect Lightspeed with Ordio
   - Authenticate Lightspeed account

2. **Map Cash Registers to Locations:**

   - Assign your Lightspeed cash registers to Ordio locations
   - You can assign multiple cash registers to one location
   - Map each cash register to appropriate Ordio location/standort

3. **Set Start Date:**
   - Choose start date for data transfer
   - Revenue data from Lightspeed will be transferred starting from this date
   - Historical data before start date will not be imported

**Viewing Revenue Data:**

1. **Access Reporting:**

   - Go to Reporting section (as you normally would)
   - Select time period you want to view
   - Select location(s) you want to analyze

2. **View Integrated Metrics:**
   - **Total Revenue (Gesamtumsatz):** Real-time revenue from Lightspeed sales data
   - **Labor Cost Ratio (Personaleinsatzquote):** Percentage of revenue spent on labor costs
   - Compare revenue vs. labor costs for efficiency analysis

**Use Cases:**

- Monitor daily/weekly/monthly revenue trends
- Analyze labor cost efficiency
- Compare revenue across locations
- Track performance metrics over time

**Requirements:**

- Active Lightspeed POS system account
- Lightspeed cash registers configured
- Ordio locations set up
- Integration enabled in Appstore settings

#### Workflow: Changing App Language

**Purpose:** Configure app language for multilingual teams

**Available Languages:**

- Deutsch (German)
- English
- Nederlands (Dutch)
- Polski (Polish)

**Steps:**

1. **Open Menu:**

   - Open Mitarbeiter-App
   - Click menu icon (top left)

2. **Access Profile:**

   - Scroll to bottom of menu
   - Click on your name

3. **Select Language:**

   - Scroll to Profile and Account Information section
   - Find "Sprache" (Language) option
   - Select desired language from list

4. **Apply Changes:**
   - Language changes immediately
   - App interface updates automatically
   - All text displayed in selected language
   - No restart required

**Note:** Language setting is per-user, each employee can choose their preferred language independently.

#### Workflow: Lightspeed Integration Setup

**Purpose:** Connect Lightspeed POS system with Ordio for revenue data integration

**Prerequisites:**

- Lightspeed POS system account
- Ordio workspace with locations configured

**Configuration Steps:**

1. **Connect Lightspeed:**

   - Go to Settings > Appstore
   - Find Lightspeed integration
   - Click "Connect" or "Verbinden"
   - Authenticate with Lightspeed credentials
   - Authorize Ordio access

2. **Assign Cash Registers to Locations:**

   - Map Lightspeed cash registers to Ordio locations
   - You can assign multiple cash registers to one location
   - Or assign one cash register to multiple locations
   - Configure assignment in integration settings

3. **Set Start Date:**
   - Choose start date for data transfer
   - Revenue data will be transferred from this date forward
   - Historical data before this date is not imported

**Viewing Revenue Data:**

1. **Access Reporting:**

   - Go to Reporting section
   - Select time period
   - Select location(s) to view

2. **Available Metrics:**
   - **Gesamtumsatz (Total Revenue):** Real-time revenue data from Lightspeed sales
   - **Personaleinsatzquote (Labor Cost Ratio):** Percentage of revenue spent on labor costs
   - Compare revenue vs. labor costs
   - Track efficiency metrics

**Benefits:**

- Real-time revenue visibility
- Labor cost ratio tracking
- Better business efficiency insights
- Data-driven staffing decisions

### UI Components

**App Store Dashboard:**

- **Layout:** Grid of integration cards
- **Elements:**
  - Integration cards with logos
  - Status indicators (Available, Connected, Pending)
  - Quick actions (Connect, Configure, Disconnect)
  - Search and filter options
- **Interactions:** Click to view details, connect, configure
- **Visual Design:** Clean app store interface with partner logos

**Integration Configuration:**

- **Layout:** Form-based configuration interface
- **Elements:**
  - Connection status
  - Sync settings
  - Data mapping configuration
  - Schedule configuration
  - Test connection button
- **Interactions:** Configure settings, test connection, save
- **Visual Design:** Clear configuration form with status indicators

**Export Management:**

- **Layout:** List view with export cards
- **Elements:**
  - Export list with status
  - Create export button
  - Export history
  - Download buttons
- **Interactions:** Create export, download, view history
- **Visual Design:** Organized export management interface

## Visual Documentation

### Screenshots

**App Store Dashboard:**

- **File:** `/v2/img/screenshots/appstore-dashboard.webp`
- **Alt Text:** "Ordio App Store dashboard showing available integrations"
- **Caption:** Main App Store dashboard with integration cards

**Integration Partners:**

- **File:** `/v2/img/partner/lightspeed.svg`, `/v2/img/partner/3pos.svg`, etc.
- **Alt Text:** "Integration partner logos"
- **Caption:** Partner logos displayed in App Store

### Diagrams

**Integration Architecture:**

- **File:** `/v2/img/diagrams/appstore-integration-architecture.svg`
- **Description:** How Ordio integrates with external systems via API, OAuth, and webhooks
- **Use Case:** Understanding integration architecture

## Maintenance

### Update Schedule

- **Regular updates:** Monthly new integrations and improvements
- **API updates:** As needed for API enhancements
- **Security updates:** Ongoing security improvements
- **Partner updates:** As new partners join the program
- **Performance optimization:** Ongoing improvements to sync speed and reliability

### Common Updates

- **New integrations:** Add support for new third-party systems
- **API enhancements:** Improve API capabilities and documentation
- **Sync improvements:** Enhance data synchronization reliability and speed
- **Export enhancements:** Add new export formats and options
- **Security improvements:** Enhance OAuth and API security
- **Partner program expansion:** Add new partners and integrations

## Related Documentation

- [Product Pages Inventory](../../pages/product-pages/PRODUCT_PAGES_INVENTORY.md)
- [Product Features Inventory](../PRODUCT_FEATURES_INVENTORY.md)
- [Lohnabrechnung Documentation](lohnabrechnung-documentation.md)
- [Zeiterfassung Documentation](zeiterfassung-documentation.md)

## Related Cursor Rules

- [product-pages.mdc](../../../../.cursor/rules/product-pages.mdc)
- [shared-patterns.mdc](../../../../.cursor/rules/shared-patterns.mdc)
- [global.mdc](../../../../.cursor/rules/global.mdc)