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.
  • Each merchant must have a unique FTP login.
  • 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_ABC123_202201291435.csv, where the file name consists of the required file prefix, order ID, and dateTime formatted as YYYYMMDDHHSS.
  • Outbound shipments must be placed into the /out directory with the file naming convention shp_*.csv. For example, shp_467890_202201291435.csv, where the file name consists of the required file prefix, a unique identifier, and dateTime formatted as YYYYMMDDHHSS.
  • Outbound inventory must be placed into the /out directory with the file naming convention inv_*.csv. For example, inv_1_202201291435.csv, where the file name consists of the required file prefix, inventory version number and dateTime formatted as YYYYMMDDHHSS.

Important: All filenames must begin with the correct prefix (e.g. inv_ for inventory), have file extension .csv, and must be unique.

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.