⚠ IMPORTANT: Select the correct Model, Storage, and Color from the dropdowns BEFORE scanning. Only use this text for this.
Scanner is OFF
Select an invoice and set the model/storage/color above, then click Start
SCANNING ACTIVE — AIM SCANNER AT IMEI BARCODE
Each scan is captured automatically. You can also type manually above.
Current Scan Queue (0)
IMEI Number
Model
Storage
Color
Actions
🧾
Invoices
Phone purchase invoices
All Invoices
Invoice #
Supplier
Date
Total Qty
Amount
Actions
No invoices yet. Click "+ REGISTER NEW INVOICE".
🏢
Suppliers
Manage registered suppliers
Registered Suppliers
Sup #
Name
Phone
Address
Description
Status
Actions
No suppliers yet.
📊
Master Dashboard
Full inventory overview
0
Stock Quantity
0
Total Value
0
Active Suppliers
0
Avg Unit Cost
Master Inventory Database
Date
Sup #
Supplier
Phone
Address
Invoice #
IMEI
Model
Storage
Color
Actions
✅
Available Phones
QC-passed phones ready for selling
✅ Mark Existing Phones as GTS
Paste or upload the IMEIs that should be in GTS (e.g. your 67 new phones). This sets their TestStatus = PASS so they show in GTS counts. Phones already PASS, or not found in inventory, are skipped.
0
Total GTS
0
Available
0
Sold
0/0
Grade LC1 (Avail / Sold)
0/0
Grade LC2 (Avail / Sold)
0/0
Grade LC3 (Avail / Sold)
GTS Phone Inventory
#
IMEI
Model
Storage
Color
EAN
Grade
🔋 Batt%
Region
Technician
Remarks
Status
Edit
No GTS-passed phones yet. Run the QC importer to add test results to your phones.
👨🔧 Technician GTS Performance
Counts phones with TestStatus=PASS, grouped by Tester. Week = Mon → today.
💰
Sold Phones
Sales invoices — create one for every sale
Total Invoices
0
Total Revenue
AED 0
Today
0
This Month
0
📊 Per-Model Summary
Aggregates by Full Model from currently displayed sales
Full Model
LC2
LC1
LC3
Total Qty
Unit Purchase
Parts Cost
Final Purchase
Unit Selling
Final Selling
Profit
No sales to summarize.
📋 Per-IMEI Sales
No
IMEI
Model
Storage
Color
Grade
Battery
Region
Unit Purchase Price
Auto Parts
Extra Parts
Total Phone Price
Unit Selling Price
Final Selling Price
Profit
Sold On
Invoice #
No sales yet. Click 📋 NEW SALES INVOICE above to record sales.
Invoice #
Date
Customer
Lines
Total Qty
Grand Total
Action
No invoices yet. Click 📋 NEW SALES INVOICE above to create your first.
📋 New Sales Invoice
Pick phones already recorded as sold, set unit prices, then save
📦
Pick Phones for This Invoice
Only unbilled sales are shown. Add more via ➕ ADD SOLD PHONES.
IMEI
Model
Storage
Color
Grade
Sold On
No unbilled sales available.
0 selected
📋 Invoice Lines (auto-grouped)
#
Item Description
Qty
Grade
Unit Price (AED)
Total
Tick phones above to see grouped lines.
GRAND TOTAL:
AED 0.00
No items yet
➕ Add Sold Phones
Scan IMEIs from GTS to record sales. Prices added later when you build an invoice.
#
IMEI
Model
Storage
Color
Grade
Nothing scanned yet
0 phones scanned
🏷️ Part Barcode Labels
A barcode (Code128) for each part. “Print Labels” makes a PDF — one page per label at your exact mm size. Open it and print at 100%.
Label×mm
📥 Upload Sales File
Bulk-add phones from GTS to Sales. One IMEI per row.
• The file must have a single IMEI column (header on row 1, IMEIs below).
• Every IMEI must be in GTS (TestStatus = PASS, not yet sold).
• If any IMEI is already sold OR not in GTS, the upload is refused and a full list of problems is shown — fix the file and re-upload.
• On success, all phones are added to Sales as unbilled (price entered later via invoice).
#
IMEI
Model
Storage
Color
Grade
Status
Adding phones to Sales...0 / 0
💵 Bulk Update Sales Prices
Match by IMEI → fill Parts Cost + Selling Price (USD) for existing Sales.
• Required columns: IMEI, PartsCostUSD, SellingPriceUSD.
• Optional: PurchasePriceUSD (overrides per-phone purchase snapshot).
• System converts USD → AED using live FX rate at upload time.
• Updates existing Sale records (matched by IMEI). New IMEIs not in Sales → reported as errors.
• Sales remain "unbilled" (no invoice link) until you build an invoice. You can still edit prices later via ✏️.
#
IMEI
Model / Storage / Color
Purchase (USD)
Parts Cost (USD)
Selling (USD)
→ AED Purchase
→ AED Parts
→ AED Selling
Status
Updating Sales records...0 / 0
✏️ Edit Unit Price
⚠️ This sale is on an invoice. The invoice's grand total will be recalculated.
✏️ Edit Extra Parts Cost
This is the cost of parts that were used on this phone but not tagged with the IMEI at issue time. The system automatically calculates parts that WERE tagged with this IMEI.
✏️ Edit GTS Phone
💵
Pricing Table
Standard Purchase + Selling prices per Model + Storage (in USD)
0
Model + Storage rows
$0
Avg Purchase
$0
Avg Selling
#
Model
Storage
Purchase Price (USD)
Selling Price (USD)
Margin
Notes
Actions
No pricing rows yet. Click ✨ Seed Initial Rates to load the 16 entries from your reference sheet, or ➕ ADD MODEL to enter one manually.
📋 Per-IMEI Cost Breakdown
Paste IMEIs (one per line) or upload an Excel column of IMEIs. Edit Extra Parts inline for any phone missing parts cost.
#
IMEI
Model / Storage / Color
Purchase
Auto Parts (AED)
Extra Parts (AED)
Total Cost (AED)
Status
📊 Batch Selling Summary
Paste or upload IMEIs already in GTS — builds a per-model profit summary in USD using your selling prices.
💵 Add Pricing Row
Margin:$0.00 (0%)
📊
EAN Scanner
Scan or type an EAN barcode to find the phone
💡 Tip: Just point your barcode scanner at the EAN code on the phone box.
⚠ No phone found with this EAN. Try scanning again or check the code.
🔧 PARTS & REPAIR
📋 Supervisor
Supervisor log of parts technicians need. Mark as given when handed over.
➕ New Request
Requests (Pending: 0)
Date
Supervisor
Tech
IMEI
Model
Part
Priority
Status
Action
🧾
Parts Invoices
Part purchases grouped by invoice #
Invoice #
Supplier
Date
Line Items
Total Qty
Amount
Photo
No parts invoices yet.
📦
Part Entry
Record parts received from supplier
Stock Received History
Date
Part Name
iPhone Model
Color
Supplier
Ref #
Qty
Unit Price
Total Value
Actions
No stock entries yet.
🔩
Part Issue
Issue parts for repair jobs
📷
Scan Part Barcode
Click the box, then scan a part label — it fills the part fields below automatically
📤
Bulk Issue Parts from Excel
Upload your QC sheet — auto-issues Battery Cell, Strips, Housing per row
🛒
Cart Mode
OFF — issue one part at a time
Total Received
0
Net Used
0
Returned
0
Available
0
Auto = oldest batch (FIFO)
— pick an IMEI to see —
🛒 Parts Cart 0
📱 IMEI:
👤 Tech:
IMEI + Tech locked while cart has items. Clear cart to change them.
Part
Model
Color
Supplier
Qty
Unit AED
Total
Cart is empty. Pick a part above and click + Add to Cart.
CART TOTAL:
AED 0.00
Issuance History
Date
Part Name
iPhone Model
📱 IMEI
Color
Technician
Job Ref
🏭 Supplier
Qty
Unit Price
Total Value
Action
No issuances yet.
🛒
Order List
Parts to reorder — low or out of stock
Parts to Reorder
Part
Model
In Stock
Usual Supplier
Last Cost
🙋 Requested by Technicians (not in stock)
🛠️
Damaged Parts
Track parts damaged by technicians during repair — kept separate from normal usage
🛠️ RECORD A DAMAGED PART
This will deduct from your stock just like Parts Usage, but it's tracked separately for accountability.
📊 Damage by Technician
No damage records yet.
🛠️ Damage History
Total Loss: AED 0
Date
Technician
📱 IMEI
Part
iPhone Model
Color
Qty
Reason
Notes
Cost
Action
No damage records yet.
📱
Phone Repair Cost
See all parts installed on a phone (by IMEI) and total parts cost
💡 Tip: You can also click any IMEI in the IMEI Database, Parts Usage, or Returns tables to jump here.
Parts Installed
0
Returned
0
🛠️ Damaged
0
Net Parts
0
Total Parts Cost
AED 0
🔩 Parts Installed
Date
Part Name
Color
Technician
Qty
Unit Price
Total
Job Ref
↩️ Parts Returned (deducted from cost)
Date
Part Name
Color
Technician
Qty
Unit Price
Refund
Condition
🛠️ Damaged Parts (added to cost)
These parts were damaged during repair on this phone — the cost is real and is included in the total.
Date
Part Name
Color
Technician
Qty
Unit Price
Cost
Reason
📱
Enter an IMEI above to see all parts installed on that phone.
✨
No parts have been installed on this phone yet.
📊
Parts Dashboard
Full inventory overview with values
Total Received
0
units in stock
Qty Used
0
units issued
Returned
0
units back
Qty Remaining
0
available now
Total Stock Value
AED 0
total investment
🚚 Total Shipping
AED 0
across 0 invoices
🚚 Invoice Shipping Summary
Shipping cost recorded per invoice (supplier + ref). Click 🚚 Set Shipping to edit.
Supplier
Ref #
Parts on Invoice
Invoice Value
Shipping Cost
Grand Total
No invoices yet.
📋 Parts Inventory
Part Name + iPhone Model + Color. Filter by invoice to scope Total In & Total Cost.
Part Name
iPhone Model
Color
Total Qty In
Avg Unit Price
Total Cost
Qty Used
Returned
Net Used
Qty Remaining
Net Used Cost
No stock data yet.
👤 Technician Summary
Technician
Parts Issued
Parts Returned
Net Used
Total Value Used
📅
Daily Parts Usage Report
Parts issued by date — filter and print
0
Total Entries
0
Total Qty Used
AED 0
Total Value
0
Technicians
Parts Usage Report
#
Date
IMEI
Part Name
iPhone Model
Color
Technician
Invoice Ref
Qty
Unit Price (AED)
Total Price (AED)
Select date range and click Generate.
⚠️
Low Stock — Order Report
Parts that need to be reordered
0
Out of Stock
0
Low Stock
0
Total Items
0
Units to Order
⚠️ Parts Needing Reorder
🔴 Out of Stock | 🟡 Low Stock
#
Part Name
iPhone Model
Color
Total Received
Total Used
Remaining
Suggested Order Qty
Status
Set threshold and click Generate.
📥 Import IMEIs from Excel
STEP 1 — Download Template
Fill in just 3 columns: IMEI, Model Name, Price — one row per phone.
📝 Model Name should be the full description: "iPhone 12 Pro Max 256GB Black" — the system will split it into Model / Storage / Color automatically. 📦 Date, Supplier, and Invoice info will come from the invoice you select in Step 2.
STEP 2 — Select Invoice
STEP 3 — Upload Excel File (.xlsx or .xls)
0 IMEIs ready to import
#
IMEI
Model
Storage
Color
Price
Status
💰 Bulk Update Phone Prices
FILL IN PRICES FOR PHONES MISSING A PRICE
Step 1: Filter by model (and storage if you want) → click Download Price Sheet.
Step 2: In the Excel, fill in New Price for each phone (one column only — IMEI/Model/Storage are locked).
Step 3: Upload it back. Only rows with a New Price are updated; blanks are skipped.
⓵ Only phones without a price appear in the download (focus on what's missing).
STEP 1 — Pick Filter & Download Sheet
Pick a model to see how many phones need pricing.
STEP 2 — Upload Filled Price Sheet
0 matched / 0 not found
#
IMEI
Model
Current Price
New Price
Status
📋 Import QC Test Data
Add QC results to phones already in your database
Upload your QC Excel — the system matches each row by IMEI to an existing phone, then updates its QC fields.
Phones not in the database are flagged "Not Found" and skipped. No new phones are created.
STEP 1 — Download Template (Optional)
Pre-filled with all your IMEIs + current QC data (if any).
📝 You can also upload your QC Excel directly without downloading the template — as long as it has an IMEI column, the system maps the rest automatically.
STEP 2 — Upload QC Excel
0 matched / 0 not found
#
IMEI
Model
Grade
🔋
Carrier
Tester
EAN
Status
Updating...0 / 0
✨ Import NEW GTS Phones
Bulk-add new phones to GTS — duplicates auto-skipped
• IMEIs already in the database are silently skipped (no re-upload of the same list).
• New IMEIs are created with TestStatus = PASS so they land directly in GTS Phones.
• Technician (Tester) is optional — phones without one still count and appear in GTS.
• Required column: IMEI. Optional: Model, Storage, Color, Grade, Battery Health, Tester, Region, Comments.
Upload Excel
✨ 0 NEW to add
🔄 0 existing → will be UPDATED
❌ 0 bad rows
#
IMEI
Model
Storage
Color
Grade
🔋
Tester
Region
Status
Creating new GTS phones...0 / 0
🩺 Bulk Add Doctor Phone Error
Record diagnosed errors for phones in bulk
Upload an Excel with two columns: IMEI and Doctor Phone Error.
The system will find each IMEI in your database and update its Doctor Error field.
Phones not in the database are skipped — no new phones are created.
STEP 1 — Download Template
Two-column file: IMEI + Doctor Phone Error.
The template comes pre-filled with all your IMEIs (and any errors you've already recorded). Fill in the error column and re-upload.
STEP 2 — Upload Filled Excel
0 matched / 0 not found
#
IMEI
Model
Current Error
New Error
Status
Updating...0 / 0
💱 Fix Currency Label on Phones
Bulk-change the Currency label on phones
Use this when prices were entered in the wrong currency. This only changes the label — the price number stays the same.
Example: 222 phones with "AED 1,730" become "HKD 1,730".
FROM — Phones currently labeled as:
— phones match this filter.
TO — Change label to:
Updating...0 / 0
⚠️ DANGER ZONE — Wipe All Phones
🚨 This will permanently delete ALL phones from your IMEI database.
• 0 phones will be deleted.
• Parts Usage / Returns / Damaged Parts records will be KEPT (orphaned by IMEI).
• Invoices and Suppliers will be KEPT.
• This cannot be undone — please back up first.
STEP 1 — Download backup first
A full Master Excel will be saved to your Downloads folder.
✓ Backup saved
STEP 2 — Type confirmation
To confirm, type exactly: DELETE 0
Deleting...0 / 0
👥 User Management
Manage all registered accounts. Only admins can promote, demote, or delete users.
Email
Name
Role
Auth Method
Created
Actions
Loading...
Edit Record
Changes will be recomputed with FIFO stock tracking.
Pick a batch to change which supplier this is deducted from.
🔑 Change Password
Choose a batch
This part has multiple stock batches. Choose which one to edit or delete.
✨ Categorize Part Names
Review the proposed renames below. Editable — change any suggestion to whatever you want, untick rows to skip them.
Then click Apply Renames to update all matching records across stock-in, parts usage, and returns.
Use the canonical format: Category / Variant.
Scanning…
Current name
→
Proposed name (editable)
Records
🚚 Set Invoice Shipping
Set the total shipping cost for an entire invoice. The amount is distributed across all parts on that invoice proportionally to their value.