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! 🔍
     

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 the 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:

Please note that all fields marked with * are mandatory.
     

- 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 the Start Position and the End Position of each field:

Please note that all fields marked with * are mandatory

          

2. How to create a new Excel 

Creating an Excel with all your orders is easier than you might 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. 

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 a second address.
  • City: Mandatory.
  • State: Optional.
  • ZIP: Mandatory.
  • 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.
  • 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.
  • 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).

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

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

  • 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.

  

Upload the File

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

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

 

Done! 🎉
  

🔍 What's Next?

Did this answer your question?