Android (Tablet) + Web App for Product Catalog (Offline & Online Sync, REST API, MySQL) Project Description: We are looking for an experienced Android + Web developer (or small team) to build a modern product catalog app for sales representatives. Database already migrated from access (old) to MySQL and product images The app must work offline and online, allowing agents to browse products, manage clients, and create orders without internet connection. When connectivity is restored, data should automatically sync with a cloud-based backend (MySQL + REST API). The goal is to replace an old PC-based system that requires manual synchronization with a mobile-first cloud architecture. Android App (Tablet & Mobile): - Login system (online & offline) - Product catalog with filters by category, name, or code - Display images, prices, and stock information - Local data storage (SQLite / Room) - Client management with profile, notes, and history - Order creation with discounts, taxes, and totals - Queue of pending orders (sync when connection is available) - Manual and automatic synchronization - Clean Material Design UI Web Admin Panel: - Admin/seller login - Manage products (CRUD + image upload) - Manage clients - View and export orders received from the mobile app - Dashboard with basic statistics (sales, orders per agent, etc.) Backend / API: - REST API (Laravel/Lumen or Node.js preferred) - Cloud-hosted MySQL database - JWT authentication - Swagger / OpenAPI documentation - Support for image/file upload endpoints Technical Requirements: - Experience in Android apps with offline/online synchronization - Strong skills in Laravel/Lumen or Node.js - Solid understanding of MySQL - Familiar with Material Design UI or tailwind - Clean, documented, version-controlled code (GitHub required) Deliverables: 1. Android APK + full source code 2. Web Admin panel (responsive, CRUD operations) 3. REST API + documentation 4. MySQL scripts (database structure) 5. Installation & deployment manual Estimated Timeline: 6/8 weeks Preferred Freelancer Location: Developers or teams based in India, fluent in English or Spanish Communication: - Weekly progress updates - Communication via Freelancer chat, Zoom or Telegram - Must agree to milestone-based delivery Proposed Milestones: 1. App design and navigation setup 2. REST API + MySQL integration 3. Offline/Online synchronization 4. Web Admin panel (CRUDs and Dashboard) 5. Testing, documentation and final delivery Required Skills: Android, Kotlin, Java, Laravel, Lumen, Node.js, MySQL, REST API, Swagger, Material Design, SQLite, Git, JavaScript, Web Development, PHP, API Integration Notes: We prefer freelancers who can provide previous examples of Android apps with offline synchronization and REST API integration. Good communication and consistent progress reporting are essential.