DropStream Sales Channel File Exchange Integration: Flat File Specification

DropStream’s Sales Channel File Exchange (SCFE) lets you send CSV-formatted orders into DropStream for fulfillment by your warehouse — useful when a sales channel has no direct API or app integration.

How do I use DropStream SCFE?

To use the DropStream Sales Channel File Exchange, contact DropStream Support at support@getdropstream.com, and request more information about a DSCFE connection.

The following Flat File Specification describes how to format a CSV file tor setting up a DropStream SCFE connection.

Flat File Specification

DropStream SCFE files are formatted as variable-length, comma-delimited text.

There are three types of DropStream SCFE file:

• Order Files contain Pick Header (PH) and Pick Detail (PD) records.
• Shipment Files contain records about confirmed shipments.
• Inventory Files contain records comprising a snapshot of current inventory levels.

Order File format

Pick Header and Pick Detail records for a single order are grouped together in a single file, with Pick Header first, followed by its associated Pick Detail record(s).

The following is a picking order sample (PH and PD records). Each record occupies a single line in the file.

"PH","2016981433","12345678","JOAN HARRY","5050 Road N","","Waterloo","ON","N1N 1N1","CA","","555-666-7777","JOAN HARRY","5050 Road N","","Waterloo","ON","N1N 1N1","CA","Ground","P","","2020-03-07T00:00:00Z","AMZ",""
"PD","2016981433","1","13358A","16","0.00"
"PD","2016981433","2","2564A","6","0.00"
"PD","2016981433","3","568955","6","0.00"
"PD","2016981433","4","5666","6","0.00"
"PD","2016981433","5","5665","4","0.00"

Pick Header (“PH”) record

The Pick Header (PH) record contains the following values, in this order:

| Field Name | Required (Y/N) | Notes/Value(s) | | — | — | — | | Record Type | Y | "PH" | | ClientOrderNumber | Y | The number that is unique to this order as assigned by the source sales channel | | Customer PO Number | N | The purchase order number used by the customer when the goods were ordered | | Ship to Name | Y |   | | Ship to Address1 | Y |   | | Ship to Address2 | N |   | | Ship to City | Y |   | | Ship to Province/State | Y | Provide standard US Postal Service and international codes | | Ship to Postal/Zip Code | Y |   | | Ship to Country | Y | ISO Alpha-2 | | Ship to Attention | N |   | | Bill to Name | N |   | | Bill to Address1 | N |   | | Bill to Address2 | N |   | | Bill to City | N |   | | Bill to Province/State | N | Provide standard US Postal Service and international codes | | Bill to Postal/Zip Code | N |   | | Bill to Country | N | ISO Alpha-2 | | Bill to Attention | N |   | | Ship Method | Y | Ship Methods Code - Carrier & Service Level | | Ship Payment Type | N | Collect/Consignee = "C"
Bill Recipient = "R"
Third Party = "T"
Prepaid = "P" (the default value if blank) | | Ship Pay Account Number | N |   | | Order Date | N | Format: "YYYY-MM-DDThh:mm:ssZ"

Pick Detail (“PD”) record

The Pick Detail (PD) record has the following format:

See the attached Sample Order File for an example of PH and PD records.

Examples by DropStream adapter version:

Sample Order File — DS adapter version 1

Sample Order File — DS adapter version 2

Sample Order File — DS adapter version 3

Shipment File format

Shipment confirmation files are sent to the FTP as a notification of orders and items that have shipped.

See the attached Sample Shipment File for an example.

Inventory File format

The inventory snapshot file is sent to the FTP as a notification of inventory levels at the point in time the file was generated.

See the attached Sample Inventory File for an example.

Sample Files

• Order Files

  • Sample_Order_File.csv
  • ds_adapter_version_1_order_file_all_fields_filled.csv
  • ds_adapter_version_2_order_file_all_fields_filled.csv
  • ds_adapter_version_3_order_file_all_fields_filled.csv

• Shipment File

  • Sample Shipment File

• Inventory File

  • Sample Inventory File

Attachments