Export and Update eCommerce Cost Attributes in Bulk

Updated 1 month 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 Excel template for eCommerce cost changes recently changed, and the rollout was by SBU/department:

As of

SBU

Departments

Aug. 30, 2023

Food & Consumables

  • D1 Candy & Tobacco
  • D2 Personal Care
  • D4 Household Paper
  • D13 Household Cleaning
  • D40 Pharmacy OTC
  • D46 Beauty
  • D79 Baby Consumables Hardlines
  • D80 Service Deli
  • D81 Com Bread
  • D82 Impulse Merchandise
  • D91 Frozen
  • D92 Grocery
  • D93 Meat
  • D95 Snacks & Beverages
  • D97 Wall Deli
  • D98 Bakery

Sept. 13, 2023

Home & Hardlines

  • D3 Stationery
  • D9 Sporting Goods
  • D11 Hardware & Tools
  • D12 Do It Yourself
  • D14 Cook & Dine
  • D16 Patio & Garden
  • D17 Home Décor
  • D19 Arts, Crafts, Sewing & Fabrics
  • D20 Bath & Shower
  • D22 Bedding
  • D56 Horticulture
  • D71 Furniture
  • D74 Home Management

Sept. 13, 2023

Entertainment, Toys, and Seasonal (ETS) & Apparel

  • D5 Media & Gaming
  • D6 Cameras & Supplies
  • D7 Toys
  • D18 Seasonal
  • D21 Books & Magazines
  • D23 Men's Apparel
  • D24 Boys Apparel
  • D25 Shoes
  • D26 Baby & Toddler Apparel
  • D29 Intimate Apparel
  • D31 Accessories
  • D32 Jewelry
  • D33 Girls Apparel
  • D34 Women's Apparel
  • D58 Wireless Service Inc.
  • D67 Celebration
  • D72 Electronics
  • D85 Photo Services
  • D87 Wireless

Oct. 10, 2023

Hardlines

  • D10 Automotive

Oct 2024

Food

  • D90 Dairy
  • D94 Produce
  • D96 Liquor

What Has Changed?

The Excel file for your eCommerce cost changes now requires you to enter:

  • Orderable Pack Cost (previously, only Unit Cost was required).
  • Cost start dates and end dates to schedule cost changes for eCommerce items.
  • Additional attributes (optional): Supplier Recommended Retail, Cost Driver, Cost Driver Percent Change, and Cost Driver Portion of Item Cost.

Reminders

The Cost Change Scenario application no longer supports cost changes. You may export a spreadsheet in the Supplier One Maintenance Hub to update the cost for eCommerce items at the Walmart Item Number (configuration) level – across all warehouses and facilities for the items. eCommerce cost updates at the facility level are not supported in Supplier One.

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.

Which Attributes Can You Download in this Export?

eCommerce Cost > Attribute Group

eCommerce Cost > Attribute Names

Cost > Cost (orderablePackCost)

Required fields:

  • Orderable Pack Cost (aka Vendor Pack Cost)
  • Effective Date (aka Cost Start Date)
  • Expiration Date (aka Cost End Date)

Optional field:

  • Supplier Recommended Retail ($/unit)

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

Optional fields:

  • 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 these required attributes: Orderable Pack Cost, Effective Date, and Expiration Date. The other attributes are optional. You can find the attribute definition and data requirements in the row beneath the attribute name.
    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. 

Common Errors and Ways to Fix Them

If errors are found in your cost submission, you'll receive an email with a link to the activity. Here are some common errors in cost management.

Error Description

What It Means

What You Should Do

Cost submission for item is stale, same costs exist in our system

The cost you submitted for the item already exists in our database.

In the spreadsheet from the activity details, update the cost to a new value and upload the file back into Supplier One.

Validation Failure: Please input cost to two decimal places and retry this submission.

There is an invalid number of digits after the decimal point. eCommerce cost is usually truncated to two decimal places.

In the spreadsheet from the activity details, make sure there are only two digits after the decimal point and upload the file back into Supplier One.

Validation Failure: Cannot update with zero or null cost. Please retry update.

A $0 or null cost is not accepted by our systems.

In the spreadsheet from the activity details, update the cost to a non-zero value and upload the file back into Supplier One.

It looks like there was a glitch. Please try again. If the problem persists, contact Walmart Partner Support.

A system error or technical issue occurred.

Please file a case ticket with Walmart Partner Support. Make sure to include the Activity ID in your case details.

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?