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)
Shippeo does not build macro because, for maintenance reasons, the knowledge needs to belong to the customer
Was this article helpful?
0 out of 0 found this helpful