Add Items in Bulk in Seller Center

Relevant to:  

There are a few steps you need to follow to successfully and efficiently list your items on Walmart.com. This article gives you a step-by-step walkthrough of the Item Setup process using Excels. If you would like to add items directly in Seller Center without using Excel sheets, refer to Add a Single Item in Seller Center.
 

Setup by Match vs. Full Item Spec

There are two ways that you can set up your items:

1. Setup by Match: Choose this option if you want to match your items to existing item content on Walmart.com. This is a much faster option than using the Full Item Spec. We recommend using Setup by Match first and then using the Full Item Spec for any items that do not return a match.
   
   ** Note: Item Setup By Match is currently available only in Seller Center, not in the API. **
    

2. Full Item Spec: Choose this option if you want to set up an item using your own content or if no match was found for your item(s) using Setup by Match.

​

Setup by Match

Step 1: Download the Setup by Match Spec

To download the Setup by Match Spec from Seller Center:

1. Log in to Seller Center.

2. Click on the Add New Items link in the left navigation menu.

3. ​Click on the Setup by Match download button.

Step 2: Fill out the Spec

** Important: You must enable macros when you open the Setup by Match Spec in Excel. If you try to save the Spec and required fields have been left empty, the macros will trigger an alert and highlight the fields in red. **

To fill out the Setup by Match Spec:

1. Open the Spec in Excel. Excel will inform you that the workbook contains macros. 

2. Click on the Enable Macros button.

 

3. Read the Instructions page.

 

4. Fill in your data. 

5. Save the Spec.

** Note: Save the Spec in either XLSM or XLSX. By default, Excel saves the Spec as XLSM. **

Next, see Upload and submit the Spec.

 

Full Item Spec

Step 1: Download the Full Item Spec

To download the Full Item Spec from Seller Center:

1. Log in to Seller Center.

2. Click on the Add New Items link in the left navigation menu.

3. ​Click on the drop-down menu titled Select a category.

 

5. From the Select a category drop-down menu, select the category for the Spec you want to download. 

6. Click the Download button.

​

Step 2: Fill out the Spec

** Important: You must enable macros when you open the Spec in Excel. If you try to save the Spec and required fields have been left empty, the macros will trigger an alert and highlight the fields in red. **

To fill out the Spec:

1. Open the Spec in Excel. Excel will inform you that the Spec contains macros. 

2. Click on the Enable Macros button.

   
    

3. Read the Instructions page.

4. Choose a tab for the subcategory your items belong to, which is at the bottom of each Spec. If an item doesn't fall into one of the subcategories, select the Other tab.

5. Fill in your data. Once you start filling out the fields, you will notice that some fields require you to select from a drop-down menu while others are free-text fields. 

   ** Note: For in-depth information about how to fill out the Specs, view How to Fill Out the Full Item Spec and Sample Item Setup Specs. Some fields like Product Name have max character limits. If you exceed the max character limits, the item will fail to set up. **
    

6. Save the Spec.
   
   ** Note: Save the Spec in either XLSM or XLSX. By default, Excel saves the Spec as XLSM. **

​

Step 3: Upload and submit the Spec

To upload the Spec:

1. Log in to Seller Center.

2. Go back to the Add New Items page, and attach the Spec by either:
   • Dragging and dropping your file into the drop zone.

 

• Or, clicking on the Upload Spec button.

3. Click the Submit button.

   ** Note: If you try to attach the wrong file type (png, xls, jpg, etc.), an error message will appear until you attach the right file type. **
   
    

Step 4: Track your feed status

Roughly a minute after your file has been submitted, you can track the status of your files on the Feed Status page. To get to the Feed Status page:

1. On the left navigation bar, under Items & Inventory, select Feed Status.
    

 

 The Feed Status page shows the following information: 

• ​Feed ID: The reference ID of your feed. 

• Date: The date the file was submitted and began processing.

• Status: The status of that particular file.

• Submitted: The number of SKUs that were submitted in the file.

• Processed: The number of SKUs that processed successfully.

• Pending: The number of SKUs that are still pending Item Setup completion.

• Errors: The number of errors encountered. The numbers in this field link to the error message page. For items you attempted to set up using the Setup by Match Spec, this is where you can see the items that couldn't be matched.

• Error File: Link to download the errors into a CSV file. For items you attempted to set up using the Setup by Match Spec, this is where you can see the items that couldn't be matched. 

2. To see the errors for the SKUs you submitted, locate the Errors column header. 

3. In the Errors column, click the blue number. You will be taken to a page that has a list of the SKUs in your file/feed that have errors, as well as the reason for the error. You can also download your Feed Status as an Excel file. 

   
    

Step 5: Resolve any errors

To resolve the errors in your feed:

1. Examine the Feed Status page for the locations of the errors.

2. In the Spec, locate and resolve the errors listed on the Feed Status page. Then, save the Spec in the correct file format mentioned in Step 2. 

3. Reupload the corrected Spec in Seller Center.

4. Track the status of this new feed and verify that the errors are resolved.

​** Note: If you used the Setup by Match Spec and received errors, it's because we didn't have content for those particular items. You will need to Copy and Paste the SKUs that received errors into the Full Item Spec and provide the necessary content. Refer to the Full Item Spec instructions in Step 2 for more information. **

 

Step 6: Track the status of your items

Once your feed has been submitted, you can track the status of each item by filtering the SKU Details by that particular SKU. If the item is still Processing, then it is still being set up in our catalog. For Sellers who have not launched yet, the item will move to a Staged status, which means the item is finished setting up and will be published once you go live. Once you go live, items will go directly into the Published status.