Part 1: Modernizing Freight Forwarding — The High-Level Architecture & End-to-End Workflow
Part 1 of our 3-Part Series on Streamlining Logistics with GoExcel Freight Portal for Odoo.
Figure 1: The GoExcel Customer Portal Dashboard provides a centralized hub for all shipment operations.
The Freight Forwarding Bottleneck
In an era where shippers and consignees expect instantaneous digital interactions, many freight forwarding companies remain bogged down by legacy operational friction:
❌ Traditional Workflow:Unverified Email Inquiries ➔ Manual KYC Paperwork ➔ Spreadsheet Quotes ➔ Endless Email Threads ➔ Manual Data Entry into TMS ➔ Carrier Booking ➔ Repetitive "Where is my cargo?" Tracking Calls ➔ Scanned Draft B/L Markups ➔ Re-keying Invoices
This manual, fragmented cycle leads to five major industry headaches:
Slow Turnaround Times: It takes hours—or even days—just to gather container specs, quote a prospect, and confirm space allocation.
Cumbersome Customer Onboarding & KYC: Collecting Business Registration Numbers (BRN), tax IDs (TIN/SST), financial documents, and contact details over scattered emails delays business transactions.
Double (and Triple) Data Entry: The same container specs, addresses, and port pairs get typed manually into quotations, booking sheets, shipping instructions, and customer invoices.
Endless "Where Is My Cargo?" Inquiries: Customer service teams spend up to 40% of their day answering status phone calls and emails to provide container milestones, vessel ETDs, and cutoff updates.
Draft B/L Amendment Chaos: Amending draft Bills of Lading via email markups introduces typos, misaligned cargo weights, and costly shipping line amendment fees.
The Solution: GoExcel Freight Portal for Odoo
The GoExcel Freight Portal transforms Odoo into an end-to-end digital logistics operating system. It provides a secure, branded customer portal directly connected to your back-office freight ERP.
Instead of siloed tools, the entire shipment lifecycle—from customer registration and quoting to operations, documentation, milestone tracking, and billing—flows through a single unified engine.
The 4 Core Pillars of the Digital Freight Workflow
The GoExcel Freight Portal structures the complete shipment lifecycle into four interconnected operational phases:
Phase 1: Commercial Quoting & Rapid Conversion (Steps 1 to 5)
Self-Service RFQ Web Portal: Prospects and clients submit quote requests 24/7 across Ocean (FCL/LCL), Air, and Land freight with dynamic container builders and volumetric calculators.
Comprehensive Logistics Parameters: Captures Incoterms, Type of Movement, HS codes, Place of Delivery, and value-added trade services (Certificate of Origin, Marine Cargo Insurance, Fumigation, Form D/E).
Intelligent Back-Office Rating: CS teams compute foreign currencies, ocean freight rates, and local handling charges in minutes with real-time margin tracking.
Interactive Portal Viewer: Clients inspect formatted quotation PDFs directly in their browser and accept terms instantly via integrated chatter.
1-Click Conversion: Approved quotations copy directly into operational Freight Booking Jobs with zero manual re-entry.
Phase 2: Operational Execution & Customer Booking Hub (Steps 6 & 7)
Carrier Booking: CS secures space with ocean liners and logs carrier booking references, vessel/voyage details, and port cutoff schedules.
Automated Customer Dispatches: One-click Booking Confirmation emails keep customers informed of cargo cutoffs, container pickup locations, and ETDs.
Customer Portal Booking Management: Clients can view their active booking jobs (/my/booking_jobs), inspect container particulars, download attached shipping documents, and even initiate House BL creation online.
Figure 2: Customer Portal Booking Jobs management screen with status tracking and document access.
Phase 3: Self-Service Bill of Lading (HBL) Lifecycle (Steps 8 to 10)
Instant Draft HBL Generation: House BLs are generated directly from the booking job, inheriting cargo quantities, weights, and container numbers.
Multi-Step Portal B/L Editor: Customers directly edit Shippers, Consignees, Notify Parties, container marks, and cargo weights in the portal—eliminating manual paperwork.
Original Release & Security Lock: Once the shipping line confirms the final SI, CS transitions the BL status to Original, automatically locking the portal form against edits and granting instant access to download the official Original B/L PDF.
Phase 4: Financial Settlement & Integrated Invoicing
Cross-Referenced Freight Billing: Customer invoices automatically link to their parent Booking Jobs, complete with dedicated sidebar navigation.
In-Browser PDF.js Inspection: Clients view, verify, and download official invoice PDFs directly within the portal.
Seamless e-Invoicing Compliance: Full alignment with national e-invoicing requirements (goexcel_einvoicing_my) and transparent payment status tracking.
Figure 3: Customer Portal Invoice view featuring in-browser PDF preview and cross-links to related freight bookings.
Game-Changing Capabilities Beyond the Core Workflow
In addition to the 10-step quotation-to-BL process, the GoExcel Freight Portal includes powerful standalone modules designed to delight customers and reduce back-office overhead:
1. Real-Time Public & Portal Shipment Tracking (/tracking)
No more repetitive tracking inquiries. Shippers, consignees, and partners can track their cargo anytime:
Universal Multi-Reference Search: Track shipments by Job No (booking_no), House B/L No (hbl_no), Master B/L No (obl_no), or Carrier Booking No (carrier_booking_no).
Interactive Chronological Milestones: Powered by goexcel_chronological_event_alert, a visual timeline displays required dates, actual completion dates, and dynamic status badges (New, In Transit, Done).
Comprehensive Shipment Details: Real-time display of vessel name, voyage number, POL, POD, and assigned container numbers.
Direct Portal Quick Actions: Shippers can click the "Track" button in their portal booking job table or the "Track Shipment" sidebar button to view live cargo progress in 1 click.
Configurable Access: Administrators can set the tracking page to Public (open to anyone with the reference) or restricted to Signed-in Portal Users.
Figure 4: Real-time public and portal shipment tracking with chronological milestone timeline.
2. Digital Customer Onboarding & Self-Registration (/customer_registration)
Bring new shippers and trading partners into your ecosystem effortlessly:
Tokenized One-Time Invitations: CS/Sales teams generate secure UUID-based invitation links with pre-configured email templates (customer.registration.invite).
Comprehensive Online Registration: Customers complete their legal profile online—including Company Name, Address with dynamic state filtering, BRN, Buyer SST, and Buyer TIN.
Automated Tax & TIN Validation: Integrated TIN validation ensures tax compliance upfront before transactions begin.
Contact Persons & Document Uploads: Automatically provisions dedicated Accounts and Sales contacts and allows customers to upload SSM, tax certificates, and credit applications directly into Odoo chatter.
Instant Internal Alerts: The inviting sales representative and designated finance team members receive automated email notifications and chatter updates the moment onboarding is completed.
Figure 5: Self-service digital customer registration form capturing verified company details and KYC documents.
3. Modular Back-Office Administration (res.config.settings)
Full administrative control over portal visibility and security:
Modular Dashboard Toggles: Enable or disable portal dashboard cards (Quotations, Booking Jobs, Bill of Lading, and Invoices) independently based on your business model.
Security & Access Control: Switch the tracking interface between public access and authenticated portal users with a single setting.
Configurable Notification Groups: Easily assign which internal team members receive instant alerts when new clients register online.
Figure 6: Flexible back-office configuration settings governing customer portal visibility and access control.
Why Connected ERP + Customer Portal Wins
Capability | Legacy Freight Forwarding | GoExcel Freight Portal
|
Customer Onboarding | Paper KYC forms, email attachments & manual typing | Secure tokenized self-registration with automated TIN validation |
Quote Ingestion | Unstructured emails with missing specs | Multi-modal Web RFQ with dynamic container builders & trade services |
Data Propagation | Re-typed into Quote, Booking, B/L, and Invoice | 100% Automated 1-Click Data Transfer across all documents |
Booking Management | Booking sheets kept internal; updates emailed | Portal customer booking hub with document downloads & Draft edit |
B/L Verification | Hand-marked PDFs & messy email chains | Structured multi-step portal form editor with live partner creation |
Cargo Visibility | Daily "Where is my cargo?" calls & emails | 24/7 self-service tracking with interactive milestone timelines |
Financial Settlement | Invoices detached from operations; re-keyed | Linked portal invoices with e-invoicing compliance & PDF.js viewer |
Data Security | Edits possible after issuance; no audit trail | Automated portal edit locking upon Original B/L release |
Summary & What's Next
By bridging your customers directly with your freight operations inside Odoo, you eliminate manual re-keying, accelerate documentation turnaround, and deliver a modern, transparent logistics experience that wins repeat business.
In Part 2: Quoting, Portal Acceptance & Job Creation (Steps 1 to 5), we dive deep into the first half of the shipment lifecycle—from web inquiries to operational booking jobs.
In Part 3: Carrier Execution, Self-Service B/L & Release (Steps 6 to 10), we explore carrier confirmations, live milestone tracking, self-service Draft B/L editing, and secure Original B/L releases.
Comments