Insights Reports

Breakdown of the pre-formatted reports which can be generated on the Reports section of the Insights tab.

The Reports section of the Insights page provides several pre-formatted reports you view directly in ShipStation, or export to a document such as PDF, CSV, Excel, or plain text.

Each report has various filter options to help you export only the data you need, whether that data is within a specific date range or from a specific store or carrier account.

The reports are sorted into the following categories:

  • Orders: Reports include Order Details, Buyer Comments, and Country Comparison.

  • Products: Reports include Item Demand Summary, Returned Products, and Product Sales.

  • Shipments: Shipment Count by User, Shipping Manifest, Shipped Items, Shipping Cost, and Batch Detail.

  • Accounting: Report includes Account Balance History.

  • Inventory Reports: Reports include Inventory Low Stock Report, Inventory Out of Stock Shipments, Inventory Audit Report, and Inventory Status Report.

    These inventory reports relate only to ShipStation's Native Inventory Solution.

  • Hotkey & Barcode Scan Actions: Shipstation Legacy Layout Only. Reports include a Hotkey Reference Sheet, Barcode Scan Action Quick Reference Sheet, and a Barcode Scan Action Report.

  • Raw Data Exports: Reports include Customers, Shipped Items, Orders, Shipped Orders, and Product Aliases.

The sections below provide details on each of the reports within each section, including information on where ShipStation pulls the data in the reports from.

Access Insight Reports

Follow the steps below to access Insight Reports in ShipStation:

To learn about each type of report, review the sections below.

Orders

The Orders report pulls data specific to the orders that have either imported into or been created in ShipStation.

Order Detail

The Order Detail report will generate a block of information for each order that matches the parameters of the filter. Below, the numbers in red on the screenshot correspond to their listed explanations.

Required Filters:

  • Date Range (Start Date and End Date)

Optional Filters:

  • Store

Other Options:

  • Include product images on order details report

INS_orderdetail_numbered.png

Field

What does it mean?

1

Recipient Name

Ship To Name for the order.

2

Recipient Address

Ship To Address 1 & 2 for the order.

3

Recipient City

Ship To City for the order.

4

Recipient State Code

Ship To State for the order.

5

Recipient Postal Code

Ship To Post Code for the order.

6

Recipient Country Code

Ship To Country for the order.

7

Date Paid

The date the order was paid for, according to the order source.

8

Amt Paid

The amount the customer paid for the order, according to the order source.

9

Record #

Order Number for the order.

10

Store

The Name of the store where the order was created.

11

Marketplace

The marketplace or selling channel the store is connected to.

12

Buyer Comments

Notes from Buyer for the order.

13

Internal Notes

Internal Notes for the order.

14

Item Image Thumbnail

Thumbnail image generated using the Product Image URL. Will only be displayed if Include product images on order details report option is selected.

15

Item ID

Product SKU for each unique line item in the order.

16

Title

Product Name for each unique line item in the order.

17

Options

Product Options for each unique line item in the order.

18

Unit Price

Individual Unit Price for each unique line item in the order.

19

Quantity

Quantity for each unique line item in the order.

20

Extended Price

Multiply Unit Price x Quantity for each unique line item in the order.

Country Comparison

The Country Comparison report will generate a chart and breakdown of orders based on the Ship To Country.

Required Filters:

  • Date Range (Start Date and End Date)

Country comparison report with number annotations.

Field

What does it mean?

1

Sales by Country Graph

Pie chart representing the sum of all product Quantities for orders with an Order Date within the date range, organized by Ship To Country.

2

Items Sold Country Graph

Pie chart representing the sum of all Order Totals for orders with an Order Date within the date range, organized by Ship To Country.

3

Country Name

Country name for each unique Ship To Country for orders with an Order Date within the date range

4

Country Abbreviation

The 2-digit country code for each unique Ship To Country for orders which have an Order Date within the date range

5

Items Sold

Sum of all product Quantities for orders going to the Ship To Country with an Order Date within the date range

6

Total Sales

Sum of all Order Totals for orders going to the Ship To Country with an Order Date within the date range

Buyer Comments

