All Collections
Label Creator
To Ship
How to import Excel, CSV or TXT files with your shipments' data
How to import Excel, CSV or TXT files with your shipments' data

Learn how to import your orders and generate your labels in a few minutes

Updated over a week ago

Importing all your order data through a file may seem stressful to manage. 

That's why ShippyPro makes this easy for you. You can either download a predefined template or customize the columns so that you don't have to start from scratch!

 
Let's see how it works! 🔍

Using the New Experience?

The New Experience may differ in some details.
Learn more in the article related to the New Experience.

1. How and what you can import

As you already know, you can import an Excel, a CSV or a TXT

But what if you already have a File with all orders data?
Do you have to copy and paste all the information into the downloaded template?

Of course not! Here's our solutions:
​      

- Importing an already existing Excel or CSV

You can import an already existing CSV or Excel by adjusting our fields to your columns. 

From Label Creator > To Ship, click on Import Excel/CSV/ TXT > Customized Columns.

For Example: if in your file the field Company comes first and Name in the second column. You only have to switch our predefined column order according to yours, just like this:

💡Note: all fields marked with * are mandatory.

💡Note: for CSV files, the supported delimiter is the semicolon (;)
​     

- Importing an already existing TXT 

Also importing a TXT with your order data requires only a few clicks. 

Click on Import Excel/CSV/TXT > Customized Columns.

You just need to specify Start Position and End Position of each field:

💡Note: all fields marked with * are mandatory

          

2. How to create a new Excel 

Creating an Excel with all your orders is easier than you think.
​ 

Here's how to do it step by step! 🔍
​  

Download the Example Template

From Label Creator > To Ship, click on Import Excel/CSV/ TXT on the top right corner of the page and download the example file. 

📌 Click here to download it directly from this Help page.

Please, follow this procedure carefully. Any different Excel won't be imported in our system. 

Fill the Data ✏️

Let's take a look at the mandatory and optional fields.

  • Name: Mandatory.

  • Company: Optional. You can add the eventual customer's company.

  • Street 1: Mandatory. Please add the main address.

  • Street 2: Optional. You can add some additional info.

  • City: Mandatory.

  • State: Optional.

  • ZIP: Mandatory (NOTE: the Zip code column must be formatted as text).

  • Country: Optional. If not filled, our platform will automatically add the country from which the ShippyPro User comes. You need to fill the field with the country code prefix ISO ALPHA CODE 2.

  • Phone: Mandatory.

  • Email: Optional. Add customer's email address if you'd like to send Tracking Email Notification.

  • Order Number : Mandatory. The order number is unique. Please remember to enter a different number for each order, otherwise the line won't be accepted.

    💡Note: Please do not insert any special characters in the Order Number (Transaction ID). Special characters will create issues when importing the recipient data.

  • Currency, Total, Items Count, Content Description are mandatory only in case of international shipments that include Customs documents. 

💡Note: Currency must be filled with a three letter code (ex: USD, EUR).

💡Note: Items' images are not imported.

  • Amount paid for the shipment, Cash on delivery, Parcels, Weight, Length, Width, Height e Note are all optional. 

💡Note:

  1. With regard to Cash on delivery, only the value must be added. (ex: 4,50)

  2. By adding the amount of Parcels included in the shipment, you won't be able to manage the dimension of each of them through the Excel lines, therefore all the parcels will have the same dimension.

📌 To manage parcels dimensions or items details, we pur at your disposal our API, click here to read our API Documentation.

  • Is return: Optional. 

💡Note: Please remember to type true only when the shipment is a return. Add false if there are some returns within the excel. Otherwise, you can leave this field empty.

  • Date: Optional. 

💡Note: Complete this field only if you'd like to set a different date form the original one.

  • Shipping Service: Optional. 

💡Note: Complete this field only if you'd like to add a shipping rule you set on ShippyPro Carrier Rules or Filters.

You can add as many order lines as you want!

Upload the File

As soon as you completed the template with all the required data, click on Upload Excel, CSV, TXT > Choose.

📌 In case you face error 500 message while trying to upload your file, you should check if your order details contain some emojis and, if yes, delete them as they block the correct order import. 


You'll find the orders you imported with Excel/CSC/TXT directly under the relative section near your Marketplaces: 

 

📌 In order to have a more detailed and complete report, ShippyPro offers the specific API Call GetShippedOrders.

If you'd like to receive a quotation for its activation on your Profile, contact our Support Team either via chat or form request from your Support Panel by clicking on the black HELP button in the lower right corner of your account.

Would you like to change your sender address once imported your orders? Discover here how!

Done! 🎉
​  

🔍 What's Next?

Did this answer your question?