How to Build an International Buyer CRM

If you export, you may already have a buyer CRM without calling it one: a spreadsheet started by a founder years ago, extended by every salesperson since, with three columns called “Notes”, a tab per trade fair and phone numbers in four different formats. It works until someone leaves, a show brings in 300 new contacts, or you try to send one message to every distributor in Germany.

Building a buyer CRM properly is mostly a design exercise. The decisions below apply whether you end up in a spreadsheet, a general CRM or an export-specific tool. Make them once, write them down, and the database stays useful as it grows.

Start from the questions the database must answer

Before choosing fields, list the questions you want to answer in under a minute. For a typical exporter:

• Who are our buyers in a given country, and who owns each one?
• Which buyers asked about a given product, and what did we last offer them?
• Who did we meet at a particular show, and who has not heard from us since?
• Which buyers are distributors, which are retailers, which are manufacturers?
• Who has agreed to receive WhatsApp messages from us?
• When did this buyer last order, and what?
• Which buyers have we sent samples to and not heard back from?

Every field and tag in your design should help answer one of these. If a proposed column answers none of them, leave it out. Unused columns are where data quality starts to slip, because nobody feels responsible for them.

Accounts and contacts: one company, several people

The first structural decision is whether a record is a company or a person.

In export sales, the company is what you sell to: it issues the purchase order, pays, and appears on the commercial invoice. But you deal with people: a purchasing manager, a quality manager who approves samples, an owner who signs off on new suppliers, an accounts clerk who sends payment confirmations. People also move. The purchasing manager at a Dutch importer may be at a German wholesaler next year.

Three workable models:

For a small or mid-sized exporter, one record per buying company with a clearly named main contact is the right start. Put secondary contacts in a structured note (name, role, email, phone) and promote to a separate model only when you regularly sell to large buyers with several people involved.

Whatever you choose, keep order history on the company. If the purchasing manager leaves, you still need to know that the company bought four containers of chickpeas last year.

The core fields

Here is a field list that covers the questions above without becoming a form nobody fills in. Format rules matter as much as the fields: they decide whether you can filter and deduplicate later.

Notice what is not here: a “status” free-text column, a “comments” column separate from notes, a “priority” column with values like “high!!”. Those are better handled with tags, below.

Country, currency and time zone

International data has specific traps.

• Country names. “UAE”, “U.A.E.”, “United Arab Emirates” and “Emirates” are four countries to a filter. Use one list and pick from it.
• Phone numbers. Store them with the plus sign and country code, without leading zeros after the code. Leave out spaces, dashes and brackets too. A number saved as “0532…” cannot be dialled from abroad or matched against the same number saved as “+90532…”.
• Currency. Record the currency the buyer wants to be quoted in, not the one you prefer. A buyer in Morocco may want EUR; a buyer in Kenya may want USD.
• Time zone. You may not need a separate field: country and city tell you. Where a country spans several zones (the United States, Brazil, Australia), add the city and use it when scheduling messages.

Tags versus fields

This is a decision that is easy to get wrong. A simple rule:

• Use a field when each buyer has exactly one value and you will sort or filter by it: country, owner, currency, business type.
• Use a tag when a buyer can belong to several groups at once, or when membership changes over time: shows attended, products of interest, stage of a conversation, special lists.

A buyer can be tagged “SIAL Paris 2026”, “Gulfood 2027”, “Walnuts”, “Dates”, “Samples sent” and “Private label” all at once. Trying to hold that in fields produces columns called “Show 1”, “Show 2”, “Product 3”.

A tag naming convention

Tags multiply. Without a convention, you end up with “Sial 2026”, “SIAL Paris”, “sial-paris-26” and “SIAL” on different buyers. Agree a prefix scheme and keep a short written list of allowed tags.

Prefixes keep tags grouped when sorted and make their purpose obvious. Review the tag list once a quarter: merge near-duplicates and retire stage tags you no longer use.

Data hygiene that survives a busy season

A buyer database decays on its own. People change jobs, companies change names, and every trade fair adds a batch of records entered in a hurry. Hygiene is a small habit, not a project.

Preventing duplicates

Duplicates are the most damaging problem because they split one buyer’s history across records. Prevent them at entry:

• Search by email, phone number and company name before creating a record.
• Treat the email address and the international phone number as the identifiers. Company names vary too much (“Al Noor Trading LLC”, “Alnoor Trading”, “Al-Noor”).
• When importing a list, match against existing records first and add only new ones. Never let an import overwrite an existing buyer’s data without checking.