The Buyer Comments report will provide you a list of orders that include a Note from Buyer as well as the text of the note.

Required Filters:

  • Date Range (Start Date and End Date)

Optional Filters:

  • Order Status

Insights report Buyer Comments numbered.

Field

What does it mean?

1

Marketplace

Marketplace or selling channel from which the order imported into ShipStation.

2

Order #

Order Number for the order

3

Recipient

Ship To Name for the order.

4

Note

Notes from Buyer for the order.

Products

The Products report pulls data specific to the products included on order records in ShipStation or products included on orders that have had returns processed in ShipStation.

Item Demand Summary

The Item Demand Summary report will provide you a list of products that were ordered in the given date range, and their total revenue. This report is similar to the Product Sales report, but can be filtered based on order status.

Required Filters:

  • Date Range (Start Date and End Date)

  • Group Product By

Optional Filters:

  • Order Status

  • Order Filter

Other Options:

  • Sort By

Field

What does it mean?

SKU

If the Group Product By filter is set to Marketplace Listing SKU, this will be the SKU that imported in ShipStation from the order's source.

If the Group Product By filter is set to Product Record SKU or Parent Record, this will be the SKU for the product record stored in ShipStation.

Item Name

The Product Name for the product record.

# Orders

Count of orders that include the product record as a line item.

# Items

Sum of Quantity for the product record.

Item Revenue

Sum of Extended Price for the product record.

Product Sales

The Product Sales report will provide you a list of products that were ordered in the given date range, and their total revenue. This report is similar to the Item Demand Summary report, but can be filtered based on store.

Required Filters:

  • Ordered During (Start Date and End Date)

  • Show Products By

Optional Filters:

  • Store

Product sales report with number annotations.

Field

What does it mean?

1

Store Name

The Name of the store where the order product data was pulled from.

If you do not use the optional Store filter, the report will populate based on store.

2

SKU

If the Show Product By filter is set to Marketplace Listing SKU, this will be the SKU that imported in ShipStation from the order's source.

If the Show Product By filter is set to Product Record SKU or Parent Record, this will be the SKU for the product record stored in ShipStation.

3

Description

The Product Name for the product record.

4

Category

The Category for the product record.

5

Qty Sold

Sum of Quantity for the product record

6

Total Sales

Sum of Extended Price for the product record

7

Qty Sold (Total for Store)

Sum of Quantity for all products from the store.

8

Total Sales (Total for Store)

Sum of Extended Price for all products from the store.

Returned Products

The Returned Products report will provide a list of products that were included in return shipments created for ShipStation orders. The report will also include the reason given for the return at time of shipment creation, as well as the carrier fee for both the original outbound shipping label and the return label.

Required Filters:

  • Date Range (Start Date and End Date)

Field

What does it mean?

SKU

Item SKU for the return shipment line item.

Product Title

Item Name for the return shipment line item.

Qty Returned

Quantity for the return shipment line item.

Product Cost

Unit Price for the return shipment line item.

Return Reason

Return reason selected when the return was created through ShipStation or the Branded Returns Portal.

Outbound Shipping

Carrier Fee for the original outbound shipping label associated with the return.

Inbound Shipping

Carrier Fee for the return shipping label.

Sold To

Buyer Name for the order associated with the return.

Shipments

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

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.

Inventory Reports

The Inventory Reports pull data specific to ShipStation's internal inventory solution. These reports do not reference inventory levels maintained by connected marketplaces, selling channels, or other third-party services.

Inventory Low Stock Report

The Inventory Low Stock Report will provide you with a list of products whose stock count is at or below the reorder threshold set in the product defaults.

Required Filters:

  • Group Products By Parent SKU

Field

What does it mean?

SKU

Item SKU for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead.

Product Name

Item Name for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead.

Stock

Total Stock count for the product or Parent product.

Allocated

Amount of the product or Parent product placed in orders that are currently Allocated.

Available

Total Stock count minus Allocated.

Re-Order Threshold

The Reorder Threshold set in the product defaults for the product or Parent product.

Shortage

Available divided by Re-Order Threshold as a percentage.

Run an Inventory Low Stock Report

Inventory Audit Report

