Exporting Data from the Catalog

Updated 3 months ago ​by Merch Transformation Change Management

You can download data into read-only or editable spreadsheets for products and item configurations in your Supplier One catalog.

To download editable spreadsheets for item configuration and supply chain attributes, make sure to select the Item Configurations view of the catalog.

Catalog - Products View

  1. Find items using the Product ID search bar, and/or use the Filters to narrow down your list or grid of items. The number of items you can export depends on the type of export:
    1. Full Item Report: Download items that have active logistics configurations. This report also includes current DSV inventory counts.
      For larger catalogs, we recommend using our Walmart API to download your report.
    2. DSV Export: Download and edit DSV Inventory attributes for up to 5,000 items at a time. This export supports up to 10,000 total rows. If you have selected facilities that will exceed 10,000 rows, try selecting fewer facilities.
    3. Export Insights & Edit Content: Download and edit Product Content and Site Experience attributes for up to 5,000 items at a time. This export will include all available insights to help you improve the product content.
    4. Basic Export (Read Only): Download a pre-defined list of attributes for up to 40,000 items at a time.
      If you're experiencing issues exporting a custom set of product content attributes, please use the Product Content & Site Experience workflow in the Supplier One Maintenance Hub.

Catalog - Item Configurations and Hierarchies View

  1. Find items using the Product ID search bar, and/or use the Filters to narrow down your list or grid of items. The number of items you can export depends on the attributes you want to view and if you want to edit them:
    1. Read-only > Basic Export: Download a pre-defined list of attributes for up to 40,000 items at a time.
    2. Editable > DSV Inventory, Product Content & Site Experience, or Item Configuration & Supply Chain: Download and edit attributes for up to 5,000 items at a time.
      The DSV Inventory export supports up to 10,000 total rows. If you have selected facilities that will exceed 10,000 rows, try selecting fewer facilities.
    To export data for selected items only, click the check boxes in the item list or grid.
  2. Click Export.
    1. To download a pre-defined list of attributes in a read-only spreadsheet: Click Basic Export. Your spreadsheet will start downloading automatically.
    2. To download an editable spreadsheet: Click the maintenance category to go to the Maintenance Hub workflow and select the attributes you want to download and edit.
      1. DSV Inventory > Step 4
      2. Product Content & Site Experience > Step 5
      3. Item Configuration & Supply Chain > Step 4
You cannot use the Basic Export spreadsheet to update items. To edit attribute values, select the maintenance category under Editable in the export menu.

Export Download Times

Download times vary depending on the number of items and attributes you're exporting. Estimates are:

  • Up to 10,000 items = Up to 30 seconds
  • 10,000–20,000 items = Up to 1.5 minutes
  • 20,000–40,000 items = Up to 2 minutes

Which Attributes Are in the Basic Export?

These are the pre-defined lists of attributes that you can download in a read-only spreadsheet.

Catalog View

Attributes

Products

  • GTIN
  • Item ID
  • Product Name
  • Category
  • Product Type
  • Product Publish Status
  • Main Image URL
  • Customer Review Count
  • Avg. Customer Rating
  • Key Features
  • Site Description
  • Walmart.com Price
  • UPC
  • WUPC
  • Walmart.com Shelf Name
  • Walmart.com Page URL
  • Content Quality Score
  • Is Variant
  • Site Start Date
  • Site End Date
  • Offer Status
  • Offer Lifecycle Status
  • Buy Box Winner
  • Offer Unpublished Reason
  • Online Replenishable
  • Non Replenishable Reason Code
  • Online Orderable
  • Offer Price
  • Brand
  • Brand Code
  • SKU
  • Color
  • Shipping Depth
  • Shipping Width
  • Shipping Height
  • Supplier
  • Plus any custom product attributes that you have selected and saved
We are working on a solution to bring back the DSV - On Hands Inventory, DSV - Total Reserved Inventory, and DSV - Available to Sell Inventory attributes for DSV items. You can view these attributes in the item table in your Supplier One catalog or download current DSV inventory counts in the Full Item Report.

Item Configurations

  • Walmart Item Number
  • Item ID
  • Product GTIN
  • Product Name
  • Product Category
  • Item Configuration Status
  • Item Description 1
  • Merchant Name
  • Merchant Email
  • Supplier Stock ID
  • UPC with check digit
  • UPC without check digit
  • Department Number
  • Fineline
  • Supplier Number
  • Supplier Name
  • Contract Sequence Number
  • Buying Region Code
  • Corporate Replenishable
  • Replenishable for Walmart.com
  • Last Changed Date
  • Orderable Pack Quantity
  • Warehouse Pack Quantity
  • Orderable Pack GTIN
  • Warehouse Pack GTIN
  • Unit Cost
  • Selling Price
  • Item Type
  • Item Subtype
  • Site Description
  • Key Features
  • Brand Name
  • Customer Review Count
  • Average Customer Rating
  • Content Quality Score
  • Supply Item Effective Date
  • WPID
  • Walmart.com Shelf Name
  • Site Main Image URL
  • Site Start Date
  • Site End Date
  • Site Status
  • Unpublished Reason
  • 1P Offer Lifecycle Status
  • 1P Offer Status
  • Buy Box Winner
  • Online Orderable
  • Offer Type
  • Offer Price
  • Walmart.com Price
  • Fulfillment Method
  • Walmart.com Page URL
We are working on a solution to bring back the DSV - On Hands Inventory, DSV - Total Reserved Inventory, and DSV - Available to Sell Inventory attributes for DSV items. You can view these attributes in the item table in your Supplier One catalog or download current DSV inventory counts in the Full Item Report from the Products view of the catalog.

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?