Export and Update Store Cost Attributes in Bulk

Updated 2 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).

The Cost Change Scenario application no longer supports cost changes. You may export a spreadsheet in the Supplier One Maintenance Hub to update cost attributes for store and shared items at the Corporate or DC level.

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.
  • This does not change how store-specific cost is submitted through EDI, nor does it affect the cost timing for items that flow through the warehouse.
  • Warehouse and vendor-managed pricing items/suppliers should continue using existing processes to provide cost changes.

Which Attributes Can You Download in this Export?

Store Cost

These attributes allow you to update costs for store and shared items at a national level regardless of store or warehouse location.

Store Cost > Attribute Group

Store Cost > Attribute Names

Cost > Cost (orderablePackCost)

  • Orderable Pack Cost
  • Supplier Recommended Retail ($/unit)
  • Effective Date
  • Expiration Date

Cost > Cost Drivers (costDrivers), Cost Drivers 1 (costDrivers), Cost Drivers 2 (costDrivers)

  • Cost Driver
  • Cost Driver Percent Change
  • Cost Driver Portion of Item Cost

Supply Item > Trade Funds (tradeFunds)

  • National List Cost ($/unit)
  • Efficiency Discount ($/unit)
  • Accrual Rate (%)

DC Cost

These attributes allow you to update costs for store and shared items at a warehouse or distribution center level. These costs depend on warehouse location.

Remember to provide the DC Number for each cost update in your maintenance spreadsheet.
If an item routes through a High Velocity DC, you will receive the DC Cost template regardless of the item type. You can update the Corporate cost for the item by entering National under the DC Number column. If you only update Corporate cost, then the DC cost will remain at the current value. The impact will be visible in POs cut incorrectly.
Entering National creates two submissions (with the same Submission ID) if your spreadsheet also includes DC Numbers – 1 for Corporate cost updates and 1 for DC cost updates.

DC Cost > Attribute Group

DC Cost > Attribute Names

Supply Item > Trade Funds (tradeFunds)

  • National List Cost ($/unit)
  • Efficiency Discount ($/unit)
  • Accrual Rate (%)

Cost > Cost (orderablePackCost)

  • Prepaid Cost
  • Collect Cost
  • Supplier Recommended Retail ($/unit)
  • Effective Date
  • Expiration Date

Cost > Cost Drivers (costDrivers), Cost Drivers 1 (costDrivers), Cost Drivers 2 (costDrivers)

  • Cost Driver
  • Cost Driver Percent Change
  • Cost Driver Portion of Item Cost

Export Your Spreadsheet

  1. In the left navigation menu, click Items and Inventory and select Maintenance Hub.
  2. On the Cost tile, click Update cost.
  3. Copy and paste up to 5,000 Walmart Item Numbers in the box. Then, click the Export button.

Complete and Submit Your Spreadsheet

  1. Open the spreadsheet and fill in the new values for the store cost or DC cost attributes. Cost, Effective Date, and Expiration Date are required attributes for all cost submissions. You can find attribute definitions and data requirements in the row beneath the attribute names.
    1. If your items are sold in stores or shared, you'll get the Omni Cost maintenance spreadsheet.
    2. If your items are sold in stores or shared AND are eligible for cost updates at the warehouse or distribution center level, you'll get the DC Cost maintenance spreadsheet.
      You can copy and paste the Sellable GTIN, Walmart Item Number, and Supplier Name down if you need to add additional DCs for those items.
    If you need to add another cost driver, insert three blank columns after the existing Cost Drivers attribute columns. Then, copy Rows 3-6 for Cost Drivers 2 and paste them into the same rows of the blank columns. Change the number in the attribute name so that it is in sequence: Cost Drivers 3. You can repeat this process as needed to include all of the cost drivers.
    By default, your spreadsheet will be named with the date and time it is created. Remember to save your spreadsheet in Excel Workbook, or .xlsx, format when you're 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.

Please allow up to 60 days for your cost update to be approved. If the activity has had the Walmart Action Required status for more than 60 days, file a case ticket and Partner Support will reach out to the merchant on your behalf. 

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?