The Inventory Audit Report provides a list of any stock changes that occurred within a selected time frame.

Required Filters:

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

Optional Filters:

  • Specific SKU

Field

What does it mean?

SKU

Item SKU for the product.

Product Name

Item Name for the product.

Event Date/Time

Date and time when the action occurred.

Type

Action that occurred.

Quantity

Amount to which total stock count changed.

Stock

Total stock count after action occurred.

User

User who initiated the action.

Description

The Note entered during the action. Only available when adjusting stock manually through product defaults.

Run an Inventory Audit Report

Inventory Out-of-Stock Shipments

The Inventory Out-of-Stock Shipments report lists shipments created with out-of-stock products in the order.

Required Filters:

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

Optional Filters:

  • Specific SKU

Field

What does it mean?

Tracking #

Tracking Number for the shipment.

Order #

Order Number for the order linked to the shipment.

Ship Date

Ship Date for the shipment.

User

Full Name of the user who created the shipment.

Action

Action(s) taken by the user when creating the shipment.

SKU

Item SKU for the out-of-stock product.

Name

Item Name for the out-of-stock product.

Qty

Line Item Quantity of the out-of-stock product shipped.

Run an Inventory Out-of-Stock Shipments Report

Inventory Status Report

The Inventory Status Report provides inventory stock counts for a list of products that have an assigned inventory location.

Required Filters:

  • Group Products By Parent SKU

Field

What does it mean?

SKU

Item SKU for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item SKU instead.

Product Name

Item Name for the product.

If Group Products By Parent SKU filter is set to Yes, ShipStation will group all Variant products together and display the Parent product's Item Name instead.

Last Cost

Cost amount entered the last time stock count was adjusted.

Avg Cost

Average Cost amount when stock count is adjusted.

Stock

Total Stock count for the product or Parent product.

Allocated

Amount of the product or Parent product in currently Allocated orders.

Available

Total Stock count minus Allocated

Re-Order Threshold

Reorder Threshold set in product defaults for the product or Parent product.

Run an Inventory Status Report

Hotkeys Report

Hotkeys allow you to perform common functions within ShipStation use a keyboard command instead of your mouse.

ShipStation has both Basic hotkeys that are always active and Advanced hotkeys, which you can enable or disable as needed (Advanced hotkeys are enabled on your account by default).

To view the available hotkeys in ShipStation, click the Help menu Get Help icon. Black Question mark, inside of a gray circle, inside of a black square. and choose Hotkeys.

Dropdown menu for Support (question mark icon). Red box highlights Hotkeys option.

To print the hotkey report in ShipStation Legacy, go to Insights > Reports > Hotkey and Barcode Scan Actions. Then click the Hotkey Reference Sheet option.

You cannot currently print a sheet of your hotkeys in ShipStation's new layout, but this functionality is coming soon!

Hotkey Reference Sheet

The Hotkey Reference Sheet report will generate a list of hotkey actions you can use within ShipStation.

Optional Filters:

  • Hotkey Type

Basic Hotkeys

General

?

List hotkeys (a.k.a. keyboard shortcuts)

Esc

Close window

Shift + Click

Select multiple rows

Ctrl + Click

Toggle row selection

Move to the next row

Move to the previous row

Move to the next Order Details window

Move to the previous Order Details window

Ctrl + Shift + S

Enable Barcode Listening screen to view, batch, or ship scanned orders.

On a Mac, use Cmd + Shift + s instead.

Advanced Hotkeys

Shipping Orders

Navigation

U

Update all stores

/

Focus QuickSearch

N

Create new orders

G + O

Go to Orders

V

View Order Details window

G + S

Go to Shipments

W

Read weight from scale

G + F

Go to Shipments > Fulfillments

R

Get rate

G + R

Go to Shipments > Returns

Q

Toggle QuickShip

G + B

Go to Shipments > Batches

S

Create label (a.k.a. Ship Orders)

G + E

Go to Shipments > End of Day

C

Show Rate Calculator

G + K

Go to Shipments > Pickup

B

Create new batch

G + P

Go to Products

O + R

Reload Orders grid

G + I

Go to Products > Inventory

