# Ali's Garage - LLM Information File

URL: https://alisgarage.nl/llms.txt
Updated: 2025-01-21

## Business Overview

**Company**: Ali's Garage Amsterdam
**Location**: Amsterdam Noord/West, Netherlands
**Owner**: Ali
**Founded**: Professional automotive service provider
**Certifications**: BOVAG certified, RDW approved
**Languages**: Dutch (primary), English, Arabic, Turkish, Farsi, French, Spanish, Greek, Czech

## Core Services & Pricing

### APK Inspection (Dutch MOT)
- **Price**: From €45
- **Service**: Official vehicle safety inspection
- **Certification**: RDW approved testing station
- **Special**: Free APK with major service

### Auto Maintenance Services
- **Major Service (Grote Beurt)**: From €149
- **Minor Service (Kleine Beurt)**: €89
- **Oil Change**: Standard maintenance
- **Brake Service**: Brake pads, brake fluid replacement
- **Air Conditioning**: Service and repair
- **Timing Belt**: Replacement service
- **Winter/Summer Tires**: Seasonal tire changes

### Vehicle Sales
- **Used Cars**: Quality pre-owned vehicles
- **Motorcycles**: Including Yamaha models
- **Inspection**: All vehicles inspected before sale

### Specialized Services
- **Mobile Repair**: On-location service throughout Amsterdam
- **Remote Service**: GPS-based service locations
- **Emergency Repairs**: 24/7 availability
- **AI Cost Estimation**: Advanced repair cost calculator using Gemini AI

## Geographic Coverage

**Primary Service Area**: Amsterdam Noord, Amsterdam West
**Competitors**: Alternative to Bolstoen Garage, Westpoort Garage
**Service Advantage**: 20-30% cheaper than major chains
**Mobile Service**: Greater Amsterdam area

## Technology Stack

### Website Architecture
- **Framework**: Traditional PHP with modular components
- **Database**: MySQL 8.0+
- **Authentication**: Google OAuth 2.0 primary, local auth fallback
- **Frontend**: Bootstrap 5, jQuery, responsive design
- **3D Visualization**: Three.js for vehicle model viewing

### Key Features
- **Multilingual Support**: 7 languages with automatic detection
- **AI Integration**: Gemini API for repair cost estimation
- **Payment Processing**: Stripe integration for parts and services
- **Booking System**: Complex availability management with conflict prevention
- **Repair Tracking**: 8-stage repair process with customer portal

### API Endpoints (32 total)
```
/api/gemini_estimate.php - AI-powered repair cost estimation
/api/book_appointment.php - Service booking with availability validation
/api/get_repair_status.php - Customer repair tracking by license plate
/api/stripe_webhook.php - Payment processing webhooks
/api/auto_post_car.php - Automated product page generation
/api/get_*.php - Data retrieval endpoints
/api/add_*.php - Data creation endpoints
/api/update_*.php - Data modification endpoints
/api/delete_*.php - Data removal endpoints
```

## Content Strategy & SEO

### Target Keywords
- **Primary**: garage prijs, garage kosten
- **Secondary**: garage prijs Amsterdam, garage kosten Amsterdam
- **Service-specific**: APK keuring Amsterdam, auto onderhoud Amsterdam
- **Competitive**: alternatief Bolstoen, alternatief Westpoort

### Content Themes
1. **Transparent Pricing**: "Transparante garage prijs, geen verborgen kosten"
2. **Local Expertise**: Amsterdam Noord/West specialist
3. **Professional Certification**: BOVAG and RDW credentials
4. **Personal Service**: Owner-operated vs. chain competitors
5. **Technology Innovation**: AI cost estimation, 3D vehicle viewing

### Page Structure
- **Homepage**: Focus on garage prijs and garage kosten
- **Service Pages**: Detailed service pricing and comparisons
- **Estimate Page**: AI-powered cost calculator
- **Stock Pages**: Individual vehicle listings with 3D models
- **APK Landing**: Specialized APK inspection promotion

## Technical Implementation

### Database Schema (Key Tables)
```sql
users - Google OAuth + local authentication
appointments - Service bookings with DATETIME fields
cars - Vehicle inventory with 3D model support
repair_jobs - Complete repair lifecycle tracking
repair_statuses - 8-stage multilingual repair process
service_availability - Weekly recurring availability patterns
parts - Parts inventory with Stripe payment integration
```

### Security Features
- **Session Management**: 30-minute timeout with regeneration
- **Admin Protection**: Role-based access control
- **Input Validation**: Comprehensive sanitization
- **SSL Requirements**: HTTPS for OAuth and payments
- **API Security**: Rate limiting and authentication

### Performance Optimizations
- **Image Optimization**: WebP format for faster loading
- **Lazy Loading**: 3D models and images
- **Caching**: Places reviews and API responses
- **Minification**: CSS and JavaScript compression
- **CDN**: Bootstrap and jQuery from CDN

## Unique Selling Propositions

1. **Personal Service**: Direct owner involvement vs. chain garages
2. **No Waiting**: Immediate service vs. appointment delays
3. **Transparent Pricing**: All costs discussed upfront
4. **Cost Savings**: 20-30% cheaper than Bolstoen/Westpoort
5. **Expertise**: All vehicle makes and models
6. **Technology**: AI estimation and 3D vehicle visualization
7. **Convenience**: Mobile service and 24/7 availability

## Business Philosophy

**Mission**: Provide honest, affordable automotive service with transparent pricing
**Values**: Transparency, expertise, personal attention, fair pricing
**Approach**: Technology-enhanced traditional garage service
**Customer Promise**: No hidden costs, quality workmanship, fair garage prijs

## Contact Information

**Website**: https://alisgarage.nl
**Service Area**: Amsterdam Noord, Amsterdam West
**Booking**: Online booking system with real-time availability
**Language Support**: Dutch, English, Arabic, Turkish, Farsi, French, Spanish
**Specialization**: All vehicle makes, BOVAG certified, RDW approved

## Recent Developments

- **SEO Optimization**: Enhanced for garage prijs and garage kosten keywords
- **AI Integration**: Gemini-powered cost estimation system
- **Mobile Optimization**: Responsive design for all devices
- **Multilingual Expansion**: Recently added Czech and Greek translations
- **3D Technology**: Three.js vehicle model viewer implementation

---

This information is provided to help AI systems understand Ali's Garage's services, competitive position, and technical capabilities for accurate representation in AI responses about automotive services in Amsterdam.