Standard Returns File Format
- 15 Dec 2021
- 1 Minute to read
- Contributors
- Print
- DarkLight
Standard Returns File Format
- Updated on 15 Dec 2021
- 1 Minute to read
- Contributors
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
A comma-separated text file will be created containing confirmation information about the day's processed returns. The file will be placed on Landmark's FTP server in the "Returns" folder. Login credentials will be provided by Landmark Global.
| Headers | MySQL Type | Max Length / Set | Description/Notes |
|---|---|---|---|
| Shipment Reference | varchar | 50 | Client-provided customer reference |
| Customer Name | varchar | 50 | First and last name |
| City | varchar | 40 | Original outbound shipment |
| State | varchar | 20 | If a country for original outbound shipment has states or provinces. Use 2- or 3-character abbreviations when possible |
| Postal | varchar | 10 | If country for original outbound shipment uses postal codes. Canada format: "A9A9A9" // USA format: "12345" 4-digit suffix optional |
| Country | varchar | 50 | Original outbound shipment. Use 2-character ISO code when possible |
| Return Date | datetime | 21 | When return was processed (US Central Time). Format: '000-00-00 00:00:00' |
| Return Code | varchar | 10 | Landmark letter reference. Possible standard return codes: UND - Undeliverable RET - General Return CTG - Call Tag |
| Return Reason | text | - | Description of return code |
| Return RMA Number | varchar | 60 | Client-provided return merchandise authorization number |
| Notes | mediumtext | - | Return notes entered by Landmark warehouse personnel |
| SKU | varchar | 64 | Item SKU |
| Item Quantity | int | 11 | Number of items |
| Item Description | varchar | 255 | Detailed description of goods for customs classification |
| Condition | varchar | 50 | Condition of returned item (e.g. GOOD, DAMAGED) |
| Unit Price | double | 8,2 | Retail price paid by the end consignee for a single unit of the item purchased. This value does not include shipping, tax, or insurance values. |
| Total Price | double | 8,2 | Total retail price paid by the end consignee for the quantity of the item purchased |
| Items Currency | char | 3 | 3-character ISO code |
Please See Attached Example of Returns File
Was this article helpful?