Order Management

Updated on September 23rd, 2023

  • 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
  • General
  • 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 Purchase Orders Export - Analytics

Overview

This article explains about Historical Exports analytics report in Extensiv Order Manager.

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 Purchase 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 link to the file also expires after 24 hours.
  • 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.
  • The export does not include the Total Cost column found in the Items tab.
  • Parameters/filters to export by are limited to the destination warehouse, milestones, status, vendor, as well as created, received, and delivered date ranges.
  • Each row represents a purchase order item.

How to Access this Feature

Go to the Analytics Module and view the Purchase 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

  • Row Number
  • Purchase Order Number
  • Vendor Name
  • Authorizer Name
  • Internal Notes
  • Date Created
  • Date Issued
  • Date Authorized
  • Vendor Confirm By
  • Currency Code
  • Purchase Order Status
  • Incoterm Shipping Rule
  • Payment Term
  • Purchase Order Format
  • Custom Purchase Order Number
  • Purchase Order Milestones
  • Warehouse Name
  • Warehouse Phone
  • Warehouse Phone Ext
  • Warehouse Address 1
  • Warehouse Address 2
  • Warehouse Address 3
  • Warehouse City
  • Warehouse State
  • Warehouse Zip Code
  • Warehouse Country
  • Vendor Name
  • Vendor Address 1
  • Vendor Address 2
  • Vendor Address 3
  • Vendor City
  • Vendor State
  • Vendor Zip Code
  • Vendor Country
  • Item Status
  • Item Buyer
  • Item Packaging
  • Item Reference Number
  • Item Memo
  • Item Quantity Ordered
  • Item Unit of Measure Quantity
  • Item Unit of Measure Name
  • Item Original Unit Cost
  • Item Discount
  • Item Discount Type
  • Item Billed Unit Cost
  • Item Landed Unit Cost
  • Item Percentage Tax
  • Item Delivery Stock Location
  • Item Est Delivery Date
  • Item Delivery Date
  • Item Billed Date
  • Item Payment Date
  • Item Received Date
  • Notes to Vendor
  • Notes from Vendor
  • Vendor SKU
  • Master SKU
  • UPC
  • Product Name
  • MPN
  • Product Description
  • Product Attributes

For each row, refer to Item Quantity Ordered & Item Status together to understand Units Received (or any other status). Purchase Order Status will tell you the overall status for the PO, but the Item Status will tell you the specific status of the items belonging to a PO.

 
historical data purchase orders

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Changing an Order to Amazon Multi-Channel Fulfillment (MCF)
  • How To Remove an App in Order Manager

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