Updating the Supply Item Status Code

Updated 4 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 can export a spreadsheet in the Maintenance Hub to update the Supply Item Status Code when you want to activate, deactivate, or delete Owned or DSD items.

Do not change the Supply Item Status Code if the item has on-hands or on-orders because that will cause issues with receiving.

The Supply Item Status Code indicates the status of an item's ability to be used for replenishment, store orders, etc.

Valid Attribute Value

Definition

A

Active - The item is available to use.

Before you activate an item, make sure the item meets both of the following criteria:

If you activate an item that has a future Item Effective Date or a past Supply Item Expire Date, our system will automatically change the Supply Item Status Code back to Inactive.

I

Inactive - The item is no longer available to use.

Inactive items will still sell through the Stores and Online until there are 13 continuous months of inactivity. If there’s a sale during this time, our system will restart counting the 13 months.
When the status code has been Inactive for 13 months, our system will automatically change the code to D for Deleted.

D

Delete - The item is no longer available to use, and the process to purge it from the system will begin. It may take up to 90 days to complete the purge once the item has been deleted.

A Walmart Associate will need to approve your submission for the change to be completed.

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. Select Export custom set of attributes.
  5. Open the General drop-down menu, and select Supply Item Status Code.
    If you provided Walmart Item Numbers for DSV items, you will not see Supply Item Status Code because you cannot update it.
  6. Click the Export button.

Complete and Submit Your Spreadsheet

  1. Open the spreadsheet and select the new value for the Supply Item Status Code. 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?