================================================================================ BukaOlshop Admin System v1.0 - Setup Guide ================================================================================ QUICK START (5 MENIT) ================================================================================ 1. UPLOAD FILES - Upload semua file ke hosting - Pastikan folder uploads/ dan logs/ writable (chmod 755) 2. SETUP DATABASE - Create database: bukaolshop_admin - Import file: database/schema.sql 3. KONFIGURASI - Edit: config/config.php - Set DB_HOST, DB_USER, DB_PASS, DB_NAME 4. COBA LOGIN - URL: http://yourdomain.com/public/ - Username: admin - Password: admin123 5. INPUT API KEY - Go to Settings - Paste API Key dari BukaOlshop - Save SELESAI! ✓ ================================================================================ DETAIL DOKUMENTASI ================================================================================ README.md - Overview dan fitur lengkap INSTALASI.md - Panduan instalasi step-by-step FITUR.md - Daftar semua fitur sistem (150+) SETUP_GUIDE.txt - File ini STRUKTUR FOLDER ================================================================================ bukaolshop-admin/ ├── api/ - API handlers │ ├── upload-produk.php - Upload manual │ ├── upload-csv.php - Upload CSV │ ├── edit-produk.php - Edit produk │ ├── delete-produk.php - Delete produk │ ├── clear-cache.php - Clear cache │ ├── sync-kategori-lokasi.php │ ├── download-template.php │ └── get-upload-detail.php │ ├── classes/ - Core classes │ ├── Database.php - Database wrapper │ ├── Auth.php - Authentication │ ├── BukaOlshopAPI.php - API client │ ├── Cache.php - Caching system │ └── CSVHandler.php - CSV parser │ ├── config/ │ └── config.php - Configuration │ ├── database/ │ └── schema.sql - Database schema │ ├── includes/ │ ├── middleware.php - Auth middleware │ └── layout.php - Master layout │ ├── public/ - Web root │ ├── .htaccess - Security & rewrite │ ├── index.php - Router │ ├── login.php - Login page │ ├── dashboard.php - Dashboard │ ├── upload-produk.php - Upload page │ ├── daftar-produk.php - Product list │ ├── kategori-lokasi.php - Sync page │ ├── riwayat-upload.php - History page │ ├── profil.php - Profile page │ ├── setting.php - Settings page │ └── logout.php - Logout │ ├── uploads/ - Temporary storage ├── logs/ - Error logs │ └── Docs ├── README.md ├── INSTALASI.md ├── FITUR.md └── SETUP_GUIDE.txt DEFAULT ACCOUNT ================================================================================ Username: admin Password: admin123 CHANGE DEFAULT PASSWORD: SQL Query: UPDATE admin_users SET password = PASSWORD('newpassword') WHERE username = 'admin' Or: Login → Profil → Change Password IMPORTANT SETTINGS ================================================================================ 1. Database Connection File: /config/config.php - DB_HOST: localhost atau IP server - DB_USER: MySQL username - DB_PASS: MySQL password - DB_NAME: bukaolshop_admin 2. API Key File: /public/setting.php - Dapatkan dari aplikasi BukaOlshop - Paste di Settings page 3. Permissions chmod 755 uploads/ chmod 755 logs/ chmod 644 public/.htaccess 4. .htaccess Pastikan Apache mod_rewrite enabled RewriteEngine On COMMON ISSUES & SOLUTIONS ================================================================================ ERROR: 404 Not Found → Check .htaccess di public/ → Check Apache mod_rewrite enabled → Check document root pointing ke /public ERROR: Cannot connect to database → Check credentials di config/config.php → Check MySQL running → Try using 127.0.0.1 instead of localhost ERROR: Uploads folder not writable → chmod 755 uploads/ → chmod 755 logs/ ERROR: API Key 401 Unauthorized → Generate new API Key di BukaOlshop → Update di Settings page → Clear cache ERROR: CSV upload failed → Check file format (UTF-8 encoding) → Check PHP upload_max_filesize >= 10MB → Validate CSV format dari template FITUR UTAMA ================================================================================ ✓ Upload Produk Manual - Form multiple produk - Search kategori & lokasi - Validasi real-time ✓ Upload CSV Masal - Support 1000+ produk - Preview sebelum upload - Download template ✓ Daftar Produk - Search by nama - Pagination - Edit inline - Delete ✓ Kategori & Lokasi - Sinkronisasi dari API - Search filter - Caching system ✓ Dashboard - Statistik real-time - Recent data - Quick actions ✓ Security - Password bcrypt - Session timeout - CSRF protection - SQL injection prevent PERFORMA & OPTIMIZATION ================================================================================ Cache System: - Kategori/Lokasi: 1 jam - Product list: per halaman - Manual clear dari dashboard Database: - Indexes pada kolom penting - Foreign keys untuk integrity - Prepared statements API: - Response caching - Request limiting awareness - Error handling SUPPORT RESOURCES ================================================================================ Documentation: - README.md - Overview - INSTALASI.md - Installation - FITUR.md - All features - SETUP_GUIDE.txt - This file Troubleshooting: - Check /logs/error.log - Test database connection - Verify file permissions - Check PHP version >= 7.4 - Test cURL extension NEXT STEPS ================================================================================ 1. ✓ Upload files 2. ✓ Setup database 3. ✓ Configure settings 4. ✓ Test login 5. ✓ Input API Key 6. → Start uploading products! TIPS & TRICKS ================================================================================ 1. Bulk Upload: - Use CSV untuk banyak produk - Download template untuk format - Validate sebelum upload 2. Performance: - Clear cache regularly - Use pagination for lists - Search untuk filter 3. Backup: - Export database regularly - Backup CSV produk - Keep API Key safe 4. Security: - Change default password - Use strong password - Regular backup - Update PHP version FILE CHECKLIST ================================================================================ Required Files: [ ] /config/config.php [ ] /database/schema.sql [ ] /public/.htaccess [ ] /public/index.php [ ] /classes/Database.php [ ] /classes/Auth.php [ ] /classes/BukaOlshopAPI.php [ ] /classes/Cache.php [ ] /classes/CSVHandler.php [ ] /includes/middleware.php [ ] /includes/layout.php Web Pages: [ ] /public/login.php [ ] /public/dashboard.php [ ] /public/upload-produk.php [ ] /public/daftar-produk.php [ ] /public/kategori-lokasi.php [ ] /public/riwayat-upload.php [ ] /public/profil.php [ ] /public/setting.php [ ] /public/logout.php API Endpoints: [ ] /api/upload-produk.php [ ] /api/upload-csv.php [ ] /api/edit-produk.php [ ] /api/delete-produk.php [ ] /api/clear-cache.php [ ] /api/sync-kategori-lokasi.php [ ] /api/download-template.php [ ] /api/get-upload-detail.php Documentation: [ ] /README.md [ ] /INSTALASI.md [ ] /FITUR.md [ ] /SETUP_GUIDE.txt (this file) Folders: [ ] /uploads (create if not exist, chmod 755) [ ] /logs (create if not exist, chmod 755) VERSION INFO ================================================================================ System: BukaOlshop Admin System Version: 1.0 Build: January 2025 License: Proprietary Requirements: - PHP 7.4+ - MySQL 5.7+ - Apache with mod_rewrite - cURL extension CONTACT & SUPPORT ================================================================================ Installation Issues: - Check all files are uploaded - Verify folder permissions - Test database connection - Check PHP version Configuration Issues: - Edit config/config.php - Check database credentials - Verify API Key Functional Issues: - Check browser console for errors - Check /logs/error.log - Verify database integrity - Test API Key validity ================================================================================ System Ready for Production Use! ================================================================================ Untuk bantuan lebih lanjut, baca dokumentasi lengkap di README.md Selamat menggunakan BukaOlshop Admin System!