Club Points Loyalty

​

Overview

​

Database Structure

​

ClubPoint Model

• user() - BelongsTo relationship with User model (app/Models/ClubPoint.php:9)
• order() - BelongsTo relationship with Order model (app/Models/ClubPoint.php:13)
• club_point_details() - HasMany relationship with ClubPointDetail (app/Models/ClubPoint.php:17)

• user_id - Customer who owns the points
• order_id - Associated order (if points earned from purchase)
• points - Number of points earned or spent
• convert_status - Whether points have been converted/redeemed

​

How Club Points Work

​

Earning Points

1. Making Purchases - Points awarded based on order total
2. Product Reviews - Earn points for leaving product reviews
3. Referrals - Get points when referred users make purchases
4. Special Promotions - Bonus points during promotional periods

​

Point Relationships

public function user(){
    return $this->belongsTo(User::class);
}

public function order(){
    return $this->belongsTo(Order::class);
}

public function club_point_details(){
    return $this->hasMany(ClubPointDetail::class);
}

​

User Balance

• Increases when points are earned
• Decreases when points are redeemed
• Has a detailed transaction history via club_point_details

​

Point Transactions

​

Earning Points Transaction

1. Create a new ClubPoint record
2. Associate with the user and order (if applicable)
3. Set positive point value
4. Update user’s total balance
5. Create detail records for tracking

​

Redeeming Points Transaction

1. Verify sufficient balance
2. Create a new ClubPoint record with negative value
3. Mark as converted (convert_status)
4. Update user’s remaining balance
5. Apply discount to order

​

Club Point Details

• Individual point transactions
• Point expiration dates
• Conversion history
• Transaction descriptions
• Point sources and uses

public function club_point_details(){
    return $this->hasMany(ClubPointDetail::class);
}

​

Configuration

​

Point Earning Rules

• Points per currency unit - How many points per dollar/euro spent
• Minimum order value - Minimum purchase to earn points
• Product exclusions - Products that don’t earn points
• Point multipliers - Special categories with bonus points

​

Point Redemption Rules

• Minimum redemption threshold - Minimum points needed to redeem
• Maximum redemption per order - Cap on points usable per transaction
• Point value - Monetary value of each point
• Redemption restrictions - Products or categories where points can’t be used

​

Integration with Orders

public function order(){
    return $this->belongsTo(Order::class);
}

• Tracking which orders generated points
• Viewing point history per order
• Refunding points if orders are cancelled
• Validating point awards based on order status

​

User Interface

​

Customer Dashboard

• Current point balance
• Point earning history
• Redemption history
• Point expiration dates
• Available rewards

​

Checkout Integration

• See available points
• Choose how many points to redeem
• View discount amount
• See remaining balance after redemption

​

Point Lifecycle

​

Point Expiration

• Set expiration dates for earned points
• Send notifications before points expire
• Automatically remove expired points
• Track expiration history

​

Conversion Status

• 0 - Points are available/pending
• 1 - Points have been converted/redeemed
• 2 - Points have expired
• 3 - Points were refunded (order cancelled)

​

Best Practices

​

Point Value

​

Communication

• Show point balance prominently in user account
• Display points earned on order confirmation
• Send emails when points are about to expire
• Highlight point value during redemption

​

Engagement

• Offer bonus point promotions periodically
• Create point milestones with special rewards
• Show progress toward next reward tier
• Gamify the experience with achievements

​

Reporting and Analytics

​

Key Metrics to Track

• Total points issued
• Points redeemed vs earned
• Average customer point balance
• Point liability (outstanding unredeemed points)
• Redemption rate percentage
• Most popular redemption amounts

​

Financial Tracking

1. Calculate point liability - Total unredeemed points × point value
2. Track point expense - Cost of redeemed points
3. Monitor point breakage - Points that expire unused
4. Measure ROI - Increased customer lifetime value vs point costs

​

Example Scenarios

​

Scenario 1: Purchase Points

Customer: John Doe
Order Total: $100
Point Rate: 10 points per $1
Points Earned: 1,000 points

ClubPoint Record:
- user_id: 123
- order_id: 456
- points: 1000
- convert_status: 0 (available)

​

Scenario 2: Point Redemption

Customer: John Doe
Available Points: 1,000
Points to Redeem: 500
Point Value: 100 points = $1
Discount Applied: $5

ClubPoint Record:
- user_id: 123
- order_id: 789
- points: -500
- convert_status: 1 (redeemed)

New Balance: 500 points

​

Scenario 3: Order Cancellation

Original Order: Cancelled
Points Earned: 1,000
Action: Refund points

ClubPoint Record:
- user_id: 123
- order_id: 456
- points: -1000
- convert_status: 3 (refunded)

Note: Reverses original point award

​

Integration Points

​

With User Accounts

• Display point balance in account dashboard
• Show point history and transactions
• Enable point-to-wallet conversion (if supported)

​

With Orders

• Award points on order completion
• Allow point redemption at checkout
• Handle point refunds on cancellations
• Track point source per order

​

With Products

• Mark products as point-eligible or excluded
• Set bonus point multipliers per product
• Display potential points on product pages

​

Security Considerations

​

Migration and Seeding

1. Create database tables for ClubPoint and ClubPointDetail
2. Add point balance field to users table (for quick access)
3. Set up default configuration values
4. Optionally award welcome bonus points to existing customers
5. Create scheduled tasks for point expiration

​

Future Enhancements

• Point tiers - Silver, Gold, Platinum status levels
• Point sharing - Transfer points between users
• Point gifting - Buy points for others
• Dynamic rates - Surge point earning during slow periods
• Partner points - Earn points from affiliated services
• Charitable donations - Donate points to causes