Members & levels

Membership levels, the members list, statuses, custom fields, groups, dues collected by hand, renewals, and moving your roster in from a spreadsheet or Wild Apricot.

Membership levels

Admin → Levels. A level is a kind of membership — Individual, Family, Lifetime — with a price and a term.

SettingWhat it means
NameShown on the join page and in the portal.
PriceEntered in dollars: type 25 or 25.00 for $25.00. A price of 0 activates the member immediately with no card.
Duration (months)How long one term lasts, counted from the day the member joins or renews. Default 12.
RenewalManual: the member pays again each term. Auto: the first payment starts a Stripe subscription that charges again each term (yearly when the duration is 12 months or more, otherwise monthly).
  • Terms always run from the join or renewal date. There is no calendar-year or fixed-date renewal.
  • There is no family or household bundle; each person is one member.
  • Levels cannot be deleted. Archive hides a level from the join page, the portal and imports, while every membership that used it keeps its history.
Every price box in the admin is in dollars. Type 35 or 35.00 for a $35 level; $ signs and commas are fine too.

Members list

Admin → Members. Search by name or email, filter by status (All, Active, Pending, Lapsed, Cancelled), and page through 50 at a time. The list is always sorted by last name, then first name. From here you can Add Member, Export CSV and Import CSV.

Opening a member shows their details, notes, custom fields, groups, membership history and payments. You can change their email (it must be unique within the guild), name, phone, status, notes, directory visibility and custom fields.

There are no bulk actions on the members list. To change many members at once, use a CSV import (below); to email many members, use audiences in Email.

Statuses

StatusMeaning
PendingAdded or signed up but not yet paid or activated. New members start here.
ActiveHas a current membership. Only active members count toward the free plan limit, appear in the directory, and get member pricing on events.
LapsedTheir membership end date passed and they have not renewed. Set overnight by the daily job.
CancelledRemoved from the guild. "Deleting" a member sets this status; the record and its history are kept.

Setting a member to Pending or Lapsed by hand ends their current membership; setting them to Cancelled cancels it. The editor asks you to confirm. Moving a member back to Active by hand does not create a membership — use Assign / renew membership for that.

Custom fields

Admin → Settings → Custom fields. Each field has a label, a type (text or dropdown with a comma-separated list of options) and a show on join form switch. Fields appear in the member editor, on the public join form when switched on, and on the member's Profile tab in the portal. Removing a field definition stops it being shown; values already stored on members are not erased.

Groups

Groups are labels for sets of members — the board, a bee, a committee. Create and manage them on the Email screen, or tick groups in a member's editor. A group can be chosen as an email audience. Deleting a group removes the label; the members stay.

Chapters are different: a chapter is a separate child guild with its own address, members and events, for multi-chapter organisations. Chapters cannot have chapters of their own, and are archived rather than deleted.

Dues collected by hand

Open the member and use Assign / renew membership. Choose the level; the end date is pre-filled one full term from today, and you can type a different date. Optionally record the amount and how it was paid (cash, check, comp, card taken offline, other) and a note. When an amount is entered, a payment appears in Payments with an "Offline" description.

  • The new term starts today, not at the end of the current one. If someone renews early, type the later end date yourself.
  • Any earlier active membership is closed when the new one is assigned.
  • No receipt or confirmation email is sent for dues recorded by hand.

Renewals and lapsing

A daily job runs at 08:00 UTC (early morning in the US):

  • Sends a renewal reminder 30, 14, 7 and 1 day before a membership end date, with a link to renew in the portal. Reminders go to every active member with an end date, including those on auto-renew.
  • The day after the end date, marks the membership expired and the member Lapsed — there is no grace period. Memberships with no end date never lapse.
  • Sends a one-time "we miss you" email 7 days after a member lapses, unless they have opted out of newsletters.

Auto-renew charges are made by Stripe. When a renewal payment succeeds, the end date is extended by one term and the member is made active again; no email is sent for that renewal. If a card fails, nothing changes in QuiltHosting until the end date passes and the member lapses normally; the member can update their card from the portal.

CSV import

