A comma-separated text file will contain a basic summary of deleted shipments, generated either daily or hourly, depending on the client’s settings. This file can either be placed on Landmark’s SFTP server or dispatched externally to a client SFTP server. Login credentials to the Landmark server will be provided by your integration manager.
Standard Format
Header Name | Mandatory? | Description | Example |
|---|---|---|---|
Client Name | Yes | Mercury client name | ClientName123 |
Shipment Reference | Yes | Mercury shipment reference | 123-4567-8910 |
Landmark Tracking Number | Yes | Mercury LTN | LTN123400123 |
Deleted By | Yes | Name of the user that deleted the shipment | FirstName Last |
Deleted Reason | Yes | Reason provided for deleting the shipment | Backordered shipment |
Deleted Date | Yes | Date that the shipment was deleted in Mercury in YYYY-MM-DD format (see example) | 2025-01-29 |
Barcode | No | Human-readable barcode value | |
Package Reference | No | Mercury package reference |
Variant Format: Third Party With Items
Header Name | Mandatory? | Description | Notes | Example |
|---|---|---|---|---|
Client Name | Yes | Mercury client name | ClientName123 | |
Shipment Reference | Yes | Mercury shipment reference | 123-4567-8910 | |
Third Party ID | No | data_shipment_third_party_integration_details.shipment_identifier | This reference ties back to the third party system the shipment came from. If there is no third party shipment_identifier (or row entry) leave the field blank | ABCD7NI96HRBC |
Third Party System | No | data_shipment_third_party_integration_details.integration_system | This reference ties back to the third party system the shipment came from. If there is no third party integration details entry for the shipment leave the field blank. | ThirdPartyInc |
Landmark Tracking Number | Yes | Mercury LTN | LTN123400123 | |
Deleted By | Yes | Name of user that deleted the shipment | FirstName Last | |
Deleted Reason | Yes | Reason provided for deleting the shipment | Backordered Shipment | |
Deleted Date | Yes | Date that the shipment was deleted in Mercury in YYYY-MM-DD format (see example) | 2025-01-29 | |
Fulfillment Facility | No | Where the shipment would have been fulfilled from | Leave blank if the shipment was not a fulfillment shipment | Landmark AU |
Sku | No | One row per Mercury item. sku number goes here | Leave blank if there are no Mercury items (e.g. domestic non-fulfillment shipments may not include any item details) | 205040737 |
Line Number | No | Mercury item third party line number | Leave blank if there are no Mercury items (e.g. domestic non-fulfillment shipments may not include any item details) | 1 |
Quantity | No | Mercury item quantity deleted | Leave blank if there are no Mercury items (e.g. domestic non-fulfillment shipments may not include any item details) | 2 |