PickArt: Art-Hospitality Marketplace Platform

PickArt addresses the intersection of art, hospitality, and technology by creating a three-sided marketplace platform. The system enables property hosts to enhance guest experiences with curated artwork while providing artists with new sales channels and giving guests the ability to purchase pieces they encounter during their stays.

The platform combines physical art placement with digital commerce through QR-code based discovery and comprehensive order management, including automated PDF document generation for legal compliance and ownership transfer.

PickArt operates as a comprehensive ecosystem serving three distinct user groups:

Rendering Strategy

• Static Site Generation (SSG): Pre-renders artwork galleries and property pages for fast load times
• Incremental Static Regeneration (ISR): Updates static content when artwork status changes
• Server-Side Rendering (SSR): Handles dynamic admin platform and real-time data requirements
• Hybrid Approach: Balances performance with dynamic functionality

Database Design

• Complex Relational Model: Artists, artworks, properties, spots, orders, and QR codes with sophisticated relationships
• Artwork Lifecycle Management: Draft → Approval → Allocation → Live → Sold status workflow
• Audit Trails: Complete order event tracking for legal compliance
• Multi-Address Support: Separate billing and shipping address management

The platform generates unique QR codes for each artwork placement, enabling instant discovery and purchase. When guests scan a code:

• Artwork details load with complete provenance information
• Location context enhances the discovery experience
• Checkout flow maintains purchase momentum
• Real-time inventory prevents overselling

Dynamic Pricing & Logistics

• Multi-Currency Support: Handles pricing in CHF, EUR, USD with real-time conversion
• Shipping Calculations: Automated cost calculation based on artwork dimensions and destination
• Take-Home Options: Instant ownership transfer for immediate pickup
• International Compliance: Automated customs documentation and tax handling

When artwork is purchased, the platform automatically generates legally compliant documentation:

• Release Vouchers: Legal transfer documents with 6 different types based on purchase method and tax status
• Authenticity Certificates: Artist-signed provenance documentation
• Customs Declarations: International shipping compliance documents

All documents are generated as professionally formatted PDFs using React PDF with dynamic content population.

Multi-Role Access Control

• Artists: Artwork upload, status tracking, sales analytics
• Property Hosts: Spot management, allocation preferences, revenue tracking
• Platform Admins: Full system oversight, approval workflows, analytics dashboard

Allocation System

The platform includes intelligent artwork-to-property matching:

• Dimensional Constraints: Ensures artwork fits designated spaces
• Style Preferences: Matches property aesthetics with appropriate art styles
• Price Range Targeting: Aligns artwork pricing with property guest demographics
• Availability Management: Real-time tracking prevents allocation conflicts

Order Management

• Multi-Stage Workflow: Pending → Processing → Shipped → Delivered tracking
• Automated Notifications: Email updates for all stakeholders throughout process
• Stripe Integration: Secure payment processing with webhook-driven status updates
• Refund Handling: Automated artwork status updates when refunds occur

Next-intl Implementation

• Three Languages: English, German, and Italian with comprehensive translations
• Static Generation: Pre-renders all language variants for optimal performance
• Dynamic Metadata: SEO optimization for each locale and artwork combination
• Type-Safe Translations: Full TypeScript support prevents translation errors

Cultural Localization

• Currency Handling: Automatic conversion and formatting based on user location
• Legal Compliance: Country-specific terms of service and privacy policies
• Shipping Regions: Comprehensive international delivery support
• Cultural Adaptation: Localized content and imagery for different markets

Frontend

• Next.js 15 - App router with server components for optimal performance
• TypeScript - Full type safety across the entire application
• Tailwind CSS v4 & Shadcn/UI - Modern utility-first styling with accessible components
• Next-intl - International localization with static generation

Backend & Data

• Supabase - PostgreSQL with real-time capabilities and storage CDN
• Drizzle ORM - Type-safe database operations with migration management
• TanStack Query - Client-side state management and caching

Business Logic

• Stripe - Payment processing with comprehensive webhook handling
• React PDF - Dynamic PDF generation for legal documents
• Resend - Transactional email delivery with React components
• QR Code Integration - Physical-to-digital artwork discovery

Type Safety & Validation

• End-to-End TypeScript: From database schema to frontend components
• Zod Validation: Runtime type checking for all user inputs and API responses
• Drizzle ORM: Type-safe database operations with automatic schema generation
• Strict ESLint Configuration: Enforces code quality and consistency

Performance & Security

• Server Components: Leverages Next.js 15 app router for optimal performance
• Row-Level Security: Database policies ensure users only access authorized data
• PCI Compliance: Secure payment processing with webhook validation
• GDPR Compliance: Comprehensive privacy controls and data protection

PickArt demonstrates how technology can create new markets by solving real-world problems for multiple stakeholders simultaneously. The platform's architecture enables scalable operations while handling complex multi-sided marketplace dynamics.

The system showcases advanced full-stack development capabilities, from automated legal document generation to international localization, while maintaining type safety and performance optimization throughout the entire application.