Order Management

Updated on January 17th, 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
  • Accounting
  • 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

Analytics - COGS by SKU

What does this report reveal:

This Extensiv Order Manager report reveals your COGS and the number of units sold per Master SKU over a specified period of time.

How to read this report:

To read this report, filter by SKU, Brand and/or date range you wish to find your product costs per SKU. Each unit sold contributes to your COGS, so a high cost with low units sold should be investigated to allow price increases for certain products and influence a better margin.

NOTE

Bundle products that are sold as bundles but are broken down and shipped as core components will still display in this report under the bundle SKU.

 

What actions to take after analyzing this report:

After your analysis, you can take your COGS data and compare it to your sales summary totals to understand how much of a chunk your costs has taken out of your revenue. This should help you decide if you are comfortable with your true profits or if your costs are too high for any sort of profit. Thus, you should decide to either liquidate or reprice specific products.

Important Note

The Date Range on this report searches by the Order Date. However, in Extensiv Order Manager COGS are calculated/recorded at the time that the order status moves into Shipped. This means that if there was an order placed in January but it wasn't shipped until March, Extensiv Order Manager won't "record" COGS data until March. You would still see the order when the date range was set to the month of January. So the data is calculated when the order status moves to Shipped, but the search results show orders by their order date.

 

How to export this report:

This report is exportable in Microsoft Excel format. For instructions, see Exporting Reports.

sku analysis cost analysis

Was this article helpful?

Yes
No
Share additional feedback about this article

Related Articles

  • Updating the Address/Return Address for Your Warehouse
  • Adding BigCommerce as a Sales Channel

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