-
Order Management
- Dashboard
-
Orders
- FBA Workflow Box Contents & Secondary "Ship From" Address
- Shipping Orders
- Resolving an Order in Missing Product Information Status
- Fulfilling an order using MCF (Multi-Channel Fulfillment) for a Core Product in a Bundle
- Changing an Order to Amazon Multi-Channel Fulfillment (MCF)
- Downloading and Printing Pick Lists
- Ship Multiple-Package Orders
- Downloading and Printing Packing Slips
- Resolving Missing Product Info Orders
- Resolving Out of Stock Orders
- Missing Stock Location and Configuring Inventory
- Creating a Manual Order
- Resolving an order that is "Missing Fulfillment Source"
- Changing Fulfillment Method and Source
- FBA Order Management
- Export an Order to a 3PL
- Searching and Filtering Orders
- Validating Shipping Addresses
- Reprinting Shipping Labels
- Multi-Channel Fulfillment
- Resolving an Awaiting Payment Order
- Can I create an RMA for an FBA order?
- Restoring a Cancelled Order
- Exporting Orders
- Merging Orders in Order Manager
- Splitting Orders in Order Manager
- Importing Tracking Information for Shipped Orders via a Spreadsheet
- Unresolved: Missing Order Info
- Unresolved: Missing Fulfillment Source
- How to add an item to an existing order
- Updating Orders in Bulk
- Customizing the organization of Columns in the Orders Module
- What does the error "Weight cannot be less than the total customs item weight" mean?
- Shipping an Order with Multiple Packages
- Extensiv Order Manager Workflow for Sending Dropship Orders via Email
- Manually Mark an Order as Shipped - Individually or in Bulk
- Customs
- Importing Orders Via Spreadsheet (In Bulk)
- Restore an On-Hold Order
- Canceling an Order
- Creating and Receiving an RMA
- Importing External Shipments
- Creating a Manual Order - Individually or In Bulk
- FBA Workflow
- Stock Transfers
- Box Contents Defaults for FBA Workflows
- Duplicate or Clone an Order
- Custom Fields for Orders (Custom Columns)
- Bulk Actions for Orders
- UPS Electronic Customs Documents - ETD & Commercial Invoices
- Shipping Orders - Processing Options
- DHL eCommerce Integration Specifics
- Amazon FBA: Common Errors and Troubleshooting
- Orderbot: Split Order by Available Stock
- Update about Accessing Orders
- Pre-order/Back Order Workflow
-
Inventory
- Uploading Inventory Through the UI
- How to Search for SKUs in the Inventory Module
- Manually Transferring Stock to Another Location
- Adding Inventory to a Stock Location Manually
- Creating Auto-Reorder Rules
- How to Filter Inventory by Warehouse
- Excluding a Warehouse from Showing Stock for all Products in Bulk
- Excluding Warehouse's Stock at the SKU Level
- Importing Stock Minimums
- Uploading Auto-Reorder Rules in Bulk
- Inventory Module Overview
- Incoming Units per Master SKU
- Inventory Update Triggers
- Inventory Value Reconciliation
- Channel Allocation Rules in Bulk (Global)
- Importing Inventory
- Channel Allocation Rules
- Uploading Inventory via Spreadsheet
- Inventory Rules per Master SKU
- Inventory Rules - Edit History
- Importing Reorder Rules
- Exporting Inventory
- Exporting Stock Details
- Inventory - How Extensiv Order Manager Presents Bundle Inventory
- Inventory - Transfers Tab
- Stock Edit History Export
- Stock Location - Inventory Management Functionality
- Bulk Inventory Reconciliation
- Strict FIFO
- Viewing Stock Edit History
-
Purchase Orders
- How to Create a Manual PO
- Auto POs + Reorder Rules
- Searching for POs
- How can I delete a line item from a purchase order?
- Updating PO Number Prefix
- How to Automate Purchase Orders (Auto-POs)
- Paste from CSV - PO Import
- Understanding Purchase Order (PO) Statuses
- Authorizing a P.O.
- Canceling a P.O.
- Printing a P.O.
- Receiving a P.O.
- Re-Sending a PO
- Voiding a P.O.
- Working with PO Milestones
- Restoring a PO
- Available Actions for a PO
- Exporting POs
-
Shipments
- Printing End of Day Forms
- How do I print an End of Day form or Package Level Detail report for UPS shipments?
- Searching for Shipments
- Printing Shipping Labels
- Tracking Shipments
- Voiding Shipments
- Exporting Shipments
- Postal Zones
- Shipments - Resending Confirmation Emails
- RMA Exports
- Parcel API Launch for Extensiv Brands
- Customers
-
Products
- Adjusting Master SKUs
- How to Disable Inventory Updates for a Specific Sales Channel
- How to Enable Extensiv Order Manager to Automatically Calculate Order Weight Based on Product Weight
- How to Reassign a Listing SKU to Another Product
- Search For Products
- How to Manage Products
- How to Import Your Vendor Products
- Associating a Listing SKU to a Master SKU
- How does Extensiv Order Manager handle variations of the same product?
- Creating Core Products in the App
- Creating Vendor Products in the App
- Creating Product Variations Through the UI
- Creating Listing SKUs through the UI
- Creating Bundles/Kits Through the UI
- Custom Bundle/Kit Export
- Custom Product Fields
- Creating Products via Spreadsheet
- Creating Vendor Products in Bulk (Via Spreadsheet)
- Creating Products through the UI
- Creating Listing SKUs in Bulk (via Spreadsheet)
- Product Creation FAQ
- Exporting Products
- Instructional Video - Master Product Spreadsheet
- Managing Digital SKUs
- Analytics
-
Settings
-
General
- Configuring Shipping Presets
- Update My Profile
- Disable the Inventory Update From Extensiv Order Manager to All Sales Channels
- How to Enable Out of Stock Control for eBay Sales Channels
- Company Info and Additional Account Settings
- Installing an App from the Order Manager App Store
- How to View Your Extensiv Order Manager Invoices
- How To Remove an App in Order Manager
- Ruby Has 3PL Integration
- Company Time Zone Setting
- Tax Identifiers
-
Sales Channels
- Deactivating a Sales Channel
- Editing Sales Channels
- Enable or Disable Extensiv Order Manager Email Notifications to Your Customers
- Shopify Tags
- Shopify Locations
- Amazon Cancellation Settings
- Steps in Adding Walmart as a Sales Channel
- Adding Newegg as a Sales Channel
- Adding eBay as a Sales Channel
- Viewing a Sales Edit Channel's History
- Reactivating Sales Channels
- Adding Amazon as a Sales Channel
- Adding Shopify as a Sales Channel
- Adding a Manual Sales Channel
- Adding Sales Channels
- Assigning a Packing Slip and/or Email Template to your Sales Channel
- How to Exclude a Warehouse From Pushing Inventory to a Sales Channel
- Setting Up Shipment & Carrier Mappings for Your Sales Channels
- Amazon Pacific Time Orderbot Setting
- Walmart Fulfillment Services - WFS
- WFS Workflow
-
Webhooks
- Order Creation Webhook
- Shopify Cancellation Webhook
- Shopify Refund Webhook - POS Orders
- Shopify Fulfillment Webhook
- Shopify Refund Webhook (e-commerce Orders)
- Shopify Product Deletion Webhook
- BigCommerce Webhook
- Shopify Product Update / Product Edit Webhook
- Shopify Auto-Subscribing Webhooks
- Order Payment Webhook
-
Shipping Providers
- Adding FedEx as a Shipping Provider
- How to Add Express 1 as a Shipping Provider
- Adding Amazon Buy Shipping as a Shipping Provider
- UPS Mail Innovations Services
- Adding DHL eCommerce as a Shipping Provider
- FedEx ETD
- Deactivate or Reactivate a Shipping Provider
- Adding Shipping Providers
- Customizing Shipping Services and Package Types Per Shipping Provider
- Vendors
-
Warehouses & Vendors
- Creating and Configuring Warehouses in Extensiv Order Manager
- Can I have additional order information populated on my Shipping label?
- Configuring Shipping Label Print Format Options
- Inventory Dependent Warehouses
- How to Configure the Order Export File for FTP Connections
- Deactivating a Warehouse in Extensiv Order Management
- Updating the Address/Return Address for Your Warehouse
- Search for Vendors
- Configuring a Dropship Vendor
- Creating an In-House Warehouse
- How do I connect Extensiv Order Manager with Deliver?
- Configuring Dropship Vendor FTP
- FTP Inventory Import for a 3PL
- Setting Up Domestic Backup Warehouses
- Setting Up a Warehouse's International Rank
- Pick List Settings
- Setting Up a 3PL Warehouse
- Setting Up Document Print Settings
- Setting a Dropship Template and Fulfilling Orders with a P.O.
- Use Component Inventory Setting for Bundles and Kits
- Instructional Video - Creating Warehouses & Warehouse Settings
-
Orderbots
- Orderbots - Complete List of Filters & Actions
- Postal Zones in Extensiv Order Manager
- Automating Orders to Fulfill from a Specific Warehouse
- Editing an Orderbot
- Deactivating an Orderbot in Extensiv Order Manager
- Mark Order as Shipped Orderbot
- Replace Address Orderbot
- Creating an Orderbot
- Support for Shopify's Additional Details
- Orderbots filtered by zip code range
- Adding Order Item to Order Orderbot Action
- Commonly Used Orderbots
- Understanding Apply Best Rate vs Cheapest Rate Orderbots
- Orderbot: Set order weight and dimensions based on products
- Orderbot: Using Hold the order for and Mark Order as Shipped
- Templates
-
General
- API
- API Integrations
- Accessing and Navigating Order Manager
- Error Messages
-
Order Manager
- Formatting Order Information When Shipping to US Territories
- Endicia's pay-on-use return labels?
- Integrating Endicia
- What are Orderbots?
- How To Set Up Shipments Import
- Setting Up Billing/Inventory Allocation Zones
- Reactivating an Orderbot
- [FAQ] What other Amazon marketplaces do you integrate with?
- Enable Shopify POS
- Adding BigCommerce as a Sales Channel
- Does Order Manager Support Amazon Buy Shipping?
- Error: "The Shippers shipper number cannot be used for the shipment"
- Shopify POS Location Capture and Orderbot
- Edit Shopify Order Items
- Order Export Configuration in the UI- Complete List of Order Export Fields
- Error Message “Invalid Customs Item Data”
- FBA to FBM Conversions - Amazon North America Remote Fulfillment with FBA Sellers
- Where does Extensiv Order Manager determine Inventory Value and COGS from?
- BigCommerce Order Statuses
- Brexit for UK Inventory & Shipments
- Customer Experience Upgrades
- Addressing missing Snapshot Data on July 9, 2023
-
Popular Articles
- Accounting Integrations
Where does Extensiv Order Manager determine Inventory Value and COGS from?
The term "Inventory Value" refers to the dollar amount that each unit of a Master SKU is worth. Inventory Value is recorded as the Cost of Goods Sold (COGS) once the order has been shipped.
Inventory Value for each unit comes from one of two places:
- Actual IV Entries - These entries exist in the IV FIFO Queue. These are entries Order Manager has officially created from one of the following methods: Receiving units via Purchase Order or using the Reconciliation feature. You can find the history of these actual entries by clicking the Inventory Value History button under Stock Details on a warehouse basis.
- Default IV - The assigned value Order Manager gives to your units that have no Actual IV Entry (aka when there is a "Discrepancy"). Default IV is used for Analytics purposes and for the COGS amount recorded upon shipment.
- First In, First Out (FIFO) Landed Cost value for units received via a Purchase Order which creates Actual IV Entries.
NOTE
The Landed Cost used for Inventory Value will incorporate any Aggregate Costs for the PO divided amongst the Total Units Ordered. Aggregate Costs do not include the automatically shown "Item Cost" amount, only any additional costs added. So in the example below, the total "PO Aggregate Costs" would be $75. The Purchase Order amount is $1,075.00.
NOTE
Aggregate Costs for a PO (found in the Details tab of a PO) are automatically factored into the final Inventory Value for stock when it is received via PO. The Aggregate Costs for a purchase order do NOT include Discounts. If you want the Inventory Value FIFO Queue to reflect any applicable discount, then that discount needs to be manually included in the final cost for each line item. That means you will need to physically edit the Landed Cost field for every line item that has a discount on a PO from its current value to one that incorporates the price of the line item with the Discount applied. If you do not physically edit the Landed Cost value for a line item, then it will simply be calculated using the default calculation.
Example: You received 10 units of a SKU via PO at an IV for $1 each even though the Default Vendor Product Cost is $2. You manually added 100 units of the same SKU directly via the Inventory Module and you didn't Reconcile them. You now have 10 units with an Actual IV entry of $1, and 100 units with a Default IV of $1 each, bringing your Total IV for that SKU to $110. As long as any of the 10 units received via PO are unshipped and you have un-reconciled units, your 100 units will be valued at $1. But as soon as the last of your 10 units received via PO are shipped, Default IV will start pulling from the Default Vendor Product Cost (covered below), so your 100 un-reconciled units would then be valued at $2 each, with a Total IV of $200.
- The Default Vendor Product's "Cost" can be found in the Vendor Product. Order Manager will use the top line quantity to calculate Inventory Value.
- If there is no cost associated with the Vendor Product, Order Manager looks for Vendor Cost in the product.
- If Order Manager cannot find any of the above for the product, IV and COGS will be shown as $0.
For instructions on how you can edit your IV queue, see this article on the Inventory Reconciliation feature.