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

7 day sales

Number of units sold the previous seven days

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 day 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.

ACP (Average Cost Price)

COGS / number of units sold

Age

Length of time a product has been listed for sale

ASP (Average Sale Price)

revenue / number of units sold

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.

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

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

Discounts %

Discount percentage of gross revenue

Expected Date

The calendar date that items on a purchase order are anticipated to arrived. Providing an expected date that is as close to accurate as possible will improve the accuracy of your replenishment forecast.
For a variant or product, this is the last expected date of open purchase orders for this variant or product.

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 Lost Profit

Replenishment * (price - cost price)

Forecasted Lost Revenue

Replenishment * price

Forecasted Profit

Projected profit for the "days of stock" period

Forecasted Revenue

Projected revenue for the "days of stock" period

Gross Revenue

number of units sold * regular price

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.

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

Margin

profit / revenue

Markup

profit / COGS

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. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Opening Stock Cost

Cost value of opening stock. 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. The stock is based on the historical inventory snapshots taken by Inventory Planner.

Opening Stock Retail

Retail value of opening stock. 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.

Platform Fee

The cost of your eCommerce store or inventory management system

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

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 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

Revenue

number of units sold * price

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. Returns are not 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 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).

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

The product 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

Number of units * Stock Retail

Stock Retail

The product price for purchase by shoppers in your store. 

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. 

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?