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 |