SanMar Invoice Converter

Pages 🔄 Transform 📋 Order Dashboard 🎁 Gift Certificates 📊 SanMar Price List 🧾 SanMar Invoices 🖼️ Upload Thumbnail 💰 Payroll Journal 📊 Bonuses
vv256

Download from SanMar FTP

Or select date range: to

Or Upload File Manually

Upload a SanMar invoice detail file (.txt) downloaded from FileZilla or the FTP above.

No file selected

Conversion Logic

Field Mapping

  • InvoiceNumber: "INV-" + SanMar Order ID
  • Sales Order: "SO-" + SanMar Sequence ID
  • PONumber: Your PO number (preserved as-is)
  • Amount: Invoice total, formatted with $

Date Handling

  • PayableDate: Ship date from SanMar (M/D/YYYY)
  • DueDate: Net30 due date (M/D/YYYY)

Constants

  • Id_Vendor: 1002 (SanMar)
  • Id_Vendor_Charge: 1002
  • Imported SW: Left blank (fill after import)