Salta al contenuto principale

Import carriers from a CSV file

When you need to build your carrier network from scratch — or add many subcontractors in one go — adding them one by one with the "+ ADD CARRIER" dialog is slow. The CSV import lets you upload up to 200 carriers starting from a spreadsheet: you download a ready-made template, fill it with your data and upload it. Compared with the client import, the platform does one extra thing here: it recognises carriers already registered on Truckscanner and automatically sends an invitation to those who are not registered yet.

Forwarder

Before you start

  • A forwarder account with the ADMIN or OPERATOR role: importing carriers — like adding them manually — requires one of these two roles.
  • A spreadsheet (Excel, Google Sheets, LibreOffice) to fill in and save the template in CSV format.
  • The CSV file can contain at most 200 data rows and weigh at most 5 MB.

1. Open the import dialog

From the left-hand menu, in the "Operational & Transport" section, open the "Carriers" entry (URL /company/{companyId}/network): the page is titled "Carrier network". At the top right of the header, click the "⤴ IMPORT CSV" button, next to the lime "+ ADD CARRIER" button.

The modal dialog "Import carriers from CSV" opens, with the subtitle "Upload a CSV file to import carriers in bulk".

2. Download the template and fill it in

Inside the dialog, at the top, click the green "Download CSV template" link: the browser immediately downloads the template_vettori.csv file, ready with the header row and two example rows.

Below the link, a preview table shows you the template columns with two example rows, so you immediately know what to write in each column. The eight columns of the template_vettori.csv template are:

ColumnWhat it holdsRequired
ragione_socialeName of the carrier companyYes
paeseCountry code of the VAT number, e.g. ITYes
partita_ivaVAT number, without the country prefixYes
nome_referenteName of the contact personNo
email_referenteContact email — if filled in, a carrier not yet registered receives the invitation email (see "What happens next")No
telefono_referenteContact phoneNo
referenziatoMarks the carrier as "vouched": si / / true / 1, or no / false / 0 / emptyNo
noteFree text on the carrier recordNo

3. Upload the file and start the import

Once you have filled in the template, go back to the dialog. You can drag the file into the dashed area "Drag the CSV file here or browse", or click on it to open your operating system's file picker. The area accepts only .csv files up to 5 MB.

As soon as the file is selected, the area turns into a row showing the file name and its size, and the "IMPORT" button at the bottom right becomes active.

Click "IMPORT". The button switches to the "Importing…" state while the platform processes the file: for large files or many VAT numbers to recognise it may take a few seconds. Picked the wrong file? Click the X next to the name to remove it and upload a different one.

4. Check the result

When the import finishes, a confirmation toast appears at the top right — for example "3 carriers imported" — and inside the dialog a green box with the same count. If there are no errors, the dialog closes by itself after a couple of seconds.

The new carriers appear in the table straight away and the status tab counters at the top update. Every imported carrier enters with the correct status automatically: those already registered on Truckscanner enter as "Active", those not registered yet as "Invited".

In the "Recommended" column you see a green tick on the rows of the carriers you set to si in the referenziato column of the CSV.

What happens next

Unlike the client import — which only populates your address book — the carrier import also starts the collaboration. What happens depends on one thing only: whether that carrier is already registered on Truckscanner or not.

  • Carrier already registered on Truckscanner. The platform recognises it from the VAT number and adds it to your network as "Active": no email, no invitation to accept. It is operational straight away — you can assign load mandates to it right now.
  • Carrier not registered yet. It enters your network as "Invited". If the CSV row had the email_referente, the invitation email automatically goes out to that address: . The contact finds in the email a link to register their company and join your network. If instead the row had no email, the carrier stays "Invited" but no email is sent: to get them the invitation, open their row and use the "Copy invitation link" button, then send it to them yourself (WhatsApp, SMS, email).

The referenziato column turns on the vouched-carrier status. Setting si means you vouch for that carrier: when it accepts the invitation and registers, it skips the document verification onboarding and is born already "Active" instead of waiting for verification. For a carrier that is already registered (and therefore enters as "Active" right away), the flag stays as a simple note on the relationship.

What the other side sees

Carrier

A carrier not yet registered that has an email in the CSV receives the NC-A03 invitation email: a message on behalf of your company with a link to register and join your network. When they complete registration, their row in your table moves from "Invited" to "Active". The path seen from the carrier's side is described in Accepting a forwarder's invitation.

Common issues

See also