Where do you find Manage database?

Go to Settings in the left menu and click Manage database. The page has three tabs: Contact fields, Product fields and Order fields. Per tab you'll see two sections:

  • Xendy fields: the fixed fields that Xendy uses, with for each field the column from your database that fills it (columns Xendy field and Your column). Fields with the Required badge are needed by Xendy to be able to send emails and calculate revenue; fields with Recommended are not required, but they allow Xendy to do more for you.
  • Other fields: all remaining fields (columns Field and Field type). You can use these freely to filter audiences and to display values in your emails.

Linking and unlinking fields

In the Xendy fields section you determine which column from your database fills each Xendy field. This ensures that imported data ends up in the right place. For contact fields these are Email address, First name and Last name; all three are required.

Linking a field:

  1. Go to Settings > Manage database and open the correct tab.
  2. For the Xendy field in the Your column column, select the column that should fill the field.

A green checkmark next to the field means it is linked; a warning icon means it has not been linked yet. A column that already fills another Xendy field is greyed out and cannot be selected here.

Unlinking a field: Select the Not linked option in the Your column column. Existing contact data is retained. Please note:

  • Required fields can be linked to a different column, but cannot be left empty.
  • A Xendy field with a padlock is managed by your import integration (such as your webshop). That integration cannot be changed: the next import would revert it anyway.

Changing field types and creating custom fields

Change field type:

  1. Go to Settings > Manage database and find the field under Other fields.
  2. In the Field type column, choose the desired type. The change is saved immediately.
Field typeUse
Text (default)Free text
DateDates; in filter rules you can choose, for example, Is in the last X days
Number without decimalsWhole numbers
Number with decimalsNumbers with decimals, such as amounts
BirthdayA date of birth; in filter rules you can choose, for example, Has a birthday today or Age becomes X

Dates must be stored in the field as YYYY-MM-DD or DD-MM-YYYY (optionally followed by a time). Other formats are not counted in filter rules. You can also change the type of a field with a lock icon.

Create a new contact field:

  1. On the Contact fields tab, click New field.
  2. In the Create new contact field modal, enter a Field name of at least 3 characters: letters, numbers, spaces, or underscores. Xendy saves the name in lowercase, with underscores instead of spaces.
  3. Under Field type, choose Choose a field type yourself (and select the Field type), or Link to a Xendy field (and select the field under Link to).
  4. Click Create field.

New fields are then available for segmentation and personalization in your emails. You can only create custom fields for contact fields. You can also create a field during an import using Add field; such a field will be given the type Text (default).

Deleting fields

Fields under Other fields can be permanently deleted. Please note: deleting a field also erases all data stored in that column for all your contacts. This cannot be undone.

  1. Go to Settings > Manage database and find the field under Other fields.
  2. Click the trash icon next to the field and confirm the action.

Are you still using the field in filter rules or as personalization in an email? Update those first. A filter rule based on a deleted field will no longer work, and a personalization tag with that name will appear literally in your email.

Not every field can be deleted:

  • Xendy fields cannot be deleted; you disconnect them via Not linked (except required fields, which cannot be cleared).
  • Fields with a padlock icon were created by your import integration (such as your webshop). These cannot be deleted: the next import will automatically restore them. You can change the field type, though.

Frequently asked questions

All data in that field is permanently deleted for all your contacts. This can't be undone. So make sure you no longer need the data before deleting a field.

No. Only fields under Other fields without a lock icon can be deleted. Fields with a lock icon are managed by your import connection (such as your webshop): the delete option is missing for those, and the next import would automatically restore such a field anyway. You don't delete Xendy fields; you unlink them via Not linked (except for required fields).

Custom fields are available after creation in the filter rules of your segments (under Contact data) and for personalization in your emails. Type @ in the email editor to open a list of available fields and select the desired field.

You can fill a field per contact using Edit in the side panel, for a selection of contacts using Set field under All contacts, or with an import in which you link a column to the field.

Joeri Ras

Written by

Joeri Ras

Founder & co-owner @ Xendy

Prefer to talk directly?

Related articles