The DropStream Warehouse File Exchange is a file-based Warehouse Management System integration. It uses three types of files for the integration:
- Sales Order files
- Shipment Confirmation files
- 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 conventionord_*.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 conventionshp_*.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 conventioninv_*.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
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
Batch File Processing Specification
File Transfer Connection Strings
Comments
Please sign in to leave a comment.