PO ARN Processor
Match Purchase Orders with Amazon Reference Numbers using multiple shipment files and vendor codes
📋 Instructions
Upload your
PO Upload Processed Excel file
(contains purchase order data with vendor codes)
Upload
multiple Shipments CSV files
(can select multiple files at once or drag & drop multiple files)
The tool will match based on:
Order/PO Number
- Must match exactly
Fulfillment Center
- Matches FC codes from shipments
Vendor Code
- Matches channel-specific vendor codes
PO Warehouse Final
- Matches with Ship from location (Encore/UNIS)
The tool handles multiple Amazon channels with same PO numbers going to same FC from different warehouses
Download the processed Excel file with ARN column added to all accept sheets
📊
PO Upload Processed File
Excel file (.xlsx) with vendor codes & warehouse data
Choose PO Upload File...
🚚
Shipment Files
Multiple CSV files with ARN and shipping data
Choose Shipment Files...
💡 You can select multiple CSV files at once
Process Files & Generate ARN Data
Processing...
✅ Processing Complete
📥 Download Combined File