Skip to main content

Reading the InventoryIQ product list and product page

Read every column, icon and tab on the InventoryIQ Products page so you can see each product's on-hand units, landed cost and stock value by warehouse.

Written by Emily Burrows

About

Applies to: InventoryIQ

The InventoryIQ product list shows, for every product you sell or stock, how many units you have on hand, what they cost on average and what your on-hand stock is worth on a date you choose. Each product page then breaks those numbers down by warehouse, by purchase order (PO) and by sale.

InventoryIQ is Finaloop's inventory management product: it tracks every unit you buy and sell, and its full cost, first in, first out (FIFO), so each sale uses the cost of the oldest units in that warehouse. A unit's full cost, its landed cost, is the product price plus freight, duties, fees and the other costs of getting it into stock.

Use this reference to read each column, icon and tab. To set up InventoryIQ or learn how its pieces fit together, see InventoryIQ: Everything you need to know.


1. Where to find your products

Go to Inventory → Products. The page has two tabs: Product list, the list of all your products, and Assemblies, every assembly recorded across your products for a period.

Products come from your connected sales channels, such as Shopify and Amazon, and from products you add yourself. At the top of Product list you'll find:

  • As of date: the date every number in the list is calculated for. It defaults to today.

  • Search Product name or SKU and Filters, to narrow the list.

  • Export, to download the list as a file (Export file) or send it to Google Sheets.

  • Actions, with Bulk unit edit, Merge products, Hide from product list, Duplicate and Add product.

  • On-hand inventory cost: the total on-hand cost of all your products on the selected date.

When you've just made changes, or new data is syncing, a message under On-hand inventory cost says your numbers are being recalculated. They usually update within a few minutes.


2. Product list columns

Each row is one product. By default, the list is sorted by On-hand units, and you can sort by most columns by clicking the column name. There are 14 columns in all, and 3 of them only show when More details is on.

Column

What it shows

Product

The product name. Click it to open the product page.

SKU

The product's stock keeping unit (SKU).

Source

Where the product comes from, such as a sales channel or a product you added.

Attributes

Icons for merged, active, recipe and component (and dropshipping, if you dropship).

Opening balance

Units in your opening balance. Shows with More details.

Purchased

Units purchased and received. Shows with More details.

Net units depleted

Units that left stock, minus units restocked. Shows with More details.

On-hand units

Units in stock on the selected date.

Average cost / unit

The average landed cost per unit of your on-hand units.

On-hand cost

The total landed cost of your on-hand units.

In-transit units

Units shipped that you haven't received yet.

In-transit total cost

The landed cost of those in-transit units.

In-process units

Units ordered on a PO that haven't shipped yet.

In-process total cost

The landed cost of those in-process units on their POs.

Here's how the unit columns fit together: Opening balance + Purchased - Net units depleted = On-hand units. Net units depleted counts units fulfilled, assembled into other products, transferred to another warehouse, marked as dead inventory or adjusted in a physical count, minus units restocked.

In-transit and in-process units aren't part of your on-hand units. They join your on-hand units, and your list, once the shipment is received.

On-hand cost adds up the actual landed cost of each unit you have on hand, layer by layer, so it can differ slightly from On-hand units × Average cost / unit because of rounding. Units with missing costs count as $0 in both cost columns.

More details and Expand warehouses

Two controls above the list change what you see:

  • More details: turn it on to add the Opening balance, Purchased and Net units depleted columns.

  • Expand warehouses: shows every product's numbers split by warehouse. Click Collapse warehouses to go back. To expand a single product, click the arrow next to its name.

Products list with More details on, the Attributes icons and a product expanded to show its warehouses, outlined.

① More details, ② Attributes, ③ the warehouse breakdown.


The Attributes icons

Each product has four icons in Attributes, plus a fifth if you dropship. An icon shows in color when it applies to the product and grayed out when it doesn't. Hover over an icon to see what it means:

  • Merged: this product is merged with one or more other products. See Merging multiple products.

  • Active: the product has at least one unit in transit, purchased or depleted, or has an opening balance.

  • Has recipe: the product has a recipe or has been assembled.

  • Component: the product is a component in another product's recipe or assembly, such as an item in a bundle.

  • Dropshipping: the product has sales fulfilled through dropshipping. See Managing Dropshipping (InventoryIQ).


3. Filters and alerts on the product list

