The DropStream Warehouse File Exchange is a file-based Warehouse Management System integration. It uses three types 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
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:
Batch File Processing Specification
File Transfer Connection Strings
Comments
Please sign in to leave a comment.