What fields are included in each Insights Report?

The Insights Reports page in ShipStation provides a variety of commonly used reports you might need for your business. ShipStation has tailored each report to meet a specific need, and some reports can be customized to provide more specific data based on dates, stores, SKUs, or other criteria.

To find out if a report includes all the fields you need, see our listings of all included fields by report below:

ORDERS

ORDER DETAILS:

·   Recipient Name

·   Address (all)

·   Date Paid

·   Amt Paid

·   Record # (order number)

·   Store

·   Buyer Comments

·   Internal Notes

·   Item ID (sku)

·   Title (Item Name)

·   Unit Price

·   Qty

·   Ext Price

BUYER COMMENTS: 

·   Marketplace

·   Order #

·   Recipient

 

COUNTRY COMPARISON:

·   Total sales by country (pie chart)

·   Items sold by country (pie chart)

·   Country

·   Abbrev.

·   Items Sold

·   Total Sales

 

 

 

PRODUCTS

ITEM DEMAND SUMMARY:

·   Sku

·   Item Name

·   # Orders

·   # Items

·   Item Revenue

PRODUCT SALES: 

·   Sku

·   Description

·   Category

·   Qty Sold

·   Total Sales

·   Totals (for each store)

·   Totals (for all stores)

RETURNED PRODUCTS:

·   Sku

·   Product Title

·   Qty Returned

·   Product Cost

·   Return Reason

·   Outbound Shipping

·   Inbound Shipping

·   Sold To

  

ACCOUNTING

POSTAGE PURCHASE HISTORY

·   Transaction Time

·   Activity/Tracking #

·   Amount 

·   Balance

 

SHIPMENTS

SHIPMENT COUNT BY USER

· Shipments by User (bar graph)

·   Date & Shipment Count by User (chart)

SHIPPING COST

 

·   Ship Date

·   Recipient

·   Order #

·   Provider

·   Service

·   Package

·   Items (how many)

·  Zone

·  Shipping Paid*

·  Shipping Cost*

·  Insurance Cost

·  Weight

·  (+/-) Difference in shipping paid & cost

·   Totals

BATCH DETAIL

 

·   Batch #

·   Batch Notes

·   Created by

·   Processed Date

·   Ship Date

·   Ship From

·   # of Labels

·   # of Errors

SHIPPED ITEMS

 

·   SKU

·   Alias SKU

·   Description

·   Qty Sold

·   Total Sales

·   Totals (for each store)

·   Totals (for all stores)

SHIPPING MANIFEST

 

