Support Portal

CSV integration (for testing)

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

Version
Supported
Comments
1.2.6
YES
This version will be deprecated at the end of 2018
1.2.5
YES
This version will be deprecated at the end of 2017
1.2.4
NO
Deprecated since September 2017
2.0.0
YES
This version works with headers

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

Column header
Mandatory
Type
Description
orderId
YES
string
The order reference inside your system
orderDate
YES
date:
dd.mm.yyyy hh:mm:ss
Date when the order was created inside your system
shopUrl
MAYBE
Url
From which website the order come from
If you want to send mails/sms notifications to your customer, we recommend that you provide this information on each order
The reason is that a notification can only be send if the ShopUrl and the Language are defined on the order.
language
MAYBE
choice:
See the list of choices below
What is the language of the customer for this order or the language for the ShopUrl defined
If you want to send mails/sms notifications to your customer, we recommend that you provide this information on each order
The reason is that a notification can only be send if the ShopUrl and the Language are defined on the order.
promisedDeliveryDate
MAYBE
date:
dd.mm.yyyy hh:mm:ss
At which date did you promise the customer to deliver his/her order
This information is used to provide critical statistics on the several dashboard.
boardingComplete
NO
boolean
Accepted values: 0 or 1
All shipments for this order have been imported inside your Seven Senders account ?

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

Version
Supported
Comments
2.0.0
YES
This version works with headers
1.2.4
YES
This version will be deprecated at the end of 2018

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

Column Headers
Mandatory
Type
Description
orderId
YES
string
The order reference inside your system
orderState
NO
choice:
See the list of choices below
The new order status
datetime
NO
date:
dd.mm.yyyy hh:mm:ss
Date when the order went into this status
location
NO
string
Where the order is currently located

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

Status

Available on order update

Description
new
NO
Status when the order is created inside your account
paid
YES
Order was paid by the customer
in_production
YES
This status is useful if you need to produce/made the items ordered by the customer
in_preparation
YES
The order is processed inside your warehouse
shipped
NO
The carrier came to retrieve the order at your warehouse
completed
NO
All shipments have been delivered to the customer

Languages available

Languages
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

Version
Supported
Comments
2.0.0
YES
This version works with headers
1.2.9
YES
We will deprecate this version by the end of 2018
1.2.8
YES
We will deprecate this version by the end of 2018
1.2.7
YES
We will deprecate this version by the end of 2017
1.2.6
NO
Deprecated since September 2017
1.2.5
NO
Deprecated since September 2017

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

Column Header
Mandatory
Type
Description
trackingNumber
MAYBE
string
The shipment tracking number given by the carrier.
Mandatory if no reference number is provided

carrierName
MAYBE
choice:
See the list of choice below
Selected carrier to ship the parcel.
Mandatory if a tracking number is provided

carrierCountry
MAYBE
choice:
See the list of choice below
Country where the parcel is handed over to selected carrier / scanned for the first time by the selected carrier.
Mandatory if a tracking number is provided
carrierService
NO
choice:
"standard"
"express"
"other"
Service / Product / Tariff used by the carrier
customerFirstName
YES
string
Customer first name
customerLastName
YES
string
Customer last name
customerAddress
YES
string
Customer address. Do not use line breaks.
customerAddressZipCode
YES
string
Customer ZIP code
customerAddressCity
YES
string
Customer city
customerAddressCountry
YES
string
Customer country. Use ISO 3166-1 alpha-2
customerCompany
NO
string
Customer company if he/she choose to be delivered at his/her company
customerEmail
NO
email
Customer email address. Use this field to send email notifications to you customer through Analytics
Without this information, no mail notification can be send
customerPhone
NO
phone:
Use + for the country code (see example)
Customer phone. Use this field to send sms notifications to your customer through Analytics
Without this information, no sms notification can be send
order
YES
string
The order reference inside your system.
The shipment will be link to this order.
orderDate
NO
date:
dd.mm.yyyy hh:mm:ss
Date when the order was created inside your system
returnParcel
YES
boolean:
0 = false
1 = true
Indicates whether the shipment is a return from the customer
pickupPointSelected
YES
boolean:
0 = false
1 = true
Is the customer address a pickup point ?
parcelWeight
NO
number
Shipment weight in KG
plannedPickupDate
YES
date:
dd.mm.yyyy hh:mm:ss
Date and time agreed with the carrier to pick-up the shipment at your warehouse - this timestamp triggers the start of the delivery lead time
warehouse
YES
choice:
List of all warehouse
defined inside your account
Warehouse name defined inside your account.
promisedDeliveryDate
YES
date:
dd.mm.yyyy hh:mm:ss
Promised delivery date for this shipment to the customer
referenceNumber
MAYBE
string
Reference number for the shipment. This information is used when the carrier doesn't provide a tracking number at the beginning (like BRT carrier in Italy).
It is normally your internal reference for this shipment inside your IT system.
Mandatory if no tracking code is provided

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

Version
Supported
Comments
2.0.0
YES
This version works with headers
1.0.0
YES
This version will be deprecated at the end of 2018

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

Column Headers
Mandatory
Type
Description
trackingNumber
YES
string
The shipment tracking number given by the carrier.
carrierName
YES
choice:
See the list of choice below
Selected carrier to ship the parcel. Mandatory if a tracking number is provided
carrierCountry
YES
choice:
See the list of choice below
Country where the parcel is handed over to selected carrier / scanned for the first time by the selected carrier.
referenceNumber
YES
string
Reference number of the carrier for this shipment.

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

Country
Carrier
ch
swisspost, dpd, ups, dhl
at
postat, dpd, ups, dhl
fr
colissimo, chronopost, tnt, dpd, mondialrelay, colisprive, gls, dhl, ups
de
dhl, deutschepost, gls, ups, hermes, dpd, tnt
pl
dpd, gls, ups, dhl
cz
ceskaposta, dpd, ups
sk
ceskaposta, dpd, ups, dhl
fi
posti, postnord, ups, dhl, dpd
dk
postnord, ups, dhl, dpd
no
postnord, ups, dhl, dpd
se
postnord, ups, dhl
be
bpost, dpd, kiala, mondialrelay, ups, dhl
lu
dhl, ups, kiala, dpd
nl
postnl, kiala, dpd, mondialrelay, tnt, ups, dhl
es
correos, seur,seur_international,asm, mrw, tourlineexpress, ups, dhl
it
brt, tnt, gls, ups, dhl
gb
royalmail, yodel, parcelforce, hermes, dpd, dhl