+65 8544 7467
SINOBTD TRADEDAAS

Colombia Trade Data

Home Colombia
Colombia
Colombia Trade Data
Data Characteristics

+ One-click request for business information and contact information of both buyers and sellers;

+ Quickly locate accurate buyers and obtain market information at the first time;

+ Colombia is at a medium level of development in Latin America. Its main export products are petroleum and petroleum products, chemical products, coal, coffee, agricultural by-products and textiles, etc. It mainly imports machinery and equipment, chemical products, agricultural by-products, textiles and metal materials. The main trading partners are the United States, China, Mexico and Japan.

Data Content

Colombia Weekly Customs Data is built on import declaration records published by the Colombian customs authority (DIAN), covering goods entering Colombia. It provides the importer's registered name with NIT code (sample: 95 24 COLOMBIA S.A.S, 900397674), a unique auxiliary-enterprises module (carrier + customs broker with code), contract-level commercial references (contract No., signing date, payment reference, container No.), and triple-currency pricing (USD + COP peso + CNY) with FOB→CIF breakdown. Below is a complete breakdown of the data field system, illustrated with a sample record (Colombia import, August 2026).

I. Data Overview

Data TypeImport Customs Data (Weekly)
Data SourceColombian Customs Authority (DIAN)
Total Fields75+ fields across 6 major modules
CoverageImporter (name + NIT + customs district), Exporter (with full address), Auxiliary Enterprises (carrier, broker — unique), Goods (declaration-referenced descriptions), Logistics (contract, container, payment references), Volume & Price (USD + COP + CNY)
Update FrequencyWeekly updates with full historical backfill (sample record: month 202608, dated 2026/8/30)

II. Field Module Structure

No.Module NameFieldsRepresentative FieldsTrade Value
1Declaration Basics4Month (202608), Date (2026/8/30), HS Code (3214101000), Declaration No. (0)★★★☆☆
2Importer (Buyer) Information6Importer (95 24 COLOMBIA S.A.S), Enterprise Code (NIT 900397674), Spanish Name (95 24 COLOMBIA S.A.S.), Country (Colombia, CO), Contact/Reference (1121967966), Customs District (1081002)★★★★★
3Exporter (Supplier) Information6Foreign Exporter (TRUPER SA DE C V), Local Name (TRUPER S.A. DE C.V.), Country (Mexico, MX), City (MEXICO), Address (PARQUE INDUSTRIAL NO 1, JILOTEPEC, ESTADO)★★★★☆
4Auxiliary Enterprises4Carrier (TRANSPORTES SARVI SAS), Customs Broker (INTERLACE AGENCIA DE ADUANAS SAS NIVEL 2), Broker Code (901076655)★★★★★
5Goods & Commercial References14HS Code (3214101000), Product Description (MASTICS, POLYESTER FILLINGS), Declaration-Referenced Name (DO 2026-06978 DECLARACION(60-137) /PEDIDO 2581/...), Contract No. (62509995), Contract Date (20260721), Container No. (9134850589), Payment Reference (32820199)★★★★☆
6Volume & Price17Gross Weight (65 kg), Net Weight (64 kg / 0.064 metric tons), FOB USD (273, unit 4.2663), CIF USD (276, unit 4.3125), Freight (3 USD), COP Peso Total (845.388, unit 13,209.1875), Duty Rate (10%), CNY Total (1,859, unit 20.08442)★★★★★

III. Core Data Highlights

🚚 Auxiliary-Enterprises Module

Unique to this dataset: the carrier (TRANSPORTES SARVI SAS) and the customs broker (INTERLACE AGENCIA DE ADUANAS SAS NIVEL 2, code 901076655) are named per record — map the full service ecosystem around every buyer.

📄 Contract-Level References

Commercial contract data is embedded: Contract No. 62509995 signed 20260721, payment reference 32820199, container 9134850589 — linking customs records to actual trade contracts.

💱 Triple-Currency Pricing

Values in USD (CIF 276, 4.3125/kg), COP peso (845.388, 13,209.1875 per unit basis) and CNY (1,859, 20.08442/kg) — implied rate ≈ 3,062 COP/USD for FX back-testing.