P + B

Process the currently open batch

G + C

Go to Customers

M + S

Mark as Shipped

G + A + M

Go to Account Settings

M + B

Mark as Shipped Bulk

G + A + S

Go to Store Setup Settings

Printing Documents

G + A + C

Go to Carrier & Fulfillment Settings

P + S

Print Packing Slip

G + A + P

Go to Print Setup Settings

P + L

Print Pick List

G + A + N

Go to ShipStation Connect Settings

O + S

Print Order Summary

G + A + B

Print Order Summary

Barcode Scan Actions (Legacy Only)

The Barcode Scan Action and Barcode Quick Reference reports allow you to print a sheet of scannable barcodes to accomplish certain tasks with a barcode scan instead of your keyboard or mouse.

ShipStation Legacy Layout Only

The Barcode Scan Action reports are currently only available when using ShipStation's Legacy Layout. This functionality is coming to the new layout soon!

Barcode Scan Action Report

The Barcode Scan Action Report will generate a PDF document that includes a pre-selected list of barcodes you can use to perform actions in ShipStation. For a more customized version of this report, see the Barcode Scan Action Quick Reference Sheet.

Optional Filters:

  • Scan Action Type

  • Include Hotkeys

Scan Action Type: General

Barcodes for general actions.

Scan Action Type: Custom Shipping Presets

Note

Will generate a list of barcodes based on the Shipping Presets you've created in your account.  Only Shipping Presets that have hotkeys assigned to them can be used with barcodes.

Scan Action Type: Shipping Orders

Barcodes for Shipping Order actions
Barcode for Toggling Quickship.

Scan Action Type: Printing Documents

Barcodes for printing documents.

Scan Action Type: Navigation

Barcodes for navigating ShipStation.
Barcodes for navigating the ShipStation app.

Barcode Scan Action Quick Reference Sheet

The Barcode Scan Action Quick Reference will generate a PDF document that includes up to 10 barcodes you can use to perform actions in ShipStation.

Required Filters:

  • Include Hotkeys

Available Scan Actions:

General

  • Close modal

  • List hotkeys (a.k.a. keyboard shortcuts)

  • Enable Barcode Listening screen to view, batch or ship scanned orders.

  • Move to the next row

  • Move to the previous row

  • Move to the next Order Detail window

  • Move to the previous Order Detail window

Custom Shipping Presets

  • Varies, based on user account

Shipping Orders

  • Read weight from scale

  • Show Rate Calculator

  • Update all stores

  • Create new order

  • View Order Details window

  • GetRate

  • Create label (a.k.a. Ship Order)

  • Create new batch

  • Reload Orders Grid

  • Process the currently open batch

  • Toggle QuickShip

Printing Documents

  • Print Packing Slip

  • Print Pick List

  • Print Order Summary

Navigation

  • Go to Store Setup Settings

  • Go to Account Settings

  • Focus QuickSearch

  • Go to Orders

  • Go to Shipments

  • Go to Shipments > Fulfillments

  • Go to Shipments > Returns

  • Go to Shipments > Batches

  • Go to Shipments > End of Day

  • Go to Shipments > Pickup

  • Go to Products

  • Go to Products > Inventory

  • Go to Customers

  • Go to Carriers & Fulfillment Settings

  • Go to Printing Setup Settings

  • Go to ShipStation Connect Settings

  • Go to Subscription Settings

Raw Data Exports

The Raw Data Exports are reports that contain a lot of raw information related to the subject of the report, but the information is not formatted or sorted in any particular fashion. You would then

use the information found in the file to build your own reports.

Customers

The Customers Raw Data Export provides a list of customer records created in ShipStation within a selected date range that also have order records in ShipStation. Please note that customer records that do not have any orders yet will not appear on this report.

Required Filters:

  • Date Range (Start Date and End Date)

Field

What does it mean?

Address 1

Address Line 1 for the customer record.

Address 2

Address Line 2 for the customer record.

City

City for the customer record.

Company

Company for the customer record.

Country

Two-character Country code for the customer record.

Created

Date the customer record was created in ShipStation.

Customer ID

ShipStation's internal identification number for the customer record.

