Dashboard
—
Today
—
+1 day
—
+2 days
—
+3 days
—
Total active
—
Filtered
Expiring — next 15 days
Loading...
Active days 45–49
Loading...
Group overview
Group | Total | Today | +1d | +2d | +3d |
|---|---|---|---|---|---|
| Loading... | |||||
SP Management
⚠ Showing first 2000 records — use column filters to narrow down results
Show / page —
Group ▼ |
Card ID |
Phone |
1st Topup ▼ |
Expire ▼ |
Last Renew |
Active days ▼ |
|
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
0 selected
Replace Numbers
Card swap time (1st Topup)
Sets: 1st Topup = this time | Last Renew = this time | Expire = +7 days
Paste new number list
Import Data
Backup & restore
Download a full backup of all phone data as CSV. Use this file to restore data after a reset.
Import CSV
Export from Google Sheets: File → Download → CSV. Duplicates auto-updated.
Accepted column names
Field | Accepted names |
|---|---|
| Phone | phone_number / number / sp-1 / phone |
| Group | sheet_name / sheet |
| Card ID | ucs_card_id / device_no / no |
| Expire | expire_at / expire date / expire |
| Last renew | last_renewal_at / renewal |
| 1st topup | activated_at / 1st topup |
Data management
UCS Compare
Upload UCS data
CSV needs card_id and phone_number. +63xxx auto-converted.
Compare results
—
Mismatch
—
Missing in UCS
—
Extra in UCS
Group Config
Card ID prefix mapping
Group detected by card ID prefix. e.g. 101005 prefix 101 → P-1
GroupPrefix
Range (auto)Count
Prefix test
Type to test