CSV-Installation manual
- Jago Verzuu (Unlicensed)
Analytics
Creating multiple shipments by uploading a spreadsheet (CSV / TSV / TXT)
This is the simplest option we have. The only thing you need is a spreadsheet with shipping details and you are good to go. Your spreadsheet doesn’t even need to be edited in most cases, because we can easily map your spreadsheet headers to match the details that we need. In the steps below we explain how to do this.
Step 1: Create a spreadsheet with shipping details → The spreadsheet you are uploading to create shipments can have all sorts of information in it, but it should at least have:
Recipient name → The name of the person who this shipment is for
Recipient email address → So we can send a Track & Trace link
Recipient phone number → So our we can contact the recipient if necessary
Street + house number
Postal code
City
Country → use NL or BE
Order → This is an order reference, make sure they are unique (IMPORTANT!)
Delivery date → We take in multiple date formats - DD-MM-YYYY is most common
If you export these details from your webshop, most often they will be having different headers than shown above. This is no problem, we will map these headers one time in Step 3 and after that we will remember them, so you can use your own file without needing to change it every time.
Step 2: Upload your spreadsheet
To upload your spreadsheet, simply navigate to the Shipments button in the top menu > Upload Shipments > Upload Shipments Data. You will be presented a spreadsheet like window. Either drag and drop your spreadsheet in upper part, or hit the green button that says Upload data from file and select your spreadsheet. Make sure we have selected the right row that contains the headers of your file, and you are good to go.
You have now uploaded your spreadsheet. Time to map your headers.
Step 3: Mapping your headers… just once.
To make sure that we know which of the colums in your spreadsheet match with the details we need to create your shipments, we will ask you to map your headers one single time.
Mapping the headers of your file has been made very easy. After uploading your file you will be presented with the view as shown below:
Right of the bat we have mapped some of the values already for you. This has been done automatically based on your header names. For each of the headers that we could not map automatically, you can now proceed to map the manually.
In the example image above you can see that the Recipient Name column of the file we uploaded wasn’t matched to a value yet. We can simple click on the Lookup matching fields dropdown and find the desired value.
After we have selected the desired value, in this case Recipient Fullname we can confirm the mapping by hitting the green button.
Make sure to confirm all mappings before proceeding. Once you have ensured all headers are mapped correctly and are confirmed, you can proceed to the next step.
Step 4: Review your shipments
To make sure your shipment data is correct and usable for creating shipments, you will be shown a review window. In this overview you can see all the shipments that we are about to create for you. Any missing or incorrect data will be highlight in red. If you have red fields, you can simply add or edit data to these fields in this view, no need to go back and re-upload.
Once all your fields are cleared, you can continue.
Step 5: Your shipments have been created
That’s it, your shipments have been created successfully. The header mapping you did will be memorized by our application, so the next time you upload a spreadsheet you can just directly create the shipments you want to create, without any hassle!