CustomsEZ
CustomsEZ Logo

Revision History

Track our latest updates and improvements to the Dubai Customs Flat File Converter

Current Version

dev@b365954

Released

Jan 12, 2026 21:49

Recent Updates

v1.9.3
Latest

December 3, 2025

What's New:

  • Applied blue color theme to magazine pages (matching main page styling)
  • Added References dropdown menu with 9 categories: Incoterms, IMO Classes, Containers, Reefer Cargo, Glossary, Pallets, ULD (Air), Vessels, Trucks
  • Reordered navigation: Articles → Directory → References → Ports Map with smooth hover animation
  • Compact ports map layout with more map space, removed back button
  • Added 245 additional companies from Yellow Pages UAE (617 total companies in directory)
  • Sidebar navigation reorganized: Logistics References now above About
  • Header top bar updated to blue-600 background with white text
  • Footer updated to dark gray (gray-900) with blue-400 accent links
  • Newsletter CTA section styled with blue-600 background

release-20251109-analytics-integration

November 9, 2025

What's New:

  • Implemented live Google Analytics Data API integration with hourly caching for real-time user statistics
  • Updated landing page with UAE-specific social proof: '1,000+ UAE businesses' based on actual GA4 data
  • Made StatsBar component dynamic - fetches live UAE users (1,100+) and total active users (2,300+) from Analytics API
  • Enhanced column mapper intelligence - filters already-mapped columns from dropdown and removes old columns after mapping
  • Added validation blocking - 'Process & View Items' button disabled when Weight or Amount fields are empty
  • Made Excel file JSON content collapsible and folded by default for cleaner interface
  • Centered and bolded all table headers in Preview and Items tables with conditional red background for issues
  • Migrated from systemd to PM2 process management for zero-downtime deployments and automatic recovery
  • Created comprehensive flowcharts: CONVERTER_UPLOAD_FLOWCHART.md (7-step upload) and PROCESS_VIEW_ITEMS_FLOWCHART.md (13-step processing)
  • Updated CLAUDE.md with analytics implementation plan - documented 26% completion with live stats integration as major milestone

release-20251028-country-normalization

October 28, 2025

What's New:

  • Implemented database as single source of truth for country validation and export
  • All country codes automatically normalized to 2-letter ISO codes after Excel import
  • Removed country name mapping from backend - frontend guarantees normalized codes
  • Fixed flat file export to only use 2-letter country codes regardless of input format
  • Supports all 247 countries in database including complex names with parentheses
  • Set api1 (api.customsez.com) as primary API server with api2 as fallback

release-20251027-search-improvements

October 27, 2025

What's New:

  • Intelligent HS code search with progressive digit matching - automatically finds best match by trying full code then shortening from left
  • Smart country code suggestions with scoring algorithm - 'JPP' now correctly suggests Japan (JP) as best match
  • Added 20+ countries to suggestion list including Japan, Korea, Thailand, Malaysia, Singapore, and more
  • Automatic search when clicking magnifier icon - no need to click Search button again
  • Visual loading indicator shows 'Searching for best match' with progress message
  • Progressive search tries all digit lengths (12→11→10→9→8...) until finding valid HS codes
  • Best match highlighted with 'Closest Match' badge in search results

release-20251027-calculator-glossary

October 27, 2025

What's New:

  • Added dedicated Glossary tab in Freight Calculator with 21+ freight and customs terms
  • Implemented editable pricing for 'at actual' charges (inspection fees, storage, etc.)
  • Enhanced all charge tooltips with 'why required' explanations and legal/regulatory context
  • Added detailed definitions for TLUC, Co-loader, Addl Gear, and HS code mapping
  • Reorganized sidebar navigation: Home → Converter → Freight Calculator
  • Fixed Dubai Trade converter numeric validation - id, unit, weight, and amount fields now properly converted to numbers
  • Resolved tablet download errors caused by string-to-number type mismatches in Excel imports

release-20251025-calculator-enhancements

October 25, 2025

