Export and Update Item Configuration & Supply Chain Attributes in Bulk

Updated 3 weeks ago ​by Merch Transformation Change Management

Maintenance is not yet supported in Supplier One for: Assortments, Import Shippers (General Merchandise), Pharmacy, and Fees. Please continue using your current processes (e.g., legacy workflows or systems).

You may export a spreadsheet in the Maintenance Hub to update item configuration and supply chain details – including pricing and cost, source and destination, base trade items, logistics and transportation, store handling, and replenishment details.

To view and edit these attributes directly in Supplier One, go to the Item Configuration Overview.

Which Attributes Can You Download in this Export?

  • For shipping dimensions: The longest measurement (side) should always be entered as the “depth" with the remaining measurements entered either as the width or height.
    If an item's shipping dimensions are set up with the longest side as the width or height, it causes small parcel items to ship freight, which costs Walmart a minimum of $250 per shipment.

Create and Export Your Spreadsheet

  1. In the left navigation menu, click Items and Inventory and select Maintenance Hub.
  2. On the Item Configuration & Supply Chain tile, click Update item configuration.
  3. Copy and paste up to 5,000 Walmart Item Numbers in the box. Then, click the Continue button.
    To find the Walmart Item Numbers (WINs) for your items, go to the Item configurations and hierarchies view of your catalog and search for the Product IDs. Then, select Basic Export to download a file with the WINs.
  4. You can either: Export all available attributes or Export a custom set of attributes.
    To export a custom set of attributes, open the drop-down menus and select the attribute names.
  5. Click the Export button.

Complete and Submit Your Spreadsheet

  1. Open the spreadsheet and fill in the new values for the attributes. You can find attribute definitions and data requirements in the row beneath the attribute names.
    By default, the spreadsheet will be named with the date and time it is created. Remember to save the spreadsheet in Excel Workbook, or .xlsx, format when done.
  2. To submit your file in Supplier One:
    • Click the Upload button in the top navigation menu.
    • Drag and drop your file into the upload window, or click Choose file to select the files.
      • Upfront validations will check for common errors. If any are found, click the Download error file button to fix the errors before trying your upload again.
      • If no common errors are found, click the Continue button.
    • Provide a submission description.
    • Click Submit.

Track Your Changes

Read Track Your Submissions.

Have Questions or Need Help?

If you experience any issues viewing and managing your catalog, 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?