Insights Reports: Raw Data Exports

Describes the reports available in the Raw Data Exports section of the Insights > Reports page in ShipStation.

The Raw Data Exports are reports that contain the data fields and values related to the subject of the report, but the information is not formatted or sorted in any particular fashion. When you export a Raw Data report, you would then use the information exported in the file to build your own reports.

INS_Reports_RawDataSection_MRK.png

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, 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 in ShipStation within your specified 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 your specified 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.