Standard Fulfillment Confirmation Format
  • 25 Mar 2025
  • 1 Minute to read
  • Contributors
  • Dark
    Light

Standard Fulfillment Confirmation Format

  • Dark
    Light

Article summary

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 

HeaderMySQL TypeDescription/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 Datedatetime

When shipment information was loaded to Mercury

Processed Datedatetime

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.

Attachments

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.