📌 Objective Build a central automation pipeline for a multi-branch food chain to process real-time POS sales webhooks, map SKUs, route regional transactions across Luzon, Visayas, and Mindanao, log inventory spoilages, and deliver daily automated End-of-Day (EOD) summaries directly to executives.

🧩 How It Works

Data Integration & Processing

• Captures real-time transaction payloads via direct POS platform webhooks.

• Maps SKUs, sold units, and transaction types for accurate item tracking.

• Deducts store stock inventory automatically in the database upon each sale or logged spoilage.

Automated Regional Routing & Master Database Sync

• Routes sales records dynamically into regional tracking sheets (Luzon, Visayas, Mindanao).

• Upserts all consolidated sales and stock inventory data into a central PostgreSQL Master Database.

• Isolates and logs store spoilages separately to maintain accurate inventory audit trails.

Executive Reporting Automation

• Triggers an automated Daily End-of-Day (EOD) workflow every night at 9:00 PM.

• Compiles sales summaries and inventory updates into real-time executive reports via Telegram/Viber.

🚀 Key Results

• 100% elimination of manual End-of-Day spreadsheet compilation

• Real-time multi-region visibility for management across all branch locations

• Instant stock inventory deduction preventing stockout delays

• Automated spoilage tracking for tight food cost control

• 99.9% data accuracy in master database reconciliation

🛠️ Powered By n8n Workflow Automation • Webhook API Integrations • PostgreSQL Master Database • Telegram / Viber Messaging API • JSON Data Mapping