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
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
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)"
}
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
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"])
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())
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 (
09coffee, tea and spices), 4 for a heading, 6 for a subheading.productKeywordssearches the HS descriptions instead ("olive oil","bicycle", French words too). -
provincesandcitiesnarrow 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)