Walmart Marketplace: Most-used fields

Walmart Marketplace: Most-used fields#

The table below gives information about most-used fields that you can import from Walmart Marketplace. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

AUR

AUR

The Average Unit Retail, representing the average selling price of a single unit of a product.

metric

Authorized Orders

Authorized Orders

The number of orders that have been authorized by Walmart.

metric

Authorized Sales

Authorized Sales

The monetary value of sales that have been authorized.

metric

Authorized Units

Authorized Units

The number of units for which sales have been authorized.

metric

Average Rating

Average Rating

The average customer rating for the product, typically based on a 5-star scale.

metric

Base Item Id

Base Item Id

The unique identifier for the base version of a product, especially when multiple variants exist.

metric

Brand

Brand

The brand name of the product.

dimension

Buy Box Eligible

Buy Box Eligible

Indicates whether the seller’s offer for an item is eligible to win the Buy Box on Walmart.com.

dimension

Buy Box Item Price

Buy Box Item Price

The price of the item that currently holds the Buy Box on Walmart.com.

metric

Buy Box Shipping Price

Buy Box Shipping Price

The shipping price associated with the offer that currently holds the Buy Box on Walmart.com.

metric

Cancelled Sales

Cancelled Sales

The total sales value of orders or order lines that have been canceled.

metric

Cancelled Units

Cancelled Units

The total number of units from orders or order lines that have been canceled.

metric

Category

Category

A broad classification that helps organize and group products on the marketplace.

dimension

Commission

Commission

The total commission earned or charged for a transaction or item.

metric

Currency

Currency

The three-letter ISO 4217 currency code for monetary values.

dimension

Department

Department

The category or department to which a product belongs.

dimension

Fulfillment Lag Time

Fulfillment Lag Time

The time, in days, between when an order is placed and when the item is shipped by the seller. This is also referred to as ‘lead time’.

metric

Fulfillment Type

Fulfillment Type

The method used to fulfill an order, such as Seller Fulfilled or Walmart Fulfillment Services (WFS).

dimension

GMV

GMV

The Gross Merchandise Value, representing the total sales volume in dollars for merchandise sold through the marketplace over a given period.

metric

GMV Comp %

GMV Comp %

The year-over-year comparison percentage for Gross Merchandise Value (GMV).

metric

GMV-Commission

GMV-Commission

The Gross Merchandise Value (GMV) less the total commission amount.

metric

GTIN

GTIN

The Global Trade Item Number (GTIN), such as a UPC, EAN, or ISBN, used to uniquely identify the product.

dimension

Item Conversion Rate

Item Conversion Rate

The percentage of item views that result in a sale.

metric

Item Creation Date

Item Creation Date

The date and time when the item listing was initially created on Walmart Marketplace.

dimension

Item ID

Item ID

The item identifier generated by Walmart.

metric

Item Last Updated

Item Last Updated

The date and time when the item listing was last modified on Walmart Marketplace.

dimension

Item Page URL

Item Page URL

The direct URL to the product’s detail page on Walmart.com.

dimension

Lifecycle Status

Lifecycle Status

The current lifecycle status of the item, indicating its stage in the product’s existence (e.g., active, retired).

dimension

MSRP

MSRP

The Manufacturer’s Suggested Retail Price for the item.

metric

Maximum Seller Allowed Price

Maximum Seller Allowed Price

The highest price a seller is allowed to list the item for on Walmart Marketplace.

dimension

Minimum Seller Allowed Price

Minimum Seller Allowed Price

The lowest price a seller is allowed to list the item for on Walmart Marketplace.

dimension

Offer End Date

Offer End Date

The date when a specific offer or promotion for an item is scheduled to end.

dimension

Offer Start Date

Offer Start Date

The date when a specific offer or promotion for an item becomes active.

dimension

Price

Price

The current selling price of the item on Walmart Marketplace.

metric

Primary Category Path

Primary Category Path

The full hierarchical path of the primary category to which the item belongs on Walmart.com (e.g., ‘Electronics > Televisions > Smart TVs’).

dimension

Primary Image URL

Primary Image URL

The URL of the main image displayed for the item on its product page.

dimension

Primary Variant?

Primary Variant?

dimension

Product Category

Product Category

The general category of the product on Walmart Marketplace.

dimension

Product Level Conversion Rate

Product Level Conversion Rate

The rate at which views for a specific product convert into sales.

metric

Product Level Pageviews

Product Level Pageviews

The number of times a specific product’s page has been viewed by customers.

metric

Product Name

Product Name

The primary name or title of the product.

dimension

Product Tax Code

Product Tax Code

A seven-digit code that identifies the amount of sales tax to be collected for individual items.

metric

Publish Status

Publish Status

The current publishing status of the item, indicating whether it is live and visible on Walmart.com.

dimension

Refunded Sales

Refunded Sales

The total sales value of items or orders for which a refund has been issued.

metric

Repricer Status

Repricer Status

dimension

Repricer Strategy

Repricer Strategy

dimension

Reviews Count

Reviews Count

The total number of customer reviews submitted for the product.

metric

SKU

SKU

The Stock Keeping Unit, a unique identifier used by the seller to track the item in their inventory.

dimension

SKU ID

SKU ID

The Seller’s Stock Keeping Unit, a unique alphanumeric identifier for each distinct product and variant.

dimension

Searchable?

Searchable?

dimension

Ship Methods

Ship Methods

The available shipping methods for the item (e.g., Standard, Expedited, Freight).

dimension

Shipping Weight

Shipping Weight

The weight of the item used for calculating shipping costs.

metric

Shipping Weight Unit

Shipping Weight Unit

The unit of measurement for the shipping weight (e.g., LB, KG, OZ).

dimension

Sub Category

Sub Category

A more specific classification within a main product category.

dimension

Super Department

Super Department

A very broad grouping of products, representing the highest level in the product hierarchy.

dimension

Total LY GMV

Total LY GMV

The total Gross Merchandise Value for the previous year, used for year-over-year comparisons.

metric

Total Product Visits

Total Product Visits

The total number of times a product’s page has been viewed by customers.

metric

Total Units Sold

Total Units Sold

The total number of individual product units that have been sold.

metric

UPC

UPC

The Universal Product Code, a 12-digit number used to identify retail products.

dimension

Variant Group Id

Variant Group Id

A unique identifier for a group of product variants (e.g., all sizes and colors of a specific T-shirt).

dimension

Variant Grouping Attributes

Variant Grouping Attributes

The attributes used to group product variants together (e.g., ‘color’, ‘size’).

dimension

Variant Grouping Values

Variant Grouping Values

The specific values for the variant grouping attributes (e.g., for ‘color’ it could be ‘red’, ‘blue’; for ‘size’ it could be ‘S’, ‘M’, ‘L’).

dimension

WPID

WPID

The Walmart Product ID, a unique identifier assigned to a product in the Walmart catalog.

dimension