Project Description:
Hi we need to export the delivery details from our unshipped Amazon orders to a csv file so we can then upload that file into our Royal Mail Despatch Manager.
The file needs to contain the following fields:
"Service Reference" will always be populated with Amazon
"Service" will be populated with CRL for Standard Shipping TS1 for Expedited MP5 for all orders outside UK
"Recipient"
"Recipient Address line 1"
"Recipient Address line 2"
"Recipient Post Town"
"Recipient Postcode"
"Recipient Country Code" will be populated with standard 2 or 3 character country code
"Weight (kgs)" will be populated with
"Items" will be populated with 1
"Reference" populated with the order number
"Service Format" populated with N for CRL orders, N for TS1 & MP5
