Skip to main content

How to Import Phone Numbers into the edrone System

Importing phone numbers is a quick way to enable effective SMS communication and achieve better results.

Written by Klaudia Lewandowska

Importing phone numbers is a quick way to enable SMS and WhatsApp communication with your contacts.


​

You can import phone numbers in two ways: together with an email address, or on their own. Both follow the same import flow described in "Importing your database into edrone" — go to CRM > Import, choose "Import contacts" in the Import Wizard, select your file, and confirm the mapping, tags, and import settings on the Confirm Import screen. Here's what's specific to phone numbers.


Importing contacts with email and phone number

Make sure your file has a column with the email address and a column with the phone number.


​

On the Confirm Import screen, map each column to the right field — Email and Phone number — using the dropdown at the top of each column.


​

Note: SMS campaigns can only be sent to contacts with the SMS status "Subscribers".

If your file doesn't include a subscription status column (or some cells are empty), go to the Import Settings panel and pick the default status under "Subscription status for contacts with empty cells" — separately for the Email, SMS, and WhatsApp channels.

If you do import a status column, keep in mind: negative values (like "no" or "0") always come in as "Customers". Only explicit unsubscribe values (like "unsubscribed", "opt-out", or "wypisany") come in as "Unsubscribed".


​

Important: pay attention to the subscription status you choose for SMS and Email. Are you adding phone numbers collected from past orders, without marketing consent? Set the status to "Customers". Only set a contact to "Subscribers" when you have their explicit consent to receive marketing content.


​

Also important: in edrone, a phone number can only be linked to one email address. If your file has duplicate phone numbers, the number gets assigned to whichever email address appears first in the file.


​

When everything looks right, confirm the settings and start the import.


Importing contacts with phone number only

Prepare your file with the phone number column (and any other fields you want to include), then upload it the same way.


​

On the Confirm Import screen, map the phone number column — the system usually maps it automatically, but you can adjust it manually.


​

Tip: you can also import a WhatsApp subscription status. Just add an extra column to your file for it, and map that column during import.


​

If your file doesn't include subscription status columns, set the SMS and WhatsApp statuses in the Import Settings panel, under "Subscription status for contacts with empty cells".


​

Confirm the settings and start the import.


​

Contacts and tags show up in the system within a few minutes. Segments can take up to 24 hours to reflect the imported data.


Need more help?
If you have any further questions about importing contacts into edrone, please do not hesitate to contact us at hello@edrone.me

Did this answer your question?