Loyalty Tier Groups (Full Update)
Description
If the UUID of the Tier Group Resource exists in the system, or no UUID is provided and an External ID exists, then an update is performed. Otherwise, the resource is created.
See the Aerial Spec for more details.
File Naming Convention
TGEN_tierGroups_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 |
|---|---|---|---|---|
externalId | External identifier of the Tier Group | Max Length: 255 | string | No |
sortOrder | Sort Order for this Tier Group in the list | integer | Yes | |
localizedData | Array of localized Tier Group 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 |
values | List of associated Tier Values | Not a CSV column header. Pass each array element in its own indexed column (values[0], values[1], and so on). | array | No |
values[0] | Array element | mixed | No | |
values[0].tier | Identifier of the associated Customer Tier | string | Yes | |
values[0].colour | The colour associated with the tier in Hex format | Max Length: 255 | string | No |
values[0].definition | The definition of this tier value | string | No | |
values[0].externalId | External identifier of the Tier Value | Max Length: 255 | string | No |
values[0].isHidden | Boolean dictating if Tier Value is hidden (true or false) | boolean | Yes | |
values[0].localizedData | Array of localized Tier Value descriptions | Not a CSV column header. Pass each array element in its own indexed column (values[0].localizedData[0], values[0].localizedData[1], and so on). | array | No |
values[0].localizedData[0] | Array element | mixed | No | |
values[0].localizedData[0].languageCode | Language code the Tier Value is in | string | Yes | |
values[0].localizedData[0].name | The localized name of the Tier Value | Max Length: 255 | string | Yes |
Sample CSV
See the following tierGroups 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.