Email

Email for the customer record.

Last Order

Order Date for the most recent order linked to the customer record.

Modified

Date the customer record was last changed in ShipStation.

Name

Name for the customer record.

Orders

Count of orders linked to the customer record.

Phone

Phone for the customer record.

State

State for the customer record.

Zip

Zip (Postal Codes) for the customer record.

Orders

The Orders Raw Data Export provides a list of orders created within a date range. The export does include products, and each unique product in an order will receive its own row on the report.

Required Filters:

  • Date Range (Start Date and End Date)

Optional Filters:

  • Store

Field

What does it mean?

OrderActive

If TRUE, the order is active in ShipStation. Inactive orders are not accessible in ShipStation.

OrderAdditionalHandling

If TRUE, the Other Shipping Option This shipment requires Additional Handling is enabled for the order.

OrderAddressVerified

0 - Address has not been verified.

1 - Address was verified successfully.

2 - Address was verified, but there is a warning or error.

OrderAmountPaid

Total Paid for the order record.

OrderBuyerEmail

Buyer Email for the order record.

OrderConfirmation

Confirmation Type set in the Shipping Info on the order record.

OrderConfirmationCost

Confirmation cost for most recent estimated rate for the order record.

OrderCreateDate

Date the order record was created in ShipStation.

OrderCustomer

Buyer Name for the order record.

OrderCustomField1

Custom Field 1 for the order record.

OrderCustomField2

Custom Field 2 for the order record.

OrderCustomField3

Custom Field 3 for the order record.

OrderCustomsContents

Package Contents set in the Customs Declarations for the order record.

OrderDate

Order Date for the order record.

OrderExternalPaymentID

The marketplace's internal identifier for the payment associated with the order data. Only available for ChannelAdvisor and Sears.

OrderExternalURL

URL leading to the order's record on the marketplace.

OrderHeight

Height set in the Shipping Info for the order record.

OrderHoldUntil

Hold Until date for the order record.

OrderID

ShipStation's internal identifier for the order record.

OrderImportBatch

ShipStation's internal identifier for the action that created the order record.

OrderImportKey

The identifier that ShipStation will use to match imported order data to order records. Usually, this is the marketplace's internal identifier for the order, or the order number.

OrderInsuranceCost

Insurance cost for most recent estimated rate for the order record.

OrderInsuranceProvider

Name of Insurance option set in the Shipping Info for the order record.

OrderInsuredValue

Value for Insurance option set in the Shipping Info for the order record.

OrderInternalNotes

Internal Notes for the order record.

OrderItemCreateDate

Date the item within the order record was created in ShipStation.

OrderItemDescription

Name for the item within the order record.

OrderItemExtendedPrice

Extended Price for the item within the order record.

OrderItemExternalID

The marketplace's identifier for the item within the order record.

OrderItemID

ShipStation's internal identifier for the item within the order record.

OrderItemISBN

ISBN for the item within the order record.

OrderItemItemURL

orderitem.itemurl (based on order.orderid)

OrderItemModifyDate

Date that the item within the order record was last changed in ShipStation.

OrderItemOptions

Item Options for the item within the order record.

OrderItemOrderId

ShipStation's internal identifier for the order record.

OrderItemQuantity

Quantity for the item within the order record.

OrderItemShippingAmount

Shipping Amount for the item within the order record.

OrderItemSku

SKU for the item within the order record.

OrderItemTaxAmount

Tax Amount for the item within the order record.

OrderItemThumbNailUrl

Image URL for the item within the order record.

OrderItemUnitCost

Unit Cost for the item within the order record.

OrderItemUnitPrice

Unit Price for the item within the order record.

OrderItemUPC

UPC for the item within the order record.

OrderItemWarehouse

Warehouse Location for the item within the order record.

OrderItemWeight

Weight for the item within the order record.

OrderItemWeightOz

Weight (in ounces) for the item within the order record.

OrderLength

Length set in the Shipping Info for the order record.

OrderMarketplaceName

The name of the integration that was used to create the order record in ShipStation.

Examples: eBay, Shopify, StitchLabs, Custom Store, ShipStation

