Import Historical Waybill Mappings

Upload bulk UPS files that you've already parsed by hand to teach the system historical waybill-to-customer mappings.

Total Waybill Histories

11,586

Stored in database
Last 24 Hours

296

Newly imported
Unique Customers

90

With imports (last 7 days)
Upload Historical Bulk File

Click to upload or drag and drop

Excel files only (.xlsx, .xls)

File Format Requirements:
  • Column A: Shipment Date (e.g., 2025-10-10)
  • Column B: Customer/Company Name or Username (e.g., PTXCARDS, PhucLe8)
  • Column C: Waybill/Tracking Number (e.g., 1ZA1T871...)
  • Column I: Sender Name (name_from field - e.g., "1000607114 ONTARIO INC.") - enables historical sender matching
  • For full UPS export format with all columns (date, company, waybill, weights, name_from, etc.)
  • Headers will be auto-detected (looks for "Waybill" or "Tracking" in first 10 rows)
What This Does:
  • Creates WaybillHistory records for each waybill → customer mapping
  • Enables Priority 3 (Historical Waybill at 100% confidence) for future uploads
  • If Column D provided: Enables Priority 0.6 (Historical Sender Matching) for sender name associations
  • Skips duplicate waybills automatically (safe to re-run)
  • Matches customer names intelligently (tries exact, case-insensitive, partial, and excel_searchname)
Import from Final Invoices (NEW)

Click to upload or drag and drop

Select multiple final invoice Excel files

What This Does:
  • Select multiple final invoice files (e.g., "Calvin Ng A1T871 November 22, 2025 #475.xlsx")
  • Customer name is extracted from filename (everything before " A1T871")
  • Waybill numbers are parsed from Column C (starting from first row with "1Z")
  • Creates WaybillHistory records for future auto-matching
  • Skips duplicates and waybills already in database
Benefits of Historical Import
Instant Learning

System learns from all your old files at once

100% Confidence

Historical waybills auto-match at highest confidence

Time Savings

Dramatically reduces manual Stage 2 assignments

Safe Operation

Only creates new records, never modifies existing data

Recent Activity (Last 7 Days)
Simple Supplies Canada 1,299 waybills
Kozmo 1,283 waybills
BB Branded 1,106 waybills
Deck Out Gaming Ltd. 864 waybills
Yume Cards 721 waybills
HPW Cards Inc. 517 waybills
1000607114 Ontario Inc (New Wave TCG) 443 waybills
1261692 Ontario Ltd (KD Collectibles Ltd) 378 waybills
Trinity Hobby 351 waybills
Poké Jeux 324 waybills