Loyalty Points Manager
Hey everyone! I'm excited to introduce my brand new loyalty points manager app! It's designed to make keeping track of your loyalty points simple. And to make it even better, it comes with a built-in WhatsApp notification feature so you never miss an update on your points.
Let's jump right in and see how to use it. The app has two tabs: 'All Customers' and 'Settings'.
The "All Customers" Tab:
This tab is your primary interface for viewing customer loyalty data and processing point redemptions, and it has two main widgets:
1. Search Customers by Name:
-
Located at the top of this tab, you'll find a search bar (text input field).
-
Type a customer's name (or part of it) here, and the table below will instantly filter to show only matching customers, making it easy to find someone quickly.
-
Clearing the text in this field will display all customers again.
2. Customer Information Table:
This is the main part of the tab, listing your loyalty program members. Each row represents a single customer, and the columns display specific details:
-
ID: Shows a unique identification number assigned to each customer in the system.
-
Customer Name: Displays the full name of the customer.
-
Points: Shows the customer's current loyalty point balance (e.g., "1250 points"). This value updates automatically as customers earn or spend points.
-
Value: Displays the monetary equivalent of the customer's current points (e.g., "$12.50"), calculated based on the "Points per 1 [Currency Symbol]" setting you configured in the "Settings" tab.
-
Rating: Shows a visual star rating (e.g., ⭐⭐⭐☆☆) representing the customer's current loyalty tier, determined by their total points and the "Customer Rating Settings."
-
Action ("Pay" Button): Each customer row features a "Pay" button. Clicking this button for a specific customer opens a new dialog window, allowing you to process a payment using that customer's accumulated loyalty points.
The "Settings" Tab:
This tab allows you to customize how the Loyalty Points Manager operates. Here, you can configure database connections, points calculation rules, customer ratings, notification messages, and application appearance. Settings are grouped into expandable sections for clarity.
Database Settings
Configure how the application connects to your customer and transaction data. This section includes:
-
Database Path: Enter the full file path to your SQLite database file. Alternatively, click "Browse..." to open a file dialog and select your database file. The application will attempt to connect to this database when the path is set or changed.
Points Calculation Settings
Define how loyalty points are calculated and can be used. This section includes:
-
Points per 1 [Currency Name] (Input Field): Enter the number of loyalty points a customer earns for each unit of your selected currency spent (e.g., if set to 100, and currency is "$", then $1.00 spent earns 100 points). The label "[Currency Name]" updates based on your "Currency Symbol" choice.
-
Payment Threshold (Input Field): Enter the minimum transaction value (in your currency) required for a customer to automatically earn points for that sale (e.g., if set to 10.00, sales below this amount won't earn points automatically).
Customer Rating Settings
Define point thresholds for different customer rating (star) levels and the points awarded per transaction for customers at each level. This section includes:
-
Points for X Stars (Input Field): Enter the total loyalty points a customer must accumulate to achieve a specific star rating (e.g., "Points for 5 Stars": 1000).
-
Points to Add (Input Field): Enter the number of additional points a customer at this X-star level will earn per qualifying transaction (e.g., for a 5-star customer: 30 points).
WhatsApp Notification Templates
Customize the automated WhatsApp messages sent to customers. Default templates are provided, which you can edit:
-
Points earned message (Text Area): Edit the template for messages sent when a customer earns points.
-
Points spent message (Text Area): Edit the template for messages sent when a customer redeems points.
-
Rating level increased message (Text Area): Edit the template for messages sent when a customer's rating level increases.
-
Points earned message (Max Level customer) (Text Area): Edit the template for messages sent when a top-tier (max rating) customer earns points.
"⬇️ Insert Placeholder" Button (per template):
Below each template editor, click this button to see a menu of available placeholders (e.g., {customer_name}, {points_earned}). Selecting a placeholder inserts it into the template at your cursor's position, allowing for dynamic message content.
Other Settings
Configure general application behavior and appearance. This section includes:
-
Shop Name (Input Field): Enter your shop or loyalty program name. This name can be used in WhatsApp notification templates (via the {shop_name} placeholder).
-
Currency Symbol (Dropdown Menu): Select the currency symbol (e.g., $, €, £) used throughout the application and in calculations. This also updates the label for "Points per 1 [Currency Name]".
-
Theme (Dropdown Menu): Choose the visual theme for the application. The application's appearance will change immediately. The available themes include:
Light
Dark
Green
Blue
Red
Purple
-
Enable Keyboard Emulation for Payments (Checkbox): If checked, the application will attempt to type the payment amount into your POS system automatically when processing a points payment. Important: Ensure your POS payment field is active before confirming payment.
Update Settings (Button)
Click this button to save all changes made in the "Settings" tab. Some changes (like the Database Path) may trigger a data reload. A confirmation message will appear briefly after saving.
Note: This app is not yet complete, but I wanted to give you a preview. Stay tuned for more details.
-
Hey Rushdy Musammir,
I'll add the LKR symbol, no problem. Now, for the bot service, could you please provide a detailed, step-by-step explanation of the process you used? A small, easily overlooked detail is often the root cause.
I will add another method for sending notifications alongside WhatsApp.
-
It appears that the WhatsApp setup number has been updated. Check the following link to get the most recent one:
https://www.callmebot.com/blog/free-api-whatsapp-messages/ -
Have you tried sending an API request using the following endpoint?
https://api.callmebot.com/whatsapp.php?phone=[phone_number]&text=[message]&apikey=[your_apikey]Just replace the phone number, apikey, and message text with your own values, then paste the full URL into any browser to test it.
-
Hey everyone,
Loyalty Points Manager has been updated.
Here’s what’s new:
New Currency Added: Sri Lankan Rupee (LKR)
You can now select the Sri Lankan Rupee (LKR) as your currency in the Settings tab.
Enhanced Customer Notifications: Choose Your Platform!
You now have more control over how you communicate with your customers. A new "Platform" dropdown menu has been added for each customer in the main table. You can now choose to send automated notifications and custom messages via:
-
WhatsApp
-
Facebook Messenger
Simply select the desired platform for each customer. The application will use that choice for all future notifications for that person. If you don't want to send notifications to a specific customer, just select "None".
For complete instructions on how to configure Facebook Messenger notifications, check the official CallMeBot setup guide at the link below:
https://www.callmebot.com/blog/facebook-messenger-custom-commands/
Download link:
https://mega.nz/file/5d8mCRCZ#RTPdMDRZZCZONwkYjmZbtYOQA7v2KhUAN-LUw-qgNQk
-
-
Hey Rushdy,
The process for setting up Facebook Messenger is exactly the same as how you configure WhatsApp.
All you need to do is:- Get the Messenger API Key: Each customer who wants Messenger notifications needs their own unique API key from the CallMeBot service.
- Paste the Key into the 'Code' Field: Once you have the key, open that customer's profile in Aronium and paste the key directly into the 'Code' field. This is the same field you use for the WhatsApp API key.
After pasting the key, simply select "Facebook Messenger" as the platform in the Loyalty Manager, and it will work perfectly.
-
Hi John,
I'm from Pakistan, and I'm really happy to read this post, truly appreciate your efforts! I had been looking for this method, points, and WhatsApp notifications, and it’s amazing that I found all of them in the same day and in the same post.
I know just saying thank you isn’t enough, but still thank you so much for sharing this helpful information!
I also have a humble request: please consider adding the PKR currency (Rs) option as well. That would be a great addition for users from Pakistan.
And please share the updated link again -
Hi John, Love the time and effort you have put in to this. I am having a bit of a problem with it though. I have been trying to configure it to my Aronium database (.db file) and i just keep getting an error message. "could not connect to database" please explain what I am doing wrong.
Regards Rose
-
Hey Abdullah Khan,
Thank you so much for your incredibly kind message. I'm glad to hear that the app is exactly what you were looking for. I added Pakistani rupees (PKR) based on your request.
Download link: https://mega.nz/file/BZFCRCpK#f76F7_tXXZmvZTVkmlDIz2tvXPSkGLkYCMtugKnaitQ
-
Hey Rose Dubreu,
Thank you so much. It’s most likely a permission related issue. The app doesn’t have sufficient rights to read or write to the database file, resulting in an “access denied” error.
Please reach out to me via this email j93609566@gmail.com, so we can further investigate the issue.
Best regards, John
-
hey Robik Shrestha,
I added Nepalese rupees (NPR) based on your request.
Download link: https://mega.nz/file/gEFmiazR#Lr9Hpd5uqQYduuA1mhivJfqlOyhBAdWmS5KkETKwWKg
-
Hi John, Your work is incredible. I have a small request, Can you make the software able to run on windows 7...since the software is built using python 3.9, Its showing ...\Appdata\Loacal\Temp\_MEI37722\python39.dll failed to load error on windows 7. Can you somehow make it work on windows 7? Its really useful for me...
-
Hey Arun,
My apologies for the long delay in responding. Please reach out to me via email at
j93609566@gmail.com to discuss this further?
-
Hey Pazhani Selvan,
Please reach out to me at j93609566@gmail.com
so we can further investigate this issue. -
Hey everyone,
The app has been updated.
Details:
-
NGN Currency: Added support for Nigerian Naira.
-
Settings Reorganization: The settings menu has been reorganized into clear tabs (General, Rules, Notifications, Appearance) to make navigation easier and cleaner.
-
Lottery System: Implemented a new automated Lucky Draw feature.
-
Example: You can configure it to run every Friday with a prize of 1,000 points. The system will automatically pick a random customer, add the points to their balance, and send them a "You Won!" message via WhatsApp or Facebook Messenger.
-
Download link: https://mega.nz/file/kFl2BJbJ#R3m1pVrKQkXBww9XN4_bAMgRUk00HIy8HwlQNbd-0Zo
-
Please sign in to leave a comment.
Comments
55 comments