Metrics are important and allow you to understand your store and how it performs better.
 

7 Days Sales

Number of units sold the previous seven days

30 Days Revenue

Shows revenue for the most recent 30 days regardless of the date range of the report. For example, if using Inventory KPIs report for April 1 - 7, the 30 Days Revenue will still show revenue for the last 30 days. The Revenue column will show revenue for the date range of the report.

30 Days Sales

Shows how many units of a product has sold in the last 30 days. This will include stockouts (out of stock days) if applicable.

30 Days Stockouts

The number of days in the last 30 days when a product has been out of stock.

ABC Class or “A” Class, “B” Class, “C” Class

Classes are categories of your inventory. By default, “A” Class includes SKUs comprising the top 80% of revenue, “B” Class is the next 15%, and “C” Class is the final 5%. You can change these percentages in Account > Settings > Forecasting. Classes are determined based on the last 30 days of sales.

ACP (Average Cost Price)

COGS / number of units sold

Actual Sales

Shown on the Edit Forecast page, Actual Sales indicates the units sold less returns.

Age

Length of time a product has been listed for sale

ASP (Average Sale Price)

revenue / number of units sold

Available Stock is inventory on hand at that location in excess of what will be needed during the days of stock (planning period). This metric is based on the lowest amount of stock needed (based on the forecast) during the days of stock. Any inventory available over that amount is identified as available stock. (Note that Overstock is excess inventory after the days of stock. Available stock is excess inventory during the days of stock.)

AVG Cover (in months)

number of units in stock / average monthly sales

AVG PO Cover (in months)

number of units in non-closed purchase orders / average monthly sales

AVG Retail Price

Revenue / units sold for the selected period of time

AVG ROS (Average Return on Sales)

profit / number of units sold

AVG Sales / Day

Sales / time period in days. There are no adjustments for out of stock days.

AVG Sales / Mo

Average sales/month is sales for all days average for the month. There are no adjustments for out of stock days.

AVG Stock Units (Average stock units)

Units in stock during the selected time period / number of days in the selected time period

Barcode

The UPC of a product

Brand

Brand is the name the product is sold under on your site. For example, Nike.

Bundles

Kits, bundles, or groups of variants can be designated as bundles. Read more about how to set up bundles and how they will show in Replenishment.

Category

A label for a group of similar products. For example, skis might be in a winter sports category.

CBM

Cubic Meters per unit. When this is set, Inventory Planner will show CBM in purchase orders so that you can estimate how many cubic meters the container will be.

Closing Stock

The amount of stock on hand for the end of a time period. It's based on the historical inventory snapshots taken by Inventory Planner.

Closing Stock Cost 

Cost value of stock at the end of the selected period. Cost price is the product price in the supplier catalog. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Closing Stock Gross

Gross value of stock at the end of the selected period. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Closing Stock Retail

Retail value of stock at the end of the selected period

Cost of Goods Sold (COGS, Sale cost)

number of units sold * cost price

COGS Diff % (Percentage change in COGS)

Change in cost of goods / Cost of goods for the current period 

Conversion Rate

Number of units purchased / number of page views

This information pulls from Google Analytics.

Cost price

Product price in the supplier catalog

Created at

When the product was imported or created in Inventory Planner

Current Stock

Inventory level available as of the last sync between Inventory Planner and your connected platform(s).

Days of Stock

The number of days that inventory should cover. This is important to determining an accurate inventory. 

It is also used to report on overstocked inventory. Products with stock in excess of forecasted days of stock will show as overstocked.

Discounts

gross revenue - revenue
The discounted price is taken from actual sales orders by comparing the listed price to the price in the sale order. 

Discounts %

Discount percentage of gross revenue

Expected Date

The calendar date that items on a purchase order or transfer are anticipated to arrived. Providing an expected date that is as close to accurate as possible will improve the accuracy of your replenishment forecast. 

