Membership Group Setup

Membership Group Setup

🌐 Backend — EQuipWebRetail ModeMembership Setup

Chapter 3: Membership Setup — 3.2 Membership Group Setup

Use Membership Group Setup to create your loyalty tiers — like Regular, Gold, Platinum, or Diamond. Each tier can have different benefits, discounts, and point-earning rates. Members automatically upgrade or downgrade based on rules you set here. Each group defines discount levels, point earning rates, upgrade criteria, referral caps, benefit packages, and paid membership plans.

When to use this: When you need to create or manage member tier groups (e.g., Gold, Silver, Platinum) and their benefits.

Prerequisites

  • No prerequisites — groups are top-level configuration

Membership Group List

📝 General Description

The Group list shows all configured membership tiers. Typically a retailer sets up 3–5 tiers with increasing discounts and benefits. The tier with Is Default Group = ON is automatically assigned to all new member registrations.

⚙️ UI Elements

ElementTypeFunction
+ Add NewGreen ButtonCreate a new membership tier
ExportOrange ButtonDownload tier list as Excel
Search BarText InputFilter by group name

3.2.1 Data Grid Columns

ColumnDescription
GroupNameTier name (clickable → opens edit form)
MembershipGroupIdSystem-generated ID
DiscountDefault discount % applied to members in this tier
PointsPercentagePoint earning rate (e.g., 1% = earn 1 point per $1 spent)
RankingTier hierarchy position (lower number = higher tier)
ReferenceNoOptional reference code for this tier
DeletedHidden/deleted status

3.2.2 Add / Edit Membership Group

Main Card

FieldTypeRequiredDescription
Group NameText✅ YesTier name shown at POS and in reports (e.g., "Gold", "VIP", "Platinum")
Discount (%)Number✅ YesDefault discount applied when a member of this tier makes a purchase
RankingNumberNoTier hierarchy (1 = highest tier). Used for auto-upgrade logic. Lower = better tier.
Membership TypeDropdownNoClassification type (Standard, Premium, etc.)
DescriptionTextareaNoTier description shown in member-facing communications

Toggle Settings

ToggleWhen ONWhen OFF
Is Default GroupNew members are automatically assigned to this tier on registrationTier must be selected manually when registering a new member

[!IMPORTANT] Only one group should have Is Default Group = ON. Having multiple default groups will cause unpredictable behaviour during member registration and may result in members being assigned to the wrong tier.

Referral Card

FieldTypeDescription
Referral Invitation CapCurrencyMaximum total referral reward a member in this tier can accumulate. Acts as a cap across all referral programs.

Image Card

FieldTypeDescription
Group ImageFile UploadBadge or icon representing this membership tier. Displayed in member-facing apps and digital loyalty cards.

Criteria Card (JSON-based Upgrade Rules)

These fields define the requirements a member must meet to be automatically upgraded to this tier:

FieldDescription
Accumulation TypeHow qualification is measured: Total Spending (dollar amount) or Total Visit (visit count)
Accumulation UnitTime window for evaluation: Monthly, Yearly, or Lifetime
Spending ThresholdMinimum cumulative spend required to qualify for this tier
Total Visit RequiredMinimum number of visits required (used if Accumulation Type = Total Visit)

Example: Gold tier with criteria "Total Spending > $500 in 12 months" will auto-upgrade any Regular member once they hit $500 cumulative spend within a 12-month rolling window.

Benefits Card (JSON-based Group Benefits)

FieldDescription
Welcome PointsBonus points granted immediately when a member joins or upgrades to this tier
Birthday BonusSpecial reward issued on the member's birthday (works with Auto Drive BIRTHDAY trigger)
Point MultiplierMultiplier applied to all points earned (e.g., 2.0 = double points on every purchase)

Allows members to purchase this tier directly (instead of earning it through spending):

FieldDescription
Plan NameName of the paid membership plan (e.g., "Annual Gold Membership")
Plan PriceCost to purchase this tier (e.g., $99/year)
Plan DurationHow long the paid membership is valid before renewal is required

This requires UsePaidMembership = true in backend settings.


3.2.3 Custom Fields

The Membership Group form supports custom fields configured through the Custom Field Setup page.

Go to Settings → Custom Field Setup → Set Page to membershipGroup to add extra fields to the Group edit form.

These are stored in the userfld1userfld10 and CustomField1CustomField10 columns of the MembershipGroup table.


3.2.4 Outlet-Level Settings

Each membership group can have per-outlet overrides stored in MembershipGroupOutletSetting. This allows different outlets to apply different discount rates for the same tier without creating separate group records.


3.2.5 POS Sync Behavior

Membership Group changes sync to POS terminals on the next scheduled data sync.

ChangePOS Effect After Sync
Discount % changedNew rate applied to all members in this group
Tier deletedMembers of deleted group lose tier benefits
New group addedNew tier available for member assignment
Default group changedNew registrations auto-assign to new default

How to Edit a membership group

  1. In the Membership Group Setup page, find the membership group you want to change.

  1. Click the blue group name link. The edit form opens — it looks the same as the "Add New" form, but all fields are already filled in with the current values.

  1. Change the fields you need to update.

  2. Click Save to apply your changes.

Expected Result: The member group is saved and available for member assignment.

[!TIP] To make changes, just click the name of any membership group in the list — the same form opens with everything already filled in. Change what you need and click Save.


💡 Example

Scenario: A fashion retail chain sets up a 4-tier loyalty program.

The screenshot above shows a real 6-tier configuration:

