Click here for instructions on filling out version 2 of the Full Item Spec.
Before you publish an item on Walmart Marketplace, you need to specify the item details during Item Setup. This is called defining the attributes of an item. After you have identified the right category for your item(s), download the relevant Spec and proceed with the defining attributes step. Read through the Item Image Guidelines
and have the image URLs ready.
** Note: This article only explains the common attributes required for Item Setup. There will be compliance attributes and additional required attributes that should be identified and defined based on the category and type of item you are setting up. **
To see a completed Spec, download the zip file at the bottom of the article Sample Item Setup Specs.
1. Product identification attributes
Product Name: Title of the product; will be displayed on the Item Page.
Product ID Type: Unique identifier used in the Product ID field. For example, UPC, GTIN, ISBN, ISSN.
Product ID: Alphanumeric ID that uniquely identifies the item. For example, 758151704024.
SKU: Your item identifier, unique for every item in your catalog. Your SKU must be less than 50 characters.
Brand: Name of the brand.
Manufacturer Part Number: (Optional)
Model Number: (Optional)
** Note: If you ever need to update the SKU or Product ID of your items, you can find detailed instructions in How to Update an Item's SKU and How to Update an Item's Product ID. **
2. Item description attributes
For Search Engine Optimization (SEO) purposes, include the item's name and relevant keywords in both the Long Description and the Short Description. For more information, read SEO Best Practices for Item Descriptions.
Long Description: Includes all the important features for the item and can be up to 4,000 characters in length. This displays well as a list.
Short Description: Overview of the key selling points of the item. Written in paragraph form and formatted in HTML (maximum of 1,000 characters in length). For SEO purposes, repeat the item's name and relevant keywords.
Shelf Description: Appears in the category listing, in the Search box for the item and under the Buy Box. It is a bulleted list of two or three key features for the item, and must be less than 1,000 characters.
3. Image-related attributes
- Main Image URL: Provide the final destination image URL (no redirects) that is publicly accessible (no username/password required) and ends in a proper image extension, such as .jpg, .png or .gif.
Main Image Alt Text: For SEO purposes, repeat the item's name and relevant keywords.
Additional Asset URL: Additional Image URLs (if any) should be provided in this attribute column. Use the columns Additional Asset URL(#1), (#2) and (#3) if you have additional images for your item. The default provided is three columns, allowing for three additional images. If you wish to provide more than three additional image URLs, you can insert the necessary number of columns. Copy and Paste the three additional asset columns (Additional Asset-Alt Text, Additional Asset-Asset URL and Additional Asset-Asset Type) for each additional image. Although you can only upload one Main Image, you can add as many additional assets as you like.
- Additional Asset Text: Brief text about the image should be included. For SEO purposes, include the item's name.
4. Tax-related attributes
5. Price Details
6. Shipping-related attributes
Global shipping settings are configured in Seller Center and apply to your entire catalog. When defining specific Shipping Override Settings for an item, use the attributes listed below:
- Is Shipping Allowed
- Shipping Method
- Shipping Region
- Shipping Price
For more information, read Configuring Item-Level Shipping Exceptions
7. Variant Group-related attributes
A variant group is a group of individual items that only differ by a few attributes. Below are attributes that should be used to set up variant groups:
- Variant Group ID
- Variant Attribute Name
- Swatch Attribute Name
- Swatch Image URL
- Is Primary Variant
For additional information, read Manage Variant Groups
8. Compliance attributes
Compliance attributes differ depending on the item category. For example, all clothing items should have the attributes Required Textile Act Labeling and Country of Origin-Textiles defined. Similarly, food items should have the attributes Has GMOs and GMO-Free Claim attributes defined. And, for certain products sold in California, you need to specify the Prop65Warning Text attribute. You should provide all of the relevant compliance attributes for your items in the Spec or XSD to meet the compliance requirements.
9. Additional category-specific attributes
Additional category-specific attributes are different for every category and help describe items. For example, clothing category items require additional details like Gender, Clothing Size, Color, Fabric Material Name, Fabric Care Instructions, Fabric Material Percentage, Occasion, etc. These attributes are important because they help Walmart categorize your items correctly.
Current allowed Shipping Weight-Unit: The only identifier type allowed at the moment is LB. All other units like KG, G, MG and OZ, although specified in the Specs and the XSDs, are not allowed and will cause an error if submitted.
Follow the steps below if you are using version 3 (the most recent version) of the Full Item Spec:
Step 1: Make sure you've selected the correct category and subcategory
Attributes vary by subcategory, so you must choose correctly to fill in the best attributes for your item. If you need to review how to make this selection, refer to Selecting The Best Category For An Item
Step 2: Open the correct template and enable macros.
These instructions will assume macros are enabled. The macros will facilitate the process and help check your information. If you have trouble getting the macros to work, try quitting Excel entirely (i.e., closing the whole program, not just the workbook) and reopening the template.
Step 3: If you're filling out this for the first time, read the Instructions tab.
Step 4: Open the sheet for the subcategory in which you want to sell items.
If you're unsure of what subcategory your item falls into, refer to the subcategory section of Selecting The Best Category For An Item.
Step 5: Go to the Walmart Toolbar and click "Show Required Fields Only".
To expedite the process of setting up items, you only have to complete the required fields. All universally required fields are in bold. There may be some additional conditionally required fields (not bolded) depending on the other fields you enter. If so, you may return to this toolbar and click Show All Fields
to enter the necessary fields. If you do not see Show All Fields or Show Required Fields only, save your file and reopen Excel.
Step 6: Fill out all of the required fields.
Some helpful tips:
If you are copying data from another file, you must right click to perform Special Paste and select Values. If you fail to do this correctly, your Excel may mark valid data as invalid.
Exercise caution when setting up your SKU and Product ID, as these are more difficult to change later. We do not recommend using EAN. If you ever need to update the SKU or Product ID of your items, you can find detailed instructions in Updating The SKU Of An Item and Updating An Item's Product ID (eg: GTIN, UPC, ISBN, ISSN, EAN).
When writing your Description and Key Features, follow the guidelines in Using SEO Best Practices In Your Item Descriptions.
- For the help identifying the Product Tax Code, see Current Tax Codes For The Walmart Marketplace.
For your Main Image URL, you should provide a URL where the image is hosted. If you are using Walmart's internal SFTP to host your images, then you can use the following for this field: partnerId/dirname/imagefilepathname. The Spec will mark this as invalid because it isn't a URL, but you will still be able to upload the file without any feed errors so that the item is created successfully.
Global shipping settings are configured in the Seller Center and apply to your entire catalog. To override the global shipping setting for a specific item, refer to Configuring Item Level Shipping Override Settings.
- In the Compliance section, there are several attributes that become required depending on how you fill in the required attributes, including: Is Prop 65 Warning Required, Contains Batteries, and Has Warranty. So, for example, if you answer Yes to Has Warranty, then you will have to provide either a Warranty Text or a Warranty URL.
Step 7: If you want to understand more about each field, hover over the 6th row to see examples.
This will also display:
whether the item is required, conditionally required or optional
whether you should be entering text, a decimal, an integer, etc.
the character limit for the field
Step 8: If you require more information on a field, open the Data Definitions tab.
Use Find & Select. Search for the name of the attribute whose definition you want to know.
Step 9: If desired, provide additional images.
If you have more than one image, go back to the Walmart Toolbar and click Show All Fields. Go back to the Images columns. If you have more than 1 additional image, click the Add More button to create new columns to use for more images. Make sure your images follow the Item Image Guidelines.
Step 10: If desired, set up a variant group.
Follow the instructions in Manage Variant Groups
Step 11: After filling out all the required attributes, click Validate Fields.
Validations help you catch the most common errors in filling out templates and improve data quality. However, they do not verify the accuracy of the data and do not capture all possible errors.
If all lines have green in the Validate column (column 2 or B), then your file is ready to go. Proceed to Step 12.
If you have lines with red in the Validate column (column 2 or B), go to the Walmart Toolbar and click Show All Fields. Scroll through the sheet to find the cells with errors. There are three types of errors:
Red - Required cells are empty. Every field with a bolded name is required. If all of the fields with bolded names have been filled out, you are missing conditionally required attributes. Most commonly, this will occur if you answer yes in a field like "Contains Batteries." You will then be required to enter "Battery Type".
Grey - Cell contains invalid data. Hover over line 6 to see the appropriate type of input and rewrite your data to match, or click on the drop-down menu for that cell to see valid values. For example, price is a decimal, which means that "abc" is an invalid input. Enter a valid value like "10.00" to correct the problem. To give another example, for cells with drop-downs, you must select one of the options from the drop-down.
Blue - Sheet contains duplicate SKUs. Rename your SKUs so they are all unique.
Once you've corrected your errors, run the validations again. Repeat until you have no errors.
Step 12: After your file passes the validation, upload it to Seller Center.
Follow the instructions in Setting Up Items In The Seller Center under Setup by Category, starting from step 3.
- You cannot use normal copy and paste to enter data in the file. If copy and pasting is necessary, you must right click to perform Special Paste and select Values. If you fail to do this correctly, your Excel may mark valid data as invalid. If your Excel is marking valid data as invalid, we recommend downloading the Spec again and using special paste to copy your data into the new file to correct the problem.
- If macro options do not appear or the Walmart Toolbar is missing buttons, save your file and restart Excel. Make sure to click Enable Macros when you reopen the Spec. This error is known to occur if too many Spec files are opened consecutively.