walmart.xlsx

	A	B	C	D	E	F	G	H
1	Attribute Name	Definitions	Product Type	Example Values	Min Characters	Max Characters	Min Number of Values	Recommended Number of Values

2	Academic Institution	Name of College or other school. This is to distinguish the school from its sports team.	T-Shirts	Stanford University; California State University, Berkeley; MIT	1	100	0	n/a
3	Additional Image URL	Secondary images of the item. File Format: JPEG (.jpg). Recommended Pixel Dimensions: 2200px x 2200px. Minimum Pixel Dimensions for Zoom 1500px x 1500px. Resolution: 300 ppi. Maximum file size: 5MB. Aspect Ratio: 1:1 (Square). Recommended File Naming: GTIN-14 digit Image URLs should end in an image file type (.jpg) to follow best practices. They must link to a public image file that loads as an image	T-Shirts	n/a	1	2500	0	5
4	Assembled Product Depth - Measure	The depth of the fully assembled product. NOTE: This information is shown on the item page as length of the product.	T-Shirts	5;10;16;22	1	16	0	n/a
5	Assembled Product Depth - Unit	The depth of the fully assembled product. NOTE: This information is shown on the item page as length of the product.	T-Shirts	5;10;16;22	1	16	0	n/a
6	Assembled Product Height - Measure	The height of the fully assembled product.	T-Shirts	5;10;16;22	1	16	0	n/a
7	Assembled Product Height - Unit	The height of the fully assembled product.	T-Shirts	5;10;16;22	1	16	0	n/a
8	Assembled Product Weight - Measure	The weight of the fully assembled product.	T-Shirts	1.75;5;12;32	1	16	0	n/a
9	Assembled Product Weight - Unit	The weight of the fully assembled product.	T-Shirts	1.75;5;12;32	1	16	0	n/a
10	Assembled Product Width - Measure	The width of the fully assembled product.	T-Shirts	5;10;16;22	1	16	0	n/a
11	Assembled Product Width - Unit	The width of the fully assembled product.	T-Shirts	5;10;16;22	1	16	0	n/a
12	Brand License	A brand name that is not owned by the product brand, but is licensed for the particular product. (Often character and media tie-ins and promotions.) It can also be another brand or a celebrity.	T-Shirts	EV1;Signature;Life is Good;Harley Davidson;Michael Jordan;Disney	1	4000	0	n/a
13	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. See the portions of the California Health and Safety Code related to Proposition 65 to see what products require labels and to verify the text of your warning label. If no Prop 65 warning please leave value blank for this attribute.	T-Shirts	For Example: This product can expose you to chemicals including [name of one or more chemicals], which is [are] known to the State of California to cause [list associated harm(s) e.g. cancer, birth defects or other reproductive harm, etc].	1	5000	0	n/a
14	Character	A person or entity portrayed in print or visual media. A character might be a fictional personality or an actual living person.	T-Shirts	Batman;Dora the Explorer;Hello Kitty;Jojo Siwa;Minnie Mouse;Power Rangers;Wonder Woman;SpongeBob SquarePants;Mario;Pac-Man;Elsa;Spider-Man	1	50	0	n/a
15	Character Group	Character group name or fictional team name as they appear in a media product.	T-Shirts	X-Men;Transformers;The Lion King;My Little Pony;Disney Inside Out;Avengers;Angry Birds;Disney Princesses;Delta Squad;Frozen;Trolls;Minecraft;Justice League	1	50	0	n/a
16	Closure Type	The type of fastener used to keep a garment closed on the wearer and to facilitate putting on the garment.	T-Shirts	n/a	n/a	0	0	n/a
17	Clothing Feature	Clothing feature has been created to source more dominate value needs in customer experience specific to fashion garment items; that are not valid for more category wide features attribute. Similar in production of specific features attributes: bag/case features; electronic features; wallet features; Bra features;Clothing product features are the various characteristics, design features, and elements that make up the product. In fashion, product features can include texture/surface treatment, silhoulette, garment or fabric construction, and specialized features.;THE FEATURES OF APPAREL: There are different features or elements an apparel product that distinguish it. These features can be changed or altered in the product development process in order to meet the brand's merchandising needs.	T-Shirts	n/a	n/a	0	0	n/a
18	Clothing Fit	Terms that describe the way a garment will fit when worn.	T-Shirts	n/a	n/a	0	0	n/a
19	Clothing Occasion	An specific occasion which a piece of apparel may be used for	T-Shirts	n/a	n/a	0	0	n/a
20	Clothing Shoulder Style	The overall style of the shoulder area of a garment	T-Shirts	n/a	n/a	0	0	n/a
21	Designer	Name of the person who planned the form, look, or workings of the product to be made or built.	T-Shirts	Tommy Hilfiger; Calvin Klein; Vera Wang; Coco Chanel	1	400	0	n/a
22	Embellishment Type	Decorative, non-functional ornamentation/embellishment that enhances an item's appearance, such as bows, fringe, or sequins. Descriptive terms for an embellishment on the item.	T-Shirts	n/a	n/a	0	0	n/a
23	Fabric Construction	Describes the overall construction of the fabric element of the product (e.g. knit, woven).	T-Shirts	n/a	n/a	0	0	n/a
24	Frame Color Configuration	Describes the frame color configurations available through the third party partner. This is not a Walmart variant.	T-Shirts	Black; Brown; Silver	1	40	0	n/a
25	Front End Photo Partner	Name of the partner that hosts the website or application where customers will find the Photo item	T-Shirts	n/a	n/a	0	0	n/a
26	Manufacturer Name	The name of the manufacturer.	T-Shirts	Procter & Gamble; Apple; Sony; General Motors; Yamaha	1	60	0	n/a
27	Manufacturer Part Number	MPN uniquely identifies the product to its manufacturer. For many products this will be identical to the model number. Some manufacturers distinguish part number from model number. Having this information allows customers to search for items on the site and informs product matching.	T-Shirts	5061025; TSR-1002; 4-40-3/4-pan-phil	1	60	0	n/a
28	Maximum Order Quantity	The maximum number of items a customer can order. This maximum limit defines the quantity tiers for Walmart Photo products.	T-Shirts	20;100;1000	1	17	0	n/a
29	Minimum Order Quantity	The minimum number of items a customer can order. This minimum limit defines the quantity tiers for Walmart Photo products.	T-Shirts	1;5;20	1	17	0	n/a
30	Model Number	Model numbers allow manufacturers to keep track of each hardware device and identify or replace the proper part when needed. Model numbers are often found on the bottom, back, or side of a product. Having this information allows customers to search for items on the site and informs product matching.	T-Shirts	G62-465DX; MFP00112BBQN	1	60	0	n/a
31	Net Content Statement	Complete product net content statement, as it appears on product packaging.	T-Shirts	6 - 5.3 OZ (150g) CUPS;1.98 Lb (900g)	1	500	0	n/a
32	Number of Pieces	The number of small pieces, slices, or different items within the product. Piece Count applies to things such as puzzles, building block sets, and products that contain multiple different items (such as tool sets, dinnerware sets, gift baskets, art sets, makeup kits, or shaving kits.) Examples: A gift basket of 5 different items has a “Piece Count” of 5.; A 105-Piece Socket Wrench set has a "Piece Count" of 105.; A 500-piece puzzle has a “Piece Count” of 500.	T-Shirts	5;105;500	1	17	0	n/a
33	Paper Finish Configuration	Names of paper configurations that are available for third party partners. These are not Walmart variants, this information is passed through to the third-party partner.	T-Shirts	n/a	n/a	0	0	n/a
34	Pattern	Decorative design or visual ornamentation, often with a thematic, recurring motif.	T-Shirts	Herringbone, Houndstooth, Letter Print, Paisley, Geometric, Fruits, Floral, Plaid, Checkered, Solid, Jacquard; Animal Print, Chevron, Polka Dots, Stars, Moire, Striped, Argyle, Cartoon, Camouflage, Hearts	1	400	0	n/a
35	Personal Relationship	Descriptive terms for the roles people have in each other's lives, commonly centered on family or romance.	T-Shirts	n/a	n/a	0	0	n/a
36	Photo Accessory Item SKU	This is the identifier (SKU) that is collected from the Vendor to handle the accessory items (e.g. extra book pages, card envelopes).	T-Shirts	WJ_CW4152615213-9	1	50	0	n/a
37	Photo Configuration Attribute Names	Designate all attributes for which the item has configurations.	T-Shirts	n/a	n/a	0	0	n/a
38	Photo Item Store WUPC	The Walmart UPC for a Walmart Store item that is equivalent to the Walmart.com photo item	T-Shirts	648127739405	1	15	0	n/a
39	Photo Order Quantity Tier	Merchant-defined quantity tiers related to delivery method and most commonly used for photo prints.	T-Shirts	1; 2	1	17	0	n/a
40	Product Line	Product lines exist as a sub-structure of brands and, frequently, as a super-structure of models.	T-Shirts	501 Original;Gwen;Cool Comfort;Purple Label;Paradise Bay	1	400	0	n/a
41	Recycled Material Content - Percentage of Recycled Material	Corresponding percentage of the recycled material used to create the item. Used in conjunction with Recycled Material attribute.	T-Shirts	30;40	1	16	0	n/a
42	Recycled Material Content - Recycled Material	Type of recycled material used to create the item.	T-Shirts	Bamboo; Cotton; Glass; Plastic	1	4000	0	n/a
43	Retail Packaging	Descriptive terms for the way a product is packaged for sale to the customer.	T-Shirts	n/a	n/a	0	0	n/a
44	Sleeve Style	Descriptive terms for the style of garment sleeves. Does not include descriptive terms for sleeve length (which appear under the Sleeve Length Style attribute).	T-Shirts	n/a	n/a	0	0	n/a
45	Sports League	If your item has any association with a specific sports league, enter the league name. Abbreviations are fine. NOTE: This attribute flags an item for inclusion in the online fan shop.	T-Shirts	NFL;WWE;MLB;NBA;NASCAR;USA Archery	1	100	0	n/a
46	Sports Team	If your item has any association with a specific sports team, enter the team name. NOTE: This attribute flags an item for inclusion in the online fan shop.	T-Shirts	San Jose Earthquakes;San Jose Sharks;Golden State Warriors;Las Vegas Raiders;San Francisco 49ers;San Francisco Giants;Stanford Cardinal;Oakland Athletics	1	200	0	n/a
47	T-Shirt Type	Specifies the type of T-Shirt for the item	T-Shirts	n/a	n/a	0	0	n/a
48	Theme	A dominant idea, meaning, or setting applied to an item.	T-Shirts	Animal;Jungle;Princess;Desert;Unicorns; Hawaiian,Religious;Retro;Carnival;Space;Hollywood;Rocker;Beach;New York City;Multi-theme; Resort	1	800	0	n/a
49	Third Party Accreditation Symbol on Product Package Code	The code representing a symbol or marking third party accreditation on the product package.	T-Shirts	n/a	n/a	0	0	n/a
50	Warranty Text	Warranty Text (the full text of the warranty terms, including what is covered by the warranty and the duration of the warranty). NOTE: please remember to update the text of your warranty as your warranty changes.	T-Shirts	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.	1	20000	0	n/a
51	Warranty URL	The Warranty URL is the web location of the image, PDF, or link to the manufacturer's warranty page, showing the warranty and its terms, including the duration of the warranty. URLs must begin with http:// or https:// NOTE: Please remember to update the link and/or text of the warranty as the warranty changes. If supplying an image, provide the final destination image URL (no-redirects) that is publicly accessible (no username/password required) and ends in a proper image extension. Recommended file type: JPEG Accepted file types: JPG, PNG, GIF, BMP Maximum file size: 5 MB.	T-Shirts	http://www.walmart.com/warranty_info.pdf	1	2500	0	n/a
52	Product Name	Title of the product to be displayed on the Item Page. Your title should ideally be under 90 Characters, Maximum 100 Characters. Anything over 90 characters will negatively impact your Search Engine Optimization (SEO).	T-Shirts	Jockey Essentials Durable Cotton Crew Neck T-shirt, 3 Pack (Men's & Men's Tall)	10	199	0	n/a
53	Brand Name	The name provided by the brand owner that is intended to be recognized by the consumer as represented on the product. If item does not have a brand, use "Unbranded". This should be the brand ONLY, not brand + product line. Make sure brand name is spelled, punctuated & capitalized properly according to the brand itself.	T-Shirts	Under Armour;Levi's;Adidas;Ralph Lauren	1	60	0	n/a
54	Site Description	Overview of the key selling points of the item, marketing content, and highlights in paragraph form. For SEO purposes, repeat the product name and relevant keywords here.	T-Shirts	A must-have wardrobe essential in every woman should have, get ready for spring with these Athletic Works Women’s Core Active V-neck T-shirts 2-packs. These semi-fitted V-neck short-sleeve tees have a simple yet stylish look that is perfect for the gym or day-to-day activities. The sueded fabric made from recycled polyester and spandex gives it a soft and luxurious feel great for layering on those cooler nights outdoors and great freedom of movement in any activity. With moisture-wicking fabric, you’ll be dry and comfortable all day long, making it ideal for a wide range of activities. With a fun assortment of colors that you can mix and match, it will be no surprise these will be your favorite “go-to” tees. This spring, you definitely can’t go wrong with these Athletic Works Women’s Core Active V-neck T-shirt 2-Pack	1	100000	0	n/a
55	Key Features	Key features will appear as bulleted text on the item page and in search results. Key features help the user understand the benefits of the product with a simple and clean format.	T-Shirts	• Online Exclusive 2-Pack;• 92% Recycled Poly/8% Sueded Spandex;• Grey Heather- 46% Recycled Poly/46% Poly/8% Sueded Spandex;• Short Sleeve;• Moisture Wicking Technology;• Semi-fitted;• Size XS to XXXL;• Machine Washable	1	10000	3	6
56	Main Image URL	Main image of the item. File Format: JPEG (.jpg). Recommended Pixel Dimensions: 2200px x 2200px. Minimum Pixel Dimensions for Zoom 1500px x 1500px. Resolution: 300 ppi. Maximum file size: 5MB. Aspect Ratio: 1:1 (Square). Recommended File Naming: GTIN-14 digit Image URLs should end in an image file type (.jpg) to follow best practices. They must link to a public image file that loads as an image	T-Shirts	n/a	1	2500	0	n/a
57	Count Per Pack	The number of identical items inside each individual package given by the "Multipack Quantity" attribute. Examples: (1) A single bottle of 50 pills has a "Count Per Pack" of 50. (2) A package containing two identical bottles of 50 pills has a "Count Per Pack" of 50. (3) A 6-pack of soda labeled for individual sale connected by plastic rings has a "Count Per Pack" of 1. (4) A 6-pack of soda in a box whose cans are not marked for individual sale has a "Count Per Pack" of 6. (5) A gift basket of 5 different items has a "Count Per Pack" of 1.	T-Shirts	1;2;10;50	1	10	0	n/a
58	Total Count	The total number of identical items in the package or box; a result of the multiplication of Multipack Quantity by Count Per Pack. Examples: (1) A single bottle of 50 pills has a "Total Count" of 50. (2) A package containing two identical bottles of 50 pills has a "Total Count" of 100. (3) A gift basket of 5 different items has a "Total Count" of 1.	T-Shirts	1;50;100	1	17	0	n/a
59	Multipack Quantity	The number of identical, individually packaged-for-sale items. If an item does not contain other items, does not contain identical items, or if the items contained within cannot be sold individually, the value for this attribute should be"1." Examples: (1) A single bottle of 50 pills has a "Multipack Quantity" of"1." (2) A package containing two identical bottles of 50 pills has a "Multipack Quantity" of 2. (3) A 6-pack of soda labelled for individual sale connected by plastic rings has a "Multipack Quantity" of"6." (4) A 6-pack of soda in a box whose cans are not marked for individual sale has a "Multipack Quantity" of"1." (5) A gift basket of 5 different items has a "Multipack Quantity" of"1."	T-Shirts	1;2;4;6	1	4	0	n/a
60	Is Prop 65 Warning Required	Selecting "Yes" indicates the product requires California's Proposition 65 special warning. Proposition 65 entitles California consumers to special warnings for products that contain chemicals known to the state of California to cause cancer and birth defects or other reproductive harm if certain criteria are met (such as quantity of chemical contained in the product). See the portions of the California Health and Safety Code related to Proposition 65 for more information.	T-Shirts	n/a	n/a	0	0	n/a
61	Age Group	A general grouping of ages into commonly used demographic labels. • Infant, 0-1 • Toddler, 1-3 • Child, 4-10 • Tween, 11-13 • Teen, 14-17 • Adult, 18-64 • Senior, 65+	T-Shirts	n/a	n/a	0	0	n/a
62	Clothing Neck Style	A garment's neckline or neck style.	T-Shirts	n/a	n/a	0	0	n/a
63	Clothing Size	Clothing size as it appears on the garment label. Use this attribute for general sizes (S, M, L) as well as general numbered sizes (2, 4, 6, etc). For items that have unique sizes (dress shirts, bras, etc.) use the specific size attribute.	T-Shirts	One Size;2;22;10-12;XXS;M;M-L;2XL;3X;2T;4T-5T;4XLT;4P;29R;1XP;10 Slim;M Petite;2XL Plus;14/16 Plus;20 Plus;15 Husky;9 Months;18-24 Months	1	17	0	n/a
64	Clothing Size Group	The common sizing groups used by the retail clothing industry.	T-Shirts	n/a	n/a	0	0	n/a
65	Clothing Style	Styles and designations that apply generally to various types of clothing.	T-Shirts	n/a	n/a	0	0	n/a
66	Clothing Top Style	Style terms descriptive of clothing tops.	T-Shirts	n/a	n/a	0	0	n/a
67	Color	Color refers to the actual color defined by the manufacturer. For Example, an item may be gray and black (which are used in the Color Category attribute) but the manufacturer calls the color Space Gray.	T-Shirts	Jet Black;Black;Blue;Aqua;Lime Green;Silver;Black/Red	1	600	0	n/a
68	Color Category	Select the color from a short list that best describes the general color(s) of the item. This improves searchability as it allows customers to view items by color from the left navigation when they perform a search. Please list all colors for the item. If the item has more than one color, please select Multi-color in addition to primary colors. Don’t list more than the three main colors.	T-Shirts	n/a	n/a	0	0	n/a
69	Condition	This refers to the state of an item, indicating its level of wear, prior use (if any), appearance, and overall quality. Availability of condition types may vary by product/category as well as by Seller eligibility per program. For more details, review this Help article: https://sellerhelp.walmart.com/seller/s/guide?language=en_US&article=000011205.	T-Shirts	n/a	n/a	0	0	n/a
70	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.)	T-Shirts	Dry Clean Only; Machine Washable; Hand Wash; Do Not Bleach; Do Not Dry Clean; Machine Wash Cold; Tumble Dry, Low Heat	1	5000	0	n/a
71	Fabric Content - Fabric Material Name	A list of every major constituent fiber by percentage using its generic name, as is legally required for yarns, fabrics, clothing and other household items.	T-Shirts	Organic Cotton; Jute; Nylon; Fleece;Wool;Fur;Faux Fur;Sequin	1	4000	0	n/a
72	Fabric Content - Fabric Material Percentage	The percentage of each fiber within the garment.	T-Shirts	20;60;75;95	1	16	0	n/a
73	Gender	Indicates whether this item is meant for a particular gender or meant to be gender-agnostic (unisex).	T-Shirts	n/a	n/a	0	0	n/a
74	Has Written Warranty	Indicates an item has written warranty documentation included on the product label, inside the product packaging, or a website URL or PDF available for customer review. Pursuant to California Civil Code Section 1793.01 (The Song-Beverly Consumer Warranty Act), an express warranty for consumer goods sold within California must not commence earlier than the date of delivery of the item to the consumer. If applicable, please review and update the warranty terms for this item.	T-Shirts	n/a	n/a	0	0	n/a
75	Net Content - Measure	The numeric net content portion that appears on an item. Please Note: If your item includes multiple items with the same UOM, add them together to get the total measurement. If the item is a set with multiple items that do not share the same UOM, list as 1 Each.	T-Shirts	1;12;32	1	16	0	n/a
76	Net Content - Unit	The unit of measure as defined on the product labeling. For example, a gallon of milk has 128 Fluid Ounces: Measure = 128 and Units = Fluid Ounces. Please Note: If your item includes multiple items with the same UOM, add them together to get the total measurement. If the item is a set with multiple items that do not share the same UOM, list as 1 Each.	T-Shirts	n/a	n/a	0	0	n/a
77	Sleeve Length Style	Descriptive terms for sleeve length.	T-Shirts	n/a	n/a	0	0	n/a
78	Small Parts Warning Code	To determine if any choking warnings are applicable, check current product packaging for choking warning message(s). Please indicate the warning number (0-6). 0- No warning applicable; 1- Choking hazard is a small ball; 2- Choking hazard contains small ball; 3- Choking hazard contains small parts; 4- Choking hazard balloon; 5- Choking hazard is a marble; 6- Choking hazard contains a marble.	T-Shirts	n/a	n/a	0	0	n/a
79	Zippered	(Y) for Yes, if product has a zipper fastener feature. (N) for No, if it does not have a zipper fastener feature.	T-Shirts	n/a	n/a	0	0	n/a
80	Variant Group ID	Required if item is a variant. Make up a number and/or letter code for "Variant Group ID" and add this to all variations of the same product. Partners must ensure uniqueness of their Variant Group IDs.	T-Shirts	HANESV025	1	300	0	n/a
81	Variant Attribute Names	The designated attribute by which an item is varying.	T-Shirts	n/a	n/a	0	0	n/a
82	Is Primary Variant	Note whether item is intended as the main variant in a variant grouping. The primary variant will appear as the image when customers search and the first image displayed on the item page. This should be set as "Yes" for only one item in a group of variants.	T-Shirts	n/a	n/a	0	0	n/a
83	Swatch Images - Swatch Variant Attribute	Attribute name corresponding to the swatch.	T-Shirts	n/a	n/a	0	0	n/a
84	Swatch Images - Swatch Image URL	URL of the color or pattern swatch image. This is required for products with visual variations and will be shown as a small circle on the item page. File Format: JPEG (.jpg). Recommended Pixel Dimensions: 100px x 100px. Resolution: 300 ppi. Maximum file size: 5MB. Recommended File Naming: GTIN-14 digit. Provide the final destination image URL (no-redirects) that is publicly accessible (no username/password required.)	T-Shirts	http://www.walmart.com/somepath/some-image.jpg	1	2500	0	n/a
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100