What's New:

  • Fixed LCL W/M calculation to correctly use MAX(weight_tons, volume_cbm) formula for sea freight charges
  • Corrected Port Handling minimum logic to distinguish volume minimums from amount minimums
  • Implemented THC mutual exclusivity - Terminal Handling (THC) and DG Handling (THC) cannot be selected together
  • Added automatic THC switching when Dangerous Goods checkbox is toggled in Special Requirements
  • Enhanced cost summary with independent scrolling - breakdown table scrolls separately from page
  • Hidden Package Dimensions section for FCL shipments (only shown for LCL and Air)
  • Simplified Special Requirements by combining Temperature Controlled and Perishable into single 'Refrigerated Cargo (Reefer)' option
  • Compacted total display in cost summary header for better space utilization
  • Added comprehensive tooltips with 21-term freight glossary explaining all abbreviations and charges
  • Enhanced Package Dimensions display with CBM calculations, W/M insights, and visual weight vs volume comparison

release-20251025-tariff-updates

October 25, 2025

What's New:

  • Updated Freight Calculator with latest 2025 tariff pricing from AL FUTTAIM LOGISTICS
  • FCL 20ft/40ft inbound tariffs updated for Jebel Ali Port with new direct, optional, and special handling charges
  • LCL inbound tariffs updated for Jebel Ali CFS with comprehensive charge breakdown
  • FCL 20ft/40ft outbound (export) tariffs updated for Jebel Ali Port
  • LCL outbound (export) tariffs updated for Jebel Ali CFS
  • Calculator now provides accurate real-time cost estimates based on current logistics rates
  • Removed all AFL-related service charges from calculator tariff structures
  • Streamlined navigation by removing version display from sidebar footer

release-20251024-sidebar-calculator

October 24, 2025

What's New:

  • Added compact sidebar navigation for improved site navigation
  • Integrated comprehensive freight cost calculator with live cost summary
  • Implemented 2-column layout with sticky summary for real-time cost visibility
  • Added Google Analytics tracking for all calculator user interactions
  • Track transport mode, direction, container selections, and charge toggles
  • Monitor PDF downloads, share actions, and calculation completions
  • Enhanced user experience with live cost updates as selections change

staging-api-proxy-20251020-1305

October 20, 2025

What's New:

  • Implemented standalone API proxy architecture with automatic fallback
  • All Dubai Trade endpoints now call centralized API server (api.customsez.com)
  • Automatic fallback to local storage if API is unreachable or times out
  • Enhanced reliability and maintainability with centralized API logic
  • API response times optimized (7-24ms average) with 3-second timeout protection
  • Comprehensive logging for monitoring API health and fallback usage

production-hotfix-20251020-1240

October 20, 2025

What's New:

  • Fixed critical rate limiting issue preventing bulk Excel file validation
  • Increased server rate limits from 100 to 10,000 requests per minute
  • Increased Nginx rate limits from 120 to 5,000 requests per minute
  • Large files with hundreds of rows now process without errors
  • Improved system capacity for concurrent validation requests

production-release-20251020-1200

October 20, 2025

What's New:

  • Added 'Who CustomsEZ Is For' section showcasing 4 target user types (Importers, Exporters, Freight Forwarders, Customs Brokers)
  • Enhanced Dubai Trade manual reference with professional badge-style link
  • Added 3 additional official government resources: Services Guide, Integrated Customs Tariff PDF, and Customer Guide PDF
  • Implemented Server Proxy Architecture for enhanced API security
  • Improved link styling and visual consistency across landing and resources pages
  • Updated resources page with complete official documentation library

staging2-release-20251016-1220

October 16, 2025

What's New:

  • Fixed rate limit issues preventing page load for new users
  • Added activation password prompt when rate limits are exceeded
  • Download file now uses the uploaded Excel filename automatically
  • Added validation requirement before proceeding to header page
  • Improved error messages with longer display duration (8 seconds)
  • Enhanced user experience with clear rate limit notifications

staging2-release-20251015-1239

October 15, 2025

What's New:

  • Empty freight and insurance input fields by default instead of showing '0'
  • Fixed Content Security Policy for Google AdSense integration
  • Improved form user experience with cleaner default values
  • Enhanced security headers for better ad platform compatibility

staging1-release-20251014-1800

October 14, 2025

What's New:

  • Added 8-digit HS code truncation option for compatibility
  • Implemented bulk update feature for similar HS codes and country codes
  • Added live preview updates when HS code limit is changed
  • Improved validation workflow with count displays for bulk updates
  • Enhanced user efficiency when fixing multiple similar errors

About Updates

We continuously improve the Dubai Customs Flat File Converter based on user feedback and Dubai Customs requirements.

Updates are deployed to our staging environment first for testing, then to production after thorough validation.

Build ID: b365954 • Branch: dev