Metrics are important and allow you to understand your store and how it performs better. This article explains all the metrics you may encounter.
#
7 Days Revenue
Shows revenue for the most recent seven days regardless of the date range of the report.
For example, if using the Inventory KPIs report for April 1 - 7, the 7 Days Revenue will still show revenue for the last seven days. The Revenue column will show revenue for the date range of the report.
7 Days Sales
The number of units that were sold the previous seven days.
14 Days Revenue
Shows revenue for the most recent 14 days regardless of the date range of the report.
For example, if using the Inventory KPIs report for April 1 - 7, the 14 Days Revenue will still show revenue for the last 14 days. The Revenue column will show revenue for the date range of the report.
14 Days Sales
The number of units that were sold the previous 14 days.
30 Days Revenue
Shows revenue for the most recent 30 days regardless of the date range of the report.
For example, if using the 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
The number of units that were sold in the last 30 days, 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.
Stockouts are the days when a product is out of stock. For example, if stockouts shows as '15', then that means the stock level for the variants was 0 or less for 15 days during the date range.
A
ABC Class or “A” Class, “B” Class, “C” Class
Classes are categories of your inventory. By default, the “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. By default, we calculate classes based on revenue within the last 30 days of sales, but the option to calculate it based on the number of units sold and lifetime sales is available.
ACP (Average Cost Price)
Average cost price = COGS / number of units sold
Actual Sales
Shown on the Edit Forecast page, Actual Sales indicates the number of units sold less returns.
Adjusted Sales Velocity
The adjusted sales velocity is based on forecast heuristics such as "excluding holiday sales". Note that it can be different to the sales velocity, calculated as sales divided by the number of days in stock.
Age
The length of time since the first order date for a product or variant. If it hasn't yet been sold, then the "created at" date will be used as the start date for calculating age.
Alerted (Filter)
The alerted filter (where Alerted = Yes) highlights variants that have either run out of stock or will run out of stock before they can be replenished (stockouts are forecast during the lead time). Alerted items will be indicated with either a red or yellow "Details" icon.
Annotated (Filter)
The annotated filter (where Annotated = Yes) displays variants that contain information in the Notes field. To view the Notes field, click on the gear icon in the upper right corner of Replenishment.
Approve
Found in the bulk actions menu, "Approve draft" is used to change a purchase order's status from "Draft" to "Open".
ASP (Average Sale Price)
Average sale price = Revenue / number of units sold
Assembly
An assembly must be produced from components (variants) before it can be placed into stock and made available for sale. These goods are pre-assembled before they are sold and fulfilled.
Assemblies include any produced goods with a bill of materials (BOM), and bundles/kits that must be produced before sending to Amazon (or a different fulfillment warehouse). All bundles associated with FBA are considered assemblies, since Amazon only carries finished goods/produced bundles.
Assembly (filter)
Add the "Assembly" filter to search for component variants connected to a specific bundle.
Assembly component (filter)
Add the "Assembly Component" filter to limit variants in display to component variants that are needed when assemblies are sold.
Assembly orders
Also considered “production orders,” these are orders to build new assemblies from existing (or incoming) component stock. Learn more about Assembly Orders.
Assembly cycle
An assembly cycle is a production cycle describing how often assemblies are produced (in days). For example, to break down assemblies replenishment into a weekly production schedule, you would input 7 days as the assembly cycle.
The assembly cycle is configured in the "Assemblies" view of Replenishment as the frequency of production runs in days.
Assembly time
The time it takes to produce new assemblies if/when component stock is available. Note that this is separate from the component (variant) lead time which describes how long it takes to order items from a supplier.
The assembly time is configured in the "Assemblies" view of Replenishment as the time it takes in days to produce new assemblies from existing component variant stock. It defines the "Expected Date" for new assembly orders.
Available on hand (filter)
The "Available On Hand" filter displays all items in stock (when Available On Hand = Yes). If Available On Hand filter = No, then only items with 0 or negative stock levels will show in the report.
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, while available stock is excess inventory during the days of stock.)
AVG cover (in months)
Average cover in months = Number of units in stock / average monthly sales (AVG sales per month)
... where stock is always the current stock and average monthly sales are always for the Replenishment period.
AVG lead time
Average lead time is calculated per variant by looking at the number of days between a purchase order's creation and received date, for every purchase order containing the item. The total is then averaged.
AVG PO Cover (in months)
Average purchase order cover in months = Number of units in non-closed purchase orders / average monthly sales
AVG Retail Price (Average Retail Price)
Average retail price = Revenue / units sold for the selected period of time
Where:
Revenue = gross revenue - discounts - returns
Gross revenue = number of units sold × sales order price before discounts and taxes
Discounts = gross revenue - revenue
Returns are the number of product units included on returns (items sent back to the merchant). Return information is pulled from your connect sales platform and cannot be edited with Inventory Planner.
AVG ROS (Average Return on Sales)
Average return on sales = profit / number of units sold
AVG Sales / Day
Average sales per day = Sales / time period in days
There are no adjustments for out of stock days.
AVG Sales / Mo
Average sales per month = Sales / time period in months
There are no adjustments for out of stock days.
AVG Stock Cost (Average stock cost)
Average stock cost = Sum of stock cost of inventory during the select time period / number of days in the selected period
Where:
Stock cost = units in stock × cost price of the item
Cost price is the variant's price in the supplier catalog. It is the price you pay to a vendor per item as noted on your purchase order.
Historical stock information is available as of the date that your Inventory Planner account was created.
AVG Stock Gross (Average stock gross)
Average stock gross = Sum of gross stock cost of inventory during the select time period / number of days in the selected period
Where:
Stock gross = regular price × stock
The regular price is the product retail price before discount, sometimes called the "compare to" price. This price is set in your sales platform and cannot be edited in Inventory Planner.
Stock is the number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Historical stock information is available as of the date that your Inventory Planner account was created.
AVG Stock Retail (Average stock retail)
Average stock retail = sum of gross stock retail of inventory during the select time period / number of days in the selected period
Where:
Stock retail = Price × stock
This will be the retail price of a unit of inventory.
Price is the current product retail price as set on your sales platform. This price is set in your sales platform and cannot be edited in Inventory Planner.
Historical stock information is available as of the date that your Inventory Planner account was created.
AVG Stock Units (Average stock units)
Average stock units = Units in stock during the selected time period / number of days in the selected time period
Historical stock information is available as of the date that your Inventory Planner account was created.
B
Barcode
The UPC of a product.
If your connected sales platform does not have a barcode field, you can import this information using a Single or Multiple Vendor Catalog.
Brand
The name a product is sold under on your connected site, e.g. Nike.
Note: For Shopify users, the "Vendor" field in Shopify maps to the "Brand" field in Inventory Planner.
Bundles
A group of variants sold together as a single unit, e.g. a first aid kit.
Note that bundles are different from Assemblies that need to be pre-manufactured or pre-assembled before they are placed into stock and made available for sale.
Read more about how to set up bundles and how they will show in Replenishment.
Bundle (filter)
Add the "Bundle" filter to search for component variants connected to a specific bundle.
Bundle component (filter)
Add the "Bundle component" filter to only display component variants which are sold as a part of bundles.
C
Category
A label for a group of similar products. For example, skis might be in a winter sports category.
Categories are created in your connected sales platform and are not editable within Inventory Planner.
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.
Replenishment CBM = CBM of an individual item × replenishment amount
Class (filter)
The "Class" filter refers to ABC Class or “A” Class, “B” Class, “C” Class.
Classes are categories of your inventory. By default, the “A” Class includes SKUs making up the top 80% of revenue, “B” Class is the next 15%, and the “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.
Closing Stock
The amount of stock on hand for the end of a time period. The closing stock is based on the historical inventory snapshots taken by Inventory Planner.
Closing stock cost
The cost value of stock at the end of the selected period.
Closing stock cost = Cost price × stock as of last sync
Where the cost price is the product price in the supplier catalog and the stock is based on the historical inventory snapshots taken by Inventory Planner. Note: This is always based on the historical cost prices. Contact support to update metrics based on the current cost price.
Closing stock gross
The gross value of stock at the end of the selected period.
Closing stock gross = Regular price × units in stock
Where regular price is the retail price before discounts and the stock is based on the historical inventory snapshots taken by Inventory Planner. Note: This is always based on the historical regular retail prices.
Closing stock retail
The retail value of stock at the end of the selected period.
Closing stock retail = Price × units in stock
Where the stock is based on the historical inventory snapshots taken by Inventory Planner. Note: This is always based on the historical retail prices.
Collection
A collection is a set of products presented together, also usually visible on the store's front end. A collection can contain products from different categories and a product can belong to several collections.
Collections are created in your connected sales platform and are not editable within Inventory Planner.
Cost of Goods Sold (COGS)
COGS = Number of units sold × landing cost price
If the "landing cost price" is not set, or is set to "0.00", the "Cost Price" field is used.
The landing cost price is the total unit cost for including cost price and related expenses. In addition to the vendor cost it includes shipping, handling, and discounts. Landing cost is the cost price in addition to extra expenses (not only the extra expenses).
Note: For EU merchants, VAT should be included as part of the Cost Price.
"Cost price" is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
COGS Diff % (Percentage change in cost of goods sold)
Percentage change in COGS = (Cost of goods during current time period - Cost of goods during previous time period) / Cost of goods during the previous time period
Combined Warehouse
A combined warehouse can be used to see total demand from more than one warehouse. A combined warehouse allows you to choose which warehouses to include to show total demand (sales information). You also specify which warehouses' stock to consider.
Competitive price
For Amazon sellers, the competitive price is pricing for active offer listings based on two pricing models: New Buy Box Price and Used Buy Box Price.
Components lead time
Component variant lead times are configured using the "Variants" view in Replenishment. They will be pulled into the "Assemblies" view automatically, and are considered in the replenishment analysis for new assemblies (above and beyond what can be assembled from existing component stock).
Conversion rate
Conversion rate = Number of units purchased / number of page views
This information pulls from Google Analytics and cannot be edited in Inventory Planner.
Cost compare
The "Cost Compare" metric shows the cost prices from each vendor associated with a variant.
When you have a variant that can be sourced from different vendors, there could be different cost prices associated with each. The "Cost Compare" feature shows each of these cost prices.
Cost price
Cost price is the variant price in the supplier catalog. It is the price you pay to a vendor per item as noted on your purchase order. If there's more than one vendor, the cost price displayed is an average of them.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (as updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
When you have a variant that can be sourced from multiple vendors, there could be different cost prices associated with each. The "Cost compare" feature can display each of these cost prices.
Learn more about how to compare costs when a variant is sourced from more than one vendor.
Created at
The date at which the product was imported or created in your sales platform.
Note the "created at" date will reflect when the product or variant was set up in your system, and is different from the "published at" date which indicates when a product most recently became visible to your customers.
Current stock
The inventory level available as of the last sync between Inventory Planner and your connected platform(s).
Custom Alert (filter)
Using the Custom Alert filter (where Custom Alert = Yes) will display variants that have alert settings which differ from your account settings.
Low stock alerts, email frequency, safety stock, and notify in advance alerts can be set in Account > Settings > Alerts.
Variants can be given different settings by selecting them and using Bulk Actions.
D
Days of Stock
The number of days that inventory should cover.
Days of Stock are important to determining reasonable replenishment recommendations, and are also used to report on overstocked inventory. Products with stock in excess of forecasted days of stock will show as overstocked.
"Days of Stock" closing stock
The estimated amount of inventory available for sale at the end of the Days of Stock period. The "Days of Stock" figure is the number of days that inventory should cover, starting after the lead time (i.e. the time it takes to order and receive inventory from your vendor).
The Days of Stock closing stock is calculated by taking the Lead Time closing stock and subtracting the estimated number of units sold during the Days of Stock (i.e. the Days of Stock period forecast).
For example, a Days of Stock closing stock of 110 on February 13 2021 indicates that the estimated stock level will be 110 units as of February 13 2021, where February 13 2021 is today's date, plus the lead time in days, plus the Days of Stock in days.
The Lead Time closing stock factors in the current stock level, items on order and transferring in/out of the selected warehouse, and units estimated to be sold during this time (indicated as the Lead Time forecast).
"Days of Stock" period forecast
The number of units that should sell during the "Days of Stock" period.
For example, a "Days of Stock" period forecast that reads 1010 for 30 days indicates that Inventory Planner calculates 1010 units should sell during the 30 day period (where Days of Stock is set to 30).
Details
By clicking on the "i" icon in the Details column, you can access more information about replenishment, forecasted stock levels, edit the forecast or historical sales information, view stock history, set up bundles, merge or link variants, and customize low stock alerts.
Discounts
The discounted price is taken from actual sales orders by comparing the listed price to the price in the sale order.
Discounts = Gross revenue - revenue
Where:
Gross revenue = number of units sold × sales order price before discounts
Revenue = gross revenue - discounts - returns
Discounts %
The discount percentage of gross revenue.
Discounted (filter)
Using the Discounted filter (where Discounted = Yes) displays all items that have a planned discount.
Planned discount = Regular price - price
E
Excluded holiday sales
The number of units sold and corresponding number of dates removed from the forecast calculation.
For non-seasonal forecasting methods (Recent Sales & Trends and Last Sales), it can be helpful to exclude certain periods of unusual sales from the forecast calculation. For example, by excluding Black Friday and Cyber Monday sales, the forecast the following weeks and months will not be overstated following a spike in sales. Configure excluded sales in Account > Settings > Forecast.
Expected Date
The calendar date that items on a purchase order or transfer are anticipated to arrive. 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.
The expected date on a transfer will show as creation date + lead time by default. This can be edited when creating a purchase order or transfer.
F
First 7 Days Revenue
Revenue made during the first 7 days after the first sale date. If the first sale date is not available, then the product creation date is used.
First 7 Days Sales
The number of units sold during the 7 days after the first sale date. If the first sale date is not available, then the product creation date is used.
First 30 Days Revenue
Revenue made during the first 30 days after the first sale date. If the first sale date is not available, then the product creation date is used.
First 30 Days Sales
The number of units sold during the 30 days after the first sale date. If the first sale date is not available, then the product creation date is used.
First 60 Days Revenue
Revenue made during the first 60 days after the first sale date. If the first sale date is not available, then the product creation date is used.
First 60 Days Sales
The number of units sold during the 60 days 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 received on a purchase order or transfer.
First Received Qty (Quantity)
Number of units received into inventory from the initial vendor purchase order or transfer.
Read more about receiving a purchase order.
First Sold At
Shows the first sales for a product.
This information comes from your sales platform and cannot be edited in Inventory Planner.
Forecast
Projected customer demand shows as sales in units for the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Forecast Cost
Forecast cost = forecast units * cost price per unit
This is the projected cost of forecasted units for the "days of stock" period.
The forecast is the projected customer demand shows as sales in units for the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Forecast Lost Sales
Forecast Lost Sales = Sales units missed during the lead time due to stockouts
Stockouts are the days when a product is out of stock. If there is a stockout during the lead time based on the forecast, current and incoming stock, potential sales will be missed since a new PO can only arrive after the lead time. This is an estimation how many sales units will be missed during lead time.
Forecast Lost Profit
Forecast Lost Profit = Forecast Lost Sales * (price - cost price)
Forecast Lost Revenue
Forecast Lost Revenue = Forecast Lost Sales * price
Forecast Profit
Forecast profit = forecast units * profit per unit
This is the projected profit for the "days of stock" period.
Profit/Unit is forward-looking to show the listed price and current landed cost. For Amazon sellers, product profit is the competitive price - landed cost price - estimated platform fee. If landed cost price is not available, Inventory Planner will use cost price.
The forecast is the projected customer demand shows as sales in units for the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Forecast Revenue
Forecast revenue = forecast units * price
Projected revenue for the "days of stock" period
The forecast is the projected customer demand shows as sales in units for the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Forecast Sales
Projected customer demand shows as sales in units for the selected period on the Overview > Forecast section. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
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 Wholesale
The number of units needed for wholesale orders during the 'days of stock' period.
G
GMROI (Gross margin return on investment)
GMROI = profit / average stock cost
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Average stock cost = sum of stock cost of inventory during the select time period / number of days in the selected period
Stock cost = units in stock * cost price of the item
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
Historical stock information is available as of the date that your Inventory Planner account was created.
Gross Regular Revenue
Gross Regular Revenue = number of units sold * regular price
Gross Regular Revenue is calculated using the regular price (sometimes called the 'compare to' price).
Gross revenue = number of units sold * sales order price before discounts and taxes
Gross Revenue
Gross revenue = number of units sold * sales order price before discounts and taxes
Gross Revenue does not subtract returns and is same as Gross Sales metric in Shopify.
Gross Sales
Gross Sales = Sales + Returns
Number of units sold during the time period. Returns are not deducted from this number.
H
Hidden in Overstock (Filter)
Using the Hidden in Overstock filter (where Hidden in Overstock = Yes) will display items that will not show in the Overstock report. Using the overstock report, you can hide variants from view (for example, items that are relatively new and you do not consider overstocked).
Holiday excluded sales
When a non-seasonal model is used, 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.
I
ID
A unique number assigned to each variant by your eCommerce platform or inventory management system.
Image
Photo of the product or variant. This is pulled from your connected sales platform.
In Assemblies
When viewing stock levels of assembly components (usually in the Variant view of Replenishment), this represents additional/separate units that have already been assembled into final goods. These are not available to create new assemblies.
In-Stock % (In-Stock percentage)
In-Stock % = Days in stock / Days in the selected period
This is the inverse of the Stockout % metrics.
Stockouts are the days when a product is out of stock.
IP Tag
IP tags (Inventory Planner tags) allow you to assign tags within your IP account. These allow you to group, filter or search using these labels. Read more about how to set up IP tags here.
IP Variant
If there is a component of your bundle that is not sold individually, you can create an IP variant. An IP Variant only exists in Inventory Planner. Read more about how to set up an IP variant here.
IP Variant (Filter)
Using the IP Variant filter (where IP Variant = Yes) will display only IP Variants in your report. Read more about how to set up an IP variant here.
IP Warehouse
An IP warehouse is used when your store has inventory in a location that does not fulfill customer orders directly. This manual warehouse is used to transfer stock to other locations that do handle order fulfillment.
Is Bundle Component (Filter)
Using the Is Bundle Component filter (where the Is Bundle Component = Yes) will display only variants that are tied to bundles in Inventory Planner.
L
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 including cost price and related expenses. In addition to vendor cost it includes shipping & handling, and discounts. Landing cost is the cost price in addition to extra expenses (and not only the extra expenses).
Note: For EU merchants, VAT should be included as part of the Cost Price.
Landing costs can be imported. This is useful when to do when you have recently created your Inventory Planner account. Over time, this will be replaced by Inventory Planner's computed landing cost price as you create and receive purchase orders as long as you set the shipping cost and select to update variants when a PO is saved.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
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 or transfer
Last Sold At
Shows the most recent date of sales for a product
This is set in your sales platform and cannot be edited in Inventory Planner.
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 Closing Stock
The estimated amount of inventory available for sale at the end of the Lead Time period. The Lead Time is the amount of time it takes to order a product from the vendor and receive it into inventory. The Lead Time Closing Stock factors in the current stock level, items on order and transferring in/out of the selected warehouse, and units estimated to be sold during this time (indicated as the Lead Time Forecast). Lead Time Closing Stock showing as 110 with a date of January 14, 2021 indicates that the estimated stock level will be 110 units as of January 14, 2021. This date will be today's date plus the lead time in days.
Lead Time Forecast
The number of units that Inventory Planner estimates will be needed during the specified lead time. A lead time forecast showing 24 and 'for 14 days' indicates 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
Price * Number of units sold for the lifetime of the product
This is all revenue and is not limited to the revenue from only the date range of the report. To see revenue from the report date range, use 'revenue'.
Price and unit sales information comes from your sales platform and cannot be edited in Inventory Planner.
Lifetime Sales
Number of gross units sold during the lifetime of the product.
This is all units sold and is not limited to the number of units sold during the date range of the report. To see units sold only during the report date range, use 'sales'.
Unit sales information comes from your sales platform and cannot be edited in Inventory Planner.
Listing
Listings are the item you sell, that we sync from your connected platform.
These are the Variants.
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.
M
Margin
Margin = profit / revenue
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Markdown
Markdown = Gross Regular Revenue - Gross Revenue
Gross Regular Revenue = number of units sold * regular price
Gross Regular Revenue is calculated using the regular price (sometimes called the 'compare to' price).
Gross revenue = number of units sold * sales order price before discounts and taxes
Markdown %
Markdown percentage = Markdown / Gross Regular Revenue
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 on your sales platform. When details on a product page are changed, Inventory Planner will reflect the date that those details were updated.
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.
N
Name
The product or variant title. This column in Inventory Planner will also display with SKU, barcode, and ASIN. If you would like to only see the product or variant title, use the 'Title' column instead.
Next to Assemble
Before purchasing new component stock, you can create new Assembly Orders to use existing component stock based on the recommended ‘Next To Assemble’ quantity.
The Replenishment quantity for Assemblies is the ‘Next To Assemble’ quantity + the additional replenishment needed to satisfy forecasted sales during the Days of Stock period. If there is not enough existing component stock to assemble any new assemblies, the ‘Next to Assemble’ quantity will be the same as the Replenishment quantity.
No Cost Price (Filter)
Using the No Cost Price filter (where No Cost Price = Yes) will show variants that do not have a cost price set in Inventory Planner.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Notes
Information you enter about a variant. 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.
O
On Assembly
Number of units in the process of being assembled. Any assembly with 'Open' or 'Partially Received' status will reflect the number of units yet to be assembled in the 'On Assembly' total.
Old Stock (Filter and Label)
Old stock is stock that does not have sales for more than 2 months and was created more than 2 months ago. It also has not been received for more than 2 months and there are no on order quantities.
On Order
On Order indicates the number of units in active purchase orders to vendors. Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
On Order % (On Order Percentage)
On order % = units in active purchase orders for a particular variants / all units on order.
On Order indicates the number of units in active purchase orders to vendors.Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
On Order Cost
On order cost is the cost value of "on order" units.
Cost price is the product price in the supplier catalog.
On Order indicates the number of units in active purchase orders to vendors. Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
On Order Cost %
On order cost % = the cost value in active purchase orders / the total cost value on order.
Cost price is the product price in the supplier catalog.
On Order indicates the number of units in active purchase orders to vendors.Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
On Order Retail
On order retail is the retail value of "on order" units.
Retail value is the current product retail price as set on your sales platform. This is set in your sales platform and cannot be edited in Inventory Planner.
On Order indicates the number of units in active purchase orders to vendors. Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
On Order Retail %
On order retail % = Retail value of a particular variant in active purchase orders / the total retail value on order.
Retail value is the current product retail price as set on your sales platform. This is set in your sales platform and cannot be edited in Inventory Planner.
Active purchase orders have 'open' or 'partially received' status. Purchase orders with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Note that warehouse transfers will show quantities in the 'transfer in' and 'transfer out' columns. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
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. The stock is based on the historical inventory snapshots taken by Inventory Planner. Cost price is the product price in the supplier catalog. Note: This is always based on the historical cost prices. Contact support to update metrics based on the current cost price.
Opening Stock Gross
Gross value of opening stock.
Regular price * units on hand at the beginning of a report time period.
Regular price is the retail price before any discounts are applied.
The stock is based on the historical inventory snapshots taken by Inventory Planner. Note: This is always based on the historical regular retail prices.
Opening Stock Retail
Retail value of opening stock.
Price * opening stock
The stock is based on the historical inventory snapshots taken by Inventory Planner. Note: This is always based on the historical retail prices.
Options
Sizes, colors and other variant options that apply to that SKU or product. This is set in your sales platform and cannot be edited in Inventory Planner.
Order Limit
Order limit will reflect the "maximum shipment quantity" from Amazon's restock report in your Seller Central account.
The order limit will be reflected in the 'to order' amount, along with the minimum order quantity and units of measurement amounts.
Overstocked (Filter)
Using the Overstocked filter (where the Overstocked = Yes) will display variants that are forecast to have stock on hand beyond the planning period, provided that no new orders have been received in the past two months. The planning period is the lead time + days of stock as set in the Replenishment section of Inventory Planner.
Overstocked Cost
The cost value of stock on hand that exceeds the planning period. The planning period is the lead time + days of stock as set in the Replenishment section of Inventory Planner.
Overstocked Retail
The retail value of stock on hand that exceeds the planning period. The planning period is the lead time + days of stock as set in the Replenishment section of Inventory Planner.
Overstocked Units
The number of units that exceeds the planning period. The planning period is the lead time + days of stock as set in the Replenishment section of Inventory Planner.
Overstocked Variants
The number of variants (SKUs) that have units in stock exceeding the planning period. If a single variant has 100 units overstocked, that will count as 1 overstocked variant and 100 overstocked units.
Note that this is different than 'overstock units' which will show the sum of all units overstocked. The planning period is the lead time + days of stock as set in the Replenishment section of Inventory Planner.
P
Page Views
The number of times that product page has been viewed. This information pulls from Google Analytics and cannot be edited in Inventory Planner.
Past Lost Profit
An approximation of the profit lost due to stockouts. Profit is the difference between revenue and cost of goods sold for an item. This is calculated based on the profit during the report date range and stockouts during that period.
Lost Profit = profit * stockouts% / (100 - stockouts%)
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Stockouts % = Out of stock days / Days in the selected period
Stockouts are the days when a product is out of stock.
Past Lost Revenue
An approximation of the revenue lost due to stockouts. Revenue is how much customers pay for a product less discounts and returns. This is calculated based on the revenue during the report date range and stockouts during that period.
Lost Revenue = revenue * stockouts% / (100 - stockouts%)
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Stockouts % = Out of stock days / Days in the selected period
Stockouts are the days when a product is out of stock.
Past Lost Sales
An approximation of the number of units not sold due to stockouts. Calculated based on the number of units sold during the report date range and stockouts during that period.
Lost Sales = sales * stockouts% / (100 - stockouts%)
Sales are the number of units sold during the report date range.
Stockouts % = Out of stock days / Days in the selected period
Stockouts are the days when a product is out of stock.
Past Revenue
Revenue for prior periods (ie previous months). Note the difference compared to Past Revenue LY, which is the revenue earned during the same month the prior calendar year. Past revenue shows revenue earned in the same year where applicable.
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.
Past Revenue LY
The revenue earned during the same month the prior calendar year. Note the difference compared to Past Revenue, which is revenue for the prior period (ie prior months).
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.
Past Sales
Units sold during prior periods (ie previous months). Note the difference compared to Past Sales LY, which is the units sold during the same month the prior calendar year. Past sales shows units sold in the same year where applicable.
Sales are the number of units sold for the selected period (date range of the report) less returns.
This is information comes from your sales platform.
Past Sales LY
Units sold during prior calendar year. Note the difference compared to Past Sales, which is the units sold during the prior period (ie previous months).
Sales are the number of units sold for the selected period (date range of the report) less returns.
This is information comes from your sales platform.
Period
Time span or dates included in data showing
Planned Discount
Calculated as Regular Price - Price.
Price is the current product retail price as set on your sales platform. Regular price is the product retail price before discount, sometimes called the 'compare to' price. Price and regular price are set in your sales platform and cannot be edited in Inventory Planner.
Planned Margin
Planned Margin = (historical price - historical cost price) / historical price
Price is the product retail price that was set in your sales platform as of the end of the date period selected in the top right. Price is set in your sales platform and cannot be edited in Inventory Planner.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order. For this metric we look at the cost price that was set as of the period selected in the report.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Planned Markup
Planned markup = 100 * (historical retail price - historical cost price) / historical cost price
Planned Sales
Planned Sales viewed on the Edit Forecast page of Inventory Planner will include any edits to the Inventory Planner forecast and wholesale orders if applicable. The Planned Sales will show units sold for the entire month (not remaining days if viewing the current month).
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 'platform' fee' will be the total fees charged by the connected platform for the date range of the report. Platform fees include referral fees, variable closing fee, per item fee, and FBA fees.
Platform fees are currently available only for Amazon.
Platform Variant Fee
Platform variant fee is the fee per unit charged by the connected platform (currently only supported for Amazon connections).
The 'platform' fee' will be the total fees charged by the connected platform for the date range of the report.
Product ID
The unique ID (identification number) for the product (or parent of a group of SKUs or variants).
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 as set on your sales platform. This is set in your sales platform and cannot be edited in Inventory Planner.
Products
Products are the main version of an item you sell on your store.
(Example: Tshirt with graphic design)
A product may have different variations (Colour, Size, Weight, etc), which we see a "Variants"
Product Name
The title given to the product in your store. This information is set on your connected sales platform and cannot be edited in Inventory Planner.
Profit
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Profit/Unit
Profit/Unit is forward-looking to show the listed price and current product landed cost. For Amazon sellers, product profit is the competitive price - landed cost price - estimated platform fee. If the landing cost is not set, Inventory Planner will use cost price instead.
Profit %
Profit for one variant / Profit for all variants
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Profit Diff % (Percentage Change in Profit)
Percentage Change in Profit = (profit during current time period - profit during previous time period) / profit during the previous time period
Profit = Revenue - COGS - Platform Fee
Revenue = gross revenue - discounts - returns
COGS = number of units sold * landing cost price
If landing cost price is not set the cost price field is used.
Published at
The date that your product or variant became visible to your customers. Note that if a product is published, then unpublished, and published again, the 'published at' date will be the most recent date when the item became visible on your site.
R
Received Cost
The total cost value of the items received on a Purchase order, in the selected date range on the report:
Received Cost = Received Qty * Cost Price
Received Qty
The number of units received during the date range of the report.
Received Retail
The total Retail value of the items received on a Purchase order, in the selected date range on the report:
Received Retail = Received Qty * Price
Received Units Cost
On a purchase order, the cost price only of units that have been received. The cost price of non-received units, called Remaining Units Cost, are excluded from this figure.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Regular price
Product retail price before discount, sometimes called the 'compare to' price. This is set in your sales platform and cannot be edited in Inventory Planner.
Remaining Units Cost
On a purchase order, the cost price only of units that have not been received. The cost price of received units, called Received Units Cost, are excluded from this figure.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Replenish Date
The last date to place an order to avoid running out of stock, or the current date if/when stock is predicted to run out prior to when more stock can be received (based on the forecasted sales during the Lead Time).
Note: if a Min Stock is configured, then Replenish Date is based on the last date to place an order to avoid running below the Min Stock level. If there is no Min Stock, then the Min = 0.
Replenishable (Filter)
When Replenishable filter = 'Yes,' items that are marked as replenishable will show in the report. Items marked as non-replenishable will be excluded. Replenishable items are ones to be reordered. When the Replenishable filter = 'No' then non-replenishable items will show and replenishable items are excluded from view.
Discontinued and dropshipped items should be marked as non-replenishable.
Replenishable (Status in Columns)
As a column, Replenishable shows if an items is replenishable or non-replenishable. 'Yes' in the Replenishable column indicates the item is replenishable. 'No' indicates the item is non-replenishable.
Replenishment
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Replenishment CBM
Volume of an individual item shown as CBM * replenishment
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 is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Replenishment Cost
Replenishment cost = replenishment * cost price.
This is the purchase cost to cover the "days of stock" period. Cost price is the product price in the supplier catalog.
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Replenishment Profit
Replenishment profit = replenishment * (price - cost).
The expected profit of products needed to cover the "days of stock" period.
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Replenishment Retail
Replenishment retail = replenishment * price.
The retail value of products to cover the "days of stock" period. Retail price is the price the customer will pay.
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Return %
Returns Units / Gross Sales.
Note: The "Sales" metric factors in returns. "Gross Sales" does not.
Return Units
Number of product units included on returns (items sent back to the merchant). Return information is pulled from your connect sales platform and cannot be edited with Inventory Planner.
Returns Revenue
The revenue amount (units * sales order price) sent back to customers following returns to the merchant. Return information is pulled from your connect sales platform and cannot be edited with Inventory Planner.
Revenue
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 %
Revenue Difference percentage = (revenue during current time period - revenue during previous time period) / revenue during the previous time period
The change in the revenue from the previous time period.
Revenue = gross revenue - discounts - returns
S
Safety Stock
The minimum stock level for a product.
Sales
Sales are the number of units sold for the selected period (date range of the report) less returns.
This is information comes from your sales platform.
Sales %
Number of units sold for one variant / Number of units sold for all variants
Sales are the number of units sold for the selected period (date range of the report) less returns.
Units sales information comes from your sales platform.
Sales Diff % (Percentage change in the number of units sold)
Sales Difference percentage = (sales during current time period - sales during previous time period) / sales during the previous time period
This is the change in the number of units sold from the previous time period.
Sales are the number of units sold for the selected period (date range of the report) less returns.
Sales information comes from your sales platform.
Sales for Forecast
The number of units purchased by customers during the specified date range and the corresponding number of days in that range after removing the Excluded Holiday Sales.
Sales (period)
The number of units purchased by customers during the specified date range (sales period for forecast) and the corresponding number of days in that range.
Sales Period for Forecast
The date range of customer orders used to calculate the forecasted demand.
Sales Velocity
Sales velocity = sales / number of days product was in stock for the selected period.
Out of stock days are excluded from the calculation. In stock means the stock level is at least 1 unit.
Sales are the number of units sold for the selected period (date range of the report) less returns.
If the first sale of the variant occurs during the reporting period, then the sales velocity calculation starts with the first sale date by default. Contact the Inventory Planner team if you would like the 'created at' date used instead of the 'first sold at' date.
This is information comes from your sales platform.
Sales Velocity / Day
Expressed in days, Sales velocity = Sales / (Period for forecast in Days - Stockouts in days)
Out of stock days are excluded from the calculation. In stock means the stock level is at least 1 unit.
Sales are the number of units sold for the selected period (date range of the report) less returns.
If the first sale of the variant occurs during the reporting period, then the sales velocity calculation starts with the first sale date by default. Contact the Inventory Planner team if you would like the 'created at' date used instead of the 'first sold at' date.
This is information comes from your sales platform.
Sales Velocity / Mo
Expressed in months, sales velocity = (sales / days with stock in the time period) * 30.
Sales velocity/month is sales when the product is in stock averaged for the month.
Out of stock days are excluded from the calculation. In stock means the stock level is at least 1 unit.
Sales are the number of units sold for the selected period (date range of the report) less returns.
If the first sale of the variant occurs during the reporting period, then the sales velocity calculation starts with the first sale date by default. Contact the Inventory Planner team if you would like the 'created at' date used instead of the 'first sold at' date.
This is information comes from your sales platform.
Seasonal (Filter)
Using the seasonal filter (where Seasonal = Yes) will show only variants that are set to use a seasonal forecast.
Sell Through
Sell through = Sales for the selected period / (closing stock for the selected period + sales).
'Sales' in Inventory Planner is net sales and is different than 'Gross Sales'. 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.
To see when current stock will run out, use 'stock cover in days'.
Sent
Providing detail about stock status for Transfer Orders, "Sent" shows the number of units on a transfer that have yet to leave the source warehouse.
Sum of (Ordered-Sent) for all transfers = Transfer Out for source warehouse
Sum of (Ordered-Received) for all transfer = Transfer In for destination warehouse
Shipping
Amount paid by customers on orders to receive their products. This will not include shipping costs already built into the listed price. This is set in your sales platform and cannot be edited in Inventory Planner. Shipping costs on a sales order will apply to items on the order proportionally to their value.
SKU
The Stock Keeping Unit refers to a unique code you assign to your variant or product. This is set in your sales platform and cannot be edited in Inventory Planner.
Stock
Number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Stock % (Stock Percentage)
Stock % = number of units available of one variant / Number of all units available across all variants
Stock is the number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Stock Allocated For Assemblies
Represents the additional components needed to cover the Replenishment recommendation of Assemblies.
Stock Begin (Opening Stock)
number of units in the beginning of selected period
Stock Cost
Stock cost = cost * stock
Stock cost is the cost price in the supplier catalog of inventory on hand.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Stock Cost % (Stock cost percentage of all stock cost)
Stock Cost % = Stock Cost of one variants / Stock Cost of all variants
Stock cost is the cost price in the supplier catalog for all inventory on hand.
Cost price is the variant price in the supplier catalog. This is the price you pay to a vendor per item as noted on your purchase order.
If your connected platform has a cost field, we recommend updating cost prices there to keep all information in sync (updating costs in Inventory Planner will not push that information to your platform). If your platform does not have a cost field, then you can add costs directly to Inventory Planner.
Stock cover in days
The number of days the available inventory will last based on the forecast.
The forecast is projected customer demand shown as sales in units to cover the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Stock cover in weeks
The number of weeks the available inventory will last based on the forecast.
The forecast is projected customer demand shown as sales in units to cover the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Stock cover in months
The number of months the available inventory will last based on the forecast.
The forecast is projected customer demand shown as sales in units to cover the "days of stock" period. The forecast is calculated using the sales velocity and the sales trends in recent months (are sales increasing or decreasing?). Sales velocity is the rate of sales excluding out of stock days. Seasonal products emphasize the sales trends from the prior year rather than the most recent months.
Stock End (Closing Stock)
number of units at the end of selected period
Stock Gross
Stock gross = regular price * stock
Regular price is the product retail price before discount, sometimes called the 'compare to' price. This is set in your sales platform and cannot be edited in Inventory Planner.
Stock is the number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Stock in Assemblies
The number of units of a component (variant) are already being used in finished assemblies.
Learn more about forecasting demand for assemblies and their components in Inventory Planner.
Stock Retail
Stock retail = Price * stock
This will be the retail price of all units in inventory.
Price is the current product retail price as set on your sales platform. This is set in your sales platform and cannot be edited in Inventory Planner.
Stock is the number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Stock Retail % (Stock retail percentage of all stock retail)
Stock Retail of one variants / Stock Retail of all variants
Stock retail = Price * stock
This will be the retail price of all units in inventory.
Price is the current product retail price as set on your sales platform. This is set in your sales platform and cannot be edited in Inventory Planner.
Stock is the number of units of inventory. This number is pulled from your connected platform and cannot be edited in Inventory Planner (unless you have an IP warehouse set up, in which case you will need to control stock manually).
Stockouts
Stockouts are the days when a product is out of stock. For example, if stockouts shows as '15', then that means the stock level for the variants was 0 or show as a negative level for 15 days during the date range.
Stockouts % (Percentage of Stockouts)
Stockouts % = Out of stock days / Days in the selected period
Stockouts are the days when a product is out of stock.
Stockturn
Stockturn = sales / average stock for the selected period.
Sales are the number of units sold. Average stock is based on the historical inventory snapshots taken by Inventory Planner during the daily data sync with your connected platform. This metric will not be available immediately when creating an Inventory Planner account. Historical stock information is recorded starting with the date an Inventory Planner account is created.
T
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.
If you would like to set tags within Inventory Planner, use IP Tags (Inventory Planner tags). IP tags can be set using Bulk Actions.
Tax
Tax amount paid by customers on orders. This will not include taxes already built into the listed price (ie VAT). This is set in your sales platform and cannot be edited in Inventory Planner.
Title
The variant or product title (name) as defined on your connected sales platform.
To Order
To Order starts with the Replenishment number (units needed in order to meet forecasted demand) and adjusts for shipment limits and vendor considerations including MOQ (minimum order quantity) and UOM (units of measurement).
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration current stock, on order or transfer quantities, continued selling during the lead time, and how many units are needed to meet demand during the days of stock.
Order limit will reflect the "maximum shipment quantity" from Amazon's restock report in your Seller Central account.
Minimum order quantity (MOQ) is 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.
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 MOQ and UOM.
Total Available Stock
From the Compare Warehouse report, 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 Forecast
Total forecast is the total number of units forecast to be sold after % adjustments are made in the Edit Forecast section of variants.
Total Forecast Revenue
Total forecast revenue is the total revenue forecast after % adjustments are made in the Edit Forecast section of variants.
Total Revenue
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.
Total To Transfer
From the Compare Warehouse report, Total To Transfer will show as the replenishment amount for the destination warehouse as long as there is available stock in a source warehouse. If there is not sufficient stock to transfer, then Total To Transfer will be reduced to the source stock amount.
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.
Tracked inventory is set in your sales platform and cannot be edited in Inventory Planner.
Transfer In
When creating a transfer from one warehouse to another "Transfer In" represents the incoming stock to a warehouse. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
Transfer In indicates the number of units in active warehouse transfers. Active transfers have 'open' or 'partially received' status. Transfer with 'draft,' 'closed,' or 'cancelled' status are not considered active.
Transfer Out
When creating a transfer from one warehouse to another "Transfer Out" represents the outgoing stock from a warehouse. Different from purchase orders from vendors, warehouse transfers have a source and destination warehouse.
Transfer Out indicates the number of units in active warehouse transfers. Active transfers have 'open' or 'partially received' status. Transfer with 'draft,' 'closed,' or 'cancelled' status are not considered active.
U
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.
Used in Assembly Orders
The number of component units (variants) that are on assembly orders in progress (open status).
Learn more about creating an assembly orders in Inventory Planner.
V
Variants
The most granular level of items for sale in your store. This will include the type of the item such as the color or size when available. This is sometimes referred to as the 'child' and a product is the 'parent'. For example, one style of dress would the product. Then the dress in small is one variant, medium is another variant, and so on.
Variants in Stock
Recorded at aggregated levels (eg. KPI Reports by Vendor or by Category), this metric records how many Tracked Variants are currently in stock within the aggregated data set.
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. If your connected sales platform does not have a vendor reference or supplier SKU field, you can add this in the Vendor section of Inventory Planner or import this information using a Single or Multiple Vendor Catalog.
To add Vendor Reference to your purchase order or transfer, click the gear icon while editing your order.
Then enable 'Vendor Reference'.
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. If your connected sales platform does not have a vendor product name or supplier product title field, you can import this information using a Single or Multiple Vendor Catalog.
To add Vendor Product Name to your purchase order or transfer, click the gear icon while editing your order.
Then enable 'Vendor Product Name'.
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.
If an item is visible or not is set in your sales platform and cannot be edited in Inventory Planner.
W
Warnings
Warnings indicate no sales for a product or extended stockouts.
Warehouse
A 'warehouse' in Inventory Planner is automatically created based on warehouses or locations set up in your connected platform(s). Warehouses will reflect sales and performance metrics for only that location. Settings such as lead time and days of stock can be configured for each warehouse.
For Amazon connections, you will see an FBA 'warehouse' set up for each country in the Amazon region and an FBM warehouse for the entire region. (FBA is fulfilled by Amazon, and FBM is fulfilled by merchant.)
Warehouses cannot be deleted from Inventory Planner. Instead, you should disable any warehouse that you will not need for replenishment, planning, and reporting purposes.
Additional warehouses can be configured within Inventory Planner. A combined warehouse adds together the sales, stock, and/or purchase order information for more than one warehouse.
An IP warehouse is used when your store has inventory in a location that does not fulfill customer orders directly. This manual warehouse is used to transfer stock to other locations that do handle order fulfillment.
Wholesale Units
The number of units sold on wholesale orders during the date range of the report.
Y
Yesterday Sales
Number of units sold the previous calendar day