- Print
- DarkLight
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
Header | MySQL Type | Description/Notes |
---|---|---|
Client | ||
Reference | Client-provided shipment level reference | |
Name | First and last name of consignee | |
Address | ||
City | ||
State or Province | If a country for original outbound shipment has states or provinces. Use 2- or 3-character abbreviations when possible | |
Postal | If country for original outbound shipment uses postal codes. Canada format: "A9A9A9" // USA format: "12345" 4-digit suffix optional | |
Country | Use 2-character ISO code when possible | |
Phone | ||
Service Code | Landmark shipped service | |
Import Date | datetime | When shipment information was loaded to Mercury |
Processed Date | datetime | When end-carrier label was generated |
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 | Item sku. Blank if non-fulfillment order | |
Line Number | Optional, used by some clients with additional integrations | |
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.