DropStream Warehouse File Exchange Description

The DropStream Warehouse File Exchange is a file-based Warehouse Management System integration. It uses three types of files 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

DropStream 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 you or by DropStream, whichever is preferred.

Specifications

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.