Error Validations and Frequent Errors

Updated 1 month ago ​by Merch Transformation Change Management

When you're dealing with vast amounts of information at a time, it's easy to miss small details.

Error Validations Upon File Upload

You may see upfront validations for item setup and maintenance submissions. These validations will occur when you upload a spreadsheet and check that your file meets criteria such as (but not limited to):

  • Have all of the required attributes been provided?
  • Are the provided attribute values within the maximum character limits?
  • Have attributes with closed-list options been correctly selected?

If errors are found, click Download Excel File to learn what the errors are and correct them in the file. Then, save the file and upload it back in Supplier One. Or, click Fix errors in app to make corrections within Supplier One.

If you see an error message in red, review it to determine what needs be corrected. Make the updates in the file you tried to upload, save the file, and try your upload again in Supplier One.

Here's an error you might see upon file upload in Supplier One and what you can do to fix it:

Missing Spec Product Type

When you set up items by Product Type, you must select the Spec Product Type for each item on the Product Content And Site Exp tab of the spreadsheet. Click the cell and select an option from the drop-down list.

Additional Errors Found After Upload

Once your file is successfully uploaded in Supplier One, remember to check the status in the Submissions Manager. If additional errors are found, learn more by downloading the error spreadsheet from the submission details page.

Here are some common submission errors you might see after file upload in Supplier One and what you can do to fix them:

Items with Errors

These submission errors, which fall under Data Errors, Required Content Incomplete, and Requires WERCS, happen for a number of reasons.

  1. In the error spreadsheet, review the Error Description(s) in Column B.
  2. Fix the errors for each item, e.g., remove the dollar symbol from the Unit Cost in the example above. Make sure to review all tabs of the spreadsheet for errors.
  3. Once you've fixed all of the errors, upload the spreadsheet back into Supplier One. This will ensure that your submissions are tracked on the same Submission Description and ID. If you fix the error in your originally submitted spreadsheet and try to upload it, you will be prompted to download the error spreadsheet from the activity details.
Invalid Image URL

To be valid, image URLs must end in an image file type (.jpg, .png, etc.) AND link to a public image file that loads as an image.

Refer to our Image URL Specifications for a full list of requirements and tips, including instructions for creating valid imgur URLs or Cloudinary URLs.

Missing Required Fields

In the item setup spreadsheets, ALL attributes under the blue and green headers are required. These attributes are needed for Walmart to place a purchase order, for our supply chain, and for the items to be visible on Walmart.com. If you did not provide these attributes in your initial setup submission, you'll need to provide them before the items can be successfully created.

  • For imagery, refer to Types of Imagery and Image Guidelines and our Image URL Specifications.
    • If images are not yet available for your item, you can use a placeholder image in the interim. You must submit this Walmart placeholder image in order for our system to properly recognize it: https://i5.walmartimages.com/asr/24893ec1-4563-41fa-9efb-42ba1d0d5e98.f417a4c35f49d4ecd5c479905aa827b3.jpeg
      • DO NOT create your own placeholder imagery.
        Your item will not be published on Walmart.com or Grocery/Pickup until the placeholder image URL has been replaced by a product image that meets Walmart's standard requirements.
        For Fashion items: Please continue using your existing processes for imagery (i.e., do not submit a placeholder image URL during item setup in Supplier One). To accommodate Walmart’s Imagery Studio process, the Main Image URL attribute is not required during setup for all seven Fashion categories: Baby Clothing, Carriers & Accessories, Cases & Bags, Clothing, Footwear, Jewelry, and Watches.
  • The attribute definitions in Supplier One and in Row 6 of the spreadsheets include instructions to enter "None" if applicable, e.g., for California Prop 65 Warning Text and Walmart Factory ID.

During item maintenance, you cannot delete an attribute value that was previously submitted by leaving the cell or field blank. You'll need to replace or add back the previous value.

Requires WERCS

Refer to the WERCSmart Overview for common questions and answers about the assessment.

  • If a keyword has been flagged in the name or description you provided for the item, please wait 24 hours. The Compliance team will automatically review the submission. If no WERCs assessment is needed, the item will be released for creation within 24 hours. The system will automatically process the item (i.e., it should not need to be resubmitted).
  • If your items do not require a WERCS assessment OR it's been 24 hours since the assessment was completed for your items, please contact WERCShelp@walmart.com and provide the following details:
    • Your Vendor ID and Name
    • The GTINs/UPCs and Product Names for the items
    • A description of the issue or action needed
Item with the Same GTIN Exists in a Different Department

This error occurs during item setup when an item with the same GTIN already exists in a different department. Please click the chatbot in Supplier One to file a case ticket for assistance.

If the error message includes a department number AND you do have a contract in that department, you can update the contract number in the 9-Digit Supplier ID and resubmit the spreadsheet.
Exceeding Character Limit

The attribute definitions in Supplier One and on the Data Definitions tab/in Row 6 of the spreadsheets include the maximum number of characters allowed for each attribute value. The spreadsheets do not have validations, so it's best practice to verify that your attribute values meet the character limits before submitting your setup and maintenance requests.

GDSN Locked Fields

Attribute values that are GDSN locked cannot be updated in Supplier One. To fix the issue, you can either:

  • Update the attribute value to match what's in GDSN, and resubmit the spreadsheet in Supplier One
  • Make your changes in GDSN, push the data to Walmart, and create a new setup or maintenance spreadsheet for your request in Supplier One

System or Timeout Error

These are most likely technical issues on our end. Please refer to this article. We appreciate your patience!

Incorrect Product Identifier Provided

It's critical to provide the correct ID type and values for your identifiers. Please check your information before submitting your requests.

  • GTINs and UPCs require check digits. You may calculate the check digit here.
  • Walmart Item Number, WIN, WM# are the same.
  • Setup spreadsheets only support GTINs.
  • Maintenance spreadsheets only support GTINs and WINs.
  • Activity Manager > Supplier One Submissions > Spreadsheets for Data Errors only support GTINs and WINs.
  • WUPCs will not be accepted in Supplier One, but you can easily convert them to GTINs by calculating the check digit here.

Learn more details about Product Identifiers.

Make sure GTIN cells in your spreadsheets are formatted as text to retain the leading zeros in your GTIN values.

Columns Added

You can only add columns in your spreadsheet for attributes that have a "(+)" sign next to the attribute name (e.g., Key Features). If you add any other columns in your file, you will get an error.

  • For tips on adding columns in your spreadsheet (using Key Features as the example), refer to this article

Columns Deleted

Do not delete or hide any columns that downloaded in your file by default. If you delete columns that the system expects to find, you will get an error.

Have Questions or Need Help?

If you experience any issues viewing and managing your submissions, please click "Help" in the top navigation menu and select "Manage tickets" to file a case ticket. Or, select "Chat" to get real-time help from our chat bot or click "Search articles" to search Supplier One HelpDocs. 

Make sure to select the issue type Items and Inventory.

For detailed instructions, refer to Manage Case Tickets.


How did we do?