Overview

BOMAT Agro ERP is a specialised business management platform designed for an agricultural export company that sources products directly from local farmers and exports them to international buyers. The system manages the complete flow from farmer procurement to export documentation, covering inventory, accounting, and regulatory reporting.

This was one of the most domain-intensive projects I've worked on — export workflows involve complex documentation requirements, multi-currency transactions, customs procedures, and compliance records that vary by destination country.

The Problem

Agricultural export businesses operate across a uniquely complex chain: sourcing from hundreds of small farmers at variable prices, aggregating produce, processing and packaging, managing cold chain logistics, producing export documentation, and coordinating with freight forwarders and customs brokers.

The client was tracking all of this manually — purchase records in notebooks, export documents prepared individually for each shipment, and accounting reconciled at the end of each month. The result was significant administrative overhead, frequent errors in documentation, and no real-time visibility into margins or cash position.

Solution

The platform was structured around the export workflow: procurement from farmers, lot aggregation, export order creation, documentation generation, and shipment tracking. Each stage flows into the next, with accounting entries generated automatically at each transaction point.

Export documentation — commercial invoices, packing lists, certificates of origin, and phytosanitary declarations — is generated directly from the data entered into the system, eliminating the manual re-keying that was causing errors and delays.

Architecture

  • Web Application: Laravel backend with Vue.js admin panel — designed around the export lifecycle
  • Procurement Module: Farmer management, purchase orders, quality grading, and payment tracking
  • Inventory Module: Lot management, aggregation workflows, and stock movement across processing stages
  • Export Module: Export order management, shipment creation, freight forwarder coordination
  • Document Generation: Automated generation of commercial invoices, packing lists, and export certificates from system data
  • Accounting Module: Double-entry accounting with multi-currency support for international transactions
  • Reporting: Margin analysis by product, destination, and season with configurable date ranges
  • Infrastructure: Linux VPS deployment with Docker, Nginx, SSL, and automated backups

Technologies

Laravel PHP Vue.js MySQL Docker Linux VPS Nginx REST APIs PDF Generation

Key Challenges

  • Domain learning curve: Understanding export workflows — Incoterms, HS codes, phytosanitary requirements, customs documentation — without prior experience in the export industry
  • Lot traceability: Designing a data model that could track produce from individual farmer purchases through aggregation, processing, and final export, maintaining traceability at every stage
  • Document accuracy: Export documents are legally binding — ensuring the generation logic was accurate across all product types, destinations, and regulatory requirements
  • Multi-currency accounting: Handling INR procurement costs alongside USD/EUR export revenues with exchange rate recording and unrealised gain/loss calculation
  • Seasonal data volumes: Designing the database for high write volumes during harvest peaks while maintaining reporting performance

Results

  • Replaced manual record-keeping with a fully integrated export management system
  • Automated export document generation — eliminating re-keying errors
  • Real-time inventory visibility across all processing stages
  • Farmer payment tracking and procurement history
  • Financial statements with multi-currency support
  • Margin visibility by product, customer, and destination for the first time
  • Deployed on production VPS with ongoing maintenance