UPLOADING ORDERS IN SHIPPINGBO

Shippingbo allows you to import your orders directly from the interface so that the data created in Shippingbo meets your requirements.

NOTE

This file uplaod cannot be automated and should be used for one-off imports.
If you wish to automate your order imports, please refer to our tutorial Importing CSV files via FTP.

Mass import orders

Step 1 : Log into your Shippingbo account and go to the menu Configuration -> Files management -> Upload -> Order : 

Step 2 : Click on "Upload file" and download the corresponding sample file : 

Step 3: Fill in at least the mandatory data in the file: 

- date: date of the order
- orderId : order number
- lineId : order line number (must be unique)
- sku: reference of the product ordered
- quantity : quantity of the product ordered
- name: recipient's full name

- firstname : recipient's first name (do not fill in if name already filled in)
- lastname : recipient's surname (do not fill in if name already filled in)
- address 1 : delivery address
- postcode: delivery postcode
- city : delivery city
- country : delivery country code

The other columns are not mandatory, but you can add them: 

- origin : origin of the order
- originRef : origin reference of the order
- product ean
- description : product description
- companyName : if the destination address includes a company address
- you can fill in the rest of the non-mandatory columns with the shipment information.
- state : the state of the order
- totalCents : total price in cents
- lineShippingCent: the transport price of the line in cents
- totalTaxCents : total taxes in cents
- totalShippingCents : total tax for shipping costs in cents
- lineTaxExcludedCents : price of the line excluding VAT in cents
- lineTaxCents : line tax in cents

NOTE

You can also add to this file :

- the status of the order in the import file in the "State" column: the following statuses are accepted : to_be_prepared; waiting_for_stock and waiting_for_payment.

- The origin of the order in the "origin" column. Here, you can enter the external department from which the order originated, as well as whether it is a B2B order.

- Its origin reference on the service it comes from, in the "originRef" column.

Step 4 : Once your file is ready to be uploaded, click on "Drop or select file" to add it and then on "Upload" :  

NOTE

Before uploading all your orders into Shippingbo, we strongly advise you to carry out an initial import of just one order in to check that the data has been entered correctly.

NOTE

- You can leave the page before the uploaad is complete.
- There is no limit on the size of the importable file.