DropStream Sales Channel File Exchange Integration: Flat File Specification

DropStream's Sales Channel File Exchange can be used to send CSV-formatted orders to your warehouse.

How do I use DropStream SCFE?

To use the DropStream Sales Channel File Exchange, contact DropStream Support at support@getdropstream.com, and let us know you want to set up a connection.

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

Flat File Specification

All DropStream SCFE files are formatted as variable-length, double-quote enclosed, comma-delimited text. Null values (corresponding to an empty cell in a spreadsheet) should be represented as two consecutive double-quotes ("").

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","","2016-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
Order Source N Order source used to identify different marketing channels
Gift Message N Gift message to be printed on packing slip

Pick Detail ("PD") record

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

Field Name Required (Y/N) Notes/Value(s)
Record Type Y PD
Client Order Number Y  
Order Line Sequence Number N When using sequence numbers EVERY line must be sequenced
Product Code Y This code is typically different from the UPC and represents an internal code for the item. NOTE: Product SKUs may not contain a ~ (tilde) character.
Quantity Ordered Y  
Unit Price N Format: 9999999.99

➤ See the attached Sample Order File for an example.

Additional examples per 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.

Field Name Required (Y/N) Notes/Value(s)
ClientOrderNumber Y Order number from Pick Header
DateTimeShipped N UTC Time. Format: YYYY-MM-DDThh:mm:ssZ
ProductCode Y Product SKU
QuantityShipped Y Quantity shipped for this tracking number
TrackingNumber Y Tracking number assigned for the ship method
ShipMethod Y Carrier and Ship Method.
For example: UPS - Ground

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

Field Name Required (Y/N) Notes/Value(s)
ProductCode Y  
QuantityAvailable Y  

➤ See the attached Sample Inventory File for an example.

Sample Files


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.