RETAIL GLOSSARY

This is a glossary on retail terms that are used in Retail IT and Operations. The list will be updated on periodic basis :

SL NO	KEY WORD	EXPLANATION
1	Area	It represents each geographic area that belongs to a chain within the organizational hierarchy. It could be states or countries based on the geographical. Each area can belong to only one chain.
2	ARS	Auto Replenishment System is the functionality in RMS which calculates the ROQ based on the replenishment settings done by the PM in RMS
3	ASPD	Average Sales Per Day is the average of the quantity sold in a day during the stipulated time period. It is calculated as (qty_sold / number of days)
4	ATS	Available To Sell means a product is in good condition meeting all the necessary standards for sale of it to a consumer
5	Average Cost	This is the moving weighted average of unit cost captured at SKU location level. Used in margin calculations and General Ledger for stock ledger maintenance. It is calculated as ((SOH x average cost) + (Incoming qty x unit cost))/(SOH + incoming qty)
6	Average Holding Inventory	It is the average stock value held for particular times. It is used for inventory turnover and return on investment calculation. It is calculated in general as (opening Book qty + closing Book quantity)/2 or as (opening Book qty + closing Book quantity) / (number of months+1) based on the application of the formula
7	Banner	Channels are further divided into banners for better understanding of the different categories in the respective business channel
8	Barcode	Barcode is a scanner readable code in the form of a pattern of lines with varying width that is printed on a product. This displays the UPC of the product at the POS upon scanning to register the sales against the respective product
9	BI	Business Intelligence is an approach to analyse data to extract facts and relations that can be presented to the executives of an organisation to make more informed business decisions and define best practices in different areas of operations
10	Book Stock	This is the stock on hand held in the system at a given point in time. Book stock is use in inventory analysis and variance calculations
11	Branch / Store	A Location where products are sold i.e. a place where sales and returns take place for the product sold or service rendered. In general branches/stores are treated as profit centre in a retail organisation
12	Case Pack Size	It is the quantity of a single SKU that can be accommodated in one case that is supplied by the supplier. Purchase Orders are by default placed in case pack size. This is also known as supplier pack size
13	Cash Float	A float is a small amount given by the head cashier to a cashier while allocating the POS Till during the opening of the shift. This is given in multiples of smaller currency in order to return change to customers at the time purchase. The amount it returned to the head cashier during end of shift
14	Chain	It is the first level of the organization hierarchy below company in Oracle Retail. Can be used to group by store formats, concepts, geographical groups, etc. Operating currency code can be defined for the Chain.
15	Channel	This defines the different types of business models the retailer is involved in such as Catalogues store, Brick and Mortar, Ecommerce, etc. Profit centres or stores can have designated channels incorporated in the ERP for reporting purpose and drafting business plans
16	Class	Class is the second lower level in the merchandise hierarchy. This is the further subdivision of department to identify further levels of classification in a product line. Vat setting is also done at this level
17	Company	This is the highest of merchandise and organizational hierarchy in Oracle Retail. This is the level at which financial accounting is summarised in Oracle Financial system
18	CRM	Customer Relationship Management deals with the policies defined by an organisation to communicate with its existing customers and future potential customers. It covers areas of ERP, Customer Service Desk, POS, loyalty programme, marketing, data integration, customer data analysis, analytics and digitalisation
19	Customer Conversion Rate	It is the percentage of customers who have actually bought a retailer’s product or service when compared to the total footfall/Walk-in for the stipulated time period. It is calculated as (Number of Bills/Footfall) x 100
20	Customer Return /       Sales Return	This is the process wherein a customer returns the purchased product to the retailer due to dissatisfaction, damages or product quality. The product is accepted by the branch if it falls under the Returns Policy of Nakumatt Holdings and a Credit Note is given as a token of acceptance which can be used by the customer to purchase another product of their choice at Nakumatt branches
21	Cycle Count	These are short span perpetual inventory checks done at store and warehouse locations for high value shrinkage SKUs, in order to identify the root cause for loss of inventory. Cycle counts are also done at warehouse on regular basis to do health check for internal storage locations to avoid hurdles caused while picking due to incorrect inventory
22	Data Cleansing	Data cleansing is an activity done at short term intervals by technical support team to comb the data in the database by validating table relations and accuracy of the data present
23	Department	Department is also called as Category is a key level in the merchandise hierarchy where a cluster of Classes with similar product line is listed under one group for higher level reporting and classification. Budgeting, markups, intake margins, tax settings and purchase type of a category is defined at this level
24	District	Groups Stores within a Region (generally geographically) Each District can belong to only one Region
25	Division	It is the highest level in merchandise hierarchy below Company. A cluster of groups with similar product line is listed under one division for higher level reporting and classification
26	DSR	Daily Sales Report is generated as part of EOD activity at stores. It is generated in order to reconcile tenders and cash collected during the day and compared it against the system generated report. Short in cash collected or card swipes are identified.
27	End User	End users are people to use the application to execute their day to day activities. Any technical change or process change brought in will impact the end user, hence proper user training is needed before deploying any  change
28	EOD	End of Day is the process which involves closure of POS tills and generation of sales report along with sales log file for the day from back office system. This marks the end of all the transaction at store for the day. Post this activity completion, any new transaction can be done in the next business date only
29	ERP	Enterprise Resource Planning is a suite of integrated applications that we use to collect, store, manage and interpret data from our day to day business activities, including: Product planning, costing, Pricing, stock ledger maintenance, supply chain management, Marketing, sales, etc.
30	GMROI	Gross Margin Return on Investment ratio helps retailer to know what level of returns can be obtained upon the investment made for a stipulated time period. In simple terms it helps us understand the performance of a category/ item with respect to gross sales margins. This is calculated as (Gross Margin value / Average Inventory Cost)  where Gross Margin value is (Gross Sales - COGS)/Gross Sales
31	GMROS	Gross Margin Return on Selling Area ratio explains the gross margin made by the product upon the selling area allocated for the product. This is used by retailers to find the gross margin per square feet in the selling area and take decision on expansion of selling area or reduce the selling area or discontinue the product all together. This is calculated as (gross margin value/selling area in sq ft)
32	GRN	Goods Received Note is the document created when a Purchase Order is received at the branch or warehouse
33	Gross Sale	This is sum of the total amount paid by a customer to a retailer for the service enjoyed or a product purchased. This is used for reconciliation of tenders in Daily Sales Report during End Of Day Process
34	Group	This is the second highest level in merchandise hierarchy below division. A cluster of department with similar product line is listed under one group for higher level reporting and classification
35	Help Desk	A system (application, people and process) put in to place to provide support and resolve issues and concerns raised by IT and Business users within an organisation. This acts both as a bridge and a repository for communications between Business, IT Department and support team
36	Inner Pack Size	It is the break pack size of a supplier case i.e. how many quantities of an SKU are present within the break pack of a supplier case
37	Intercompany Transfer	It is the transfer of goods between two different transfer entities. Such transfers are treated as Sale of Goods from one transfer entity to another in financials, hence the name Inter-company
38	Inventory Turnover	It represents the number of times a retailer rotates his inventory during the considered time period. This is used to know how efficiently inventory is handled within the organisation. It is calculated as (COGS/Average Inventory Held)x100
39	IPO	Import Purchase Orders is the document released to a supplier from another country for supply of goods for a requested quantity within the stipulated time period
40	KPI	Key Performance Indicators are metrics used by a retail organisation to evaluate the performance in respective area of interest. KPI differ from organisation to organisation. A few examples are Sales metrics, Customer loyalty metrics, Vendor Performance Metrics, Inventory Metrics
41	KRA	Key Responsibility Areas are general outputs or responsibilities that are given to a particular team or role. The performance of the team member or head is measured based on the fulfillment of his KRAs
42	LPO	Local Purchase Order is the document released to a supplier for supply of goods for a requested quantity within the stipulated time period
43	Master Data Management	It is the approach taken by the retailer to manage the masters related to SKUs, Barcodes, Suppliers, taxations, locations, SKU – supplier and SKU – Location mapping, etc. As a best practice retailers form a Central Data Management team to centrally control all data related to master data changes to ensure better control and reduce human error
44	Maximum Book Quantity	This is the maximum stock expected to be maintained an SKU at a location at any given point in time to meet the projected demand. This is used as a check for over ordering; thereby ensuring LPO is not be raised for quantity beyond this point. In general referred to as MBQ along on with minimum book quantity
45	Minimum Book Quantity	This is the minimum stock expected to be maintained for a SKU at a location at any given point in time to meet the projected demand. This is usually set as the reorder point for the SKU and when the stock levels hit this point, new LPO is raised to meet the maximum book quantity. In general referred to as MBQ along on with maximum book quantity
46	Net Sale	This is the sales made by a retailer excluding the VAT amount. Scan margin is calculated from Net Sales and not from Gross sales. It is calculated as Gross Sale/(1+(VAT/100))
47	Non-Trading Item	These are inventory SKUs for which stock in maintained but are not sellable at POS. These include stationary, packing material, carry bags, etc. that are bought for internal use and packaging purpose. There is no direct revenue generated from these SKUs
48	Pallet Size	It is the quantity of SKUs that can be stacked in a pallet. This is calculated by as (TI X HI) where in TI is the number of cases that make up one tier of a pallet and HI is the number of tiers that make up one pallet vertically
49	Perpetual Inventory	This is a method of tracking sales and purchases of an SKU in the system in near real time. This is achieved by implementation of a robust inventory management ERP
50	Petty Cash	An easily accessible amount of cash given on regular intervals to the profit centres in a retail organisation for purchase of low value non trading items and to accommodate small expenses related to repair and maintenance. A report on usage of the fund it given by the profit centre to the head office based on which funds are reimbursed.
51	Pickup Lead Time	Time taken for transfer of goods from the supplier’s dispatch location to the retailer’s warehouse or store. This is added to the supplier lead time to arrive at the total time taken for supply of goods from the date of order approval
52	PM	Procurement manager or head who handles the buying and allocation of goods for his/her respective category
53	POQ	Prescaled Order Quantity is the final order quantity that is requested from the supplier based on the supplier pack size. This is the nearest rounding off of the ROQ based on supplier pack size and rounding off threshold set in the system
54	POS	Point of Sales is a till at the branch where payment transactions related to sale or return of Goods. It is the place when the customer pays the retailer for the product or service offered
55	Rate of Sale	This is the rate at which sale has increased or decreased in the current period compared to a similar period in the past. It is calculated as {(Current Period sale – Past Period sale)/Past Period Sale}x100
56	Region	Groups Districts within an Area, such as North, South, etc. Each Region can belong to only one Area
57	ReIM	Retail Invoice Matching is the ERP module that facilitates users to reconcile vendor invoices with GRN and raise Credit Note Request, Debit Memos, Credit Memos and release advisory to OFIN-AP for vendor payments
58	RFM	Recency Frequency Monetory Value' is a term used to measure the customer value in retail. It is commonly used in database marketing and direct marketing and has received particular attention in retail and professional services industries Recency : How recently the customer has purchased from the retailer Frequency : How often does the customer buy Monetory Value : How much does the customer spend on an average per purchase
59	RMS	Retail Merchandising System is the ERP module that facilitates users to manage the master data and inventory at Nakumatt
60	ROI	It is the percentage to measure the performance of gains obtained from the total investment made in a product or total capital invested in a business. It will give clarity on how soon we can recover our investment cost or what percentage of profit we can expect from our investment. It is calculated as (Net Profit/Total Investment) x 100
61	ROQ	Recommended Order Quantity is the requirement for goods placed by the branch or warehouse to the procurement team. This can be system generated through ARS based on SOH and MBQ set or manually calculated
62	RPM	Retail Price Management is an ERP module used to manage pricing for products sold by a retailer. Promotions, clearance and regular price changes at product level are done through this module. This publishes the information of price changes made to POS through interface and batch programs
63	RTV	Return to Vendor is the document created to assist to return of goods back to supplier due to various reasons such as damaged, non-selling, etc. A credit note is given by the supplier as a receipt of acceptance of the document
64	SBU	Strategic Business Unit is a group of profit centres management discretely due to their distinct catchment attributes though they are all held by a single retail organisation. Each unit will have a discrete marketing plan, business plan, competitive analysis done to improve efficiency and sales
65	Scan Margin	It is the margin made by a retailer by selling a product or service to a customer. This is arrived from Net Sale i.e. Sales value after Tax inorder to eliminate the VAT or other tax factor which are to be paid to the government. It is calculated as {(Net Sale – COGS)/ Net Sale}x100 or as {{Gross Sale – (COGS x (1+vat/100))}/Gross Sale}x100
66	Selling Unit Retail	It is the price at which a retailer sells a product or service to a customer
67	SIM	Store Inventory Management is the ERP module that facilitates users to manage store inventory and reordering
68	SKU	Stock Keeping Unit is the level of the SKU at which stock in maintained in the system. SKU is also called as Item in retail
69	SME	Subject Matter Expert is a person who has high level of expertise in his domain who can guide and bring in change based on best practices. They are consulted for all changes and development in their respective domain, both operational and technical
70	SOD	Start of Day involves the process of download of master data and price change data into store Back Office and Point of Sale. This also involves the process of float cash distribution and opening of POS tills for business transactions
71	SOH	This stands for Stock On Hand. In retail operations this refers to the physical stock for an SKU at a particular location. In RMS this also refers to the book quantity for an SKU at the respective location
72	SOP	Standard Operating Procedures are documents explaining the steps to be followed in various operating areas within an organisation such as Operations, Environment, Service, Inventory management, Visual Merchandising, etc. This is done in order to maintain discipline uniformity and quality standards within the organisation
73	SPF	Sales Per Square Foot/ Sales Per Footage is a retail calculation made to calculate the sales made per square feet sales area. This will give us the efficiency of the store sales team. It is calculated as (Total Sale)/(Total Sales Area (sq ft))
74	Stock Audit	These are periodic perpetual inventory checks done at a branch or warehouse location to reconcile the physical inventory with book stock and arrive at the shrinkage/variance. The variance is taken against the sales for the time period to arrive at the variance percentage. This will give a good picture on loss in margin to the retailer due to variance/shrinkage. It is calculated as (Variance Cost Value/Total Sales for the period)*100
75	Stock Holding Days	Based on the current SOH and the ASPD, a merchandiser can determine the number of days it would take for the existing inventory to be exhausted. This is used as an input parameter to arrive at the recommended order quantity in manual calculations and also in pricing strategy to liquidate non selling SKUs through discounts
76	Store Order Multiple	It defines the multiples of quantity that the store can request from the warehouses. It can be set as Each, Inner or Cases, so the store’s ROQ and transfer requests are placed as per inner size and case size defined
77	Subclass	Subclass is the lowest level of merchandise hierarchy. This is the further subdivision of class. Subclass is not unique and can repeat i.e. same subclass featuring in different class unlike other levels which are unique. Retailers can use Subclass to define brands
78	Supplier Lead Time	Time taken from the date an order is released to the supplier to the date when the supplier readies the stock for dispatch. This is added to the pickup lead time to arrive at the total time taken for supply of goods from the date of order approval
79	Tare weight	Tare weight or Tare in the weight of the empty container that holds the products. By subtracting the tare weight from the gross weight, we can obtain the net weight of the goods carried in the container
80	Transfer Entity	Transfer entity is a group of locations that share legal requirements around product management. An inter-company transfer occurs when product is transferred between locations with different transfer entities. Inter company is handled as sale of goods from one entity to another in financials
81	Transfer Zone	Clusters of profit centres or stores defined in the system to allow transfer of goods. Goods can be transferred only in between stores falling under the same transfer zone
82	UDA	User Defined Attributes are characteristics that can defined for an SKU to identify or group them for reporting purpose such as Brands, Product type, etc. Other user attributes that can be defined in RMS as ‘free from text’ UDA used for defining legacy item code against oracle code for reference purpose and ‘Date’ UDA used for defining expiry date or manufacturing, etc.,
83	Unit Cost	This is the cost price at which a product is purchased by the retailer from a supplier. This is always excluding the vat rate. This can also be expressed as the net selling retail (net sale) the supplier charges for sale of goods to the retailer
84	UPC	Unique Product Code is the unique number given to a product, usually by the manufacturer which is embedded into a Barcode or a QR code on the product for scanning purpose
85	UTS	Unavailable To Sell means a product is not in a good condition or does not meet the necessary standards for sale to a consumer. Such products are returned back to the supplier or written off from the book quantity and scrapped
86	Variance / Shrinkage	These are quantities identified as Loss in book quantity while doing a cycle count or a stock audit. It is a direct loss to the organisation. It is calculated as (Physical Count – Book Stock)
87	VAT	Value Added Tax is the charge levied on a product or service based on the selling retail. This is paid to the government at regular time intervals by the retailer. Selling price - (selling price/(1+(vat/100)))
88	Warehouse	A location where products are stored and distributed centrally for a particular catchment area serviced by the warehouse. In general warehouses are treated as cost centre in a retail organisation
89	WMS	Warehouse Management System is the ERP module that facilitates users to manage Warehouse inventory, perform complicated warehouse tasks with ease and receiving/shipping of goods based on requests created in RMS and SIM
90	Omni Channel	Omni Channel is a means of providing the customer with a seamless shopping experience whether they shop online or through mobile app or telephone or brick and mortar. Omni channel presence is a big advantage to a retailer because it increase market reach and sustaining customer base by giving them convenient modes of shopping