Members : Bulk Expiring Member Classes

Step-By-Step:

​Step 1: Navigate to the Customer's tab within Club Caddie and then to the 'Members List'. 

Step 3: In the exported excel file you'll find the following data export:

Section 1 - Labelled above you'll find a pair of data headers that are used to parse the ensuing data.

Section 2 - Each member record will be marked with a "MBR" designation in column A and will contain the following member information: ID, Customer profile ID, First Name, Last Name, Email Address, Mobile Number, Membership ID, and the membership since date.

Section 3 - Every member with class assignments will have ensuing rows designated with "CLASS" in column A. This contains information on the respective assigned classes being ID, Class Type ID, Class Type Name, Effective Date, Billed Till Date, and Expiry Date. 

Step 4: Our example goal is to identify the "Social Membership" types and set an expiration date in bulk.
To do so, we will first click into cell A2 and highlight the full sheet of data. Then under the Home banner select "Sort and Filter" and then select "Filter" to add a filter to excel.

Step 5: Once a filter is added we can sort to the desired membership class. In this example "Social Membership"



Step 6: To now set an expiration date we can navigate to Column G or "Expiry Date" and set the desired date. In this example we will set the end of the year.