Exports · ShipStation
ShipStation shipments export to dashboard
Upload the file you already download from ShipStation. Every Number reads it with no setup, picks a screen, and puts a receipt on every number.
The question behind this fileWhat did we spend on postage per carrier and store this month, and how many labels were voided or returned?
What you get
Money over time
Money adding up through the month.
The order subtotal is money and the order date dates each shipment, so it adds up the money through the period.
Click any number for its receipt: the rule, the rows it used, and the rows it left out.
Getting the file
Download it from ShipStation
In ShipStation, open a Shipped section of the Shipments tab and export the shipments, or their line items, as CSV.
Know what a row is
One row is one shipment (line-item export: one row per product per shipment).
Upload it as it is
No cleanup first. Title rows, totals rows and repeated headers are skipped and listed in each receipt.
The 60 columns we tested with, from ShipStation's documentation
Amount - Order Shipping · Amount - Order Subtotal · Amount - Order Tax · Amount - Order Total · Amount - Shipping Cost · Bill To - Account · Bill To - Country · Bill To - Party · Bill To - Postal Code · Carrier - Fee · Carrier - Name · Carrier - Service Selected · Count - Number of Line Items · Customer - Email · Custom - Field 1 · Custom - Field 2 · Custom - Field 3 · Date - Label Create Date · Date - Order Date · Date - Shipped Date · Delivery - Date · Delivery - Message · Gift - Flag · Gift - Message · Insurance - Cost · Insurance - Insured Value · Insurance - Provider · Insurance - Purchased Flag · Market - Marketplace Name · Market - Store Name · Operations - Batch ID · Operations - Batch Number · Operations - User Name · Operations - Warehouse · Order - Number · Order - Source · Order - Status · Return - Date Received · Return - Return Label Flag · Return - RMA Number · Service - Confirmation Type · Service - Package Type · Shipment - Carrier · Shipment - Declared Value · Shipment - Height · Shipment - Length · Shipment - Package Count · Shipment - Package Type · Shipment - Tracking Number · Shipment - Void Date · Shipment - Void Flag · Shipment - Weight · Shipment - Weight (Oz) · Shipment - Width · Shipment - Zone · Ship To - Address 1 · Ship To - Address 2 · Ship To - Address 3 · Ship To - City · Ship To - Company
How we know
This file is one of the 100 in our reading test. The column names are ShipStation's; the rows were generated to fit them, since we don't have your file. Your export may have more or fewer columns, and Every Number shows how it read each one before you build.