Technical pre-requisite to create orders in Shippeo

Constraints depending on the format:

Protocol	Format Accepted	Can Shippeo adapt to the file?
API	JSON XML
SFTP/FTP	JSON XML TXT / CSV / XLS / XLSX EDI	Yes but within the constraints detailed below
Email	CSV	Yes but within the constraints detailed below
Manual Import	CSV	Yes but within the constraints detailed below

 

JSON/XML/EDI

• One file per order or tour
• Unique reference for orders and tours clearly defined
• Dates for loading and delivery clearly defined
• Time and Timezone for loading and delivery clearly defined or with a simple logic
• Identifier for creation / update / cancelation clearly defined
• Addresses clearly defined, including country or identifier if addresses pre-created

XLS/XLSX/CSV

• Headers in the first line
• Unique reference for orders and tours clearly defined
• Dates for loading and delivery clearly defined
• Time and Timezone for loading and delivery clearly defined or with a simple logic
• Identifier for creation / update / cancelation clearly defined
• Addresses clearly defined, including address lines and country or identifier if addresses pre-created
• Consistency in field separators
• No empty lines
• For XLS/XLSX
  • No merged cells
  • No colors
  • No links
  • No functions
  • Single Tab
  • Consistent file encoding (excel versions)