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.	dimension
Address 1	Address 1	The first line of the recipient’s shipping address.	dimension
Address 2	Address 2	The second line of the recipient’s shipping address, used for apartment numbers, suites, etc.	dimension
Address Type	Address Type	The classification of an address, such as shipping or billing.	dimension
Address1	Address1	The first line of the recipient’s shipping address.	dimension
Address2	Address2	The second line of the recipient’s shipping address, used for apartment numbers, suites, etc.	dimension
AddressType	AddressType	The classification of an address, such as shipping or billing.	dimension
Amount	Amount	A numerical value representing a monetary quantity, such as a price, charge, or refund.	metric
Amount Type	Amount Type	Specifies the category or nature of a financial amount, such as a charge, refund, or commission.	dimension
Authorized Orders	Authorized Orders	The number of orders that have been authorized by Walmart.	dimension
Authorized Sales	Authorized Sales	The monetary value of sales that have been authorized.	dimension
Authorized Units	Authorized Units	The number of units for which sales have been authorized.	dimension
AvailToSell Quantity	AvailToSell Quantity	The quantity of an item currently available for sale in the inventory.	metric
Average Rating	Average Rating	The average star rating for an item, calculated from customer reviews.	metric
Base Commission Rate	Base Commission Rate	The standard commission rate applied to an item or category before any incentives or specific rules.	metric
Base Item Id	Base Item Id	The unique identifier for the base version of a product, especially when multiple variants exist.	dimension
Brand	Brand	The brand name of the product.	dimension
Buy Box Eligible	Buy Box Eligible	Indicates whether an offer is eligible to win the Buy Box on Walmart.com.	dimension
Buy Box Item Price	Buy Box Item Price	The price of the item from the seller currently winning the Buy Box.	metric
Buy Box Shipping Price	Buy Box Shipping Price	The shipping price for the item from the seller currently winning the Buy Box.	metric
CURRENCY	CURRENCY	The three-letter ISO 4217 currency code for monetary values.	dimension
Cancelled Sales	Cancelled Sales	The total sales value of orders or order lines that have been canceled.	dimension
Cancelled Units	Cancelled Units	The total number of units from orders or order lines that have been canceled.	dimension
Carrier Method Name	Carrier Method Name	The name of the shipping carrier and the method used for delivery (e.g., FedEx Standard, UPS TwoDay).	dimension
Category	Category	A broad classification that helps organize and group products on the marketplace.	dimension
Charge	Charge	A monetary amount applied to an order or line item, such as a fee or price.	dimension
City	City	The city component of a physical address.	dimension
Commission	Commission	The total commission earned or charged for a transaction or item.	dimension
Commission Incentive Program	Commission Incentive Program	The name of the incentive program specifically related to commissions.	dimension
Commission Rate	Commission Rate	The percentage charged by Walmart as a referral fee on the sale of an item.	metric
Commission Rule	Commission Rule	A specific guideline or condition that determines how commissions are applied or calculated for sales.	dimension
Commission Saving	Commission Saving	The amount saved on commissions due to promotions or special programs.	metric
Comparison Price	Comparison Price	A price used for comparison, often the original price before a discount or a competitor’s price.	dimension
Comparison Price Currency	Comparison Price Currency	The currency in which the comparison price is denominated.	dimension
Country	Country	The country component of a physical address.	dimension
Currency	Currency	The three-letter ISO 4217 currency code for monetary values.	dimension
Customer Email ID	Customer Email ID	The email address of the customer for the sales order.	dimension
Customer Order #	Customer Order #	The unique identification number assigned to a customer’s order.	metric
Customer Order ID	Customer Order ID	The unique identification number assigned to a customer’s order.	metric
Customer Order line #	Customer Order line #	The sequential number identifying a specific line item within a customer’s order.	metric
CustomerEmailId	CustomerEmailId	The email address of the customer for the sales order.	dimension
CustomerOrderId	CustomerOrderId	The unique identification number assigned to a customer’s order.	metric
Department	Department	The category or department to which a product belongs.	dimension
Estimated Delivery Date	Estimated Delivery Date	The anticipated date when the customer’s order is expected to be delivered.	metric
Estimated Ship Date	Estimated Ship Date	The date by which the seller is expected to ship the order and provide valid tracking information.	metric
EstimatedDeliveryDate	EstimatedDeliveryDate	The anticipated date when the customer’s order is expected to be delivered.	metric
EstimatedShipDate	EstimatedShipDate	The date by which the seller is expected to ship the order and provide valid tracking information.	metric
Fulfillment Details	Fulfillment Details	Detailed information regarding the fulfillment of an order, including specifics about how the order is handled for delivery or pickup. This can include whether partial fulfillments are allowed.	dimension
Fulfillment Lag Time	Fulfillment Lag Time	The number of operational days required by the seller to ship an order after it has been received.	metric
Fulfillment Option	Fulfillment Option	The chosen option for fulfilling an order, such as ‘Seller Fulfilled’ or ‘Walmart Fulfillment Services’.	dimension
Fulfillment Type	Fulfillment Type	The method used to fulfill an order, such as Seller Fulfilled or Walmart Fulfillment Services (WFS).	dimension
FulfillmentOption	FulfillmentOption	The chosen option for fulfilling an order, such as ‘Seller Fulfilled’ or ‘Walmart Fulfillment Services’.	dimension
GMV	GMV	The Gross Merchandise Value, representing the total sales volume in dollars for merchandise sold through the marketplace over a given period.	dimension
GMV Comp %	GMV Comp %	The year-over-year comparison percentage for Gross Merchandise Value (GMV).	dimension
GMV-Commission	GMV-Commission	The Gross Merchandise Value (GMV) less the total commission amount.	dimension
GTIN	GTIN	The Global Trade Item Number, a unique 14-digit identifier for a product.	metric
Incentive Program Name	Incentive Program Name	The name of the specific incentive program, such as ‘Walmart-funded incentives’ or ‘Reduced Referral Fee incentives’, offered to sellers to promote competitive pricing and boost sales.	dimension
Input Quantity	Input Quantity	The quantity of an item that is part of an input request, such as for inventory updates or order creation.	metric
Item Condition	Item Condition	The physical condition of the item, such as new, refurbished, or used.	dimension
Item Conversion Rate	Item Conversion Rate	The percentage of item views that result in a sale.	dimension
Item Creation Date	Item Creation Date	The date and time when an item was initially set up or 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 an item’s information, such as attributes or pricing, 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 status of an item within its lifecycle, such as active, retired, or unpublished.	dimension
Line Number	Line Number	The sequential number identifying a specific line item within an order or document.	metric
LineNumber	LineNumber	The sequential number identifying a specific line item within an order or document.	metric
MSRP	MSRP	The Manufacturer’s Suggested Retail Price for an item.	metric
Maximum Seller Allowed Price	Maximum Seller Allowed Price	The highest price a seller is permitted to list an item for on Walmart Marketplace.	metric
Method Code	Method Code	An identifier for a specific shipping or fulfillment method.	dimension
MethodCode	MethodCode	An identifier for a specific shipping or fulfillment method.	dimension
Minimum Seller Allowed Price	Minimum Seller Allowed Price	The lowest price a seller is permitted to list an item for on Walmart Marketplace.	metric
Offer End Date	Offer End Date	The date after which an item’s offer will no longer be visible or active on Walmart.com.	dimension
Offer Start Date	Offer Start Date	The date at which an item’s offer becomes visible and active on Walmart.com.	dimension
Order Date	Order Date	The date when the customer submitted the sales order.	metric
Order Line Status	Order Line Status	The status of a specific line item within an order (e.g., Created, Acknowledged, Shipped, Delivered, Cancelled).	dimension
OrderDate	OrderDate	The date when the customer submitted the sales order.	metric
Original Carrier Method	Original Carrier Method	The initial shipping carrier and method selected or used for an order.	metric
Original Commission	Original Commission	The initial commission amount charged by Walmart for a sale before any adjustments or savings.	metric
Original charge	Original charge	The initial amount charged for an item or a service before any adjustments or incentives.	metric
PRICE	PRICE	The current selling price of an item.	metric
PRODUCT NAME	PRODUCT NAME	The primary name or title of the product.	dimension
Partner GTIN	Partner GTIN	The Global Trade Item Number (GTIN) provided by the selling partner for a product.	metric
Partner Item Id	Partner Item Id	The unique identifier for an item as assigned by the selling partner.	metric
Partner Item Name	Partner Item Name	The name of the item as provided by the selling partner.	dimension
Period End Date	Period End Date	The end date of a specified reporting or data collection period.	dimension
Period Start Date	Period Start Date	The start date of a specified reporting or data collection period.	dimension
Phone	Phone	The customer’s phone number.	metric
Pick Up By	Pick Up By	The date or time by which an order is expected to be picked up by the customer or carrier.	dimension
Pick Up DateTime	Pick Up DateTime	The specific date and time an order is scheduled for pickup.	metric
PickUpDateTime	PickUpDateTime	The specific date and time an order is scheduled for pickup.	metric
Postal Code	Postal Code	The postal code or ZIP code of the recipient’s address.	metric
PostalCode	PostalCode	The postal code or ZIP code of the recipient’s address.	metric
Price	Price	The current selling price of an item.	metric
Primary Category Path	Primary Category Path	The full hierarchical path of the item’s primary category on Walmart.com.	dimension
Primary Image URL	Primary Image URL	The URL for the main image associated with a product listing.	dimension
Primary Variant?	Primary Variant?	Indicates whether an item is designated as the primary or default variant within a group of product variations.	dimension
Product Category	Product Category	A classification that helps customers find products and determines how products are grouped on the marketplace.	dimension
Product Level Conversion Rate	Product Level Conversion Rate	The rate at which views for a specific product convert into sales.	dimension
Product Level Pageviews	Product Level Pageviews	The number of times a specific product’s page has been viewed by customers.	dimension
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
Product Type	Product Type	A specific classification or type of product, used for detailed categorization and attribute requirements.	dimension
ProductName	ProductName	The primary name or title of the product.	dimension
Promo Effective Date	Promo Effective Date	The date when a promotional offer becomes active.	dimension
Promo Expiration Date	Promo Expiration Date	The date when a promotional offer ends.	dimension
Promo ID	Promo ID	A system-generated unique identifier for a specific promotion.	dimension
Promo Price	Promo Price	The special price offered during a promotion.	dimension
Promo Price Currency	Promo Price Currency	The currency of the promotional price.	dimension
Promo Status	Promo Status	The current status of a promotional offer (e.g., active, expired, pending).	dimension
Promo Type	Promo Type	The classification of the promotional offer (e.g., rollback, clearance).	dimension
Publish Status	Publish Status	Indicates whether an item is currently published and visible for sale on Walmart.com.	dimension
Purchase Order #	Purchase Order #	The unique identification number assigned to a purchase order.	metric
Purchase Order ID	Purchase Order ID	The unique identification number assigned to a purchase order.	metric
Purchase Order line #	Purchase Order line #	The sequential number identifying a specific line item within a purchase order.	metric
PurchaseOrderId	PurchaseOrderId	The unique identification number assigned to a purchase order.	metric
Quantity Amount	Quantity Amount	The numerical value representing the quantity of an item.	metric
QuantityAmount	QuantityAmount	The numerical value representing the quantity of an item.	metric
Recipient Name	Recipient Name	The full name of the person receiving the shipment.	dimension
RecipientName	RecipientName	The full name of the person receiving the shipment.	dimension
Refund	Refund	A monetary amount returned to a customer for an item or order.	dimension
Refunded Sales	Refunded Sales	The total sales value of items or orders for which a refund has been issued.	dimension
Reviews Count	Reviews Count	The total number of customer reviews submitted for an item.	metric
SHIP PRICE	SHIP PRICE	The cost associated with shipping the item to the customer.	dimension
SKU	SKU	The Seller’s Stock Keeping Unit, a unique alphanumeric identifier for each distinct product and variant.	metric
SKU ID	SKU ID	The Seller’s Stock Keeping Unit, a unique alphanumeric identifier for each distinct product and variant.	dimension
Searchable?	Searchable?	Indicates whether an item is discoverable through search on Walmart.com.	dimension
Ship Method	Ship Method	The chosen method for shipping an order, such as Standard, TwoDay, or Freight.	dimension
Ship Methods	Ship Methods	The available options for shipping an order, such as Standard, TwoDay, or Freight.	dimension
Ship Node ID	Ship Node ID	The unique identifier for a shipping node or fulfillment center.	dimension
Ship Node Name	Ship Node Name	The name of the shipping node or fulfillment center.	dimension
Ship Node Type	Ship Node Type	The classification of a shipping node, indicating its operational type (e.g., SellerFulfilled, WFSFulfilled).	dimension
Ship Qty	Ship Qty	The quantity of an item that has been shipped or is designated for shipment.	metric
Ship to City	Ship to City	The city of the destination address for shipping.	dimension
Ship to State	Ship to State	The state or province of the destination address for shipping.	dimension
Ship to Zipcode	Ship to Zipcode	The postal code or ZIP code of the destination address for shipping.	metric
ShipMethod	ShipMethod	The chosen method for shipping an order, such as Standard, TwoDay, or Freight.	dimension
Shipping Method	Shipping Method	The chosen method for shipping an order, such as Standard, TwoDay, or Freight.	dimension
Shipping Node Type	Shipping Node Type	The classification of a shipping node, indicating its operational type (e.g., SellerFulfilled, WFSFulfilled).	dimension
Shipping Program Type	Shipping Program Type	The type of shipping program used for an item, such as Standard, TwoDay, or OneDay shipping.	dimension
Shipping Weight	Shipping Weight	The weight of the item, including packaging, used for shipping calculations.	metric
Shipping Weight Unit	Shipping Weight Unit	The unit of measurement for the shipping weight (e.g., lbs, oz).	dimension
ShippingProgramType	ShippingProgramType	The type of shipping program used for an item, such as Standard, TwoDay, or OneDay shipping.	dimension
Sku	Sku	The Seller’s Stock Keeping Unit, a unique alphanumeric identifier for each distinct product and variant.	metric
State	State	The state or province component of a physical address.	dimension
Status Change Reason	Status Change Reason	This field indicates the reason why an item’s status changed within the Walmart Marketplace, such as missing images, expired offers, pricing issues, or trust and safety violations.	dimension
Status Date	Status Date	The date when a particular status was recorded for an order line or other entity.	metric
Store ID	Store ID	The unique identification number for a Walmart physical store.	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.	dimension
Total Payable	Total Payable	The total amount due to the seller after all sales, commissions, taxes, and adjustments have been applied.	metric
Total Product Visits	Total Product Visits	The total number of times a product’s page has been viewed by customers.	dimension
Total Units Sold	Total Units Sold	The total number of individual product units that have been sold.	dimension
Transaction Description	Transaction Description	A textual description detailing the nature of a financial transaction.	dimension
Transaction Key	Transaction Key	A unique identifier for a specific financial transaction.	metric
Transaction Posted Timestamp	Transaction Posted Timestamp	The date and time when a financial transaction was recorded or posted.	dimension
Transaction Reason Description	Transaction Reason Description	Provides a textual explanation for a specific transaction, such as a reason for a refund or cancellation.	dimension
Transaction Type	Transaction Type	The classification of a financial transaction (e.g., charge, refund, commission).	dimension
UPC	UPC	The Universal Product Code, a 12-digit barcode symbology used to track trade items.	metric
Unit Of Measurement	Unit Of Measurement	The unit used to quantify a product’s dimension, weight, or quantity (e.g., EACH, lbs, oz).	dimension
UnitOfMeasurement	UnitOfMeasurement	The unit used to quantify a product’s dimension, weight, or quantity (e.g., EACH, lbs, oz).	dimension
Variant Group Id	Variant Group Id	A unique identifier created by the seller to group related product variations together.	dimension
Variant Grouping Attributes	Variant Grouping Attributes	The attributes that differentiate items within a variant group, such as size or color.	dimension
Variant Grouping Values	Variant Grouping Values	The specific values for the variant grouping attributes (e.g., ‘red’ for color, ‘small’ for size).	dimension
WPID	WPID		dimension
actualDeliveryDate	actualDeliveryDate	The actual date when the order was delivered to the customer.	dimension
cancelDate	cancelDate	The date when an order or order line was canceled.	dimension
cancelReason	cancelReason	The reason provided for the cancellation of an order or order line.	dimension
cancellationCustomerFault	cancellationCustomerFault	Indicates if the cancellation was due to a fault or action initiated by the customer.	dimension
cancellationSellerFault	cancellationSellerFault	Indicates if the cancellation was due to a fault or action initiated by the seller.	metric
carrier	carrier	The shipping carrier responsible for delivering the order.	dimension
catlgItemId	catlgItemId	An identifier for an item within Walmart’s catalog.	dimension
destinationState	destinationState	The state or province of the shipping destination.	dimension
estimatedDeliveryDate	estimatedDeliveryDate	The anticipated date when the customer’s order is expected to be delivered.	dimension
offerConditionCode	offerConditionCode	A code indicating the condition of the item being offered for sale (e.g., new, refurbished, used).	metric
offerId	offerId	A unique identifier for a specific offer on an item.	dimension
orderLines.orderLine.charges.charge	orderLines.orderLine.charges.charge	A monetary amount applied as a charge to a specific line item within an order.	dimension
orderLines.orderLine.fulfillment.pickUpBy	orderLines.orderLine.fulfillment.pickUpBy	The date or time by which a specific order line item is expected to be picked up as part of its fulfillment.	dimension
orderLines.orderLine.fulfillment.storeId	orderLines.orderLine.fulfillment.storeId	The unique identification number of the store responsible for fulfilling a specific order line item.	dimension
orderLines.orderLine.orderLineStatuses.orderLineStatus	orderLines.orderLine.orderLineStatuses.orderLineStatus	The status of a specific line item within an order (e.g., Created, Acknowledged, Shipped, Delivered, Cancelled).	dimension
orderLines.orderLine.refund	orderLines.orderLine.refund	The monetary amount refunded for a specific line item within an order.	dimension
orderLines.orderLine.statusDate	orderLines.orderLine.statusDate	The date when a specific status was recorded for an order line item.	metric
orderPlacedDt	orderPlacedDt	The date and time when the customer’s order was initially placed.	dimension
otd	otd	Represents the On-Time Delivery (OTD) rate, which is a key seller performance metric indicating the percentage of orders delivered by or before the expected delivery date.	metric
ots	ots	Represents the On-Time Shipment (OTS) rate, a seller performance metric that measures the percentage of orders shipped by the expected ship date.	metric
partnerId	partnerId	The unique identification number for the selling partner (seller ID) on Walmart.com.	metric
period	period	The specified time frame or reporting interval for the data.	dimension
poNum	poNum	The purchase order number for an order.	dimension
refundRateCustomerFault	refundRateCustomerFault	The percentage of orders refunded due to reasons attributed to the customer (e.g., changed mind, wrong size).	metric
refundRateSellerFault	refundRateSellerFault	The percentage of orders refunded due to reasons attributed to the seller (e.g., damaged item, incorrect item sent).	metric
returnDate	returnDate	The date when an item was returned by the customer.	dimension
returnReason	returnReason	The reason provided by the customer for returning an item.	dimension
salesOrder	salesOrder	A unique identifier for a customer’s sales order.	metric
shippingNodeType	shippingNodeType	The classification of a shipping node, indicating its operational type (e.g., SellerFulfilled, WFSFulfilled).	dimension
trackingNum	trackingNum	The unique tracking number assigned to a package for monitoring its delivery status.	dimension
vtr	vtr	Represents the Valid Tracking Rate (VTR), a seller performance metric that indicates the percentage of orders for which valid tracking information is provided to Walmart.	metric