Loyalty Tier Values (Full Update)
Description
Upserts Tier Value Resources synchronously. Does not handle partial successes or failures if multiple are provided.
See the Aerial Spec for more details.
File Naming Convention
TGEN_tierValues_fullupdate_2026-08_<optionalSuffix>.csv
importType:fullupdateapiVersion:2026-08
Columns
Nested object fields are flattened into columns using dot notation (parent.child). Array fields are flattened using zero-based index notation, one element per column (field[0], field[1], and so on).
Note: A whole array cannot be passed in a single column: a literal value such as ['value-1','value-2'] will be rejected. To import multiple array elements, add one indexed column per element. Rows in the table below with type array describe the field as a whole and are not valid CSV column headers.
| Column Header | Description | Key Information | Type | Required |
|---|---|---|---|---|
uuid | Unique Tulip identifier of the Tier Value | string | Yes | |
tier | Identifier of the associated Customer Tier | string | Yes | |
colour | The colour associated with the tier in Hex format | Max Length: 255 | string | No |
definition | The definition of this tier value | string | No | |
externalId | External identifier of the Tier Value | Max Length: 255 | string | No |
isHidden | Boolean dictating if Tier Value is hidden (true or false) | boolean | Yes | |
localizedData | Array of localized Tier Value descriptions | Not a CSV column header. Pass each array element in its own indexed column (localizedData[0], localizedData[1], and so on). | array | No |
localizedData[0] | Array element | mixed | No | |
localizedData[0].languageCode | Language code the Tier Value is in | string | Yes | |
localizedData[0].name | The localized name of the Tier Value | Max Length: 255 | string | Yes |
Sample CSV
See the following tierValues CSV sample file.
Note: The sample CSV may contain sample ID fields which reference other resources that do not match the data in your environment.