Standard Fulfillment Confirmation Format

A comma-separated text file will be created containing confirmation information about the day's processed shipments. The file will be placed on Landmark's FTP server in the "Confirmation" folder. Login credentials will be provided by Landmark Global. There will be one row for each unique Sku/item fulfilled. For a shipment with multiple skus/items, the shipment-level details will repeat on each row.

Encapsulation

Fields will be encapsulated with double quotes where needed or if fields are sub-delimited.

File Name

Shipping_Confirmation-YYYY-MM-DD_H:i:s.csv

Example: Shipping_Confirmation_2017-11-17_000103.csv

DateTime format:

YYYY-MM-DD HH:MM:SS 24h format in America/Chicago time per the IANA TimeZone Database https://www.iana.org/time-zones 

Headers

• Client
• Reference
• Client provided shipment level reference
• Name
• Address
• City
• State or Province
• Postal
• Country
• Phone
• Service Code
• Landmark shipped service
• Import Date
• When shipment information was loaded to Mercury
• DateTime value
• Processed Date
• When end-carrier label was generated
• DateTime value
• Package Count
• Total number of cartons
• Total Weight
• Weight Unit
• LB or KG
• Tracking Number
• End carrier tracking number for each carton
• multiple numbers will be combined with a comma and a space
• Landmark Tracking Number
• Always starts with "LTN". Is an order level tracking value.
• Is Fulfillment Order
• Yes or No
• Component SKU
• Blank if non-fulfillment order
• Quantity
• Number of the component sku fulfilled
• Blank if non-fulfillment order
• Lot Number
• Blank if non-fulfillment order or component sku is not lot controlled.
• Serial Number
• multiple serial numbers will be combined with a comma and a space character
• if a sku requires serial number scans the number of values will be equal to the quantity of the sku fulfilled

Please see attached sample