Membership Dues Import Fields

To import membership dues, your import file must be a comma-separated values (*.csv) of the membership dues information. The following table explains the requirements of specific fields in the import file. For information about additional fields used to add membership dues, see Add a Membership Screen.

Template column Description
Membership transaction type

This field determines the type of membership transaction to add, such as a join or renewal. You can enter only one of these values.

To add a new membership, enter 0. To renew an existing membership, enter 1.

Discount type

For a transaction that includes a Manual membership promotion, enter the name of the promotion.

For a transaction that includes a With code membership promotion, leave this field blank. Instead, enter the promotion code in the Promotion code field.

Promotion code

For a transaction that includes a With code membership promotion, enter the code for the promotion.

For a transaction that includes a Manual membership promotion, leave this field blank. Instead, enter the promotion name in the Discount type field.

Membership program add-ons, Add-on type

When you add add-ons to a membership, the Add-on type field indicates whether the add-on is for a benefit or an additional member. You can enter only one of two values.

To add a benefit add-on, enter 0. To add an additional member add-on, enter 1.

Members receiving cards, Member

When you add additional members with membership cards to a membership, enter the system record ID for the member to receive a membership card.

To include this value in a constituent query, include the Constituent/Constituent record field.