Exporting Data from the Catalog in Spreadsheets

Updated 9 months ago ​by Merch Transformation Change Management

You can download data into read-only or editable spreadsheets for products and item configurations in your Item 360 Catalog.

Catalog - Products View

  1. Find items using the Product ID search bar, and/or use the Filter to narrow down your list of items. The number of items you can export depends on the type of export:
    1. Basic Export (Read Only): Download a pre-defined list of attributes for up to 40,000 items at a time.
    2. DSV Export: Download and edit DSV Inventory attributes for up to 5,000 items at a time.
    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.
      If you're experiencing issues exporting a custom set of product content attributes, please use the Product Content & Site Experience workflow in the Item 360 Maintenance Hub.

Catalog - Item Configurations View

  1. Find items using the Product ID search bar, and/or use the Filter to narrow down your list 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. Read-only > Custom Export: Select the attributes you want to download for up to 2,000 items at a time.
    3. 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.
    To export data for selected items only, click the check box next to the image on the item card.
  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 choose attributes to download in a read-only spreadsheet: Click Custom Export. Then, select the attributes you want and click the green Download button to create your spreadsheet.
    3. 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 3
      2. Product Content & Site Experience > Step 4
      3. Item Configuration & Supply Chain > Step 3
      In the Products view of the Catalog, you can only download an editable spreadsheet for DSV Inventory or Product Content & Site Experience. To download editable spreadsheets for item configuration and supply chain attributes, make sure to select the Item Configurations view of the Catalog.
You cannot use the Basic Export or Custom 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 Can You Select for Custom Export?

From the Item Configurations view of the Catalog, you can select and download Supply Item, Pack Configuration, and Product attributes.

Refer to the Glossary of Attributes for more details.

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 still view these attributes on the item cards in your Item 360 Catalog.

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
  • Retail 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 still view these attributes on the item cards in your Item 360 Catalog.

Was this article helpful?