PO Upload Processor

Automated Product Catalog Integration & Analysis with Smart Estimation

📋 Instructions

  1. Upload your Product Catalog CSV file (contains SKU information, carton quantities, weights, and volumes)
  2. Upload your PO Upload Excel file (purchase order data from Amazon)
  3. Click "Process Files" to generate the complete analysis
  4. The tool will create multiple worksheets with calculations and pivot tables
  5. Missing logistics data will be intelligently estimated using similar products
  6. Detail rows show fractional pallets (Volume÷75), pivot tables show shipment pallets (<15 cartons = 0, ≥15 cartons = rounded up whole numbers, min 1)
  7. Download the processed Excel file with all tabs ready for use
🧠 NEW: Smart Estimation Engine - When product data is missing, the tool will automatically estimate values based on similar SKUs, product families, and category defaults. An "estimation used" tab will show which values were estimated.

📦 ENHANCED: Simplified Pallet Logic - Detail rows use fractional pallets (Volume÷75), while pivot tables use shipment logic (<15 cartons = 0 pallets, ≥15 cartons = whole pallets rounded up from Volume÷75, minimum 1).

Processing Status