If there are multiple purchase orders, transfers, or both that are open, the earliest expected date will be reflected in the Expected Date column of reporting.

First 8 Weeks Revenue

Revenue made during the first eight weeks after the first sale date. If the first sale date is not available, then the product creation date is used. 

First 8 Weeks Sales

The number of sales occurring during the first eight weeks after the first sale date. If the first sale date is not available, then the product creation date is used. 

First Received At

Date that a product was first in stock

First Received Qty (Quantity)

Number of units received into inventory from the initial vendor purchase

First Sold At 

Shows the first sales for a product

Forecast

Projected sales in units for the "days of stock" period

Forecasted Stock

Forecasted stock is based on the forecasted demand for each product and the current stock on hand. Forecasted stock for the lead time and days of stock are available in Replenishment > Details. Read more about how different forecasts are calculated in Inventory Planner.

Forecast Lost Profit

Stockouts during the lead time * (price - cost price)

Forecast Lost Revenue

Stockouts during the lead time * price

Forecast Profit

Projected profit for the "days of stock" period

Forecast Revenue

Projected revenue for the "days of stock" period

Gross Revenue

number of units sold * sales order price before discounts 

Gross Revenue does not subtract returns and is same as Gross Sales metric in Shopify.

Gross Sales

Number of units sold during the time period. Returns are not included into this number.

Holiday excluded sales

Inventory Planner excludes holiday sales such as Black Friday, Cyber Monday and the week before Christmas so that unusually high sales do not skew forecasting calculations. 

ID

A unique number assigned to each SKU by your eCommerce platform or inventory management system.

Image

Photo of the product or variant. 

Labels

Noteworthy descriptions for products and SKUs including New Product, Overstocked, and Discounted

Landing Cost Price

Landing cost price is the total unit cost for you. In addition to vendor cost it includes things like shipping, handling and other costs.

Last Received At

Most recent date a product was received and added to inventory

Last Received Qty (Quantity)

Number of units received into inventory from the most recent vendor purchase

Last Sold At

Shows the most recent sales for a product

Lead Time

The amount of time it takes to order a product from the vendor and receive it into inventory. This is an important factor for your forecast.

Lead Time Forecast

The number of units that Inventory Planner estimates will be needed during the specified lead time. A lead time forecast of "24/14 days" shows that 24 units will be needed during a 14 day lead time. The forecast is calculated based on sales velocity. Read more about how different forecasts are calculated in Inventory Planner.

Lifetime Revenue

Number of units sold * price for the lifetime of the product

Lifetime Sales

Number of units sold during the lifetime of the product

Low Stock Alert

Based on the forecasted demand, items in stock and on order, a low stock alert will alert when a variant needs to be reordered. A low stock alert will be sent on the Replenish Date.

Margin

profit / revenue

Markdown

(Regular (compare at) Price - Sales order price before discounts) * quantity

Markup

profit / COGS

Merged Variants

When a product has an updated style or slightly changes sizes, it may be helpful to merge variants so that the new product has sales history needed to create a forecast. Learn how to merge variants.

Modified at

The last time product information was updated in Inventory Planner

MOQ (Minimum Order Quantity)

The lowest amount that you are allowed to order from a vendor. When an MOQ is set and it is not met in a purchase order, you will see a warning at the bottom of the purchase order. See more here about how to set up MOQ.

Name

The product or variant title

Notes

Information you enter about a product. For example, if an item will be available at a discounted rate later in the year, you could enter a note to indicate that information.

On Order

number of units in non-closed purchase orders

On Order % (On Order Percentage)

Units in a non-closed purchase order as a percentage of all units on order.

On Order Cost

the cost value of "on order" units

On Order Cost %

The cost value in a non-closed purchase order as a percentage of the total cost value on order. Cost price is the product price in the supplier catalog.

On Order Retail

the retail value of "on order" units

On Order Retail %

The retail value in a non-closed purchase order as a percentage of the total retail value on order.

