Bulk updating data in Sell using a CSV file


What's my plan?

If you're trying to import new data into your Zendesk Sell account, see Importing leads, contacts, and deals using a CSV file. However, if you're trying to update existing data in your account, use the information in this article to understand how to perform bulk updates to existing leads, contacts, or deals using a CSV file.
This article covers the following topics:


Using a CSV import
Splitting people and company contacts
Field types that are unsupported for import


Related articles:


Creating a CSV file to import leads, contacts, or deals
Importing leads and contacts using a CSV file
Importing deals using a CSV file




Using a CSV import

Use the CSV import option to bulk update your existing Leads, Companies (contacts), People (contacts), and Deals in Sell. Every record in your account has a unique ID that will identify an existing lead, contact, or deal in your account, and update the specific record.
To import updates

In Sell, create a Smart List of your leads, contacts or deals. When you export this file, it automatically includes the IDs of each record.
Filter the data to include only the information you want to update. In the Filter section add all the fields you need to edit then export the Smart List.
Your file automatically includes the IDs in the second column, as well as any additional fields you added.

Download and open the exported CSV file in any CSV editing software (Excel, Google Spreadsheets, etc).
Edit the columns containing the data you wanted to update. You can add any new information that you want to import as new custom fields during the import process.
On the Sell sidebar, click the Settings ( ) icon, then click Data > Bulk update.
Select Update existing data.
Select the records that you are updating (Leads, People Contacts, Company Contacts, or Deals) and upload your file.
Map the fields in your file. Make sure that you map at least one column as lead, contact, or deal ID (if you exported a Smart List, it will be the second column). Map all the fields that you want to update to their equivalent Zendesk Sell fields. You have a few choices for each column from the file:


Standard Field: Map this as one of the standard lead/person/company/deal fields

Existing Custom Field: Map this as one of the existing Custom Fields

New Custom Field: You can create a new Custom Field and map the entire column to that field

Tag: You can map a column as a Tag that will be added to the record

Note: You can map this as a Note that will be added to the record


Review your data mapping to verify that your fields are correct. The Sell ID is used to update the records with the data from the columns in your file.

Note: The bulk update cannot be reversed, so ensure your selections are correct when you verify the mapping.


Click Update.
You'll receive an in-app notification when the update is complete. Click the alert icon to view your Notifications Center update.




Splitting people and company contacts

Standard fields and custom fields can differ in your Sell account for people and companies.
To create a file with only people or company contacts


On the Sell sidebar, click the Contacts ( ) icon.
Click the Working Center ( ) menu.
In the Working Center, under Working List, click your Contacts working list.
In the Contact column, click Filter ( ) to select either person or company.



If you are only exporting a list of company contacts, the exported CSV file will populate the Contact ID column instead of the Company ID column.



Field types that are unsupported for import

The following table lists examples of fields that are currently not supported during the import process.


Table 1. Unsupported field types for import



Field
Details




status (lead)
You can update Lead Status using our Leads API endpoint.


unqualified reason (lead)
-


customer status (contact)
You can update Contact Customer Status using our Contacts API endpoint.


prospect status (contact)
You can update Contact Prospect Status using our Contacts API endpoint.


billing address

This is an additional Address field that is available to Contacts that are associated with a Deal.
You can update Billing Address using our Contacts API endpoint.



shipping address

This is an additional Address field that is available to Contacts that are associated with a Deal.
You can update Shipping Address using our Contacts API endpoint.






