📦 Reconcile OrderOP + NinjaVan (Upload CSV → Report Marketer)

Upload Order OP CSV (ada phone + marketer) dan NinjaVan CSV (ada phone + status + tracking + COD). Sistem akan padankan ikut phone, classify status (Complete/Return/Cancel/In Transit), dan keluarkan Complete sale setiap marketer. Semua berjalan di browser (client-side).

Status: Belum proses

1) Upload CSV

Order OP CSV

Contoh kolum: phone, marketer, order_id, date (optional)

NinjaVan CSV

Contoh kolum: phone, status, tracking, cod/value, updated_at (optional)

Tip: Kalau NinjaVan ada banyak row untuk phone sama, sistem akan pilih: (1) row yang nampak Complete dulu, kalau tak ada → (2) row latest updated_at (jika ada), kalau tak ada → (3) ambil row terakhir.

2) Pilih Kolum (Auto detect lepas upload)

Order OP

Phone column (Order OP) Marketer column (Order OP) Order ID column (optional)

NinjaVan

Phone column (NinjaVan) Status column (NinjaVan) Tracking column (optional) COD/Value column (optional) Updated time column (optional)

3) Status Mapping (boleh ubah ikut istilah NinjaVan)

Complete keywords (comma-separated)

Return keywords

Cancel/Fail keywords

In Transit keywords

Sistem match keyword secara contains (case-insensitive). Kalau status tak match mana-mana → “Other”.

✅ Complete Sale Setiap Marketer

Marketer	Complete Orders	Total COD
Belum ada data.

📊 Breakdown Semua Status (ikut marketer)

Marketer	Category	Orders	Total COD
Belum ada data.

🔍 MASTER (OrderOP + NinjaVan merged) — Preview

—
Belum ada data.