New Experience
      Back to home
      1. ShippyPro Help Center
      2. New Experience

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

      Order empty - Line with Order number empty

      In addition to ensuring that the Order Number column is correctly filled out (as it is a unique and mandatory field), please check that your file conforms to one of the supported formats (.csv, .xls, .xlsx) and that it uses the appropriate delimiter. For CSV files, the supported delimiter is a semicolon.

      Country X not found. Please enter a valid country code

      In addition to ensuring that the Country column is filled out correctly (you must use the 2-digit ISO ALPHA CODE for the country), please check the "Configure Columns" section to confirm that the order of the columns matches that of the imported file, particularly for the field in question..