Glossary of Attributes

Updated 9 months ago ​by Merch Transformation Change Management

When you create a read-only Custom Export spreadsheet, you can select attributes to download from four groups:

  • Supply Item
  • Pack Configuration
  • Product
  • Cost

Open the Attributes drop-down menu and select the attributes you want to download.

Use the Find function in your browser to locate a specific attribute in the table below. Or, download the Glossary in Excel.

Supply Item Attributes

Attribute Name

OIF Name

Definition

Valid Values

Examples

Factory ID

Factory ID

The Walmart Factory ID of the factory where the item will be manufactured (for items requiring factory disclosure to Walmart).

Factory IDs can be obtained by disclosing factory information in Supplier Profile on Retail Link.

28024126

Has RFID

Indicates if the item has an RFID device that allows its location to be tracked and how long it has been there.

Yes; No

No

Has Security Tag

Indicates if an item is secured via an electronic tag provided by the merchandise supplier. The tag is meant to be deactivated at the register.

Yes; No

No

Is Oversized

Indicates if the item has at least one dimension greater than 50 inches and/or a weight greater than 150 pounds.

Yes; No

Yes

MSRP

Mfgr Suggested Retail

The manufacturer's suggested retail price, which is visible to customers through product labeling or in the content description. The retail price presented from Walmart should not exceed the MSRP.

The price with 2 digits right of the decimal and no commas or dollar sign

19.95

Order Sizing Factor Quantity

Order Sizing Factor Quantity

A trade item specification other than gross, net weight, or cubic feet for a line trade item or transaction. The quantity is used in conjunction with the unit of measure for order sizing and pricing purposes.

3

Pallet Size Type

Pallet Size

Indicates whether the Supplier's pallet size is small or large, where small is 3 feet x 3 feet and large is 4 feet x 4 feet.

Small; Large

Small

Special Consideration Code

Indicates whether an item requires special consideration for receipt, internal shipment, or display.

1 - High Demand Items

2 - Retail Price Exceeds $5000

3 - High Theft Items

4 - Lock Required Items

1

Special Handling Instruction

Special Handling Instruction

Indicates whether there are instructions on how to handle the product through the shipment and delivery processes. E.g., Instructions for the type of pallet base used: Chep Pallet, Slip Sheet, etc.

Chep Pallet

Supplier Stock Number

Supplier Stock Number

The number that appears on the Walmart in-store shelf label to identify the product to the customer. Also used by Walmart supply chain.

128475657

Pack Configuration Attributes

Attribute Name

OIF Name

Definition

Valid Values

Examples

Contained Battery Type

Battery Type

Indicates whether any component of the item, including reusable packaging, contains a battery. If yes, select the battery type.

If battery type is lead acid, lead acid (nonspillable), lithium ion, or lithium metal, the item requires a hazardous materials risk assessment through WERCS.

Does Not Contain a Battery; Alkaline; Carbon Zinc; Lead Acid; Lead Acid (Nonspillable); Lithium Primary (Lithium Metal); Lithium Ion; Magnesium; Mercury; Nickel Cadmium; Nickel Metal Hydride; Silver; Thermal; Other; Multiple Types

Lithium Ion

Country of Origin - Components / Ingredients

The country where the item components or raw materials were sourced.

2-letter country code

AE

Trade Item Net Weight

Defines the net weight of the supplier pack case. This includes the weight of the case packaging.

Unit: Pounds

Measure: 15

Unit: Pounds

Product Attributes

Attribute Name

OIF Name

Definition

Valid Values

Examples

Active Ingredients: Name, Percentage

The list of active ingredients in order of potency, as shown on the item label.

Name: Luminum zirconium tetrachlorohydrex gly

Percentage: 20

Additional Image URL

A URL to a secondary (aka additional) image of the item. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name. Read about image recommendations.

http://www.somedomain.com/somepath/sideview.jpg

Age Range: Range Minimum, Range Maximum

The minimum and maximum ages for a product. Both should be the same unit of measure (e.g., months, years).

Range Minimum: 12

Range Maximum: 18

Assembly Instructions

A URL to an image or PDF showing assembly instructions (if required). It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.somedomain.com/somepath/some-image.jpg

Baby Clothing Size

The size/size range for infant and toddler clothing. Sometimes expressed as age or weight.