·   Packages (total #)

·   Items (total #)

·   Total Weight (lbs)

·   Total Customs Value

·   Total Cost

·   Recipient

·   Service

·   Weight (oz)

·   Cost

·   Tracking #

·   Order #

·   Store

·   Items (# in shipment)

·   Service (pie chart)

 

*Shipping paid is the amount the customer paid on the marketplace. Shipping cost is the amount you pay as the shipper to ship the item through your selected carrier.

 

INVENTORY REPORTS

INVENTORY LOW STOCK REPORT

 

·   SKU

·   Product Name

·   Stock

·   Allocated

·   Available

·   Re-Order Threshold

·   Shortage

INVENTORY OUT OF STOCK SHIPMENTS

·   Tracking #

·   Order #

·   Ship Date

·   User

·   Action

·   SKU

·   Name

·   Qty

INVENTORY AUDIT REPORT

 

·   SKU

·   Variant Name

·   Date Time

·   Type

·   Quantity

·   Stock

·   User

·   Description

INVENTORY STATUS REPORT

 

·   SKU

·   Product Name

·   Last Cost

·   Avg Cost

·   Stock

·   Allocated

·   Availalble

·   Re-order Threshold

 

HOTKEY & BARCODE SCAN ACTIONS

HOTKEY REFERENCE SHEET

·   General & advanced options

BARCODE SCAN ACTION QUICK REFERENCE SHEET (options include…)

·   General

·   Custom shipping Presets

·   Shipping Orders

·   Printing Documents

·   Navigation

BARCODE SCAN ACTION REPORT

·   Exports barcode actions to PDF in a grid

 

RAW DATA EXPORTS

CUSTOMERS

·   Customer ID

·   Name

·   Company

·   Phone

·   Address 1

·   Address 2

·   City

·   State

·   Zip

·   Country

·   Orders

·   Total

·   Created (date)

·   Email

·   Last Order (date)

·   Modified (date) 

PRODUCT ALIASES

·   Product SKU

·   Sku Alias

·   Store Name

·   Store ID

SHIPPED ITEMS

·   Shipment ID

·   Order ID

·   Order #

·   SKU

·   Item Description

·   Unit Price

·   Quantity

·   Extended Price

·   Ship date

·   Store Name

·   Carrier

·   Provider

·   Service

·   Tracking #

·   Warehouse

  

RAW DATA EXPORTS: SHIPPED ORDERS

·   Shipment ID

·   Order ID

·   Store Name

·   Order Number

·   Order Date

·   Order Total

·   Date Paid

·   Amount Paid

·   Shipping Paid

·   Ship Name

·   Ship Company

·   Ship Street 1

·   Ship Street 2

·   Ship City

·   Ship State

·   Ship Postal Code

·   Ship Country

·   Ship Phone

·   Buyer Email

·   Buyer Notified

·   Buyer User ID

·   Marketplace Notified

·   Ship Date

·   Qty Shipped

·   Warehouse (ship from location)

·   Carrier

·   Carrier Fee

·   Carrier Transaction

·   Shipping Service

·   Tracking Number

·   Label Created Date

·   Label Message

·   Batch ID

·   Label Voided

·   Void Date

·   Weight (oz)

·   Weight

·   Package Width

·   Package Height

·   Package Length

·   Package Type

·   Confirmation

·   Insured

·   Insurance Cost

·   Insurance Provider

·   Insured Value

·   Insurance Voided

·   Tax Amount

·   Created By

·   Zone

 

RAW DATA EXPORTS: ORDERS

·   OrderPackageType

·   OrderPayDate

·   OrderStatus

·   OrderOtherCosts

·   OrderProvider

·   OrderResidentialIndicator

·   OrderSaturdayDelivery

·   OrderRateError

·  OrderRequestedShippingService

·   OrderNumber

·   OrderLength

·   OrderMarketplaceName

·   OrderItemWarehouse

·   OrderItemWeightOz

·   OrderItemWeight

·   OrderModifyDate

·   OrderNotesFromBuyer

·   OrderNotesToBuyer

·   OrderNonDeliver

·   OrderService

·   OrderShowPostage

·   OrderStoreName

·   OrderShipStreet2

·   OrderShipStreet3

·   OrderTotal

·   OrderWeightOz

·   OrderWeight

·   OrderWidth

·   OrderUserName

·   OrderWarehouse

·  OrderShipStreet1

·   OrderShipCounrtyCode

·   OrderShipDate

·   OrderShipCity

·   OrderShipCompany

·   OrderShipName

·   OrderShipPostalCode

·   OrderShipState

·   OrderShipPhone

·   OrderShippingAmount

·   OrderItemUPC

·   OrderExternalURL

·   OrderHeight

·   OrderDate

·  OrderExternalPaymentID

·   OrderHoldUntil

·   OrderImportKey

·   OrderInsuranceCost

·   OrderID

·   OrderImportBatch

·   OrderCustomsContent

·   OrderAddressVerified

·   OrderAmountPaid

·   OrderActive

·  OrderAdditionalHandling

·   OrderBuyerEmail

·   OrderCreateDate

·   OrderCustomer

·   OrderConfirmation

·   OrderConfirmationCost

·   OrderInsuranceProvider

·   OrderItemQuantity

·  OrderItemShippingAmount

·   OrderItemOptions

·   OrderItemOrderID

·   OrderItemSku

·   OrderItemUnitCost

·   OrderItemUnitPrice

·   OrderItemTaxAmount

·   OrderItemThumbNailUrl

·   OrderItemModifyDate

·   OrderItemCreateDate

·   OrderItemDescription

·   OrderInsuredValue

·   OrderInternalNotes

·   OrderItemExtendedPrice

·   OrderItemISBN

·   OrderItemItemURL

·   OrderItemExternalID

·   OrderItemID

·   TaxAmount

·   OrderCustomField1

·   OrderCustomField2

·   OrderCustomField3

·   Zone


Currently, the fields exported in an Insight Report cannot be modified.

To create a custom report with only the specific fields you select, see the article How can I export data from my orders?

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request