| IMEI | Status | Cond. | Batch | SIM | Merchant | Customer | Activated |
|---|
| SIM serial | MSISDN | Status | Paired router | Customer | Last recharge | Returned | Submitted | In MTN base |
|---|
One device per line: IMEI or IMEI;SIM (comma or tab also work).
| IMEI | SIM | Batch | Result |
|---|
| Order | Merchant | Placed | Allocated |
|---|
In-stock routers not yet listed on the app db. Activation is blocked until a router is listed, so run this right after intake.
Returned SIMs not yet submitted to MTN for delisting. Choose which ones to send, and re-download any past submission to check MTN acted on it.
Factory-fault routers awaiting return to MTN, pre-filled in their claim format (fault descriptions, dates). Review before sending; upload the final file back as an import to mark them submitted.
Downloading marks the selected SIMs as submitted and dates the submission, so the exact list stays reproducible on the right. Unselected SIMs stay in the queue.
| SIM serial | MSISDN | Last router | Returned | Last recharge |
|---|
“Still in base” counts SIMs MTN kept reporting after we submitted them — those were not actioned. Re-queue puts one back in the list above.
| Submitted | SIMs | Still in base |
|---|
| IMEI | Status | Batch | Merchant | Reason |
|---|
A router sitting in a merchant's stock does not recharge, so a recent recharge is strong evidence it reached a customer and the activation was never captured. Applying one records an activated event dated to the SIM's first recharge, marked inferred with the recharge evidence attached. Dismiss instead if the merchant really does still hold it — the row will stop coming back.
| IMEI | Merchant | Sold | Days held | SIM | 30-day recharges | Proposed activation |
|---|
An app report tried to pair a SIM we have no record of — most often a merchant mistyping the serial at activation. The pairing was not applied, so the device still points at its known SIM and recharge attribution stays correct. Accept if the SIM is genuinely new, reject if it was a typo. Logging a swap on the device beforehand registers the SIM, so a real swap never lands here.
| IMEI | Merchant | Keeping (known SIM) | Proposed by app | Held |
|---|
| Code | Original label | Arrival (approx.) | Devices | Note |
|---|
Upload the Consolidated Tracker export (semicolon CSV). You get a full preview and data-quality report before anything is written. Committing the same file twice is refused; devices that already exist are skipped.
Upload any recurring MTN file — the type is detected automatically: app product report (CSV), MTN weekly base & recharge report (xlsx), Returned Routers / Returned SIMs tabs, or an MTN FWA Returns xlsx. Re-uploading overlapping data only applies what's new.
| # | Kind | File | Status | Applied | When |
|---|