TierDiscountPoints %RankingReference No
REGULAR0%1REG-001
SILVER5%5%5SIL-001
GOLD10%2GOLD-001
PLATINUM15%3PLAT-001
DIAMOND20%5%5DIAM-001
STAFF / EMPLOYEE30%STAFF-001

Setup Steps:

  1. Create REGULAR group → Set Is Default Group = ON (new signups auto-assign here)

2. Create SILVER group → Criteria: Total Spending > $200, Unit: Yearly, Ranking: 5 3. Create GOLD group → Criteria: Total Spending > $500, Unit: Yearly, Ranking: 2 4. Create PLATINUM → Criteria: Total Spending > $2,000, Unit: Yearly, Ranking: 3 5. Create DIAMOND → Criteria: Total Spending > $5,000, Unit: Yearly, Ranking: 5 6. Create STAFF / EMPLOYEE → Manually assigned to staff members (30% employee discount)

Result: When a Regular member's spending exceeds the threshold for the next tier, the system automatically upgrades them and grants any configured welcome points.

[!TIP] Use a STAFF / EMPLOYEE tier for employee discounts — this keeps staff discounts separate from customer loyalty tiers and makes reporting cleaner. Assign this tier manually; do not set auto-upgrade criteria for it.


Access & Permissions

RoleViewCreateEditDelete
AdminYesYesYesYes
SupervisorYesYesYesNo
CashierNo backend access

[!NOTE] Exact permissions depend on the Privileges Setup configured for each role. Contact your administrator if you cannot access this page.


Business Rules

  • Records that are linked to active transactions or other modules cannot be permanently deleted
  • Changes made here will take effect on POS terminals after the next sync
  • Deleted records can be restored from the list using the Show Deleted filter
  • All changes are logged with the user who made them and the timestamp

How to Delete a Membership Group

  1. Navigate to Membership Group Setup from the sidebar menu.

2. Click the name or code link (blue text) of the record you want to delete. 3. In the edit form, scroll down to the bottom.

4. Click the Delete button (red button). 5. A confirmation dialog appears — click Yes to confirm deletion.

Expected Result: The record is soft-deleted — it is hidden from the active list and POS terminals but can be restored later using the "Show Deleted" filter.

[!WARNING] Records linked to active transactions or other modules cannot be deleted. The system will display an error if deletion is not allowed.


How to Add a New Membership Group

  1. Navigate to Membership Group Setup from the sidebar menu.

  1. Click the + Add New button (green button).

  2. Fill in the required fields in the form.

  1. Fill in any optional fields as needed.

  2. Click Save to create the new membership group.

Expected Result: The new membership group appears in the list and is available for use across the system.


FAQ

Q: Why is the member not receiving points? A: Check that the member's group has benefit rules configured in Membership Benefit. Also verify the transaction qualifies (minimum spend, eligible products).

Q: Can I merge duplicate member records? A: This must be done by your system administrator. Contact support with both member IDs for assistance.

Q: How do I transfer a member to a different group? A: Edit the member record and change the Membership Group field. The change takes effect immediately.


Troubleshooting

IssuePossible CauseSolution
Cannot save the recordRequired fields are empty or invalidCheck all fields marked with * and fill in valid data
Record not appearing in POSPOS terminal has not synced yetWait for the next sync cycle or manually trigger sync from Terminal Status
Cannot delete the recordRecord is being used by other modulesCheck if the record is linked to active transactions, products, or other settings
Changes not taking effectBrowser cache showing old dataRefresh the page (Ctrl+F5) or clear browser cache
"Duplicate" error on saveA record with the same name/code already existsSearch the list (including deleted records) for duplicates
Page not loadingSession expired or network issueLog out and log back in. Check your internet connection

  • Product Setup > Promotion Setup — member-only promotions
  • Sales Setup > Discount Setup — member discount types
  • Sales Setup > Voucher Setup — voucher redemption for members
  • Setting > Membership Compulsory — require membership at checkout

Open Questions / Confirmation Needed

[!NOTE] The following items may vary depending on your system version and configuration:

  • Exact permission settings depend on your Privileges Setup configuration
  • Sync timing to POS terminals depends on network conditions and sync schedule
  • Some features may require additional licensing or module activation
  • Field behavior may differ between EQuip versions

If you encounter behavior not described in this manual, contact your system administrator or EQuip support team.

    • Related Articles

    • Membership Setup

      ? Backend — EQuipWebRetail ModeMembership Setup Chapter 3: Membership Setup — 3.1 Membership List The Membership List is where you manage all your loyalty members. You can look up a customer, check their points balance, update their details, or see ...
    • Outlet Group Setup

      ? Backend — EQuipWebRetail ModeMaster Data Setup Chapter 8: Master Data Setup — 8.5 Outlet Group Setup Use Outlet Group Setup to organize your outlets into logical groups — like "Central Region", "East Region", or "Franchise Stores". Grouping ...
    • Membership Benefit Setup

      ? Backend — EQuipWebRetail ModeMembership Setup Chapter 3: Membership Setup — 3.3 Membership Benefit Setup Use Membership Benefit Setup to give your loyalty members automatic discounts. For example, Gold members might get 10% off all purchases. Set ...
    • Membership Importer

      ? Backend — EQuipWebRetail ModeData Importer & Exporter Chapter 10: Data Importer — 10.3 Membership Importer Use Importer to manage and configure this feature in your EQuipWeb system. Use the Membership Importer to add many members at once from a ...
    • Membership Integration Settings

      ? Backend — EQuipWebRetail ModeMembership Setup Chapter 3: Membership Setup — 3.4 Membership Integration Settings Use Membership Integration Settings to connect your EQuip loyalty system with external CRM or marketing platforms. This allows member ...