Order Management

Updated on October 7th, 2024

  • 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
  • Inventory Analytics Dashboard
  • 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

Inventory Analytics Dashboard FAQs

Q: Why is the aging data different in the new Inventory Analytics Dashboard from the Analytics Report in Order Management?

A: We have updated and improved the calculation method for inventory aging in the new dashboard. Now, we only provide aging data for inventory received from purchase orders, based on the received date. If you have inventory that was added manually (not through purchase orders) that inventory will not be reflected in aging visuals.

Q: Why is the Inventory Snapshot Value results different in the new Inventory Analytics Dashboard from Order Management?

A: If the difference is relatively small (100s of dollars to a few thousand), it is likely caused by a difference in the reporting cut-off time used by the different systems. Order Management uses UTC (coordinated universal time) which is 5 hours ahead of US Eastern Standard Time and the new Inventory Analytics Dashboard uses the local time zone of the Brand customer.

If the difference between the two reports is larger than a few thousand dollars, please report this to the product team at bsevy@extensiv.com.

Q: How is Inventory Snapshot value calculated?

A: Inventory Snapshot value is calculated by combining the total value of inventory in the FIFO queue with the value of unreconciled inventory (inventory not reconciled with the FIFO queue). The value of inventory in the FIFO Queue = SKU Quantity x the actual landed cost on the original P.O. or the value set upon reconciliation to the FIFO Queue. The value of unreconciled inventory = SKU quantity x the default vendor cost for that SKU.  

Q: Why is the unreconciled Inventory value and quantities by warehouse called out on the Value sheet?

A: Unreconciled inventory in Order Management refers to inventory that has not been reconciled with the FIFO Queue. Unreconciled inventory originates either inventory variances (plus or minus) from you’re your connected warehouses that have not been reconciled or when product stocks are manually added. Because unreconciled inventory value is calculated based on default vendor costs, it will never be as accurate as the value of inventory in or reconciled to the FIFO Queue which is based on the actual P.O. costs. We provide the unreconciled value at the date of your snapshot as an indicator of the quality of your inventory value calculation. To ensure the most accurate calculation of your inventory value, ensure that any inventory variances are reconciled in Order Management.

Q: How do I know what good benchmarks for Inventory Turnover Ratio or Sell-through rate are?

A: Inventory Turnover Ratio measures how much of your inventory value you are moving or turning over in a date range. It is calculated as (COGS / Average Inventory Value) x100, during a date range.  A good benchmark depends on your industry, product category, or market segment. Here is a link to an article that provides some good benchmarks for consumer products (https://www.extensiv.com/blog/good-inventory-turnover-ratio. The key is to track this KPI month over month. A higher inventory turnover ratio % is generally better because it means that you are moving or turning over that percentage of the value of your inventory during a period. It is a great KPI to help you use your capital more wisely. You can increase the ratio by increasing sales velocity and/or reducing inventory levels.

Q: What is a Stockout period and Average Stockout Duration?

A: This is simply a period in which the stock for a was zero. It is measured per SKU during the selected date range regardless of the length of the period. Average stockout duration is the average length of your stockout periods.

Q: How do I exclude products or product categories from my KPI calculations?

A: Use the filters in the Dashboard Sheet controls to search for and exclude specific products, your filter settings will be saved. 

stock analysis supply insights

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Reporting in Warehouse Manager
  • Strict FIFO
  • Entering Basic Item Details

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