Insights Reports: Shipments

Describes the reports available in the Shipments section of the Insights > Reports page in ShipStation.

The Shipments reports pull data specific to shipment records created in ShipStation. These reports do not include fulfillments, orders marked as shipped, or orders updated to the Shipped status via store updates.

INS_Reports_ShipmentsSection_MRK.png

Shipment Count by User

The Shipment Count by User report will provide you with a bar graph and table that depicts the count of shipments, by each specific user, sorted by a time period you select when generating the report.

Below, the numbers in red on the screenshot correspond to their listed explanations.

Required Filters:

  • Date Range (Start Date and End Date)

  • Group By (controls the Time Period into which data will be separated.)

Optional Filters:

  • User

Shipment count by User report with number annotations.

Field

What does it mean?

1

Shipment Count Bar Graph

Graph depicts the total number of shipments, by each user, for each time period.

2

User Legend

List of all users who created shipments within the Start Date and End Date. Displays the color code that represents the user on the Shipment Count Bar Graph.

3

Time Period

The date or date range when the shipments were created. The time period will vary based on which Group By filter was selected when report was generated.

  • Day: Each time period will be one day.

  • Week: Each time period will be one week, beginning the Sunday of the week.

  • Month: Each time period will be one month, beginning the 1st of the month.

  • Year: Each time period will be one year, beginning January 1st.

4

User Name

Full Name of user who created shipments.

5

User Shipments

Count of shipments created by the specific user in the time period.

6

Total Per User

Count of shipments created by the specific user within the Start Date and End Date.

7

Total Per Time Period

Count of shipments created by any user within the time period.

8

Grand Total

Count of shipments created by any user within the Start Date and End Date.

Shipped Items

The Shipped Items report provides a list of items that are included in shipment records, with the total quantity shipped and total revenue of the product.

Required Filters:

  • Shipped During (Start Date and End Date)

Optional Filters:

  • Store

Shipped items report with number annotations.

Field

What does it mean?

1

Store Name

The Store Name for the store from which ShipStation received the orders.

Even if no Store filter is selected, the report will sort based on store.

2

SKU

Imported Item SKU for shipment line item.

3

Alias SKU

SKU for ShipStation product record linked to imported Item SKU.

4

Description

Item Name for the shipment line item.

5

Qty Sold

Sum of Quantity for the all shipment line items with the imported Item SKU.

6

Total Sales

Sum of (Unit Price x Quantity) for the all shipment line items with the imported Item SKU.

7

Qty Sold for store

Sum of Quantity for the all shipment line items in the store.

8

Total Sales for store

Sum of (Unit Price x Quantity) for the all shipment line items in the store.

Shipping Cost

The Shipping Cost Report will provide you with list of your shipments which includes a the amount the customer paid you for shipping when the order was placed in comparison to the actual cost of the shipment created in ShipStation.

Required Filters:

  • Shipping During (Start Date and End Date)

Optional Filters:

  • Store

  • Provider

  • Shipping Account

  • Service

Shipping cost report with number annotations.

Field

What does it mean?

1

Store Name

The Store Name for the store that ShipStation received the orders from.

Even if no Store filter is selected, the report will be sorted based on store.

2

Ship Date

Ship Date for the shipment.

3

Recipient

Ship To Name for the shipment.

4

Order #

Order # for the order linked to the shipment.

5

Provider

Name of the postage provider used to generate the label.

6

Service

Abbreviation of the shipping service used to generate the label.

7

Package

Abbreviation of the package type used to generate the label.

8

Items

Total Quantity of all line items in the shipment.

9

Zone

USPS Zone for the shipment.

10

Shipping Paid

Shipping Paid by the customer for the order linked to the shipment.

11

Shipping Cost

Carrier Fee for the shipment.

12

Insurance Cost

Insurance Fee for the shipment.

13

Weight (g)

Total Weight in grams for the shipment.

14

Difference (+/-)

Shipping Paid minus (Shipping Cost + Insurance Cost)

15

Total Items for Store

Sum of Items for all shipments in the store.

16

Total Shipping Paid for Store

Sum of Shipping Paid by the customer for all shipments in the store.

17

Total Shipping Cost for Store

Sum of Carrier Fee for all shipments in the store.

18

Total Insurance Cost for Store

Sum of Insurance Fee for all shipments in the store.

19

Total Weight (g) for Store

Total Weight in ounces for the shipment.

20

Total Difference (+/-) for Store

Total Shipping Paid for Store minus (Total Shipping Cost for Store + Total Insurance Cost for Store)

Shipping Manifest

The Shipping Manifest report will provide you with a list of all shipments created with a specific Ship Date.

Required Filters:

  • Shipping Date

Optional Filters:

  • Provider

  • Shipping Account (based on Provider filter selected)

  • Ship From Location

Shipping manifest report with number annotations.

Field

What does it mean?

1

Total Packages

Sum of Package Count for all shipments in the report.

2

Total Items

Sum of Items for all shipments in the report.

3

Total Weight (g)

Sum of Weight (g) for all shipments in the report, displayed as grams.

4

Total Customs Value

Sum of Customs Declared Value for all shipments in the report.

5

Total Cost

Sum of Carrier Fee for all shipments in the report.

6

Recipient

Ship To Name for the shipment.

7

Service

Abbreviation of the shipping service used for the shipment.

8

Weight (g)

Weight (g) for the shipment.

9

Cost

Carrier Fee for the shipment.

10

Tracking #

Tracking Number for the shipment.

11

Order #

Order Number for the order linked to the shipment.

12

Store

Store Name for the order linked to the shipment.

13

Items

Sum of Quantity for all line items in the shipment.

14

Item Name

Item Name for each line item in the shipment.

15

Item Quantity

Quantity for each line item in the shipment. Value will only be displayed if greater than 1.

16

Service Pie Chart

Pie Chart representing all shipments in the report, separated based on Service.

Batch Detail

The Batch Detail report will provide you with a list of batches which were created in ShipStation.

Required Filters:

  • Date Range (Ship Date) (Start Date and End Date)

Insights batch detail numbered.

Field

What does it mean?

1

Batch #

Batch Number for the batch.

2

Batch Notes

Notes which were added to the batch.

3

Created By

Full Name of the agent which processed the batch.

4

Processed Date

Date which the batch was created.

5

Ship Date

The Ship Date used when creating the shipping labels in the batch.

6

Ship From

The Ship From Location used when creating the shipping labels in the batch.

7

# Labels

Count of shipping labels which were successfully created in the batch.

8

# Errors

Count of shipments which were included in the batch that encountered an error when attempting to generate the shipping label.