New Experience: How to create an Excel / CSV report of your shipments

ShippyPro helps you keep records of your shipments data. 💡
That's why you can Download an Excel File after you've shipped your orders from Label Creator > Shipping Labels.

Let's see how it works in details! ✨
​

Summary

  1. How to Filter your Orders
  2. How to Create an Excel File
  3. How to save the Excel Template
  4. Errors & Troubleshooting

1. How to Filter your Orders

Before creating the Excel File, remember to filter your shipments. You will, in fact, include all the shipments that you view on the page Shipping Labels.

Click here to learn how to filter by Date, Status, Carrier and MarketplaceHow to use Advanced Filters

 

Tip: If you'd like to select more than 50 orders in one time, consider displaying more orders on Shipping Labels page from the bar at the top of the page.

 

2. How to Create an Excel File

Once you have decided which orders you'd like to include inside the Excel, select them all by clicking on the left top check box.

Click then on the blue button Management > Create EXCEL to create the file:

From the window that pops up, you can delete the fields you don't want to include and order the columns.

 

Note that the Excel file downloaded for different marketplaces and for orders imported via an Excel file, may have differences in the content.

Some of the data (e.g. shipping date, name, address are mandatory) while others may be omitted (such as SKU, notes and others).

 

3. How to save the Excel Template

You can also decide to save the ordered columns as a template for other Excel Files by clicking on the blue 💾 icon:

 

4. Errors & Troubleshooting

How do we calculate conversion rates?

ShippyPro has a unique table in our database that stores every currency rate conversion. This table is updated every hour by a cron function, as rates changes frequently (i.e. as a conversion done one month ago will not be the same as if it was done today).

Import excel: Country must be in 2 digit format.

When this error occurs, fill Country field with the 2 digit abbreviation of the country of destination.

Ex. France - FR

Import excel: Currency code must be in 3 digit format.

In this case you need to replace Currency value with a 3 digit content.

Ex. EUR

Import excel: Order number X has not been imported, it already exists.

Remind that order number value must be unique for each row, in fact it is not possible to import the same Order number / ID twice.