How to create an Excel / CSV report of your shipments

Here's how to download an Excel File with you orders data

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! 



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 Marketplace:  How 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. 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).