ADMIN
Upload from Google Sheet
Export your Google Sheet (File → Download → CSV or Microsoft Excel) and upload it here. Supported: .csv, .xlsx, .xls. New serial numbers are added and existing ones are updated. Files containing duplicate serial numbers are rejected (each serial must be unique).
Master list
Batch numbers are visible here for admins only — they are never shown to customers.
Add item
| Serial Number | Item Code | Item Name | Manufacture Date | Batch | Scanned | Added by | Scan count | Actions |
|---|
No records match your search.
SL No generation
Generate random 6-character alphanumeric serial numbers. Each serial is checked against the master list and other pending serials, so no duplicates occur. Generated serials are reserved for 15 days. The downloaded .xls already contains the upload headers (Serial Number, Link, Item Code, Item Name, Manufacture Date, Batch Number) — just fill in the item columns and upload the same file.
| # | Serial Number | Link | QR Label |
|---|
Pending serials (reserved, not yet uploaded)
Serials generated by any user are shown here (reserved for 15 days). Once uploaded, they move to the master list. You can clear your own pending serials here; admins can clear all.
| Serial Number | Generated at | Generated by |
|---|
No pending serials.
Scan product QR
Scan the QR code on a product to see the full record including the batch number, or enter the serial manually.
Point your camera at the product QR code.
Electricians
Create and manage electrician accounts. Electricians scan products to earn points and request redeems.
Add electrician
New password generated
Share this with the electrician — it will not be shown again. They can change it after login.
Batch upload electricians
Download the template, fill in Name / Phone / Address, then upload. Each electrician logs in with their phone number + password. Passwords are auto-generated — download the credentials file right after upload (passwords are shown only once).
| Phone (Login ID) | Name | Password |
|---|
| Phone (Login ID) | Name | Points | Scans | Redeemed | Payment method | Actions |
|---|
No electricians found.
Redeem requests
Approve or reject electrician redeem requests. Approved requests deduct the points and show the electrician's receiving method for payment.
| ID | Electrician | Points | BDT | Payout | Status | Requested | Actions |
|---|
No redeem requests.
Change my password
Signed in as –. Changing your password revokes your current session — you'll be signed in again automatically.
Manage admin users
Admin can create users (admin/subadmin/user), change roles and passwords. Sub-admin can manage other accounts but cannot change or delete the main admin. Passwords are stored hashed.
Add new user
| Username | Role | Source | Override | Last changed | Actions |
|---|
Rewards configuration
Controls how electricians earn and redeem points. Changes apply immediately.
Backup & restore
Download a full backup of all data (master list, users, electricians, redeems, settings) as a JSON file, or restore from a previous backup. Main admin only.
Audit log
Recent admin actions (deletes, config changes, redeems, uploads, and more).
| Time | User | Action | Details |
|---|
No audit entries yet.
Suspicious scans
Verification attempts that did not match the master list — possible counterfeit or invalid serials.
| Serial tried | IP | Time |
|---|
No suspicious scans yet.