Members → Import brings a list in from a CSV export (Wild Apricot or anything else). Up to 5,000 rows per file; split larger files.

  1. Choose the file. Every column is read, including ones the importer does not recognise — nothing is silently dropped.
  2. Check the column table. Each column shows an example value and a dropdown for where it goes: a known field (email, first name, last name, phone, status, notes, level, end/expiry date, joined date), Import as custom field, or Do not import. Common headings are matched for you; confirm the guesses.
  3. Promote a column to a custom field for guild-specific data. It becomes a permanent custom field for every member.
  4. Read the preview. "What will happen" shows how many members will be created, updated and skipped, and anything worth checking. Nothing is written until you press Import — changing a mapping just re-checks the file.
  5. Press Import. You get a summary, and a Download problem rows button when rows need attention.

How rows are matched. By email address, ignoring case. A row whose email already belongs to a member updates that member; a new email creates one. Rows without a usable email, rows that repeat an email already in the file, and rows with the wrong number of columns are skipped and listed.

What an update preserves. A blank cell never erases a name, phone or notes you already have. Custom-field values you entered by hand are kept unless the file supplies a new value for that field. The join date of an existing member is never changed by an import. A person who previously unsubscribed keeps that opt-out, even if they were removed and imported again. A member whose level and end date are unchanged keeps their auto-renew subscription untouched.

Levels and status. The level column is matched by name to your active levels. Naming a level on a row is an instruction to give that person an active membership now — it overrides the status column. A status the importer cannot read is treated as active and reported. If the file names a level that does not exist, the person is imported without a membership and the row is listed.

Renewal dates. A readable end/expiry date is used exactly as given. When the file names a level but has no readable date, QuiltHosting chooses one: one full term from today (or from the start date, if that is in the future). This never shortens a membership the member already holds — a later or open-ended date is kept. The chosen dates are listed per member in the problem-rows download so you can check them. A "Member Since" date sets the join date only; it never sets the renewal date.

Wild Apricot and other column headings

Headings are matched ignoring case, spaces and punctuation. These are pre-matched:

Goes toHeadings recognised
EmailEmail, Email address, Mail
First nameFirst name, First
Last nameLast name, Last, Surname
PhonePhone, Phone number, Mobile, Cell phone
StatusStatus, Membership status
NotesNotes, Note, Comments
LevelLevel, Level name, Membership level, Membership type, Membership label
End dateEnd date, Expiry, Expiration, Expiration date, Renewal date, Renewal due, Membership expires
JoinedJoined, Joined at, Join date, Member since

If two columns point at the same field, the first is used and the second is reported. Any other column can be imported as a custom field or ignored. A column that already matches one of your custom fields (by label) is matched to it automatically.

Partial imports — what they mean

Every import is recorded in the Recent imports card on the Members page (the 50 most recent, with who ran it, the counts and a Download errors button). Each ends up as:

  • Complete — nothing was lost. It can still carry news, such as renewal dates that were chosen for you.
  • Partial — something in your file did not come through in full. Your members were still imported; it is not a crash and not a rollback.

An import is partial when rows were skipped, a membership could not be assigned, a level was not found, an ignored column had data, two columns pointed at the same field, a date or status could not be read (or a status was overridden by a level), or members were held at your plan's active-member limit.

What to do: download the errors, fix those rows in your spreadsheet, and import the file again. Re-importing is the repair mechanism, because rows are matched by email and update in place. There is no undo — an import cannot be rolled back.

Read the errors before you re-run. When a row assigns a membership to someone who already has an active one, the existing membership is closed first and the new one written second. If the new one fails again, that member is left with no active membership. If your error list contains "membership failed" rows, work out why before re-running the file. Everything else is safe to re-import.
Your own export is safe to re-import. Members → Export writes the level and end date only for people who are currently active, so re-importing it does not resurrect pending, lapsed or cancelled members, and active members carry their real renewal date back in.

Export

Members → Export CSV downloads every member with these columns: email, first name, last name, phone, status, joined date, notes, level, end date. Level and end date are filled only for members with a current active membership. Exports are available to owners, admins and membership chairs.

The free plan limit

On the free plan a guild can have 30 active members. During the 30-day trial and on the Guild plan there is no limit. The limit only applies when someone is being made newly active — renewing or re-importing someone already active costs nothing. When the limit is reached, adding or activating a member fails with "Free plan is limited to 30 active members. Upgrade to the Guild plan for unlimited members." An import instead brings the extra people in as Pending and lists them as held; nothing in your file is wrong. See Billing & payments.