Glossary

January 25, 2022


Here is a list of terminology we use throughout the system, and documentation.

Metric name is the caption used in the reports and forms. Technical name is used in API, reference this in order to store or retrieve data.

Metric name

Technical name

Description

Avg inventory qtyavg_qtyAverage stock over period of time. This is calculated by adding weekly ending balances and diving the total by the number of weeks.
Avg inventory@costavg_costAverage stock at cost value.
Avg inventory@retailavg_retailAverage sotck at retail value.
BOP @ costope_costStock balance at cost value at the beginning of the period.
BOP @ retailope_retailStock balance at retail value (VAT or tax inclusive) at the beginning of the period.
BOP marginope_marginPotential margin at the beginning of the period in stock. It indicates the maximum discount percentage which can be applied without taking a direct loss.
BOP qtyope_qtyStock balance at the beginning of the period in retail units.
Calculated salessales_ticketsThis is a forecasted KPI used to reconcile physical footfall forecast and expected conversions with forecasted merchandise plan.
Clearance markdownclearance_markdownClearance markdown
Clearance markdown %clearance_markdown_rateClearance markdown rate
Conversion rateconversion_ratePercentage of visitors who make a purchase. Higher value is better, and can be attributed to several factors such as efficient marketing or attractive product mix.
Cost pricecost_priceCost price of a single item.
Current qtycurrent_qtyThis represents most recent known balance. The system maintains historical weekly balances but this balance can be updated daily (or several times a day).
Current@costcurrent_costMost recent known balance at cost value.
Current@retailcurrent_retailMost recent known balance at retail value.
Current+On ordercurrent_order_qtyQuantity available in the future. This includes current stock and amounts in transit, and purchase orders. This value can be used to calculate the missing quantities.
Days sales of inventorydsiInventory days indicates how long an item is in stock before it is sold. Ideally this would equal to the lead time of the item.
EOP qtyclo_qtyStock on hand in the end of given period. Actual figures are loaded directly from source system, and forecasts are calculated.
EOP@costclo_costStock on hand in the end of given period at cost. Actual figures are loaded directly from source system, and forecasts are calculated.
EOP@retailclo_retailStock on hand in the end of given period at retail value. Actual figures are loaded directly from source system, and forecasts are calculated.
Flat covercover_weeksFlat cover or cover weeks is a metric that indicates for how many weeks stock would last given current sales.
Forward coverforward_coverForward cover indicates, how many weeks the stock on hand should last given the forecasted sales. In open to buy this is one of the key parameters.
Full pricefull_priceFull price is the item's inital price without discounts and markdowns.
GMROIgmroiGross Margin Return of Inventory is performance metric telling how much an item or category earns over time. Higher figure is better.
Gross margingross_marginGross margin earned.
Gross margin @ full pricegross_margin_fullPotential gross margin as if all products were sold at full price.
Gross margin %gmGross margin percentage.
Gross margin % @ full pricegm_fullPotential gross margin percentage.
Intake margin %intake_marginIntake margin is the percentage applied to given purchase batch in the open to buy. By default the margin from opening balance is used but here it can be overriden.
Intake qtyintake_qtyApproximate intake units calculated based on the current (opening) average price.
Intake@costintake_costIntake at cost price, i.e. the pruchasing budget given the margin objective.
Intake@retailintake_retailIntake at retail price. This is forecastable figure, and other intake values are calculated based on this.
Inventory turnoverinventory_turnInventory turnover shows how many times inventory sells during a year.
Non-selling stocknon_sellingNon-selling stock is a calculated indicator. If it has value of 1 then the stocked item has not been sold during given time period.
Number of receiptsticket_countNumber of transactions in given store.
Number of visitorsvisitor_countNumber of visitors who come into the store, or ecommerce site. Also called Footfall.
On order qtyorder_qtyOn order is essentially the same as intake but forecasted either at cost or units.
On order qtycurrent_orderUnits currently on order.
On order@costorder_costOn order cost can be forecasted or is calculated from quantity based on the price as defined by opening balance.
On order@retailorder_retailRetail value is calculated using Intake Margin.
Optimal qtyopt_qtyOptimal quantity in hand. This value is calculated from optimal retail value.
Optimal@costopt_costOptimal stock in hand at cost value. This is calculated from retail value based on the gross margin.
Optimal@retailopt_retailOptimal stock in hand. Optimal stock is the forecasted sales for the number of weeks defined by forward cover.
OTB qtyotb_qtyOpen to buy represented in units. This is approximate figure based on average price within given category.
OTB@costotb_costOpen to buy represented at cost.
OTB@retailotb_retailOpen to buy represented at retail value.
Overbought qtyob_qtyOverstocked amount at any given time based on the future demand.
Overbought@costob_costOverstocked amount at cost value.
Overbought@retailob_retailOverstocked amount at retail value.
Permanent markdownpermanent_markdownPermanent markdown is used to report the purpose of the discount. By definition, permanent markdown is applied to goods whose end of life is reached such as previous season fashion and electronics. Once applied the price is not going up again as opposed to POS or promo markdown. It is mosty used in open to buy scenarios when you may want to access purchasing budget while old goods are still in the inventory.
POS (promo) markdownpromo_markdownPOS or promotional markdown is any discounted price which is temporary, or is applied given specific rules such as loyalty program.
POS (promo) markdown %promo_markdown_rateDiscount percentage. This figure is forecastable.
Realized markdownrealized_markdownRealized markdown is portion of the permanent markdown which was sold during given period of time. For example, if you apply permanent markdown of 20% to your entire collection of original 100k value then permanent markdown amnount is 20k, and if you sell 50% of your stock during given period then realized markdown for this period would be 10k.
Sales @ full pricesales_fullSales at full price, i.e. the item(s) original shelf price. It is calculated by adding all discounts back to the retail sales.
Sales @ retail pricesales_retailActual reported sales, or forecasted sales at retail value, tax inclusive.
Sales costsales_costCost of goods sold. For actual figures it is taken directly from the inventory management system.
Sales excl. VATsales_ex_vatSales excluding VAT, this is the figure the company finance operates with.
Sales LYsales_retail_lyActual reported sales from last year's corresponding week. The value is used for comparison purposes and is available only if the source data has been loaded to the system.
Sales quantitysales_qtyRetail units sold.
Sales YOYsales_retail_yoyYea-over-year change in sales.
Sales YOY %sales_retail_yoypYea-over-year change percentage in sales.
Sell-throughsell_thruSell through indicates how much of the opening stock is was sold during given period.
Selling priceretail_priceSelling price of an item.
Shrinkage %shrink_rateShrinkage as percentage of sales.
Shrinkage qtyshrink_qtyShrinkage is the amount of spoiled, or lost goods that can not be sold or returned to the supplier.
Shrinkage@costshrink_costShrinkage at cost value is typically what is reported on the P&L statement.
Shrinkage@retailshrink_retailShrinkage at retail value.
Stock salesstock_salesSales at retail with temporary discounts added back (but excluding any permanent markdowns).
Total markdowntotal_markdownTotal markdown sums up all different discounts.
Underbought qtyub_qtyAmount that is needed to fulfill the future demand, the Open To Buy in sales units. This is an approximate figure given the average cost within category.
Underbought@costub_costAmount that is needed to fulfill the future demand at cost, this is essentially the purchasing budget.
Underbought@retailub_retailThe Open To Buy in retail value (i.e. the selling price).
VAT ratevat_rateVAT or sales tax rate. For actual figures it is taken directly from the data source. For forecasting purposes it must be entered to the system.