OrderPilot Help
Help β€Ί Integrations

EDI vendor connections

Connect each vendor's EDI documents β€” purchase orders, acknowledgments, invoices, ship notices and catalogs β€” over SFTP, FTP, AS2 or email, with schedules and file history.

What it's for

Many vendors exchange orders and paperwork as EDI files. OrderPilot sends your purchase orders to the vendor and picks up the vendor's replies on a schedule. Each vendor has five document types:

Tab EDI type Direction What it is
πŸ“€ PO 850 You β†’ vendor Your purchase order.
βœ“ Ack 855 Vendor β†’ you The vendor confirms or rejects each PO line.
πŸ’° Invoice 810 Vendor β†’ you The vendor's invoice. It marks the order OK to ship.
🚚 Shipments 856 Vendor β†’ you The advance ship notice, with tracking.
πŸ“¦ Inventory 832 Vendor β†’ you The vendor's catalog and price file.

Where to find it

βš™ Settings β†’ Vendors & EDI. Click a vendor's box.

The screen at a glance

Each vendor box shows how many document connections are active and which types exist.

Click a vendor to open its panel. Across the top are the five document tabs. Under each are three sub-tabs: πŸ”Œ Connection, ⏰ Schedule and πŸ“œ History, plus an Active / Paused switch for that document.

Connection

Field What to enter
Method SFTP, FTP, AS2 or Email.
Host The vendor's server address, for example edi1.vendor.com.
Port Usually 22 for SFTP and 21 for FTP.
Username / Password The login the vendor gave you.
Remote path / folder The folder to send to or pick up from, for example /in or /out.
File pattern (optional) Only files matching this pattern are picked up, for example *855*.
Notes Your own notes.

With Email chosen, the server fields are replaced by:

Email transport is new. The setup saves now; sending and pickup start working once email vendors are switched on.

Schedule

History

Every file sent or received, newest first: status (sent, processed, error), file name, date and a short result.

Buttons and actions

Button What it does
βž• Add a vendor Asks for the vendor's name and adds a new vendor box. Then open it to set up documents.
Active / Paused switch Turns this document on or off. Save the connection first, or you get "Save the connection first".
Save connection Saves the connection fields.
πŸ§ͺ Test (saved settings) Tries to log in to the server with the saved settings and shows the result. Save first if you changed anything. Not shown for Email.
β–Ά Run now Runs this document once right away (send or pick up). Check History or the Jobs log for the result.
+ Add time Adds the time from the time box as a new chip.
βœ• on a time chip Removes that time. Click Save schedule to keep the change.
Save schedule Saves the schedule switch, mode, times or interval.
⬇ (History) Downloads the file.
↻ (History) Processes the file again β€” for example re-applies an 855 to update order statuses.

How to connect a vendor's EDI

  1. Get the connection details from the vendor: method (SFTP, FTP or AS2), host, port, username, password, and the folder for each document.
  2. Open Settings β†’ Vendors & EDI. If the vendor is new, click βž• Add a vendor and type its name.
  3. Click the vendor's box. The πŸ“€ PO tab opens.
  4. On πŸ”Œ Connection, choose the Method and fill in host, port, username, password and folder.
  5. Click Save connection, then πŸ§ͺ Test (saved settings). You should see a success message.
  6. Open ⏰ Schedule. Turn on Enable schedule, choose a mode and add times (for example 09:00 and 14:00), then click Save schedule.
  7. Make sure the Active switch is on.
  8. Repeat for βœ“ Ack, πŸ’° Invoice, 🚚 Shipments and πŸ“¦ Inventory, using the folders the vendor gave you for each.

How to re-run a file that failed

  1. Open the vendor and the document tab, then πŸ“œ History.
  2. Find the file. Click ⬇ to look at it if needed.
  3. Click ↻ to process it again.

Tips and troubleshooting

Still stuck? Email support@softavant.com and tell us what you were trying to do.