DEV Community

Gio Rich
Gio Rich

Posted on

Finding Canadian olive oil importers who already buy from Greece, with Python and the Canadian Importers Database

I built this actor; it's a paid tool on Apify with a free trial credit.

Say you bottle extra virgin olive oil in Greece and want a Canadian distributor. The cold-outreach version of that job is a long list of "food importers in Toronto" that mostly do not touch olive oil. The better version is a list of companies that already import olive oil, and ideally already import it from Greece.

Canada publishes exactly that. Innovation, Science and Economic Development Canada (ISED) runs the Canadian Importers Database (CID): for every HS6 product code and city, the companies that make up the top 80% of import value, with a second file that adds the country of origin. Data year 2024 covers 59,050 importers across 5,659 HS6 codes. It is free, but it ships as large Excel binary workbooks, one row per company x HS6 code (x country in the origin file), with no product descriptions in the same file.

I built Canadian Importers Database Scraper to turn those files into one JSON row per importer, filtered by HS code, keyword, province, city or origin country. The numbers in this post come from the actor's own parsing code run against the live ISED files on 12 November 2026.

Limits first: there are no phone numbers, e-mails, contact names, websites or import values in the CID, so there are none in the output. You get the company name, city, province, postal code, the HS6 products it imports and, with the origin filter, where they come from.

Step 1: every olive oil importer in Canada

HS heading 1509 is olive oil. Ask for it as a 4-digit prefix and the actor expands it to the HS6 codes under it.

from apify_client import ApifyClient

client = ApifyClient("<YOUR_APIFY_TOKEN>")

run = client.actor("rel8ble/canadian-importers-database-scraper").call(run_input={
    "mode": "importers",
    "hsCodes": ["1509"],
    "maxResults": 0,          # 0 = every match
})
importers = client.dataset(run["defaultDatasetId"]).list_items().items
print(len(importers))  # 82
Enter fullscreen mode Exit fullscreen mode

82 importers. The three HS6 codes they are listed under: 150930 virgin olive oil (62 importers), 150920 extra virgin (21) and 150990 refined (10). By province: Ontario 30, Quebec 28, British Columbia 15, Alberta 3, Nova Scotia 1, PEI 1, plus 4 non-resident importers with US addresses (Deoleo Canada in Houston, Certified Origins in Port Chester NY, among others).

Rows come broadest match first, so the top of the list is the companies listed under more than one olive oil code:

company city prov. postal code olive oil HS6 HS6 in database
AZTRADE COMPANY INC. Mont-Royal QC H3R 2K9 150920, 150930 3
C.H.O. AMERIQUE INC. Saint-Laurent QC H4T 1G1 150920, 150990 8
CONCORD SALES LTD. North Vancouver BC V7M 2H1 150920, 150990 13
COSTCO WHOLESALE CANADA LTD Ottawa ON K2E 1C5 150920, 150990 424
DEOLEO CANADA LTD. Houston TX (none) 150920, 150990 3
GROUPE PHOENICIA INC. PHOENICIA GROUP INC. Saint-Laurent QC H4S 1T2 150920, 150930 35
LA MAISON ORPHEE INC Québec QC G1P 4G4 150920, 150930 6
LIMSON CANADA, LTD. Richmond BC V7A 4X6 150920, 150990 19
UNICO INC Concord ON L4K 2A4 150920, 150990 10
WAL-MART CANADA CORP/LA COMPAGNIE WAL-MART DU CANADA Mississauga ON L5N 1P9 150920, 150990 432

totalHs6InDatabase is how many HS6 codes the company appears under anywhere in the CID. It is the only size signal the source gives: Walmart and Costco at 400+ are national retailers, a company at 3 to 15 is usually a specialist importer, which is often the better first call for a small producer.

Step 2: keep the ones already buying from Greece

Add originCountries and the actor switches to the larger by-country file and adds an originCountries field to each row.

run = client.actor("rel8ble/canadian-importers-database-scraper").call(run_input={
    "hsCodes": ["1509"],
    "originCountries": ["Greece"],
    "maxResults": 0,
})
greek = client.dataset(run["defaultDatasetId"]).list_items().items
print(len(greek))  # 16
Enter fullscreen mode Exit fullscreen mode

A trimmed real row:

{
  "companyName": "KRINOS FOODS CANADA LTD.",
  "city": "Concord",
  "provinceCode": "ON",
  "importerCountry": "Canada",
  "postalCode": "L4K 1P6",
  "hs6Codes": ["150920", "150930"],
  "hsDescriptions": ["Olive oil, extra virgin, whether or not refined, but not chemically modified", "Olive oil, virgin, whether or not refined, but not chemically modified"],
  "originCountries": ["Greece"],
  "totalHs6InDatabase": 15,
  "dataYear": 2024,
  "source": "ISED Canadian Importers Database (2024)"
}
Enter fullscreen mode Exit fullscreen mode

Step 3: drop couriers and customs brokers