Preemie; Newborn; One Size; 0-3 Months; 3-6 Months; 6-12 Months; 12-18 Months; 18-24 Months; 2T; 3T; 4T; 5T; S; M; L; XL

0-3 Months

Book Format

The physical or digital format of a book.

  • For eBook, also use the digital file format (e.g., exe, pdf, zip, etc.).
  • For Audiobook, also use the digital audio file format (e.g., mp3, aiff, etc.)
  • If Audiobook or eBook will not be delivered online (e.g., audio CD, USB stick, etc.), fill in the Physical Media Format.

Audio CD; Audio Download; Audiobook; Board Book; Braille; HTML; Hardcover; Library Binding; Mass Market Paperback; Other; PDF; Paperback; Trade Paperback; eBook

Paperback

Brand

The name, term, design, or other feature that distinguishes one seller's product from others. Can be, but is not always, the name of the company associated with the product. If the item does not have a brand, enter "Unbranded" for the value.

HP; Toshiba; Tide; M&Ms; Hanes; La-Z-Boy; Unbranded; etc.

Tide

CPSC-Regulated Indicator

Indicates that an item is likely to be regulated by the Consumer Product Safety Commission (CPSC) if it is not found on this list.

Yes; No

Yes

California Prop 65 Warning Text

This is a particular statement legally required by the State of California for certain products to warn consumers about potential health dangers.

Refer to the portions of the California Health and Safety Code related to Proposition 65 to see which products require labels and to verify the text of your warning label. If no warning is needed, then enter "None".

WARNING: This product contains chemicals known to the State of California to cause cancer and birth defects or other reproductive harm.

Clothing Size

The size as it appears on the garment label. Not used for items that have unique sizes, e.g., dress shirts, bras.

S; M; L; 2; 4; 6; One Size Fits All

S

Clothing Size Group

The common size group used by the retail clothing industry.

Big; Big & Tall; Boys; Girls; Girls' Plus; Husky; Infant; Junior Plus; Juniors; Maternity; Maternity Plus; Men; Newborn; Petite; Petite Plus; Plus; Regular; Short; Tall; Toddler; Women; Young Men's

Boys

Color

The color as described by the manufacturer.

Sky Blue

Country of Origin - Textiles

Indicates the origin where the item was manufactured and where the material is from.

  • Imported - Made completely outside the U.S. with materials from outside the U.S.
  • USA and Imported - Made (completely or partly) in the U.S. with materials from outside the U.S.
  • USA or Imported - Some units/materials of the item were made in the U.S. and some were made outside the U.S.
  • USA - Made completely in the U.S. with materials from the U.S.

Imported

Drug Facts Label Image

A URL to an image showing the drug facts label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.example.com/drug_facts.jpg

Dubbed Languages

The language(s) that a film has been dubbed with.

Spanish

ESRB Rating

The rating as provided by the Entertainment Software Rating Board.

Adult; Early Childhood; Everyone; Everyone 10+; Mature; Pending; Teen; Unrated

Teen

Energy Guide Label Image URL

A URL to an image showing the energy guide label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://walmart.com/energy_guide_label.jpg

Fabric Care Instructions

Describes how the fabric should be cleaned.

Enter details of the fabric care label found on the item. (For garments, typically located inside on the top of the back or the lower left side.)

Dry Clean Only; Machine Washable; Hand Wash

Fabric Content: Material Name, Material Percentage

The material makeup of the item.

Denim; Organic Cotton; Silk; Suede; Khaki; Jersey; Vinyl; Sateen; Fleece; Linen; Microfiber; Nylon; Polyester; Satin; Wool; Chintz

Material Name: Fleece

Material Percentage: 100

Gender

Indicates whether the item is meant for a particular gender or meant to be agnostic.

Male; Female; Unisex

Male

Has Fuel Container

Indicates whether the item has an empty container that may be filled with fuel, e.g., gasoline, CO2, propane.

Yes; No

Yes

Ingredients List Image

A URL to an image showing the ingredients list label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.example.com/ingredients_label.jpg

Ingredients Text

A list of all ingredients in an item, as found on the product label mandated by FDA guidelines and in descending order by weight.

Refer to the FDA Food Labeling Guide for more details.

Yams; Sugar; Carbonated Water; Natural Flavors

Is Variety Pack

