Importing Contact

Peasy Sales allows you to bulk import contacts from a CSV file. To import contacts

     1. Navigate to contacts from the sidebar.

     2. Click on the Import button on the top right corner.

     3. Select the CSV file you would like to import to Peasy Sales, here’s a sample

         CSV file for reference.

     4. Click on the Import button to upload the csv file to complete the process.

 
 
Original Format Import Template Contact is as per below:
 

VariablesStateDescriptionNotes
nameMandatoryCustomer Name

1)No special Characters

2)Follow exactly variables name

emailMandatory (if phone_number is empty)Customer Email

1)No special Characters

2)Follow exactly variables name

3)email format must be lowercase.

identifierOptionalDefault IdentifiersCan be removed.
phone_numberMandatory (if email is empty)Customer Phone Number

1) Make sure phone number format is correct. Eg: Start with ‘+601137777777

2)Follow exactly variables name.

statusMandatoryLead StatusMust be either New/ Reach/  Qualified/ Disqualified/ Negotiating/ Won/ Lost
custom_attributes_1OptionalAdditional custom attributes

1)Can be removed.

2)If you want to add custom attributes examples: t-shirts size you can added in while maintaining the variables name.

custom_attributes_2OptionalAdditional custom attributes

1)Can be removed.

2)If you want to add custom attributes examples: combo package A,  you can added in while maintaining the variables name.

Do’s before Importing Customer Contacts:

  1. Do make sure using the same download sample template and save it in .CSV format UTF-8 (Comma Delimited) 
  2. Do check phone_number attributes format. Make sure the phone number is store in the correct format. 

How to Check Template is in Correct Format (.CSV Format)

Click Download Contact Location >Right Click >Properties>Open With> Notepad

Click Open with Notepad:

Finally!! Contact Can Be Uploaded.

Common Errors #

My contact list is not updated after uploading the file #

Depending on the size of your contact list, importing contacts may take some time. As a general rule of thumb, every 100 contacts will take at least 10 minutes. Please check your contact list after some time.

My contact list is not updated after uploading the file after waiting several hours #

Please check:

  • That you’re using the right file format. Peasy only accept CSV (Comma-delimited) UTF-8
  • That you have all of the mandatory columns in your contact list (name, email/phone_number, status)
  • That all of your mandatory columns header are exactly as specified (lower case, no space, ie “phone_number” and not “Phone_number” or “phone number”)
  • That your custom attribute’s column headers does not contain spaces (ie “shirt_size” and not “shirt size”)
  • That your custom attribute data value matches your custom attribute type definition. For example, if you have defined “height” as numerical in your custom attribute definition, if your contact list have a “height” column header, the values for that column must be numerical.
  • That phone numbers in your contact list have a country code prefix.

What if I have duplicate contacts in my contact list? #

Contacts are identified by their email and phone number in Peasy. You can have multiple contacts with the same name, but never the same email and phone combination. Suppose you have an existing contact with these attributes:

  1. Name: John
  2. Phone number: 123456
  3. Email: empty

And if you try to import a contact list in this order:

NamePhone NumberEmailshirt_sizeResult
Peter123456 mNew name and shirt_size attribute will be saved
John123456[email protected]mNew name and email attribute will be saved 
John123456[email protected]mError. This row will be skipped since phone number 123456 is already matched to [email protected]
John123456[email protected]sshirt_size attribute will be saved

What would happened if there are erroneous rows in my contact list #

  1. If your contact list has a missing mandatory column headers, the entire file will be rejected. Not a single contact will be imported. Please add the missing column headers before importing.
  2. If your contact list is saved in a different file format other than CSV UTF-8 Comma Delimited, the entire file will be rejected. Please save the file in the correct format before uploading again.
  3. Otherwise, Peasy will skip the errorneous row and continue to import the rest of the file.
Did you find this article to be helpful?
Updated on July 3, 2023

Sign up for Peasy

Just enter your email and password to start using Peasy for free! We will re-direct you to our login page as soon as you are registered.

[fluentform id="5"]

Apply for the BSN SME Digitization Grant

Get RM2,000 worth of FB Ad Credits and 1 year subscription of Peasy Gold Free

[fluentform id="3"]