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 |