OrderModifyDate

Date that the order record was last changed in ShipStation.

OrderNonDelivery

If Non-Delivery set in the Customs Declarations for the order record.

OrderNonMachinable

If TRUE, the Other Shipping Option This order is non-machinable is enabled for the order.

OrderNotesFromBuyer

Notes from Buyer for the order record.

OrderNotesToBuyer

Notes to Buyer for the order record.

OrderNumber

Order Number for the order record.

OrderOtherCosts

Additional Charges for most recent estimated rate for the order record.

OrderPackageType

Package set in the Shipping Info for the order record.

OrderPayDate

Paid Date for the order record.

OrderProvider

Name of postage provider for Service set in the Shipping Info for the order record.

OrderRateError

Error message text for most recent estimated rate for the order record.

OrderRequestedShippingService

Requested Shipping Service for the order record. Usually, this is the shipping option your customer chooses when checking out.

OrderResidentialIndicator

C - Order was verified as a Commercial address.

R - Order was verified as a Residential address.

OrderSaturdayDelivery

If TRUE, the Other Shipping Option Saturday Delivery is enabled for the order.

OrderService

Service set in the Shipping Info for the order record.

OrderShipCity

Ship To City for the order record.

OrderShipCompany

Ship To Company for the order record.

OrderShipCountryCode

Ship To Country for the order record.

OrderShipDate

Ship Date for the order record.

OrderShipName

Ship To Name for the order record.

OrderShipPhone

Ship To Phone for the order record.

OrderShippingAmount

Shipping Paid for the order record.

OrderShipPostalCode

Ship To Postal Code for the order record.

OrderShipState

Ship To State for the order record.

OrderShipStreet1

Ship To Address Line 1 for the order record.

OrderShipStreet2

Ship To Address Line 2 for the order record.

OrderShipStreet3

Ship To Address Line 3 for the order record.

OrderShowPostage

If TRUE, the Other Shipping Option Print postage on the shipping label for this order is enabled for the order.

OrderStatus

Status of the order record.

OrderStoreName

Store Name for store the order record was created in.

OrderTotal

Total Order for the order record. This is the sum of the Product Total, Shipping Paid, and Tax Paid.

OrderUserName

Buyer Username for the order record.

OrderWarehouse

Ship from set in the Shipping Info for the order record.

OrderWeight

Weight set in the Shipping Info for the order record.

OrderWeightOz

Weight (in ounces) set in the Shipping Info for the order record.

OrderWidth

Width set in the Shipping Info for the order record.

TaxAmount

Tax Paid for the order record.

Zone

USPS Zone for the order record, based on the Ship To Postal Code and the Ship From set in the Shipping Info

Shipped Orders

The Shipped Orders Raw Data Export provides a list of shipments created within a date range.

Required Filters:

  • Date Range (Start Date and End Date)

Optional Filters:

  • Store

Field

What does it mean?

Amount Paid

Amount Paid for the order used to create the shipment record.

Batch ID

ShipStation's internal identifier for the batch in which the shipment was created.

Buyer Email

Buyer Email for the order used to create the shipment record.

Buyer Notified

If TRUE, ShipStation sent a shipment confirmation email to the Buyer Email on the order used to create the shipment record.

Buyer User ID

Buyer Username for the order used to create the shipment record.

Carrier

Name of the Carrier used to create the shipping label for the shipment record.

Carrier Fee

The cost of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

Carrier Transaction

The postage provider's internal identifier for the shipping label for the shipment record.

Confirmation

Confirmation Type used to create the shipping label for the shipment record.

Created By

Full Name of the ShipStation user who created the shipment record.

Date Paid

Paid Date for the order used to create the shipment record.

Insurance Cost

Insurance Fee of the shipping label for the shipment record, based on the Shipping Info that was used to create the label.

Insurance Provider

Insurance Provider used to create the shipping label for the shipment record.

Insurance Transaction

The insurance provider's internal identifier for the insurance purchase linked to the shipment record.

Insurance Voided

If TRUE, the insurance purchase was cancelled.

Insured

If TRUE, the shipment was insured.

Insured Value

Insurance Amount used to create the shipping label for the shipment record.

