📊 Invoice Generator

Multi-System Invoice Generation Platform

🚀 ERPNext Workflow (Recommended)

Benefits: Faster processing, real-time data, no mapping required
Process: Upload Excel with order numbers → Fetch from ERPNext API & V-Measure → Generate invoice data

📋 Input Requirements

Upload an Excel file with order_no column containing Shopify order numbers:

  • Format: #43-30221-21 or 43-30221-21
  • Multi-shipment: 43-30221-21_1
  • Data fetched from ERPNext automatically
Choose Excel file with 'order_no' column

🔄 Katana Workflow (Legacy System)

Note: Consider switching to ERPNext for better performance
Process: Upload Excel with order numbers → Fetch from Katana API & V-Measure → Generate invoice data

⚠️ Legacy System Notice

This workflow uses the older Katana integration. It requires:

  • Google Sheets order mapping (synced hourly)
  • Multiple API calls per order (slower)
  • Background scheduler for updates

Recommendation: Migrate to ERPNext workflow above for faster processing.

Choose Excel file with 'order_no' column

📦 FedEx Commercial Invoices

Upload pre-filled master sheet (generated from ERPNext or Katana) → Generate FedEx Commercial Invoices

📄 Input Requirements

Upload the master sheet generated from either ERPNext or Katana workflow above. The system will create professional FedEx commercial invoices.

Choose the master sheet with invoice data