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

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

 
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 us at [email protected]

Done! 🎉
  

🔍 What's Next?

Did this answer your question?