View source for Membership Manager

The Membership Manager add-on manages basic membership processes typical for associations and nonprofits, such as automating the join and renewal process, maintaining membership roles, and administering the access of members to restricted content on your website. It also provides access to online sales and automated billing through [[Invoice Manager]].

==How to Install Membership Manager==
Click here for information on [[Installing Add-Ons]]. <br />

==Managing Membership Accounts==
Use the Membership Manager addon to add, modify and report on membership accounts.

===Account Listing Screen===
The Account listing screen shows a list of all membership accounts, with filtering options to include all accounts, expired accounts, etc.

===Account Details Screen===
To view the details of any account, locate the account in the Account Listing Screen and click on the Account name. The details tab lists the following fields:
<blockquote>
* Account Status - The membership status of the account
** Active if they are a member in good standing
** Expired if they are an active member and their expiration date has passed with renewal. For more information about grace periods, see Membership Manager Settings
** Canceled if they have been canceled through this membership interface
** Pending if they have joined and are waiting for be activated. To automatically activate new accounts, see Membership Manager Settings.
* Primary Contact - The account's Primary Contact. Account contacts must come from one of the following
** anyone with the account set in the billing tab of their people record.
** anyone associated to the account in Membership Manager People tab
** anyone with an organization set in their people record that is associated to the account with Membership Manager
** anyone set to an organization associated to the accountThe three contact types available in INVOICE MANAGER are:
* Billing Details - Billing details is a link that takes you to the invoice manager Details Screen for this account.
* Membership Type - The membership type set for this membership account. Create new membership types in the Data tab at the top. A Membership Type is set when the Account purchases an invoice with Membership type. 
* Previous Type - When the membership type changes, the previous type is saved here.
* Anniversary Date - The anniversary date is the upcoming date which represents another year of membership. When the account pays for a membership invoice which covers this date, this anniversary date is automatically set to the next year and the account is added to the Membership Kit Fulfillment report.
* Join Date - This represents the date when this account was last converted to a membership account. This happens when a Membership Type is purchased and the account does not already have one set..
* Expiration Date - This is the date when the date when the membership privileges of this account will expire, if it is not renewed.
</blockquote>
Invoices for membership renewals and account statements are automatically generated by the system based on the criteria you specified in the SUBSCRIPTION/RENEWAL tab under MEMBERSHIP TYPES. Click here for more information about setting up accounts with MEMBERSHIP MANAGER. Members who selected to auto renew their membership during the join process do not receive an invoice, and their credit card is automatically charged for the renewal fee. <br />

'''Sending Manual Invoices or Statements.''' If you need to send a manual invoice or statement, click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and then click on MEMBERSHIP MANAGER. From here you will click on the INVOICE MANAGER tab. Next click on the NAME of the account and the PURCHASE HISTORY tab for that account. Click on the box next to any invoices you want to send and then click SEND INVOICES. If you want to send a statement, which shows all outstanding charges for the account, click the SEND STATEMENT button. <br />

If you need to send statements to multiple accounts, click on ECOMMERCE and then INVOICE MANAGER. Place a check in the box next to all accounts you want to receive a statement. Next click SEND STATEMENTS. <br />

'''How to Update Accounts Upon Renewal.''' If the member elected to auto renew their membership, their credit card is automatically charged for renewal. If the member receives an invoice, he can choose to mail in a check or pay by credit card over the phone or via the mail-in application. <br />

In order to mark the invoice as paid for payments mailed in or phoned in, log in and go to ADMIN. Click on the MANAGE ADD-ONS folder. Next click on the ECOMMERCE folder and then click on INVOICE MANAGER. From here you will click on the TOOLS tab and then select ENTER PAYMENTS/CREDITS. Select the account from the drop down menu. Choose check or credit card for payment. You can then enter the check number or credit card information and amount of payment. Click OK to save changes. Once they have paid, their expiration date will be updated automatically. <br />

For accounts on auto pay, their expiration date will be automatically updated once payment has been received. <br />

If an account has a renewal fee of $0, their renewal will be automatic and no invoice will be sent. <br />

==How to Set Up Membership Types==
When you are logged on as an Administrator, you will click on the ADMIN button, and then you will click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and finally click on MEMBERSHIP TYPES. From here you will see a list of all available membership types. Click ADD to include a new membership type. Information necessary to set up the membership type includes: <br />

'''Details Tab:''' Here you will enter the name of the membership group, the maximum number of individuals and/or companies that can be associated with an account of this type, and a description of the membership type. <br />

'''Pricing Tab:''' Here you will enter the membership price to join this group. <br />

'''Fulfillment Tab:''' Here you will specify if anyone needs to be notified upon fulfillment of an order and which group should be notified. <br />