Label Create Date

Date the shipping label for the shipment record was created in ShipStation.

Label Message

Label Messages used to create the shipping label for the shipment record.

Label Voided

If TRUE, the shipping label for the shipment record was cancelled.

Marketplace Notified

If TRUE, ShipStation sent an update to the order's marketplace to update the marketplace order data to include shipment details.

Order Date

Order Date for the order used to create the shipment record.

Order ID

ShipStation's internal identifier for the order used to create the shipment record.

Order Number

Order Number for the order used to create the shipment record.

Order Total

Total Order for the order used to create the shipment record.

Package Height

Height used to create the shipping label for the shipment record.

Package Length

Length used to create the shipping label for the shipment record.

Package Type

Package used to create the shipping label for the shipment record.

Package Width

Width used to create the shipping label for the shipment record.

Qty Shipped

Sum of Quantity for all items in the order used to created the shipment record.

Ship City

Ship To City used to create the shipping label for the shipment record.

Ship Company

Ship To Company used to create the shipping label for the shipment record.

Ship Country

Ship To Country used to create the shipping label for the shipment record.

Ship Date

Ship Date used to create the shipping label for the shipment record.

Ship Name

Ship To Name used to create the shipping label for the shipment record.

Ship Phone

Ship To Phone used to create the shipping label for the shipment record.

Ship Postal Code

Ship To Postal Code used to create the shipping label for the shipment record.

Ship State

Ship To State used to create the shipping label for the shipment record.

Ship Street 1

Ship To Address Line 1 used to create the shipping label for the shipment record.

Ship Street 2

Ship To Address Line 2 used to create the shipping label for the shipment record.

Shipment ID

ShipStation's internal identifier for the shipment record.

Shipping Paid

Shipping Paid for the order used to create the shipment record.

Shipping Service

Abbreviation of the Service used to create the shipping label for the shipment record.

Store Name

Store Name for the order used to create the shipment record.

TaxAmount

Tax Paid for the order used to create the shipment record.

Tracking Number

Tracking Number of the shipping label for the shipment record.

Void Date

Date the shipping label for the shipment record was voided in ShipStation.

Warehouse

Name of the Ship From used to create the shipping label for the shipment record.

Weight

Weight used to create the shipping label for the shipment record.

Weight Oz

Weight (in ounces) used to create the shipping label for the shipment record.

Zone

USPS Zone for the shipment record, based on the Ship To Postal Code and the Ship From used to create the shipping label for the shipment record.

Shipped Items

The Shipped Orders Raw Data Export provides a list of products within shipment records created within a date range.

Required Filters:

  • Date Range (Start Date and End Date)

  • Show Products By

Optional Filters:

  • Store

Field

What does it mean?

Carrier

Name of the Carrier used to create the shipping label for the shipment record.

Extended Price

Extended Price of the item within the shipment record.

Item Description

Item Name of the item within the shipment record.

Order #

Order Number for the order used to create the shipment record.

Order ID

ShipStation's internal identifier for the order used to create the shipment record.

Provider

Name of the Shipping Postage Provider used to create the shipping label for the shipment record.

Quantity

Quantity of the item within the shipment record.

Service

Abbreviation of the Service used to create the shipping label for the shipment record.

Ship Date

Ship Date used to create the shipping label for the shipment record.

Shipment ID

ShipStation's internal identifier for the shipment record.

SKU

Item SKU of the item within the shipment record.

Store Name

Store Name for the order used to create the shipment record.

Tracking #

Tracking Number of the shipping label for the shipment record.

Unit Price

Unit Price of the item within the shipment record.

Warehouse

Name of the Ship From used to create the shipping label for the shipment record.

Product Aliases

The Product Aliases Raw Data Export will provide you with a list of products that have alias SKUs.

Required Filters:

  • Show Product Aliases For

Optional Filters:

  • Store

Field

What does it mean?

Product SKU

The SKU for the product record.

Product Alias

The Alias SKU associated with the Product SKU

Store Name

The Store Name for the store that uses the Product Alias.

Store ID

ShipStation's internal identifier for the store that uses the Product Alias.