Opening Stock

The amount of inventory on hand at the start of the selected time period. Opening stock is computed as current stock + sales for the selected period. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Opening Stock Cost

Cost value of opening stock. Opening stock is computed as current stock + sales for the selected period. This metric does not take into account stockouts. Cost price is the product price in the supplier catalog. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Opening Stock Gross

Gross value of opening stock. Opening stock is computed as current stock + sales for the selected period. This metric does not take into account stockouts. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Opening Stock Retail

Retail value of opening stock. Opening stock is computed as current stock + sales for the selected period. This metric does not take into account stockouts. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Options

Sizes, colors and other variant options that apply to that SKU or product.

Overstocked Retail

The retail value of stock on hand that exceeds the “Days of Stock” period.

Overstocked Units

The number of units that exceed the “Days of Stock” period.

Overstocked Variants

The number of variants (SKUs) that have more units in stock than is needed to cover the “Days of Stock” period.

Page Views

The number of times that product page has been viewed. This information pulls from Google Analytics.

Period

Time span or dates included in data showing

Planned Discount

Regular Price - Price

Planned Margin

(price - cost price) / price

Planned Markup

Computed based on current retail price vs. regular retail price
This is called the compare at price in Shopify.

Planning Period Forecast

The number of units that Inventory Planner estimates will be needed during the specified days of stock. A planning period forecast of "49/30 days" shows that 49 units will be needed during 30 days of stock. The forecast is calculated based on sales velocity. Read more about how different forecasts are calculated in Inventory Planner.

Platform Fee

The cost of your Amazon platform fees. Platform fees include referral fees, variable closing fee, per item fee, and FBA fees. 

Platform fees are not currently available for other platform connections.

PO cover in days

The number of days ordered (but non-received) inventory will last given recent sales trends.

PO cover in months

The number of months ordered (but non-received) inventory will last given recent sales trends.

Price

current product retail price

Product Name

The title given to the product in your store

Profit

Revenue - COGS
This is forward-looking to show the listed price and current product cost. For Amazon sellers, product profit is the competitive price - cost - platform fee. 

Profit/Unit

Computed based on past sales to show actual (revenue-costs)/unit. 

Profit %

Profit for one SKU / Profit for all SKUs
Profit is Revenue - COGS

Profit Diff % (Percentage Change in Profit)

The change in the profit from the previous time period

Regular price 

Product retail price before discount

Replenish Date

The date to replenish a product so that it covers the “lead time” and “days of stock” period.

Replenishment

Number of units to purchase to cover the "days of stock" period

Replenishment CBM

Volume (CBM) of an individual item * replenishment amount.

CBM is Cubic Meters per unit. When this is set, Inventory Planner will show cumulative CBM in purchase orders so that you can estimate how many cubic meters the container will be.

Replenishment Cost

The purchase cost to cover the "days of stock" period. Cost price is the product price in the supplier catalog.

Replenishment Retail

The retail value of products to cover the "days of stock" period

Return Units

Number of product units included on returns (items sent back to the merchant).

Returns Revenue

The revenue amount (units * sales order price) sent back to customers following returns to the merchant.

Revenue

gross revenue - discounts - returns

Returns use the sales order return date, not original order date. This is the same as Net Sales metric in Shopify

Revenue Diff %

The change in the revenue from the previous time period

Safety Stock

The minimum stock level for a product.

Sales

Number of units sold for the selected period less returns. Returns are included into this number.

Sales %

Number of units sold for one SKU / Number of units sold for all SKUs

Sales Diff % 

The change in the number of units sold from the previous time period

Sales Velocity

Sales / number of days product was in stock for the selected period.

Sales Velocity / Day

Sales / days with stock in the time period.
Out of stock days are excluded from the calculation.

Sales Velocity / Mo

Sales velocity/month is sales when the product is in stock averaged for the month. Out of stock days are excluded from the calculation.

Sell Through

