DropStream Warehouse File Exchange Description

The DropStream Warehouse File Exchange is a file-based Warehouse Management System integration. It uses three types for the integration:

  1. Sales Order files
  2. Shipment Confirmation files
  3. Inventory files

File transfer requirements

These files are transferred via FTP, FTPS, or SFTP, with the following requirements:

  • The root directory must include two folders, /in and /out.
  • File format is CSV.
  • Inbound files, such as Sales Orders, will be placed into the /in directory with the file naming convention ord_*.csv. For example,  ord_1234_2104291435.csv, where the file name consists of the required file prefix, order number and date-time.
  • Outbound shipments must be placed into the /out directory with the file naming convention shp_*.csv. For example, shp_467890_210429.csv, where the file name consists of the required file prefix, tracking number and date.
  • Outbound inventory must be placed into the /out directory with the file naming convention inv_*.csv. For example, inv_1_210429.csv, where the file name consists of the required file prefix, inventory version number and date.
  • Each merchant must have a unique FTP login.

Sample CSV files

CSV Sample Order File

CSV Sample Shipment file

CSV Sample Inventory file

Supported protocols

The File Exchange supports the following file transfer protocols:

  • FTP (least secure)
  • FTPS (more secure)
  • SFTP (SSH + FTP) (most secure)

The file transfer service can be hosted by the user or by PackageBee, whichever is preferred.

Specifications

The File Exchange supports the following file transfer protocols:

PDF Batch File Processing Specification

Flat File Specification

File Transfer Connection Strings


Attachments

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.