Exporting your order data lets you analyze fulfillment metrics, maintain records, share information with your team, and integrate Jetpack data with your business intelligence tools. You can export up to a million lines of order data at once, with dozens of data fields including products, tracking, timestamps, costs, and customer information.
Export Overview
Jetpack allows you to export orders as a.csv file from the Orders page. You can choose to export specific orders, all orders on the current page, or all orders based on your applied filters.
Key Export Capabilities
- Export up to 1 million lines of data in a single download
- Expanded column options including Order Tags, Ship Option, Sales Channel Store, Store Shipping Method, and SKU
- Export specific orders, current page, or all filtered results
- All dates and timestamps in UTC time for consistency
Data Retention
Orders in Shipped status are available on the Orders page for 14 months from the ship date. After 14 months, orders are deleted from the Jetpack dashboard. To retrieve data for shipped orders older than 14 months, contact Jetpack Care via Slack.How to Export Orders
1
Navigate to the Orders page
From the Jetpack dashboard, click Orders on the left-hand navigation bar, then select All Orders from the menu options.
2
Apply filters or select orders to export
You have two options for choosing which orders to export:Option 1: Apply filters to display specific orders
- Click the funnel icon to open the filter panel on the right side of the page
- Select filter categories from the left side (e.g., Import Date, Fulfillment Center, Order Status)
- Choose your filter criteria from the right side of the panel
- Click Apply Filters to view matching orders
- Check the boxes next to specific orders you want to export
- Or check the box in the column header to select all orders on the current page
3
Open the Actions menu
After applying filters or selecting orders, click the Actions button. Then select Export To Excel from the dropdown menu.
4
Choose your export scope
In the popup window, select one of the following options:
- Current Selection - Only the orders you checked
- Current Page - All orders visible on the current page
- All Orders with Current Filters - All orders matching your filters (across all pages)
5
Complete the export request
Click Export Orders to submit your request. Jetpack will begin preparing your export file.
Receiving Your Export
Jetpack will send you an email with the subject line “Export of your orders.” The email contains a download link that’s valid for 24 hours.1
Open the export email
Check your inbox for the email with subject line “Export of your orders.”
2
Download the CSV file
Click the hyperlink starting with OrdersExport. The 
.csv file will download to your computer.3
Open the file
Open the downloaded file in Excel or your preferred spreadsheet application.
Understanding Your CSV Export
Your exported CSV file contains comprehensive order data across multiple columns. Here’s what each column represents:Order Identification
Dates and Timestamps
Note: All dates and timestamps are in UTC time.Customer Information
Order Source and Processing
Shipping and Tracking
Package Details
Product Information
Note: A single order may span multiple rows if it contains more than one unique product.Fulfillment Details
SLA and Fulfillment Metrics
Learn more about SLA statuses and turnaround times.
Formatting the CSV in Excel
To ensure that tracking numbers and other numeric fields are formatted correctly in Excel, follow these steps to prevent Excel from automatically converting tracking numbers to scientific notation or removing leading zeros.1
Open the downloaded CSV file
Locate and open the downloaded
.csv file in Excel.2
Access the Data import menu
Click Data in the top navigation bar, then select Get Data and hover over From File.
3
Select the import method
Choose From Text/CSV from the submenu.
4
Locate your export file
In the file browser popup, navigate to and select your exported CSV file.
5
Configure data type detection
In the import preview window, under Data Type Detection, select Do not detect data types.
6
Load the data
Click Load to import the data with proper formatting. Your tracking numbers and other numeric fields will now display correctly without scientific notation.
CSV Export FAQs
Why are some columns blank in my export?
Why are some columns blank in my export?
Columns may be blank if the relevant data is unavailable at the time of export:
- Tracking Information is blank if the order hasn’t been labeled yet
- Delivery Date is blank if the order hasn’t been delivered
- Package dimensions (Length, Width, Height, Actual Weight) are blank if the order hasn’t been packed
- Store Order ID is blank if the order was manually created or missing from an Excel upload
- Purchase Date is blank if the order was manually created
Why does a single order appear on multiple rows?
Why does a single order appear on multiple rows?
If an order contains more than one unique product, it will span multiple rows in the CSV export. Each row represents one product SKU.Example: An order with 2 different products will have:
- Row 1: Product A with its quantity
- Row 2: Product B with its quantity
Can I schedule automatic exports?
Can I schedule automatic exports?
Automatic scheduled exports are not currently available through the dashboard. However, you can:
- Use the ShipBob API to pull order data programmatically
- Contact Jetpack Care to discuss custom reporting solutions for your business needs
What's the difference between Import Date and Purchase Date?
What's the difference between Import Date and Purchase Date?
Purchase Date is the date the customer placed the order in your ecommerce store (e.g., Shopify, WooCommerce). This comes from your integration.Import Date is the date/time the order was imported into Jetpack. For integrated stores, this is typically within minutes of the Purchase Date. For manually created orders, Purchase Date is blank and Import Date is the dashboard creation date.Use Purchase Date for customer-facing reports and analytics.
Use Import Date for Jetpack fulfillment timeline analysis.
How can I export only orders from a specific fulfillment center?
How can I export only orders from a specific fulfillment center?
To export orders from a specific fulfillment center:Your export will include only orders processed by that fulfillment center.
1
Open the filter panel
On the Orders page, click the funnel icon to open the filter panel on the right side of the page.
2
Select the Fulfillment Center filter
Click Fulfillment Center from the filter categories on the left side. Then check the box next to your desired FC (e.g., Chicago, Los Angeles, Pennsylvania) on the right side.
3
Apply filters
Click Apply Filters at the bottom of the filter panel.
4
Export with filters applied
Click Actions → Export To Excel, then select All Orders with Current Filters.
Can I export order data older than 14 months?
Can I export order data older than 14 months?
Orders in Shipped status are removed from the dashboard after 14 months. If you need historical data older than 14 months, contact Jetpack Care via Slack or email.Best practice: Export your order data quarterly or monthly to maintain long-term records without relying on dashboard retention limits.
Let’s Dive Deeper
The Orders Page
Navigate and filter all your orders with customizable views
D2C Turnaround Times + SLAs
Understand SLA statuses in your export
Order Status Overview
Learn about order statuses appearing in exports
Tracking Packages
View tracking information for shipped orders
Bulk Actions on Orders
Efficiently manage orders before exporting
Shipment Details Page
View complete order information and history
Questions? Contact Jetpack Care.
If you have any questions or run into issues, you can always contact Jetpack Care for help. Our team is always here to assist via Slack, phone, or email!