Support Portal

Welcome
Login

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

VersionSupportedComments
1.2.6YESThis version will be deprecated at the end of 2018
1.2.5YESThis version will be deprecated at the end of 2017
1.2.4NODeprecated since September 2017
2.0.0YESThis 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 headerMandatoryTypeDescription
orderId
YESstringThe order reference inside your system
orderDateYESdate:
dd.mm.yyy
hh:mm:ss
Date when the order was created inside your system
shopUrlRECOMMENDEDurl
From which website the order come from. If you want to send mails/sms notifications to you customer, we recommend that you provide this information on each order. The reason is that a notification can only be send if he ShopUrl and the Language are defined on the order.
LanguageRECOMMENDEDchoice:
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 email/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.
promisedDeliveryDateRECOMMENDEDdate:
dd.mm.yyyy
hh:mm:ss
At which date you promised the customer to deliver his/her order
This information is used to provide critical statistics on the several dashboard.
boardingCompleteNOboolean
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

VersionSupportedComments
2.0.0YESThis version works with headers
1.2.4YESThis 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 HeadersMandatoryType
Description
orderIdYESstringThe order reference inside your system
orderStateNOchoice:
See the list of choices below
The new order status
datetimeNOdate:
dd.mm.yyyy hh:mm:ss
Date when the order went into this status
locationNO
stringWhen 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

StatusAvailable on order updateDescription
newNOStatus when the order is created inside your account
paidYESOrder was paid by the customer
in_production
YESThis status is useful if you need to produce/made the items ordered by the customer
in_preparationYESThe order is processed inside your warehouse
shippedNOThe carrier came to retrieve the order at your warehouse
completedNOAll shipments have been delivered to the customer


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

VersionSupportedComments
2.0.0YESThis version works with headers
1.2.9YESWe will deprecate this version by the end of 2018
1.2.8YESWe will deprecate this version by the end of 2018
1.2.7YESWe will deprecate this version by the end of 2017
1.2.6NODeprecated since September 2017
1.2.5NODeprecated 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 HeaderMandatoryTypeDescription
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

VersionSupportedComments
2.0.0YESThis version works with headers
1.0.0YESThis 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 HeadersMandatoryTypeDescription
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

CountryCarrier
chswisspost, dpd, ups, dhl
atpostat, dpd, ups, dhl
frcolissimo, chronopost, tnt, dpd, mondialrelay, colisprive, gls, dhl, ups
dedhl, deutschepost, gls, ups, hermes, dpd, tnt
pldpd, gls, ups, dhl
czceskaposta, dpd, ups
skceskaposta, dpd, ups, dhl
fiposti, postnord, ups, dhl, dpd
dkpostnord, ups, dhl, dpd
nopostnord, ups, dhl, dpd
sepostnord, ups, dhl
bebpost, dpd, kiala, mondialrelay, ups, dhl
ludhl, ups, kiala, dpd
nlpostnl, kiala, dpd, mondialrelay, tnt, ups, dhl
escorreos, seur,seur_international,asm, mrw, tourlineexpress, ups, dhl
itbrt, tnt, gls, ups, dhl
gbroyalmail, yodel, parcelforce, hermes, dpd, dhl



Did you find it helpful? Yes No