11-18-2020 02:10 PM - edited 11-18-2020 02:11 PM
Original post from user Greg Bentkowski
I was looking thru the reports and I really want to use the Shipping Costs Report. I need it to give the actual dimensions of the package and not just say it was a PKG. Is it also possible to add the product that was sold? Can the OZ be changed back to pounds for the weight.
12-15-2020 10:02 AM
I also need to customize reports. I would like orders and shipments data available in one report.
12-16-2020 12:14 PM
While you can build custom reports in ShipStation, the reports are unique for Orders and Shipments. Some fields are available for both types of reports, but some aren't. So it will depend on exactly which fields you are hoping to include in a single report. If a field isn't available for Shipments, but is available for Orders, the only way to get them into the same report right now is to export both reports then copy data from one CSV to the other. Not an idea scenario, I know.
If you haven't already, review the Create Custom Export Formats section of the Export Order Records help article to learn how to create the custom report.
2 things I notes in the reply to the main poster here that might also be useful to you:
12-16-2020 12:11 PM
The reports available in Insights > Reports cannot be customized beyond the filters that are available before you run the reports. The fields within the reports are always the same. The PKG field only lists the package type (whether you use a default like "Package" or one of your custom packages), and the weight cannot be changed from OZ, either.
HOWEVER! You can build custom reports from either the Orders or Shipments tab (depending on what type of report you want to build). The custom reports will include only the fields you define. The primary difference between the insights reports and custom reports is that the insights reports have some built in calculations and formatting while the custom reports are just CSV files that include the requested data. So for calculations you'd have to add formulas and for other types of formatting, you'd have to edit the CSV after export. Review the Create Custom Export Formats section of the Export Order Records help article to learn how to create the custom report and see if that will provide you with the report you need.
Two other quick notes...