• Manual upload
• Automatic upload via FTP
  • Configuration
  • File structure inside the directory
  • File format
• Import or update orders
  • Import an order
  • Update an order status
  • Order status
  • Available Language
• Import or update shipments
  • Import a shipment
  • Update a shipment
  • List of carriers by country

Manual upload

To import inside your Seven Senders account your orders and shipment, you can use a csv file.

You can manually upload your orders/shipments directly inside your account by going to the Upload section of your account.

Automatic upload via FTP

You can also automate the upload of your files by defining a FTP configuration.

When we detect that a new file was added inside the FTP, we will upload it inside your account.

Configuration

We will need the following information. You can send us those information via the Leave Feedback section of your account or send those to your Seven Senders interlocutor.

• Protocol
• Host
• Port
• User
• Password
• Directory
  • /Seven_Senders/import
  • /orders
  • /shipments
  • /example_name/for/example
• Mode
• Transfer mode
• Use SSL or not

File structure inside the directory

For our system to process csv file inside your FTP you need to follow the logic below:

If you define the root directory as seven_senders_import, inside this folder you should have the following folders.

• order
• order_state
• order_update
• shipment
• shipment_update

Inside each folder you should have a folder for the csv version that you are using to import orders, shipments, etc.

Inside the order folder you will have folder with the name 2.0.0 if you are using this version format to import orders inside your Seven Senders account.

If we take the previous root directory the hierarchy of folders will look like the following:

• seven_senders_import
  • order
    • 2.0.0
      • Inside this folder put your csv file to create orders
  • order_state
    • 2.0.0
  • order_update
    • 1.0.0
  • shipment
    • 2.0.0
  • shipment_update
    • 2.0.0

Example inside Filezilla, you should see this folder structure:

File format

We will need the following information regarding the file format that will be on the FTP:

• Delimeter
• Enclosure
• Escape

Import or update orders

Import an order

Version supported

Recommendations

• The csv file MUST CONTAIN the headers
• Field separator should be , (coma)
• Text separator should be "" (double quote)
• Character set must be UTF-8

Format

For version 2.0.0

Example

CSV file to import orders

"orderId","orderDate","shopUrl","language","promisedDeliveryDate","boardingComplete"
"1823316","13.11.2017 11:42:00","https://www.example.fr/","de","25.11.2017 12:00:00","0"

CSV template

Use the template order_creation_v2_0_0 attached (bottom of the page) to create orders inside you Seven Senders account.

To import this file inside the Upload section of you account select the Order creation version 2.0.0

Behaviour

Every order imported inside your Seven Senders account will receive the status New.

If the order is already inside a more advanced status (like currently processed at the warehouse), you need to update to order to match the current status.

Update an order status

Version supported

Recommendations

• The csv file MUST CONTAIN the headers
• Field separator should be , (coma)
• Text separator should be "" (double quote)
• Character set must be UTF-8

Format

For version 2.0.0

Example

CSV file to update orders status

"orderId","orderState","datetime","location"
"1823316","paid","14.06.2016 12:45:00","Paris"

CSV template

Use the template order_update_v2_0_0 attached (bottom of the page) to update orders states inside you Seven Senders account.

To import this file inside the Upload section of you account select the Order update version 1.0.0

Order status

Available Language

bg; cs; da; de; el; en; es; et; fi; fr; ga; hr; hu; it; lt; lv; mt; nl; pl; pt; ro; ru; sk; sl; sv; uk

Import or update shipments

Import a shipment

Version supported

Recommendations

• The csv file MUST CONTAIN the headers
• Field separator should be , (coma)
• Text separator should be "" (double quote)
• Character set must be UTF-8

Format

For version 2.0.0

trackingNumber

string

carrierName

choice:
See the list of choice below

carrierCountry

choice:
See the list of choice below

carrierService

choice:
"standard"
"express"
"other"

customerFirstName

string

customerLastName

string

customerAddress

string

customerAddressZipCode

string

customerAddressCity

string

customerAddressCountry

string

customerCompany

string

customerEmail

email

customerPhone

phone:
Use + for the country code (see example)

order

string

orderDate

date:
dd.mm.yyyy hh:mm:ss

returnParcel

boolean:
0 = false
1 = true

pickupPointSelected

boolean:
0 = false
1 = true

parcelWeight

number

plannedPickupDate

date:
dd.mm.yyyy hh:mm:ss

warehouse

choice:
List of all warehouse
defined inside your account

promisedDeliveryDate

date:
dd.mm.yyyy hh:mm:ss

referenceNumber

string

How to define the carrier in case of cross border shipment ?

You want to deliver products to a customer in France and you warehouse is in Germany. You will hand your shipment to DHL DE that will at the border handover those shipments to DHL FR.

In this scenario, you need to define on those shipments the carrier dhl and the carrier country de.

Example

CSV file to import shipments

"trackingNumber","carrierName","carrierCountry","carrierService","customerFirstName","customerLastName","customerAddress","customerAddressZipCode","customerAddressCity","customerAddressCountry","customerCompany","customerEmail","customerPhone","order","orderDate","returnParcel","pickupPointSelected","parcelWeight","plannedPickupDate","warehouse","promisedDeliveryDate","referenceNumber"
"456798AB","dhl","de","standard","Peter","Muller","Schwedter strasse 36A","10245","Berlin","DE","Seven Senders","p.muller@sevensenders.com","00491788654545","10034","23.10.2017 13:00:00","0","0","1.3","28.10.2017 09:00:00","superWarehouse","30.10.2017 13:00:00","sh_1_10034"

CSV template

Use the template shipment_creation_v2_0_0.csv attached (bottom of the page) to create orders inside you Seven Senders account.

To import this file inside the Upload section of you account select the Shipment creation version 2.0.0

Update a shipment

Version supported

Recommendations

• The csv file MUST CONTAIN the headers
• Field separator should be , (coma)
• Text separator should be "" (double quote)
• Character set must be UTF-8

Format

For version 2.0.0

trackingNumber

string

carrierName

choice:
See the list of choice below

carrierCountry

choice:
See the list of choice below

referenceNumber

string

Example

CSV file to update shipment

"trackingNumber","carrierName","carrierCountry","referenceNumber"
"456798AB","dhl","de","ref12345"

CSV template

Use the template shipment_update_v2_0_0.csv (bottom of the page) to create orders inside you Seven Senders account.

To import this file inside the Upload section of you account select the Shipments update version 2.0.0

Behavior

Updating a shipment can be done only if all values have been provided for the mandatory fields. Moreover the update is based on the provided reference number. The template to be used is under ‘Shipments Update’ in the Upload section of Analytics.

List of carriers by country