Advanced development Industrial distribution and logistics

Intelligent Transport Agency Manager

Grupo Cartes · 12 weeks

1.6M+

Tariff rows normalized

9+

Carriers integrated

<20s

Processing time

52K+

Postal codes mapped

Google GeminiNLPPythonSQL Server

Context

Grupo Cartes works with multiple transport carriers (DHL, GLS, TIPSA, Mensaluz, etc.) and needs to dynamically redistribute shipment volume.

The challenge

  • Each carrier sends tariffs in completely different formats
  • Objective comparison between carriers: practically impossible
  • Requesting quotes: days-long manual process
  • Redistributing load: manual, error-prone process

The solution

Automatic tariff normalization

AI (Gemini) interprets and normalizes disparate data structures from 9+ carriers, expanding geographic zones to 52,000+ postal codes. Result: 1.6M+ rows in a unified database, processed in under 20 seconds.

Dynamic load redistribution

Target distribution percentages, geographic exclusions, backup carriers and complete traceability.

Automated email bidding

Mass quote requests, intelligent response detection, visual offer comparison and award workflow.

Results

  • Direct tariff comparison across all carriers
  • Procurement process: from days to hours
  • Redistribution without complex manual intervention
  • Decisions based on objective data

Business impact

AspectBeforeAfter
Compare tariffsImpossible (incompatible formats)Instant (unified database)
Request quotesDays of manual emailsHours (automated bidding)
Decision basisSubjective / personal relationshipsObjective / normalized data
Geographic coveragePartial52K+ postal codes mapped

With 1.6M+ normalized tariff rows, cost comparison that was manually impossible is now instant. Carrier negotiations shift from relationship-based to data-driven.

Status: IN ADVANCED DEVELOPMENT

Ready to optimize your operations?

Free 30-minute diagnosis. No commitment, no smoke.