Click Filters to narrow the list by:

  • Source: the sales channel or other source.

  • Warehouse: one or more warehouses.

  • Attributes: Merged or Not merged, Recipe or No recipe, Active or Inactive, Component or Not component, and Dropshipping or Not dropshipping if you dropship.

  • View hidden from product list: Visible or Not visible, to find products you hid with Hide from product list.

  • Fractions: Fractions enabled or Fractions disabled, for products you track in part units, such as raw materials.

  • Product tags: the tags you added to products.

Click Reset all filters to clear them.

Units with missing costs

When at least one product has units that left stock while Finaloop had no stock recorded for them, a Units with missing costs alert shows at the top of the list. Those units have no cost, so they didn't add to your cost of goods sold (COGS), what the products you sold cost you. This usually means an opening balance, a transfer or a PO is missing, or a quantity or date on one is off.

Turn on Show products with missing cost units in the alert to see only those products, with a Units with missing costs column. To find and fix the cause, see Why do I have units with missing costs in InventoryIQ?.


4. The product page

Click a product in the list to open its page. At the top, Product details opens to show the product's Merged products, its tags, notes and attachments, and Manage vendor costs and Customer prices. The menu at the top right lets you edit, hide, duplicate or merge the product, or turn fractions on or off.

Below it are five tabs: Stock, FIFO, COGS, Recipes and Assemblies.

InventoryIQ product page with the Product details panel and the Stock, FIFO, COGS, Recipes and Assemblies tabs outlined.

① Product details, ② the product tabs, ③ As of date.

Stock tab

Stock shows the product in each warehouse on the As of date you pick: In-transit units, On-hand units, Avg. cost/unit and On-hand cost. If a warehouse is linked to a connected Shopify store, Sync to Shopify on its row updates the quantity in Shopify to match the on-hand units in Finaloop. It works when As of date is today and the on-hand units are a whole number.


FIFO tab

FIFO shows your FIFO layers in each warehouse: one row per PO, opening balance, assembly or transfer that brought units in, listed in the order they were received. When the product sells, Finaloop uses the cost of the oldest layer first, then moves to the next one once that layer is used up.

Click the arrow next to a warehouse to see its layers. Each layer shows the PO, Vendors, Received on date, units Purchased, Net units depleted, On-hand units, Landed cost/unit and On-hand cost. A warehouse with units with missing costs shows how many next to its name.

Turn on Show breakdowns to replace Net units depleted with what used each layer: Fulfilled, Assembled (out), Stock transfers (out), Dead inventory, Inventory lost, Other adjustments, Physical Count Adjustment and Restocked. Click Export to download the layers.

To see how each layer's landed cost is built from your POs, shipments and transfers, see How InventoryIQ calculates your full cost per unit.


COGS tab

COGS shows the cost of the units that left stock in each period, by sales channel, plus dead inventory, product giveaways, product donations and inventory lost. These are the amounts behind COGS on your Profit & Loss for each sales channel. Pick a single Warehouse to add or edit quantities with Add to COGS. For the steps, see InventoryIQ: Everything you need to know.


Recipes tab

Recipes lists the product's recipes under Product recipes: the components and quantities used to make 1 unit of it, with the period and warehouse each recipe applies to. If the product is used to make other products, they're listed under Component of other product recipes/assemblies. To create or edit a recipe, see Managing recipes & assemblies.


Assemblies tab

Assemblies lists the times this product was assembled from its components, on two tabs: On-demand, assemblies Finaloop records from a recipe when an order is fulfilled, and Manual, assemblies you record with Manual assembly. To learn how assemblies affect your landed cost, see Managing recipes & assemblies.


FAQs

Why doesn't my on-hand count include units on the way?

Units count as on hand only once their shipment is received. Until then, they show in In-transit units or In-process units, and on your Balance Sheet as inventory in transit or in process.


Why did a product's numbers change for a past date?

Because InventoryIQ recalculates from your records. When you add or edit a PO, shipment, transfer, opening balance or physical count, Finaloop recalculates every affected date, so past on-hand units and costs update too. To lock a counted value in place, record a physical count, see Updating inventory based on physical counts.


Why is my product missing from the list?

It may be hidden or filtered out. Click Filters, select Not visible under View hidden from product list and check that no Source, Warehouse or Attributes filter is excluding it.


Related articles


Need help?

If a product's on-hand units or costs don't match what you expect, reach out to our Support team through chat or at [email protected], and include the product SKU, the warehouse and the As of date you're looking at.

Did this answer your question?