'''Subscription/Renewal Tab:''' Here you will enter information about membership renewals, such as the expiration period type (calendar or periodic), number of days or months until expiration, and month of expiration (if duration type is set to calendar). You will also set the group that this member type is added to. Click here to learn more about how to add new groups to the system. <br />

*Periodic memberships are those that end after the specified number of days or months after the initial purchase.
*Calendar memberships start in a month that you specify and must be renewed the following year before that month.  When a customer pays for renewal of a membership based on a calendar year, their expiration date will be updated. However, if they pay for an additional year more than 6 months before the current membership expires, it will be applied to the current membership period.

You can also choose to automatically renew memberships by clicking on the “Renew on expiration” box. If you choose this option, you will set a renewal price and the number of days before expiration that a bill is sent, as well as the grace period for bill payment before their memberships becomes inactive. <br />

'''Purchase Tab:''' Here you will check the box if you want custom copy on the receipt for this membership type and enter the custom text you want on the invoices sent to members in this group. <br />

Click OK when you are done entering information to save changes. <br />

==How to Edit Membership Types==
You can edit a membership type by clicking on the MEMBERSHIP MANAGER folder and then on MEMBERSHIP TYPES. From here you will see a list of all available membership types. Click on the paper/pencil icon next to the name of the membership type you want to edit. You can make changes to any of the information that you input when you added the membership type. Click SAVE when you are done making changes. <br />

==Membership Settings==
When prospective members create new accounts online, you can specify whether you want them to become ACTIVE or PENDING after paying their bill. If you want to approve memberships before they can become active, go to ADMIN, MEMBERSHIP MANAGER and MEMBERSHIP MANAGER SETTINGS and make sure the box is NOT checked. To automatically make members ACTIVE after bill payment, without the need for approval, check the box under settings and click OK to save changes. <br />

==How to Create New Accounts==
Prospective members create new accounts online by filling out a registration form. To access this form, click the REGISTER or JOIN button on the website. After entering all required information, including payment information, click NEXT to access the thank you screen. <br />

If the member pays by credit card, and your MEMBERSHIP MANAGER SETTINGS require you to authorize new accounts, they are added as a member with a PENDING status. To move them to an ACTIVE status, go to ADMIN, click on the MEMBERSHIP MANAGER FOLDER and then click MEMBERSHIP MANAGER. Click on the PENDING choice and all PENDING accounts will be displayed. Click on a specific account and choose ACTIVE from the drop down list for status. Click OK to save the change. <br />

If the member pays by credit card and you have chosen automatic activation in MEMBERSHIP MANAGER SETTINGS, then they are added as an ACTIVE member. <br />

If the member chooses to pay by check, they are added as a non-member. They are moved to PENDING or ACTIVE status (depending on your MEMBERSHIP MANAGER SETTINGS) with the MEMBERSHIP TYPE specified when joining once you have received their check and you have marked them as paid. <br />

To mark the invoice as paid, log in and go to ADMIN. Click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and then click on MEMBERSHIP MANAGER. From here you will click on the INVOICE MANAGER tab. At the top of the page select TOOLS and then click on ENTER PAYMENTS. Select the account from the drop down menu. You can then enter the check number and amount. Click OK to save changes. <br />

If a prospective member sends in a paper application, you can create the new account by logging out and clicking the REGISTER button to fill out the public join form. Make sure you are logged out so that you are not changing information on your individual account. <br />

==How to Find Information about Member Accounts==
When you are logged on as an Administrator, you will click on the ADMIN button, and from the ADMIN page you will click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and finally click on MEMBERSHIP MANAGER. <br />

Displaying Account Information: The ACCOUNTS tab lists all accounts that meet the criteria you have selected from the menu on the left of the list. Options include ALL ACCOUNTS (not just memberships) or MEMBERSHIPS, where you can choose to include ALL, ACTIVE, EXPIRED, DEACTIVATED or PENDING. <br />

To get detailed information for a particular account, click on the NAME for that account. This opens a record, which provides the account name, account status, primary contact, billing contact, membership type, join date and expiration date. You can edit the account name, contact information, membership type or status; click SAVE when you are done making changes. <br />

'''''NOTE: To change the expiration date on an account, you must first click on the box that says "Clear the expiration date.." and then click OK. This will remove the current expiration date and associated recurring purchase for the membership renewal. You will then be able to edit the member's expiration date. Once you enter the new expiration date, click OK to save the change. At this time a new recurring purchase will be set up to renew membership at the time of the updated expiration date.''''' <br />

If you click on the NOTES tab, you can add information to track membership activity. To add a NOTE, click ADD and type the text of the note. You can highlight this note/account by clicking on the ALERT box. This account will then be highlighted in yellow until you get rid of the alert by clicking on it and then hitting the CLEAR SELECTED ALERTS button. <br />

