Order Management

Updated on April 11th, 2025

  • Extensiv Hub
    Popular Articles Getting Started Using Hub Technical Issues & FAQs Extensiv's Ideas Portal
  • 3PL Warehouse Manager
    Receiving Operations Inventory Management Shipping Operations System Configuration Scanning Operations Integrations Content Best Practice Resources Release Notes Popular Articles Troubleshooting Guides
  • Warehouse Management
    Getting Started Admin Console Shipping Order Picking & Packing Receiving Customer Portal Cycle Counting Kit Building Managing Users Barcode Scanner Import/Export Integrations Barcoding Wave Picking Bin Move Mobile Receiving and Picking Settings Popular Articles Reporting
  • Order Management
    Dashboard Orders Inventory Purchase Orders Shipments Customers Products Analytics Settings API API Integrations Accessing and Navigating Order Manager Error Messages Order Manager Popular Articles Accounting Integrations
  • Integration Management
    Getting Started with Integration Manager General Support Troubleshooting Extras & Addons API Documentation Popular Articles Order Sources Order Destinations
  • FAQs
  • Network Manager
    Getting Started Order Routing Management Technical Issues Shopping Carts Settings Settings, Products, and Orders
  • Billing Manager
    Getting Started Using Billing Manager
  • Release Notes
    Extensiv Sandbox Extensiv Extensiv Hub 3PL Warehouse Manager Integration Management Warehouse Management Order Management Billing Manager
  • Fulfillment Marketplace
    Getting Started
  • Sandbox
    Getting Started
+ More
  • Help Center
  • Order Management
  • Analytics
  • Orders
  • Analytics
    • General
        • Historical Purchase Orders Export - Analytics
        • The Analytics Module's Landing Page
        • Analytics Reports
        • Printing Charts from Analytics
        • Exporting Reports
    • Products
        • Analytics - SKU Profitability
        • Y-O-Y Growth
        • Understanding Listing Profitability Analytics
        • Understanding Top Sellers & Worst Sellers Reports
        • Analytics - Trending Profitability
    • Dashboard
        • Opportunities Found by Extensiv Order Manager
    • Inventory
        • Analytics - Inventory Replenishment Alerts
        • Analytics - Snapshot Inventory Value
        • Analytics - Trending Inventory Value
        • Analytics - Critical Inventory Levels
        • Analytics - Inventory Aging
    • Customers
        • Analytics - Lifetime Value
        • Analytics - Biggest Spenders
        • Analytics - Most Frequent Customers
        • Analytics - Most Recent Customers
    • Orders
        • Historical Orders Exports - Analytics
        • Analytics - Sales Overview
        • Analytics - Biggest Tickets
        • Analytics - Shipments
    • Accounting
        • Analytics - Shipment Summary
        • Analytics - COGS by SKU
        • Analytics - Sales Summary
        • Analytics - COGS By Sales Channel
        • Analytics - Inventory Value
    • Inventory Analytics Dashboard
        • Understanding the Inventory Analytics Dashboard
        • Inventory Analytics Dashboard FAQs
      • Sales Analytics Dashboard FAQs

Historical Orders Exports - Analytics

Overview

This feature is a CSV data export tool meant for large exports of historical data. Historical data exports are not the same as grid exports which are customizable exports for live data that Extensiv Order Manager already offers in the Orders Module.

Limitations of historical exports:

  • Not real-time data - the data available for exports can be delayed for up to 24 hours.
  • Each generated CSV file is available for download for 24 hours. After that period, the entry from the export grid is deleted (from the bottom half of the screen). You can always regenerate the same request later by using the filters to submit your previous request.
  • The columns that are exported are not customizable. Instead, the export will include ALL columns available (see the list below for reference). You can edit your export once downloaded to delete/hide/rearrange columns you do not want.
  • Parameters/filters to export by are limited to sales channels, warehouses, order statuses, ship date, order date.

How to Access this Feature

Go to the Analytics Module and view the Orders subsection in the left-side panel. Then select the Historical Exports tab.

Use the available filters to narrow down your export parameters. From there, click the Generate Export button and wait while your report is generated.

You should be able to see your new request in the bottom section - when the Status column says "Succeeded", you can click the Download button in the Action column.

You should also be emailed a link to the download, which will be live for 24 hours.

