Customers (Partial Update)
File Naming Convention
TGEN_customers_partialupdate_2025-08_<optionalSuffix>.csv
importType:partialupdateapiVersion:2025-08
Columns
| Column Header | Description | Type | Required |
|---|---|---|---|
uuid | Unique Tulip identifier of the customer. Required for patching. | string | No |
externalId | Integrator provided unique identifier for the customer. | string | No |
firstName | First name of the customer. | string | No |
lastName | Last name of the customer. | string | No |
prefix | Customer name prefix (Title). | string | No |
suffix | Customer name suffix. | string | No |
disabled | Boolean dictating if customer status is disabled or not. | boolean | No |
excludeFromCampaigns | Boolean dictating if customer is excluded from marketing campaigns or not | boolean | No |
image | Image URL of the customer. | string | No |
attributes | Attribute Values associated with this customer. Supports SET_AS_NULL. | string | No |
attributes[0].value | Value of the attribute | mixed | Yes |
attributes[0].attributeExternalId | “Integrator provided unique identifier for the attribute. Typically used to map a primary key from a third party system to the Tulip resource. | string | Yes |
attributes[0].languageExternalId | External ID of the language | string | No |
addresses | Addresses associated with this Customer. Supports SET_AS_NULL. | string | No |
addresses[0].uuid | Unique Tulip identifier of the address. Required for patching. | string | No |
addresses[0].externalId | Integrator provided unique identifier for the address. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
addresses[0].address1 | Address line 1: street number and street name | string | No |
addresses[0].city | City | string | No |
addresses[0].countryCode | Country ISO code in ISO-3166-3 format | string | No |
addresses[0].zoneCode | Concatenation of Country ISO code in ISO-3166-2 format and State/Province in ISO-3166-2 | string | No |
addresses[0].postCode | Postal code of the address | string | No |
addresses[0].address2 | Address line 2 | string | No |
addresses[0].firstName | First name associated to the address | string | No |
addresses[0].lastName | Last name associated to the address | string | No |
addresses[0].phone | Phone number associated to the address (E.164 standard) | string | No |
addresses[0].emailAddress | Email address associated to the address | string | No |
addresses[0].type | Type of address | string | No |
addresses[0].disabled | Boolean dictating if address is disabled (true or false) | boolean | No |
addresses[0].isPrimary | Boolean dictating if address is the primary address for the customer | boolean | No |
importantDates | Important Dates associated with this Customer. Supports SET_AS_NULL. | string | No |
importantDates[0].uuid | Unique Tulip identifier of the important date. Required for patching. | string | No |
importantDates[0].type | Type of important date | string | No |
importantDates[0].title | Description of the important date | string | No |
importantDates[0].date | Important date of the customer in RFC3339 format | string | No |
importantDates[0].externalId | Integrator provided unique identifier for the important date. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
emailAddresses | Email Addresses associated with this Customer. Supports SET_AS_NULL. | string | No |
emailAddresses[0].uuid | Unique Tulip identifier of the email address. Required for patching. | string | No |
emailAddresses[0].externalId | Integrator provided unique identifier for the email address. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
emailAddresses[0].emailAddress | The email address. | string | No |
emailAddresses[0].type | Type of email address. | string | No |
emailAddresses[0].isPrimary | Boolean dictating if this is the primary email address for the customer. | boolean | No |
emailAddresses[0].disabled | Boolean dictating if the email address is disabled (true or false). | boolean | No |
emailAddresses[0].attributes | Attribute Values associated with this email address. Supports SET_AS_NULL. | string | No |
emailAddresses[0].attributes[0].value | Value of the attribute | mixed | Yes |
emailAddresses[0].attributes[0].attributeExternalId | “Integrator provided unique identifier for the attribute. Typically used to map a primary key from a third party system to the Tulip resource. | string | Yes |
emailAddresses[0].attributes[0].languageExternalId | External ID of the language | string | No |
phoneNumbers | Phone Numbers associated with this Customer. Supports SET_AS_NULL. | string | No |
phoneNumbers[0].uuid | Unique Tulip identifier of the phone number. Required for patching. | string | No |
phoneNumbers[0].externalId | Integrator provided unique identifier for the phone number. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
phoneNumbers[0].type | Type of phone number | string | No |
phoneNumbers[0].disabled | Boolean dictating if the phone number is disabled (true or false) | boolean | No |
phoneNumbers[0].isPrimary | Boolean dictating if the phone number is the primary phone number for the customer | boolean | No |
phoneNumbers[0].number | Phone number for the customer in E.164 standard | string | No |
phoneNumbers[0].countryExternalId | External ID of the country this phone number belongs to. Detected automatically using number if not provided. | string | No |
phoneNumbers[0].attributes | Attribute Values associated with this phone number. Supports SET_AS_NULL. | string | No |
phoneNumbers[0].attributes[0].value | Value of the attribute | mixed | Yes |
phoneNumbers[0].attributes[0].attributeExternalId | “Integrator provided unique identifier for the attribute. Typically used to map a primary key from a third party system to the Tulip resource. | string | Yes |
phoneNumbers[0].attributes[0].languageExternalId | External ID of the language | string | No |
loyaltyTiers | Loyalty Tiers associated with this Customer. Supports SET_AS_NULL. | string | No |
loyaltyTiers[0].uuid | Unique Tulip identifier of the Tier Value | string | Yes |
loyaltyTiers[0].tier | Identifier of the associated Customer Tier | string | Yes |
loyaltyTiers[0].colour | The colour associated with the tier in Hex format | string | No |
loyaltyTiers[0].definition | The definition of this tier value | string | No |
loyaltyTiers[0].externalId | External identifier of the Tier Value | string | No |
loyaltyTiers[0].isHidden | Boolean dictating if Tier Value is hidden (true or false) | boolean | Yes |
loyaltyTiers[0].localizedData | Array of localized Tier Value descriptions | array | No |
loyaltyTiers[0].localizedData[0].languageCode | Language code the Tier Value is in | string | Yes |
loyaltyTiers[0].localizedData[0].name | The localized name of the Tier Value | string | Yes |
preferences | N/A | mixed | No |
preferences.likes | Array of liked customer preferences. Supports SET_AS_NULL. | string | No |
preferences.likes[0].uuid | Unique Tulip identifier of the customerPreferenceValue | string | No |
preferences.likes[0].externalId | External ID of the customerPreferenceValue | string | No |
preferences.likes[0].disabled | Boolean dictating if this preference value is disabled (true or false) | boolean | No |
preferences.likes[0].type | The customer preference this value belongs to (External ID or UUID) | mixed | Yes |
preferences.likes[0].type.externalId | Integrator provided unique identifier for the customer preference. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
preferences.likes[0].type.displayType | Display type for this preference | string | Yes |
preferences.likes[0].type.sortOrder | Sort order for this preference in the list | integer | Yes |
preferences.likes[0].type.allowDislikes | Boolean dictating if dislikes are allowed for this preference (true or false) | boolean | No |
preferences.likes[0].type.isSingleSelect | Boolean dictating if only one value can be assigned per-customer (true or false) | boolean | No |
preferences.likes[0].type.isFilterable | Boolean dictating if value is filterable or not (true or false) | boolean | No |
preferences.likes[0].type.disabled | Boolean dictating if this preference is disabled (true or false) | boolean | No |
preferences.likes[0].type.localizedData | Localized data for name and description with associated language | array | No |
preferences.likes[0].sortOrder | Sort order for this preference value in the list | integer | Yes |
preferences.likes[0].localizedData | Localized data for value and presentation with associated language | array | No |
preferences.likes[0].localizedData[0].value | Value of the Customer Preference Value | string | Yes |
preferences.likes[0].localizedData[0].presentation | Presentation of the Customer Preference Value localization (URL, Hex or String) | string | No |
preferences.likes[0].localizedData[0].languageCode | Language code the Customer Preference Value is in | string | Yes |
preferences.dislikes | Array of disliked customer preferences. Supports SET_AS_NULL. | string | No |
preferences.dislikes[0].uuid | Unique Tulip identifier of the customerPreferenceValue | string | No |
preferences.dislikes[0].externalId | External ID of the customerPreferenceValue | string | No |
preferences.dislikes[0].disabled | Boolean dictating if this preference value is disabled (true or false) | boolean | No |
preferences.dislikes[0].type | The customer preference this value belongs to (External ID or UUID) | mixed | Yes |
preferences.dislikes[0].type.externalId | Integrator provided unique identifier for the customer preference. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
preferences.dislikes[0].type.displayType | Display type for this preference | string | Yes |
preferences.dislikes[0].type.sortOrder | Sort order for this preference in the list | integer | Yes |
preferences.dislikes[0].type.allowDislikes | Boolean dictating if dislikes are allowed for this preference (true or false) | boolean | No |
preferences.dislikes[0].type.isSingleSelect | Boolean dictating if only one value can be assigned per-customer (true or false) | boolean | No |
preferences.dislikes[0].type.isFilterable | Boolean dictating if value is filterable or not (true or false) | boolean | No |
preferences.dislikes[0].type.disabled | Boolean dictating if this preference is disabled (true or false) | boolean | No |
preferences.dislikes[0].type.localizedData | Localized data for name and description with associated language | array | No |
preferences.dislikes[0].sortOrder | Sort order for this preference value in the list | integer | Yes |
preferences.dislikes[0].localizedData | Localized data for value and presentation with associated language | array | No |
preferences.dislikes[0].localizedData[0].value | Value of the Customer Preference Value | string | Yes |
preferences.dislikes[0].localizedData[0].presentation | Presentation of the Customer Preference Value localization (URL, Hex or String) | string | No |
preferences.dislikes[0].localizedData[0].languageCode | Language code the Customer Preference Value is in | string | Yes |
socialProfiles | Social profiles associated with this customer. Supports SET_AS_NULL. | string | No |
socialProfiles[0].uuid | Unique Tulip identifier of the social profile. Required for patching. | string | No |
socialProfiles[0].externalId | Integrator provided unique identifier for the social profile. Typically used to map a primary key from a third party system to the Tulip resource. | string | No |
socialProfiles[0].type | Type of social profile. | string | No |
socialProfiles[0].value | Value of the social profile (e.g., username, phone number, URL). | string | No |
socialProfiles[0].isPrimary | Boolean dictating if this is the primary social profile of this type for the customer. | boolean | No |
socialProfiles[0].disabled | Boolean dictating if the social profile is disabled (true or false). | boolean | No |
Sample CSV
See the following customers CSV sample file.