---
title: "Standard Shipment Deleted File Format"
slug: "standard-shipment-deleted-file-format"
updated: 2026-10-20T01:57:45Z
published: 2026-10-20T01:57:45Z
canonical: "mercurydocs.landmarkglobal.com/standard-shipment-deleted-file-format"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://mercurydocs.landmarkglobal.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Standard Shipment Deleted File Format

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) Leave blank if there are no Mercury third party line numbers for the items | 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 |

Secure File Transfer Protocol. A means in which to transfer large files. Companies usually write scripts to drop and retrieve files automatically.