Walmart Glossary

Common terminology used by Walmart and Retail Link

Trait Description Definition 
ABDM = Authorized by Distribution Method  *(Current) DSD states use the Mod Flag from Retail Link to track authorized stores (Traited/Valid not applicable for DSD Item Numbers)
*VAP items are not 'Authorized' so you will need to use '0' in the filter to view these items
*Non-DSD states use Trait Flags to track authorized stores
Negative Markup Retail price is lower or below store cost
Store Specific Retail = SS Retail Retail price shown at the store.  Price can be different than Home Office Retail.  Store updates required if there is a difference
Home Office Retail = HO Retail  Retail price set by the Walmart home office
Void Store has no record of the item being in the store. This item will show as an out of stock until it has a record of it scanning into the store
Out of Stock - OOS The item has been in the store and is out of inventory.  Not on the shelf.
Typically, after 6 weeks of an item being out of stock and /or no record of being in the store, the item will convert back to a 'void'.
Negative On Hands = Out of Stock.  Work with the store/department manager to correct inventories
Modular Flag - M (Current) DSD states (Type 7) use the Mod Flag from Retail Link to track authorized stores (Traited/Valid not applicable for DSD Item Numbers) 
Negative On Hands- Neg OH Negative On Hand units is considered 'out of stock'.  The distributor/supplier will need to work with the store/dept. manager to have the inventory audited and updated.  In states that require a forecast, you will need to get this rectified in order for the system to generate the forecast and get the items into the store. 
Forecast Walmart must initiate a forecast for all stores located in a warehouse and control state; type 20 and 37 in order for it to be delivered and accepted at a store.  The forecast is generated organically by the rate of sale in Retail Link.  It picks up sales and formulates the forecast.  If you do not have a forecast for an item in the required states, work with the Walmart replenishment team to get the forecast, especially for new items.
Zero Forecast - ZeroFcst  
Zero On Hand Zero On Order - ZeroOHOO Applicable to whse and control state.  Not applicable to DSD, type 7 states
No Movement - NoMvmt The store has on hand units but no sales for that item for 4+ weeks
Valid - V Valid' is used in warehouse states, type 20 and 37 to flag items that are authorized/active items by Walmart's home office AND the store manager has accepted this item. 
The store manager has the autonomy to turn items off at the store even though they have been authorized (traited) at the Home office.  
Traited - T A Trait flag (T) is used in warehouse states, types 20 and 37.  It is used to flag authorized or active items in the store. Walmart's home office recognizes this as an accepted or approved item for warehouse states.
Store Count Store count is the number of stores that the item has sold within the selected timeframe.  It is not the same as a POD.
Markup is the amount added to the cost price to determine the selling price. Calculated by (store retail - store cost)/store cost
Minimum Markup is applicable for states that have a mandated minimum mark up
Margin Margin is the difference between retail and cost.  Calculation: (store retail-store cost)/store retail
Cost  Cost of the unit sold to Walmart
TimeFrames:  
Current Week Current Week.  WM Week = Saturday - Friday
Last Week Full version of the WM week end
Last 4 Weeks Last 4 full weeks of the WM week end
Last 13 Weeks Last 13 full weeks of the WM week end
Last 26 Weeks Last 26 full weeks of the WM week end
Last 52 Weeks Last 52 full weeks of the WM week end
Calendar WTW Calendar Week to Week
FYTW Fiscal Year to Week
Full FY Full Fiscal Year
CYTW Calendar Year to Week
Supplier FYTW Supplier Fiscal Year to Week
Supplier Full FY Supplier Full Fiscal Year
FMTW Fiscal Month to Week
FQTW Fiscal Quarter to Week 
Average Units per Store per wk -Avg U/Str Velocity.  Accounted for weeks with and/or without 0's.  Without zeros, is not factoring weeks that item was not sold or there was no inventory. 
Average $ per store per week -Avg $/Str Velocity.  Accounted for weeks with and/or without 0's.  Without zeros, is not factoring weeks that item was not sold or there was no inventory. 
On Hands - OH The number of units that are on the shelf or in the store.  
Order Book - OB Applicable to whse and control state.  Not applicable to DSD, type 7 states
In Transit - IT Applicable to whse and control state.  Not applicable to DSD, type 7 states
OOS Lost Sales Calculation *The calculation is taking each specific item/store combination, dividing last 4-week units (or sales) sold by the days on hand the last 4 weeks, then multiplying by the # of days out of stock for the current week.
*The lost sales or lost units evaluates each item/store combination to determine the impact it has by being out of stock for a single day.
Trait Description Definition 
Item Numbers

A Walmart-generated number is assigned to a distributor for a particular UPC.

The item number identifies the distributor who will be delivering an item.

Item Numbers give the ability to:

1. Track whom to pay for deliveries

2. Independent pricing

3. Sales reporting by the distributor

 

9L Case Equivalence          

The calculation for 9L is to multiply the units by the unit of measure and divide by 9,000. 

=(750ml*8,401 units)/9,000 = 700..8 9L case equivalent

SWAS Store within a Store.  

FET

Front End Transformation

ATS

Available to Sell

CRP

Current Replenishment Pricing

OND

Timeframe to include October, November, and December (can be SOND to include September)

WOS

Weeks on shelf

SPPD

Sales Per Point of Distribution

VAP

Value Added Package.  Use filters on the right to identify.  Type 7 

Index Avg $ per store relative to other stores nationally for that selection