+ Add Job — Create a new job listing manually. Edit — Update an existing listing. Delete — Permanently remove a listing. Upload Excel — Import jobs from Excel and add/update records without deleting existing jobs. Full Excel Sync — Make Firestore exactly match the Excel file. New jobs are added, existing jobs are updated, and missing jobs are deleted automatically. Export Excel — Download all current jobs from Firestore into an Excel file for backup, editing, or bulk updates.
Database: Firebase Firestore (real-time database). Authentication: Firebase Admin Login required for all changes. Job ID: Must be unique and should never be changed once created. Live Updates: Changes are reflected on the website automatically after saving.
Recommended Workflow:
Export Excel → Edit Jobs → Save Excel → Full Excel Sync.
Maintain one master Excel file as the source of truth for large-scale job management and updates.