Variety Pack Ind

Identifies assorted items that will share one UPC and be shipped in the same box (not an assortment).

Yes; No

Yes

Key Features

An item's feature benefits, which will appear in bulleted text form on the item page and in search results.

We highly recommend providing three or more Key Features per item. There are two ways that you can enter the values:

  • In one Key Features column with each value inside HTML tags
  • Across multiple Key Features columns with one value per column
  • Shelves
  • Ramps
  • Casters
  • Slide-out tray included

Lighting Facts Label Image URL

A URL to an image showing the lighting facts label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name. Label must include brightness specified lumens, estimated energy cost per year, life, light appearance, scale, energy used, and special handling information needed for disposal, as outlined by the FTC.

http://www.example.com/lighting_label.jpg

MPAA Rating

The rating provided by the Motion Picture Association of America as a guide to the appropriate age group for a piece of media.

G; PG; PG-13; R; NC-17; Not Rated

PG

Manufacturer

The name of the company that makes or produces the product. The manufacturer and brand may differ or be the same, depending on the product.

Procter & Gamble; Apple; Sony; General Motors; Yamaha; etc.

Sony

Must ship alone?

Indicates whether the item cannot be shipped with another item in the same box. If Yes, the item will not be grouped for ship price calculation.

Yes; No

No

Nutrients: Name, Amount, Percentage Daily Value, Footnote

A list of additional nutrients, not including total fat or total carbohydrates because they are separate attributes.

Name:

Amount:

Percentage Daily Value:

Footnote:

Nutrition Facts Label Image URL

A URL to an image showing the nutrition facts label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.somedomain.com/filelocation/image.jpg

Nutrition Ingredients Image URL

A URL to an image showing the nutrition ingredients label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://company.com/filelocation/image.jpg

Physical Media Format

The physical form in which the customer receives the product.

printed media; USB stick; DVD; Blu-Ray; CD; LP; VHS Tape; miniDV Tape; 8-Track Tape; Cassette Tape

Blu-Ray

Power Type

Indicates the type of power used by the item, e.g., electric, batteries.

Electric

Product Category

The IronBank Universal Product Category and Subcategory used to organize and define products.

Animal Accessories

Product Name

The product title that is displayed on the Item Page. The standard format is: Brand + Defining Qualities + Item Name + Pack Count (if applicable).

Hanes Men's V-Neck Tees, 3-Pack

Recycled Material Content: Material, Percentage

The percentage of all recycled material used to produce the item, if it or its packaging contains reused/recycled material. Can also include specific material composition, e.g., 30% recycled cotton fabric.

Material: Cotton

Percentage: 30

Ships in Original Packaging

Indicates whether it's possible, not required, to ship the item in its original packaging without being put in an outer box.

Yes; No

Yes

Shoe Size

The alphanumeric representation of the size of the shoe, as issued by the manufacturer.

US 7.5

Site Description

An overview of the key selling points of the item, marketing content, and highlights in paragraph form. For SEO purposes, include the product name and relevant keywords.

The George - Girls' Short Sleeve Polo Shirt will make a great addition to your daughter's uniform wardrobe. This short-sleeved girls' shirt has a flat knit collar and cuff for a comfortable fit. Plus, it's tagless, so your daughter's skin won't be irritated by a scratchy tag. This girls' short sleeve polo is made from a cotton blend, and treated with Scotchgard for stain protection. It has a two-button placket, an extended back hem and vents on each side hem. The girls' polo shirt is machine washable and very easy to maintain.

Site Main Image URL

A URL to the main (aka primary) image of the item. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.somedomain.com/somepath/some-image.jpg

Small Parts Warning Code

Indicates whether any choking warnings are applicable. Check the current product packaging for choking warning message(s).

0 - No warning applicable; 1 - Choking hazard is a small ball; 2 - Choking Hazard contains a small ball; 3 - Choking hazard contains small parts; 4 - Choking hazard is a balloon; 5 - Choking hazard is a marble; 6 - Choking hazard contains a marble

1

State Restrictions: States, ZIP Codes, Restriction Reason

A group of attributes to capture information when your product must and/or should be prohibited from being sold due to a law, regulation, ordinance, etc.

  • States: Select the 2-letter abbreviation for the state or territory
  • ZIP Codes: Enter all applicable ZIP Codes in the selected state or territory
  • Restriction Reason: Provide the reason for the restriction