Columns Available for Export for Historical Data

  • Order Number
  • Order Date
  • Status Description
  • Order Type (Standard, POS, FBA, Stock Transfer, Prime, or FBA Workflow)
  • Order Total
  • Currency Code3
  • Amount Paid
  • Payment Date
  • Customer Ship Amount
  • Ship by Date
  • Receive by Date
  • Notes from Buyer
  • Notes to Buyer
  • Internal Notes
  • Requested Shipping Service
  • Order Weight
  • Order Height
  • Order Width
  • Order Length
  • Insured Value
  • Insurance Cost
  • Other Cost
  • Saturday Delivery
  • Contains Alcohol
  • Contains Dry Ice
  • Dry Ice Weight
  • Gift
  • Gift Message
  • Non-Machinable
  • Show Postage
  • ITN
  • Intl Non-Delivery Action
  • Bill Duties to Sender
  • Do Not Prepay Postage
  • Include Return Label
  • Release Without Signature
  • Custom Field 1
  • Custom Field 2
  • Custom Field 3
  • External Order
  • Discount
  • Order Payment Type
  • Multi Package
  • Channel Priority
  • Fraud Analysis
  • Order Labels
  • Ship Name
  • Ship Company
  • Ship Address1
  • Ship Address2
  • Ship Address3
  • Ship City
  • Ship State
  • Ship Zip Code
  • Ship Country
  • Ship Phone
  • Ship Address Type
  • Buyer Name
  • Buyer Email
  • Ship Date
  • Tracking Number
  • Carrier Fee
  • Transaction ID
  • Ship Carrier Name
  • Ship Service Name
  • Ship Package Name
  • Listing SKU
  • Item Qty Ordered
  • Item Unit Price
  • Item Tax
  • Item Discount
  • Item Notes
  • Warehouse Name
  • Sales Channel Name
  • Sales Channel Type Name
  • Internal SKU
  • UPC
  • Digital
  • Giftcard
  • Product Name
  • Brand Name

Note About CSV Exports

It is quite common for users to open these exported CSV files using programs like Microsoft Excel to check their contents before importing the file into a separate application. However, when Microsoft Excel opens a CSV file, it attempts to interpret the data in that file and starts making changes to it.

For example, if Excel sees something in the CSV file that it identifies as a date (often incorrectly), Excel will change the date format in the CSV file to suit the way that it prefers the dates to be formatted. Unfortunately, this generally has the unintended consequence of breaking the CSV file.

THE SOLUTION
If you need to open a CSV file in Excel without breaking it, here's how to do it:

  1. Open a new Excel sheet, select the Data tab, then click 'From Text' in the Get External Data group.
  2. Browse to the CSV file and select 'Import'.
  3. In step 1 of the Import Wizard choose 'Delimited' as the original data type. Click 'Next'.
  4. In step 2 of the Import Wizard choose Comma as the delimiter (deselect the Tab checkbox) and click 'Next'.
  5. In step 3 of the Import Wizard, you tell Excel not to change your formats. With the first column in the Data Preview selected, scroll across to the last column and select it while holding the SHIFT key (all columns should now be selected). Then select 'Text' as the Column Data Format and click 'Finish'.
  6. Click OK to insert the data into cell A1
  7. You should now have a spreadsheet with the imported data but without Excel breaking the formatting required. Remember to export the file from Excel to CSV again before uploading it to the third-party application if you have made changes.
exports historical

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Navigating the Extensiv Order Manager Toolbar

Not finding the help you need?

Contact Support
Solutions
  • Solutions for Brands
  • Solutions for 3PLs
  • Solutions for 4PLs
  • Solutions for B2B
Products
  • Extensiv 3PL Warehouse Manager
  • Extensiv Warehouse Manager
  • Extensiv Order Manager
  • Extensiv Integration Manager
  • Extensiv Network Manager
Products
  • Customer Success
  • Implementation
  • Consulting
Ecosystem
  • Fulfillment Marketplace
  • Integrations
  • Partners
  • Become a Partner
Resources
  • Resource Library
  • Blog
  • Market Insights
  • What is a 3PL?
  • What is a 4PL?
  • What is a WMS?
  • Why a Cloud-based WMS?
  • Glossary
Help
  • Help Center
  • API Documentation
  • Extensiv Univerisity
  • Community
  • System Status
  • Extensiv Logo
  • 100 N Pacific Coast Hwy, Suite 1100, El Segundo, CA 90245
  • |
  • Contact Us:
  • 83-EXTENSIV 888.375.2368 (main)
  • |
  • 310.844.7570 (local)
  • Copyright © 2023 Extensiv
  • |
  • All rights reserved.
  • Privacy Policy
  • |
  • Terms of Service
  • Follow Us:
Expand