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 be define 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_ordernumber_YYMMDDhhmmss.csv.
  • Outbound shipments must be placed into the /out directory with the file naming convention shp_YYMMDD.csv.
  • Outbound inventory must be placed into the /out directory with the file naming convention inv_YYMMDD.csv.
  • 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.