If your item is restricted in multiple states or territories, copy and paste the "State Restrictions 1 (stateRestrictions)" group of attributes in your spreadsheet and change the number 1 to 2, 3, etc.
  • States: CA
  • ZIP Codes: 94086
  • Restriction Reason: Missing California Prop 65 Warning Label

Subtitled Languages

The language(s) that a film's subtitles have been written in.

English

Supplement Facts Label Image

A URL to an image showing the supplement facts label. It must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image file name.

http://www.example.com/file/supplement_facts.jpg

TV Parental Guidelines Rating

The rating required by the FCC for television shows airing in the U.S.

TV-Y7; Unrated; TV-Y; TV-MA; TV-PG-L; TV-PG; Not Rated; TV-14; TV-G; TV-Y7-FV; TV-PG-V

TV-G

Tire Size

The tire industry's standardized sizing information for the tire.

P225/50R16 91S

Total Count

The total number of identical items in the package or box, i.e., the multipack quantity multiplied by the count per pack.

12

Total Product Shelf Life (days)

The number of days that the product can be stored without becoming unfit for consumption or after which the product is no longer at its best quality.

15

Warranty Text

The full text of the warranty terms, including what it covers and its duration. Be sure to update this text as your warranty changes.

This warranty covers any defects in materials or workmanship, including installation, with the exceptions of fading or discoloration caused by exposure to sunlight or chemicals. This warranty runs for five years from the date your carpet is installed. Counterpoint will either replace your carpet with new carpet of similar composition and price, or refund the full purchase price of your carpet, whichever you prefer. Contact Counterpoint at 800-867-5309.

Warranty URL

A URL to an image or PDF showing the warranty and its terms, including its duration. The URL must be publicly accessible, have no redirects, begin with http:// or https://, and end with the image or PDF file name.

http://www.walmart.com/warranty_info.pdf

Cost Attributes

Cost Attributes

Definitions

Required or Optional

Valid Values

Examples

Orderable Pack Cost (Vendor Pack Cost)

The vendor pack cost or orderable pack cost.

Required

  • Cannot be less than 0
  • Cannot have more than 4 digits right of the decimal

40.9525

Supplier Recommended Retail ($/unit)

The retail price that the supplier is recommending for Walmart.

Optional

  • Cannot be less than 0

10.95

Effective Date

The date that the new cost should start.

Required

  • Must be a future date (i.e., not the date you submit your cost changes or prior)
  • Must be formatted as yyyy-mm-dd

2020-03-01

Expiration Date

The date that the new cost should end (if it is temporary).

Optional

  • Must be a date after the Effective Date
  • Must be formatted as yyyy-mm-dd

2020-05-31

Cost Driver Attributes

Definitions

Required or Optional

Valid Values

Examples

Cost Driver

The reason for the cost change (e.g., transportation, commodity, packaging, etc.).

  • Cost Driver 1: Required
  • Cost Driver 2 & 3: Optional

Packaging: Paperboard

Cost Driver Percent Change

The decrease or increase percentage of the component that is driving the cost change.

Required

  • Must be formatted as a decimal
  • Cannot be less than or equal to -1
  • Cannot be greater than 1

If the cost of an item's paperboard packaging has increased 12%, you would enter: 0.12

Cost Driver Portion of Item Cost

The percent of the new cost that is made up by the cost driver.

Required

  • Must be formatted as a decimal
  • Cannot be less than or equal to 0
  • Cannot be greater than 1

If the new cost of the paperboard packaging makes up 10% of the new cost of the item, you would enter: 0.10

Trade Fund Attributes

Definitions

Required or Optional

Valid Values

Examples

National List Cost ($/unit)

The minimum cost at which the supplier is selling their item to any and all buyers, including Walmart.

Optional

  • Cannot be less than or equal to 0

12.95

Efficiency Discount ($/unit)

The applied discount to the National List Cost as a result of cost savings afforded by increased order quantities.

Optional

  • Cannot be less than 0

5.95

Accrual Rate (%)

The percent of the cost (after Efficiency Discount has been applied) that is accrued as “trade funds” to be re-invested into COGS.

Optional

  • Must be formatted as a decimal
  • Cannot be less than 0

0.15


Was this article helpful?