📖Glossary of Terms
Glossary of terms for the Bee Forecast & Replenishment.
If there are no additional notes, the metrics are calculated based on variant and location dimension.
Sales
7 Days Sales
The number of units sold in the previous seven days.
14 Days Sales
The number of units sold in the previous fourteen days.
Monthly Sales
The number of units sold in the last month.
2 Month Sales
The number of units sold in the last two months.
3 Month Sales
The number of units sold in the last three months.
6 Month Sales
The number of units sold in the last six months.
Yearly Sales
The number of units sold in the last year.
Sales%
Sales% = the number of units sold in the previous 30 days of one variant / number of all units sold in the previous 30 days across all variants
First Sold At
The date when the variant was first sold.
Last Sold At
The date when the variant was last sold.
Outlier Sales
On the reports, the Outlier Sales column is represented in the format "48 on 2024/05/18". This means that 48 units of sales were eliminated on this date since these sales are outliers.
To get more information about outlier sales, please check this page.
You can see all outlier sales on the Outlier Sales page.
Sales Performance
Class
Class shows the sales performance of the variants. “A” Class includes SKUs comprising the top 80% of sales quantity, “B” Class is the next 15%, and “C” Class is the final 5%.
Class is calculated based on sales of the variants on entire store within the last 30 days of sales. It is not calculated location based.
Stock Age
This shows how many days a stock item has not been sold. It is calculated by subtracting the variant's last sold date from today's date.
If the variant has not been sold in the last year, the stock age is calculated based on the date the variant was created.
If the variant was created more than a year ago and has not been sold in the past year, the stock age is shown as 366 days.
For out-of-stock items, a value of 0 is displayed in this field.
Inventory
Inventory Quantity
The number of units in stock. Inventory quantity shows the quantity in the "Available" field on the Shopify product page.
Incoming Inventory
The number of incoming units.
Inventory Cost
Inventory cost is the total value of inventory on hand according to variant or product cost.
Inventory cost = cost * inventory quantity
Inventory Price
Inventory price is the total value of inventory on hand according to variant or product price.
Inventory price = price * inventory quantity
Inventory Policy
If the item continues selling when out of stock, it shows "continue." Otherwise, it shows "deny."
Is Tracked
If the product's inventory is tracked by Shopify, it appears as true. If it is not tracked, it appears as false.
Forecast & Replenishment
Daily Forecast
Projected customer demand shows as sales quantity for a day. You can find more detail on how to calculate the forecast here.
Weekly Forecast
Projected customer demand shows as sales quantity for a week. You can find more detail on how to calculate the forecast here.
Lead Time
The amount of time it takes to order a item from the vendor and receive it into inventory is shown in number of days.
When you change the Lead Time parameter on Settings page, days of stock forecasts and replenishment quantities are updated in real time.
Days of Stock
The number of days that inventory should cover.
When you change the Days of Stock parameter on Settings page, lead time forecasts and replenishment quantities are updated in real time.
Lead Time Forecast
The number of units that Merchbees estimates will be needed during the specified lead time.
Lead Time Forecast = Daily Forecast * Lead Time
Days of Stock Forecast
The number of units that Merchbees estimates will be needed during the specified days of stock.
Days of Stock Forecast = Daily Forecast * Days of Stock
Replenishment Quantity
Replenishment is based on forecasted demand and indicates how many more units are needed in order to meet customer demand. It takes into consideration inventory quantity, on order or transfer quantities (incoming inventory), continued selling during the lead time (lead time forecast), and how many units are needed to meet demand during the days of stock (days of stock forecast).
Lead Time Closing Stock = Max (0, (Inventory Quantity + Incoming Inventory) - Lead Time Forecast)
Replenishment Quantity = Days of Stock Forecast - Lead Time Closing Stock
Forecast & Inventory
Stock Cover Days
The number of days the available inventory (inventory quantity) will last based on the forecast.
Stock Cover Days = Inventory Quantity / Daily Forecast
Product Info
Image
It shows variant's image.
Product Name
The name of the product shows the name in the "Title" field on the Shopify product page.
Product ID
The unique ID (identification number) for the product is assigned by Shopify.
Variant Name
A variant is 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.
The variant name is assigned based on the options that you choose while creating the product and their variants on the Shopify product page.
If you see "Default Title" on the variant name, this product does not have any options like size or color.
Variant ID
The unique ID (identification number) for the variant is assigned by Shopify.
SKU
The Stock Keeping Unit refers to a unique code you assign to your variant or product. It shows the code in the "SKU" field on the Shopify product page.
Barcode
Barcode shows the code in the "Barcode" field on the Shopify product page.
Product Type
Product type shows the label in the "Product Type" field on the Shopify product page.
Vendor
The manufacturer, wholesaler, or other vendor for the product.
Cost
Cost shows the value in the "Cost per item" field on the Shopify product page.
Price
The price that you're charging for the product. It shows the value in the "Price" field on the Shopify product page.
Status
It shows the status of the product. It can be Active, Draft, or Archived.
Tags
Tags shows the label in the "Tags" field on the Shopify product page.
Created At
The time when the variant was created
Variant Age
It is calculated by subtracting today's date from the date the variant was created.
Is Published
If the product is published, it appears as true. If it is not published, it appears as false.
Others
Location
A location is a physical place or an app where you do any or all of the following activities: sell products, ship or fulfill orders, and stock inventory.
If the Location field is "All Locations", all calculations are made based on the total sales or inventory belonging to all locations for your store.
👋 If you have a different need for a forecast, please don't hesitate to contact us! We are always here to help! You can say hello with live chat on merchbees.com or send an email to support@merchbees.com.
Last updated