Automated Warehouse & INSW KEK Integration

Streamlining customs and warehouse logistics. Successfully designed and built an automated warehouse integration connecting GTISoft ERP with the Indonesia National Single Window (INSW) IT Inventory system for Special Economic Zones (KEK) at PT. Golden Tekstil Indonesia.

🌟 Key Features

• 🔄 Real-Time Transaction Sync: Syncs warehouse balance sheets (inbound, outbound, stock opname, adjustments) directly with INSW.
• 🔌 API-Based Architecture: Replaced manual file uploads with secure, automated REST APIs.
• 🛡️ Compliance Automation: Performs automated validations of customs codes, tax data, and documents.
• 📊 Operational Transparency: Provides real-time tracking logs for all goods coming in and out of the KEK zone.

🛠️ Tech Stack & Services

• Backend Logic: Node.js / Express
• ERP Integration Core: Laravel / PHP
• Database: MySQL
• Infrastructure: Alibaba Cloud ECS / Linux / Windows Server
• Integration Protocols: REST APIs / SOAP Web Services / JWT Authentication

🔧 Technical Insights

• API-Based Integration: Built microservices in Node.js to receive data from the GTISoft database, validate schemas, format them into JSON packets, and transmit them to the INSW gateway.
• Customs Rules Validation Engine: Implemented pre-flight validations to ensure every transaction conforms to Special Economic Zone rules, preventing submission rejection.
• Asynchronous Queue (RabbitMQ / Redis): Configured a message broker queue to process inventory sync requests asynchronously, preventing application lag during high shipment volumes.

🚦 Challenges and Solutions

• Unstable Government API Gateways: Network timeouts on government servers frequently interrupted data transmissions.
  • Solution: Implemented an automated retry mechanism with exponential backoff and persistent transaction queueing to ensure no data was dropped.
• Strict Government Inventory Rules: Strict constraints required that any outbound stock must link back to a matching inbound customs declaration.
  • Solution: Developed a relational mapping layer in the database that linked internal stock movement records with their corresponding customs entry numbers.

🏆 Outcome

The automated integration achieved 100% compliance with Indonesia National Single Window (INSW) IT Inventory guidelines for Special Economic Zones (KEK). It completely eliminated manual entry errors, dramatically improved audit readiness, and reduced the processing time for customs declarations from days to a few seconds.