Sales for the selected period / opening stock. Opening stock is computed as current stock + sales for the selected period. This metric does not take into account stockouts.

Sells Out In

The number of days until a product will be out of stock. 

'Sells out in' starts with your forecast, then takes into consideration your current stock and any items on order to calculate when you'll run out.

'Sells out in first' shows if stock run out before a PO arrives (based on expected date).

To see when current stock will run out, use 'stock cover in days'.  

Sells Out In First

If there are products on a purchase order "Sells Out In First" will indicate if there is a predicted stock out before products arrive. "Sells Out In" will show when products run out after the PO is delivered.
This is the same as 'Sells Out In' for products that are not on order (on an open purchase order).

Shipping

Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price.

SKU

The Stock Keeping Unit refers to a unique code you assign to your variant or product. 

Stock

Number of units of inventory

Stock % (Stock Percentage)

Number of units available of one SKU / Number of all units available

Stock Begin (Opening Stock)

number of units in the beginning of selected period

Stock Cost

Cost * stock

The product price (cost price) in the supplier catalog of inventory on hand. 

Stock Cost %

Stock Cost of one SKU / Stock Cost of all SKUs

Stock cost is the product price in the supplier catalog for all inventory on hand.

Stock cover in days

The number of days the available inventory will last given recent sales trends.

Stock cover in months

The number of months the available inventory will last given recent sales trends.

Stock End (Closing Stock)

number of units at the end of selected period

Stock Gross

Regular price * stock
Regular price is  the product retail price before discount.

Stock Retail

Price * stock
This will be the retail price of all units in inventory.

Stock Retail %

Stock Retail of one SKU / Stock Retail of all SKUs

Stockouts

Days when a product is out of stock.

Stockouts % (Percentage of Stockouts)

Out of stock days / Days in the selected period

Stockturn

sales / average stock for the selected period. Average stock is based on the historical inventory snapshots taken by Inventory Planner.

Tags

Tags are imported from your store or inventory management system. They are used to help describe and filter products, orders and other information within your store. 

Tax

Tax amount paid by customers on orders. This will not include taxes already built into the listed price.

Total Available Stock 

The sum of Available Stock from all compared locations. Available Stock is inventory on hand at that location in excess of what will be needed during the days of stock (planning period). This metric is based on the lowest amount of stock needed (based on the forecast) during the days of stock. Any inventory available over that amount is identified as available stock. 

Total Revenue

gross revenue - discounts - returns + taxes + shipping charges

Total revenue will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was returned.

Tracked Inventory (filter)

Tracked inventory means you are monitoring the stock level for that item. Untracked inventory could be drop-shipped or made to order items where you do not need to worry about low or out of stock levels. 

Transfer In

When creating a transfer (not a PO) from one warehouse to another "Transfer In" represents the incoming stock to a warehouse.
This is the same as "On Order" but in case of transfer "On Order" is not used. 

Transfer Out

When creating a transfer (not a PO) from one warehouse to another "Transfer Out" represents the outgoing stock to a warehouse. 

UOM (Units of Measurement)

The Units of Measurement (UOM) requirement specifies the granularity of products and is used when products are purchased in boxes. See more here about how to set up UOM.

Variants

Types of a product such as the color or size.

Vendor

Vendor is the distributor with whom you place orders. For example, Running Shoe Distributors.

Note that in Shopify, the Vendor field on your product page will show as the Brand in Inventory Planner.

Vendor Reference

Use this field in your purchase order when the vendor uses a different SKU or code than you use in your store. 

Vendor Product Name

A product name given by your vendor. This can be noted on purchase orders and is particularly helpful when you and your vendor have different names for the same item.

Visible (filter)

Visible items are showing on your website. Some merchants will create the product page but not make the item live on their sites, so those would not be visible items.

Warnings

Warnings indicate no sales for a product or extended stockouts.

Yesterday Sales

Number of units sold the previous calendar day

Did this answer your question?