This is the filter people miss. The CID lists the importer of record, and for small shipments that can be the courier or the customs broker, not the buyer. In the 16 Greek-origin rows, three are FEDEX EXPRESS, FEDEX LOGISTICS CANADA and IMAX CUSTOMS BROKER CORPORATION. (In the full 82-row olive oil list, AEGEAN SEA FREIGHT INC. shows up the same way.)

import re

not_a_buyer = re.compile(r"FEDEX|DHL|\bUPS\b|PUROLATOR|CUSTOMS|FREIGHT|LOGISTICS|EXPRESS")
buyers = [r for r in greek if not not_a_buyer.search(r["companyName"])]
print(len(buyers))  # 13
Enter fullscreen mode Exit fullscreen mode

Keep the dropped rows if you sell freight services; for a producer they are noise.

Step 4: match your grade

An extra virgin producer wants importers listed under 150920. Refined (150990) buyers are a different market, often food service or private label.

evoo = [r for r in buyers if "150920" in r["hs6Codes"]]
evoo.sort(key=lambda r: r["totalHs6InDatabase"], reverse=True)
for r in evoo:
    print(r["companyName"], r["city"], r["provinceCode"], r["postalCode"])
Enter fullscreen mode Exit fullscreen mode

On the real data, 8 of the 13 buy Greek extra virgin oil:

company city prov. postal code Greek olive oil HS6 HS6 in database
GROUPE ALIMENTAIRE MIRON Blainville QC J7C 5S4 150920, 150930 15
KRINOS FOODS CANADA LTD. Concord ON L4K 1P6 150920, 150930 15
SAPORITO FOODS INC Markham ON L3R 1C2 150920 13
PILAROS INTERNATIONAL TRADINGINC Laval QC H7W 5N4 150920 10
LES ALIMENTS PALMOS INC./PALMOS FOODS INC. Saint-Éustache QC J7P 4X5 150920 4
STAVROPOULOS IMPORTS INC. / IMPORTATIONS STAVROPOULOS INC. Saint-Liguori QC J0K 2X0 150920 4
ATTICA FOODS CANADA INC. Woodbridge ON L4L 6Y9 150920 2
ACROPOLIS ORGANICS CORP. Toronto ON M4B 3E5 150920 1

The other five take virgin or refined Greek oil: Kingston Olive Oil Company, Aurelius Food Co. (Ottawa), Lukes Drug Stores (Calgary), Grand Marché Col-Fax (Laval) and Peter & Paul's Baskets and Gifts (Woodbridge). A gift-basket company and a drugstore chain are real buyers too, just not the distributor you are looking for.

Eight named companies, all with a city and postal code, all already clearing Greek extra virgin oil through Canadian customs. That is a short list worth a sample shipment. Look up the company website and buyer yourself; the CID gives you the who and where, not the contact.

Step 5: size the competition

The same origin filter tells you who you are up against. With originCountries set to Italy, Spain, Greece, Portugal, Tunisia and Türkiye, 102 olive oil importers come back. Counting importers per origin country (one importer can buy from several):

from collections import Counter

run = client.actor("rel8ble/canadian-importers-database-scraper").call(run_input={
    "hsCodes": ["1509"],
    "originCountries": ["Italy", "Spain", "Greece", "Portugal", "Tunisia", "Turkey"],
    "maxResults": 0,
})
rows = client.dataset(run["defaultDatasetId"]).list_items().items
print(Counter(c for r in rows for c in r["originCountries"]).most_common())
Enter fullscreen mode Exit fullscreen mode

Italy 39, Portugal 26, Greece 16, Türkiye 13, Spain 11, Tunisia 9. Greek oil reaches fewer Canadian importers than Italian or Portuguese oil, which is either a gap or a warning, depending on your price.

Scaling it up

  • Any HS code works the same way: 2 digits for a chapter (09 coffee, tea and spices), 4 for a heading, 6 for a subheading. productKeywords searches the HS descriptions instead ("olive oil", "bicycle", French words too).
  • provinces and cities narrow by place: ["QC"] for a Quebec-only trade mission, ["Mississauga", "Brampton"] for a warehouse catchment.
  • "mode": "products" returns one row per company x HS6 code, with the French description as well, if you want to pivot by product.
  • The full olive oil pull (82 rows) took 2.5 s on my machine, the origin-filtered one about 5 s, most of it downloading ISED's files. No browser, no login.

Price and caveats

$1.00 per 1,000 results ($0.001 per row), no start fee. Empty searches and failed downloads are not charged. Every olive oil importer in Canada (82 rows) costs about $0.08; the 16-row Greek list costs $0.016.

The CID only names major importers: the companies making up the top 80% of import value for each product and city. Small importers are missing by design, and there are no values, volumes or shares per company. The data year is 2024, the newest ISED publishes. Company names are cut at 60 characters by the source (hence "TRADINGINC"). Non-resident importers have a US state in the province field and no postal code. Contains information licensed under the Open Government Licence - Canada; the actor is not affiliated with or endorsed by ISED or the Government of Canada.

Actor page: https://apify.com/rel8ble/canadian-importers-database-scraper

Need a custom scraper or a ready dataset? Hire me on Fiverr: https://www.fiverr.com/rel8ble

Top comments (0)