Email Templates (Full Update)
Description
See the Aerial Spec for more details.
File Naming Convention
TGEN_emailTemplates_fullupdate_2025-08_<optionalSuffix>.csv
importType:fullupdateapiVersion:2025-08
Columns
| Column Header | Description | Key Information | Type | Required |
|---|---|---|---|---|
externalId | Integrator provided unique identifier for the template. Typically used to map a primary key from a third party system to the Tulip resource. | Max Length: 32 | string | No |
subject | Subject of the template | Max Length: 160 | string | No |
name | Name of the template | Max Length: 160 | string | No |
content | HTML Document for the structure of the template | string | No | |
languageCode | The language code of the template | Max Length: 5 | string | No |
defaultText | Default Content for the template (to replace the {{content}} tag in the structure) | string | No | |
thumbnailUrl | URL for the email template thumbnail | string | No | |
category | The category in which the email template belongs | Max Length: 36 | string | No |
stores | List of associated store UUIDs | array | No | |
stores[0] | Array element | string | No | |
storeGroup | N/A | mixed | No | |
storeGroup.externalId | The external identifier of the store group | string | No | |
storeGroup.type | Type of the store group | Allowed: DYNAMIC, STATIC | string | No |
storeGroup.name | Name of the store group | string | No | |
storeGroup.description | Description of the store group | string | No | |
storeGroup.rules | Rules for membership in the store group. Valid keys: countryCode, disabled, district and storeType | object | No | |
isGlobal | Determines the visibility scope of the template. If true, the template is ‘Global’ and accessible by all stores automatically. If false, the template’s visibility is restricted to specific store or group assignments (if any). | boolean | No |
Sample CSV
See the following emailTemplates CSV sample file.