Import shipments via CSV files

Import your orders via CSV / Excel and prevent retyping with the CSV import module. This way you can super efficiently send all your documents, packages and pallets with the most suitable carrier. Are you unable to import or would you like us to help you? Please contact our customer service. We can even unburden you completely by printing the shipping labels for you or by packaging the shipment.

Import shipments via CSV files

Import shipments

1. Go to the Settings menu of MyWuunder (green dropdown menu). Here you set a “default service”, volume and weight if this data is not received via the CSV file or add your logo here to communicate with the recipient. read right here more about these default values.

2. Then go to the top gray bar Shipments overview and select “Book”. This is the place where you can book all your new shipments.

3. Select “Import” and then “CSV”.

Exact link request services

5. Select “choose file” and select the desired CSV file with the shipments you want to import. Always use the required fixed format (see next paragraph) or download a CSV file with an example.

6. You now have two choices (dropdown menu in the green button):

  • Import all orders as a concept: You import all orders and then book them all at once of per Unit.
  • Import and book all orders automatically: You import and book all orders at once. The latter option is particularly interesting if you are using import rules en shipping rules works.
Import orders from Bol.com
  • All draft orders are now imported by the CSV upload tool. You will now see the shipments in it Draft overview in MyWuunder.
  • An overview of all booked shipments can be found in the "Book" Overview. Here you can also, for example, copy the data of a booked shipment to send another shipment. An overview of all shipping labels, packing slips and commercial invoices can be found in the "To prepare" overview.
  • If you want to print all shipping labels quickly, you will find right here all info.

Content of the CSV file

1. Every CSV file must be constructed in exactly the same way (fixed CSV template). You can leave the cells with the shipment information and pick-up address information empty and use the default values of import- en shipping rules automatic filling.

2. In the 1st row of the CSV put the 1st column of the table below.

3. In the 2nd column of the CSV file you put the information you want to import.

4. If you want to use packing slips to collect your orders (pick & pack) or if you send international shipments for which you need commercial invoices, you can add as many order lines as necessary. 

order_line_1_weight

Weight per piece of the first item in your order

1ST ROW OF YOUR CSV

EXPLANATION

delivery_address_business

Company name recipient

delivery_address_chamber_of_commerce_number

Chamber of Commerce number receiver or customer number (option)

delivery_address_email_address

E-mail address recipient

delivery_address_family_name

Last name recipient

delivery_address_given_name

First name recipient

delivery_address_house_number

House number receiver

delivery_address_locality

Place name recipient

delivery_address_phone_number

International telephone number, for example: +3112345678

delivery_address_street_address

Street name receiver

delivery_address_zip_code

zipcode receiver

customer_reference

Shipment reference number (option)

Description

Shipment description

height

Height in centimeters

child

package of pallet (use the English term)

length

Length in centimeters

personal_message

Personal message for the recipient (option). This message is used in the email to the recipient and in the app / browser messages. Make sure you write this message in the language of the recipient.

value

Amount in Euros (e.g. 1000)

weight

Weight in grams (e.g. 1000)

width

Width in centimeters

pickup_address_business

Company name pick-up address

pickup_address_chamber_of_commerce_number

Chamber of Commerce number or business unit / department number (option)

pickup_address_email_address

E-mail address collection address (here we also send the shipping label)

pickup_address_family_name

Last name contact person pick-up address

pickup_address_given_name

First name contact person pick-up address

pickup_address_house_number

House number pick-up address

pickup_address_locality

Place name collection address

pickup_address_phone_number

International telephone number, for example: +3112345678

pickup_address_street_address

Street pick-up address

pickup_address_zip_code

Postcode pick-up address

order_line_1_description

Description of the first item in your order

order_line_1_ean

EAN code of the first item in your order

order_line_1_sku

SKU number of the first item in your order

order_line_1_hs_code

HS code of the first item in your order

order_line_1_quantity

Quantity of the first item in your order

order_line_1_country_of_origin

Country of origin of the first item in your order

order_line_1_weight

Weight per piece of the first item in your order. Weight in grams (eg 1000)

order_line_1_value

Value per piece of the first item in your order. Amount in Euros (eg 1000)​

order_line_2_description

Description of the second item in your order

order_line_2_ean

EAN code of the second item in your order

order_line_2_sku

SKU number of the second item in your order

order_line_2_hs_code

HS code of the second item in your order

order_line_2_quantity

Quantity of the second item in your order

order_line_2_country_of_origin

Country of origin of the second item in your order

order_line_2_weight

Weight per piece of the second item in your order. Weight in grams (eg 1000)

order_line_2_value

Value per piece of the second item in your order. Amount in Euros (eg 1000)​

pickup_address_address2

Possibly an addition such as 2nd floor, room XYZ etc

delivery_address_address2

Possibly an addition such as 2nd floor, room XYZ etc