Standing rules

• Every new record has country, source and owner
• Phone numbers are in international format
• Generic addresses (info@, sales@) are allowed, but a named contact is added as soon as you have one
• Bounced email addresses are removed or corrected, not left in place
• Buyers who ask not to be contacted have their permission set to no, and the date noted
• Records for contacts who are not buyers (suppliers, press, competitors) are kept out of the buyer list, or clearly tagged

A monthly 30-minute check

Filter for records with no owner, no country or no source and fix them. Search for likely duplicates by sorting on company name. Look at the newest records added by each person and check they follow the format rules. Thirty minutes a month is cheaper than cleaning 2,000 records in a panic before a campaign.

Permissions and consent

Two kinds of permission matter: who may contact the buyer, and who inside your company may see and export the data.

Contact permission. Record, per buyer and per channel, whether you may send them marketing or sales messages, and how you know. “Agreed at stand, SIAL Paris 2026, 19 Oct” is a useful entry; “yes” on its own is not. For WhatsApp, the WhatsApp Business Platform requires businesses to obtain opt-in before sending business-initiated messages. WhatsApp’s guidance says the opt-in must make clear that the person is agreeing to receive messages over WhatsApp and must name the business. For email, the rules depend on where you and your buyers are; check the data protection and marketing rules that apply in your country and in your main markets.

Internal access. Your buyer list is one of the most valuable things your export business owns. Decide who can add records, who can edit them, and who can export the whole list. In a spreadsheet this is hard to control: anyone with the file has everything. That alone is a reason many exporters move to software once the team grows.

Spreadsheet or software

A spreadsheet is a legitimate buyer CRM. It is free, flexible and everyone can use it. It stops being enough at a fairly predictable point.

If two or three of these apply, it is time to move. If none do, a well-designed spreadsheet with the field list above may serve you for another year.

Migrating your buyer data

Whether you move from one spreadsheet to a cleaner one or into software, the steps are the same.

1. Collect every source. The main sheet, each salesperson’s own list, trade show exports, email contacts of past buyers, the accounts system’s customer list.
2. Map columns to your new fields. Decide where each old column goes. Anything that maps to nothing goes into notes or is dropped.
3. Standardise formats. Country names to your list, phone numbers to international format, emails to lower case. Do this in the spreadsheet before importing; it is much faster than fixing records one by one afterwards.
4. Deduplicate. Sort by email, then by phone, then by company name. Merge notes from duplicates into one row.
5. Add tags. Turn old “status” and “show” columns into tags using your naming convention.
6. Import a small batch first. Import 20 records, check them carefully, then import the rest.
7. Freeze the old files. Rename them “ARCHIVE, do not edit” so nobody keeps adding to them.
8. Agree the rules. Share the field list, tag list and hygiene rules with everyone who uses the database.

In Double Export: when you import a CSV or Excel file, duplicate emails and phone numbers are caught and an existing buyer is never overwritten, so you can import overlapping lists without losing data already in the system.

If you are doing this right after a trade show, what to do with your buyer contacts after SIAL Paris covers cleaning a fresh pile of cards and scans. For very large batches, organising hundreds of Gulfood leads sets out a triage method. Once the database is in place, the export lead management guide explains how to qualify and route the leads in it.

How to do this in Double Export

Double Export is a CRM for exporters built around one record per buyer, and each record has a company and a contact person, plus country, email, mobile, WhatsApp, website and address, with notes and tags. There are no separate account and contact objects, so it matches the first model above: keep further people at the same company in a structured note on the record. The record also shows export order history, open orders, spend and last order date, so order history stays with the company.

You can import your cleaned spreadsheet as a CSV or Excel file. Search works by company, contact, email or phone, and you can filter by country and tag. Tags follow whatever naming convention you set, and they double as campaign audiences: a buyer tagged “List: New crop updates” next month joins any campaign aimed at that tag automatically.

Each buyer has email and WhatsApp permission settings. Buyers with WhatsApp permission off or no number are left out of WhatsApp campaigns, and buyers with email permission off are left out of email campaigns. Email, WhatsApp and call buttons sit on the record.

From there, export lead management covers working the leads in the database, and Product Sheets let you link a sheet of specifications and prices to a buyer. Pricing lists the plans, from Starter at $49 a month to Scale at $299.