🏭 Supplier with Full Address

The exporter carries a street-level address (PARQUE INDUSTRIAL NO 1, JILOTEPEC, ESTADO — TRUPER's industrial park in Mexico) — TRUPER being Latin America's largest hand-tool maker — enabling plant-level supplier verification.

📄 Declaration-Linked Product Names

Detailed names carry the underlying declaration reference (DO 2026-06978, PEDIDO 2581) — trace each customs line back to its source filing.

IV. Usage Scenarios

ScenarioCore FieldsCorrelated Fields
🏢 Find Colombian BuyersImporter, NIT, Customs DistrictProduct Description, CIF USD, Month
🗺️ Map Service EcosystemsCarrier (TRANSPORTES SARVI SAS), Broker (INTERLACE... NIVEL 2)Importer, Customs District
📄 Contract-Risk AnalysisContract No. + Signing Date + Payment ReferenceDeclaration Date (20260824), Container No.
💰 Landed-Cost AnalysisFOB (273), Freight (3), CIF (276), Duty Rate (10%)Net Weight (64 kg), COP/CNY Values
📈 Market SizingHS Code, CIF USD AmountWeekly Trend, Origin Distribution, Industry

💡 Data Value Highlight

Colombia Weekly Customs Data delivers a unique carrier + customs-broker module, contract-level commercial references (No., signing date, payment), street-level supplier addresses and triple-currency pricing (USD + COP + CNY) — ideal for Colombian buyer development, logistics-ecosystem mapping and contract-linked trade verification.

Part 1 — Basics

Q1: What is Colombia Weekly Customs Data?

Colombia Weekly Customs Data covers import declaration records for Colombia (CO) from DIAN, the Colombian customs authority. Each record contains the importer with NIT code, exporter with street-level address, a unique auxiliary-enterprises module (carrier + customs broker), contract-level commercial references, declaration-linked product names, and triple-currency pricing. The sample record shown is an August 2026 import of mastics and polyester fillings (HS 3214101000) by 95 24 COLOMBIA S.A.S from TRUPER SA DE C V of Mexico.

Q2: What makes Colombia data unique?

Four core differentiators:
                  1. Auxiliary-enterprises module — carrier and customs broker named per record, with broker code.
                  2. Contract-level references — contract No., signing date and payment reference embedded in each declaration.
                  3. Street-level exporter addresses — plant-level supplier verification.
                  4. Weekly updates — faster monitoring than monthly Andean datasets.

Q3: How frequently is the data updated?

Weekly, with full historical backfill. The sample record is month 202608, dated 2026/8/30 (declaration filed 20260824, contract signed 20260721), HS code 3214101000.

Part 2 — Field Walkthrough

Q4: How do I read the importer and entity-type fields?

- Importer (95 24 COLOMBIA S.A.S): "S.A.S" = sociedad por acciones simplificada, Colombia's simplified joint-stock company.
                  - NIT (900397674): the Colombian tax ID — deduplicate and verify in DIAN/RUES registries.
                  - Customs District (1081002) and reference (1121967966) localize the clearance and filing.
                  - Note: carriers and brokers here are also S.A.S entities (TRANSPORTES SARVI SAS; INTERLACE AGENCIA DE ADUANAS SAS NIVEL 2) — "NIVEL 2" indicates the broker's licence level.

Q5: What is in the Auxiliary Enterprises module?

Per record, two service parties are named:
                  - Carrier: TRANSPORTES SARVI SAS — the trucking company.
                  - Customs broker: INTERLACE AGENCIA DE Aduanas SAS NIVEL 2, code 901076655.

                  Aggregate these fields to map which brokers and truckers serve which buyers — a prospecting list for logistics services, or a competitive-intel map for traders.

Q6: What product is HS code 3214101000?

HS 3214101000 covers mastics and polyester fillings (glaziers' putty, grafting mastic, sealants and similar preparations). The sample's detailed name references its source filing (DO 2026-06978 DECLARACION(60-137) /PEDIDO 2581/ MERCANCA NUEVA DE PRIMERA CALIDAD...). It belongs to:
                  - Sub-industry: Other Chemicals; Industry: Chemicals

                  Typical uses: construction sealants, automotive body fillers, industrial adhesives.

Q7: Which currencies does Colombia data support?

Three value views:
                  - USD: FOB 273 (4.2663/kg); CIF 276 (4.3125/kg)
                  - COP peso: total 845.388; unit-price basis 13,209.1875
                  - CNY: total 1,859 (20.08442 per kg)

                  Cost chain: FOB 273 + freight 3 = CIF 276; duty rate field: 10%.

Q8: How do the contract and logistics references fit together?

The record embeds a timeline: contract 62509995 signed 20260721 → declaration filed 20260824 → record dated 2026/8/30.
                  - Container No.: 9134850589; payment reference: 32820199.
                  - Route: origin Mexico (MX), economic zone North America, supplier TRUPER SA DE C V (PARQUE INDUSTRIAL NO 1, JILOTEPEC).

                  The ~34-day contract-to-clearance span is a usable order-cycle benchmark.

Part 3 — Usage Scenarios

Q9: How do I develop Colombian buyers?

Steps:
                  1. Filter by HS chapter (this sample: 3214 — mastics and sealants) and week.
                  2. Extract buyer name and NIT (95 24 COLOMBIA S.A.S, 900397674).
                  3. Check repeat-import frequency by NIT across weeks.
                  4. Pitch in Spanish referencing the exact filling/sealant grades and their current Mexican supply source.

Q10: How do I map the logistics ecosystem around a buyer?

Steps:
                  1. Pull all records for a target NIT.
                  2. Tabulate the carrier (TRANSPORTES SARVI SAS) and broker (INTERLACE... NIVEL 2) on each record.
                  3. Rank brokers by record count and value share per customs district.
                  4. Approach incumbent brokers for partnerships — or target buyers whose broker coverage looks thin.

Q11: How do I verify a supplier with the address fields?

Steps:
                  1. Read the exporter's street address (PARQUE INDUSTRIAL NO 1, JILOTEPEC, ESTADO — an industrial park).
                  2. Cross-check the local name (TRUPER S.A. DE C.V.) against Mexican SIP/registry data.
                  3. Confirm consistency with origin country (Mexico, MX) and shipping route.
                  4. Flag mismatches between declared country and address country as data-quality risks.

Part 4 — Data Analysis

Q12: How do I analyze order-cycle times?

Analytical dimensions:
                  1. Contract → declaration: signing (20260721) to filing (20260824) ≈ 34 days in this sample.
                  2. Declaration → record date: 20260824 to 2026/8/30 ≈ 6 days clearance-to-entry.
                  3. By lane: compare cycles for Mexico-origin (this sample) vs China-origin vs US-origin goods.
                  4. By broker: clearance speed differences across agencies.

Q13: How do I spot hot products and assess risk?

Hot products: rank import value by HS code; flag YoY growth > 20%; mastics and polyester fillings (this sample) track Colombia's construction and automotive-refinish demand.

                  Risk framework:
                  1. FX risk — COP volatility; back-test with the parallel USD/COP values (implied ≈3,062).
                  2. Concentration risk — small buyer bases per HS code can hinge on one Mexican supplier (this sample: TRUPER).
                  3. Data risk — declaration-referenced product names (DO 2026-06978...) are long; parse the PEDIDO/DECLARACION tokens before text-matching.

How to use Colombia trade data

Use this page’s data introduction and sample to assess Colombia import and export research. Match the record type and available fields to your business question before comparing markets or companies.

Which fields should I check?

Check the reporting country, import or export direction, period, product description or HS code, units and available company fields. Customs records, shipment records and aggregate statistics do not necessarily contain the same information.

What period and update frequency are available?

Request confirmation of the latest reporting period, historical coverage and update frequency for the specific extract. A sample illustrates its format; it is not evidence of current delivery coverage.

How do I request a relevant sample?

Provide the country, product or HS code, trade direction, required period and the business question. Identify the fields you need so that their availability can be checked before selecting a service.

Talk to our trade intelligence team

Need a clearer view of your market?

Tell us the market, company, product or supply-chain question you are working on.

Start an enquiry ↗