DropStream Warehouse File Exchange Description

DropStream Support

February 01, 2022 17:10

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 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.