🔍
📦
Filter by goods type...
✕
▾
0 Containers Shown
Active Shipments
Released Shipments
Add New Customer
Customer Accounts
| Customer ID | Name | Phone | Password | Actions |
|---|
Import Customers from Sheet Data
Scans every shipment currently loaded (Michy, Deia, Ayman & the main Updates/Released sheets) for customer numbers that don't have a user account yet, so you can see who's missing and add them in bulk — with a random password and a phone number, even if they never log in themselves.
Backup & Restore
Export your customer accounts and settings to a file, then import on any device to keep everything in sync.
Google Drive Connection
Connect your Excel files from Google Drive. Sharing must be set to "Anyone with the link can view".
📁 2025 File (Historical)
Not connected
📁 2026 File (Current Year)
Not connected
Manual Upload (Fallback)
2025 file:
📂 Upload 2025 Excel (.xlsx)
2026 file:
📂 Upload 2026 Excel (.xlsx)
Activity Log
| Date & Time | Event | User | Details |
|---|
⚠ CORS Blocked — Use Google Apps Script Instead
Browsers block direct access to Google Drive from local HTML files. The fix is a free one-time Google Apps Script setup that acts as your own proxy. Takes ~2 minutes.
Step 1. Go to
script.google.com
→ click New project
Step 2. Delete everything and paste this code:
const FILE_ID = 'PASTE_YOUR_FILE_ID_HERE';
function doGet() {
const file = DriveApp.getFileById(FILE_ID);
const blob = file.getBlob();
return ContentService
.createTextOutput(Utilities.base64Encode(blob.getBytes()))
.setMimeType(ContentService.MimeType.TEXT);
}
Replace PASTE_YOUR_FILE_ID_HERE with your file ID.
Your file ID is the part of your Drive link between /d/ and the next /.
Example: docs.google.com/spreadsheets/d/THIS_PART/edit
Your file ID is the part of your Drive link between /d/ and the next /.
Example: docs.google.com/spreadsheets/d/THIS_PART/edit
Step 3. Click Deploy → New deployment → Type: Web app
Set "Who has access" to Anyone → click Deploy
Set "Who has access" to Anyone → click Deploy
Step 4. Copy the Web app URL and paste it in the Drive link field above → Save & Connect
ℹ The script runs on Google's servers and serves your file directly — no third-party proxies needed.
🔍
👤
📁
📦
Filter by goods type...
✕
▾
0 Containers Shown
🚢 In Port — Active
📅 Upcoming Arrivals
✅ Released