You can also see which organizations and people are associated with this particular account by clicking on the ORGANIZATIONS or PEOPLE tabs. <br />

==How to Export Information about Members==
When you are logged on as an Administrator, you will click on the ADMIN button, and from the ADMIN page you will click on MANAGE USERS and then PEOPLE. You will see a list of all people in your database. To get information about a specific member group, click on the FILTERS >> at the left of the list, and then click on the member group you want information about. To choose which fields of information you want, click on SET COLUMNS and then click ADD by any fields you want to add, and click DEL on any fields that you don’t need right now. Click OK and then click on EXPORT. <br />

Here you will set the file name, choose the format and click REQUEST DOWNLOAD.  To retrieve the information, from the ADMIN menu, click on TOOLS, then DOWNLOAD MANAGER. You will see a list of all downloaded files. Find yours, and when it is ready, you can click on AVAILABLE to download the information. <br />

==How to Create Membership Accounts for People Already in Your Database==
The IMPORT TOOL tab allows you to create membership accounts from people records already in your database. The name of the account is created from the first and last name in the current people record; all new accounts are set to bill through email. <br />

Click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and then click on MEMBERSHIP MANAGER. From here you will click on the IMPORT TOOL tab. <br />

Using this tool you will select the group that contains the specific members you want to import. You will also specify whether or not to create a recurring purchase or to check for duplicates. You may also select the field in your database that contains the membership type for each person and the membership expiration date. Click CREATE MEMBERSHIP ACCOUNTS when you have entered all required information. <br />

==How to Close Accounts==
Click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and then click on MEMBERSHIP MANAGER. From here you will click on the INVOICE MANAGER tab. You will see a list of all accounts or only open accounts if you check the OPEN ONLY box. To close any accounts, click the check box by the account name and click on CLOSE ACCOUNT from the menu. <br />

==How to Deactivate Accounts==
Click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and then click on MEMBERSHIP MANAGER. You will see a list of all accounts of the type specified in the menu to the left of the list. To deactivate an account, click on the account name and choose DEACTIVATED from the drop down menu in the STATUS field. <br />

==Membership Reports==
To access available membership reports, when you are logged on as an Administrator, you will click on the ADMIN button, and from the ADMIN page you will click on the MANAGE ADD-ONS folder. Next click on the MEMBERSHIP MANAGER folder and finally click on MEMBERSHIP MANAGER and then click on the REPORTS tab. Available reports are listed below; to access them click on the report name from the REPORTS tab. <br />

    '''MEMBERSHIPS BY TYPE'''
    Shows the total number of memberships by type as of the current date.

    '''MEMBERSHIP EXPIRATIONS BY MONTH'''
    Shows the total number of active membership accounts that will expire each month during the next year.

    '''MEMBERSHIP EXPIRATIONS BY TYPE'''
    Shows the total number of memberships by type that are scheduled to expire during the current month.

    '''MEMBERSHIP RENEWALS BY MONTH'''
    Shows the total number of membership renewals each month during the previous year.

== Data Structure ==
The following database tables are used and/or created by Membership Manager.

====People====
<blockquote>
People is a system Table which stores information about users. For more details, see the [[Developer Guide]]
</blockquote>

====Organizations====
<blockquote>
Organizations is a system Table which stores information about companies. For more details, see the [[Developer Guide]]
</blockquote>

====Accounts====
<blockquote>
This table is created by [[Invoice Manager]]. Membership adds the following:
; membershipDateJoin : Date: The date when this account was last converted to a membership account. This happens when a Membership Type is purchased and the account does not already have one set.
; membershipDateExpiration : Date: The date when the membership privileges of this account will expire.
; membershipTypeId : Lookup into Membership types: When set, this account is a membership account.
; membershipStatusId : lookup defined as follows:
* 1 = active
* 2 = deactivated
* 3 = pending (the account has been configured but has not been activated)
</blockquote>

====Membership Organization Rules====
<blockquote>
This is a list of organizations associated to a membership account. In Membership Manager, Memberships can be associated to individuals or to organizations. Each record in this table represents an association of organzation to a membership account. This can be set or modified in the Organizations tab of an Account in Membership Manager. When selected, all the users in the system with this organization set will be listed in the account screen in Membership Manager. 
; accountId : Lookup into accounts: The membership account
; orgId : Lookup into organizations: The organization associated to the membership account
</blockquote>

====Membership People Rules====
<blockquote>
This is a list of people who receive membership benefits from an account. In Membership Manager, users can be added to this list by checking the checkbox next to their name under the People tab of the account screen.
; accountId : Lookup into Accounts: The membership account
; memberId : lookup into People: The user associated to the membership account.
</blockquote>