Walmart Marketplace

The table below gives information about all the data fields that you can import from Walmart Marketplace.

Field UI name

Field API name

Data Type

Description

Use in Adverity

Docs

AAIA Brand ID

AAIA Brand ID

String

dimension

AUR

AUR

Float

metric

Address1

Address1

String

dimension

Address2

Address2

String

dimension

AddressType

AddressType

String

dimension

Authorized Orders

Authorized Orders

Float

metric

Authorized Sales

Authorized Sales

Float

metric

Authorized Units

Authorized Units

Integer

metric

AvailToSell Quantity

AvailToSell Quantity

Long

metric

Average Rating

Average Rating

Float

metric

Base Item Id

Base Item Id

String

dimension

Brand

Brand

String

dimension

Buy Box Eligible

Buy Box Eligible

Boolean

dimension

Buy Box Item Price

Buy Box Item Price

Float

metric

Buy Box Shipping Price

Buy Box Shipping Price

Float

metric

CURRENCY

CURRENCY

String

dimension

Cancelled Sales

Cancelled Sales

Float

metric

Cancelled Units

Cancelled Units

Integer

metric

Category

Category

String

dimension

City

City

String

dimension

Commission

Commission

String

dimension

Comparison Price

Comparison Price

Float

metric

Comparison Price Currency

Comparison Price Currency

String

dimension

Competitor Last Date Fetched

Competitor Last Date Fetched

Date

dimension

Competitor Price

Competitor Price

Float

metric

Competitor Ship Price

Competitor Ship Price

Float

metric

Competitor URL

Competitor URL

String

dimension

Country

Country

String

dimension

Coverage Areas

Coverage Areas

String

dimension

Currency

Currency

String

dimension

CustomerEmailId

CustomerEmailId

String

dimension

CustomerOrderId

CustomerOrderId

String

dimension

Department

Department

String

dimension

EstimatedDeliveryDate

EstimatedDeliveryDate

Date

dimension

EstimatedShipDate

EstimatedShipDate

Date

dimension

Fulfillment Lag Time

Fulfillment Lag Time

Integer

metric

Fulfillment Type

Fulfillment Type

String

dimension

FulfillmentOption

FulfillmentOption

String

dimension

GMV

GMV

Float

metric

GMV Comp %

GMV Comp %

Float

metric

GMV-Commission

GMV-Commission

Float

metric

GTIN

GTIN

String

dimension

Input Quantity

Input Quantity

Long

metric

Item Conversion Rate

Item Conversion Rate

Float

metric

Item Creation Date

Item Creation Date

Date

dimension

Item ID

Item ID

String

dimension

Item Last Updated

Item Last Updated

String

dimension

Item Page URL

Item Page URL

String

dimension

Lifecycle Status

Lifecycle Status

String

dimension

LineNumber

LineNumber

Long

dimension

MSRP

MSRP

Float

metric

Manufacturer Part Number

Manufacturer Part Number

String

dimension

Maximum Seller Allowed Price

Maximum Seller Allowed Price

Float

metric

MethodCode

MethodCode

String

dimension

Minimum Seller Allowed Price

Minimum Seller Allowed Price

Float

metric

Offer End Date

Offer End Date

Date

dimension

Offer Start Date

Offer Start Date

Date

dimension

OrderDate

OrderDate

Date

dimension

PRICE

PRICE

Float

metric

PRODUCT NAME

PRODUCT NAME

String

dimension

Part Terminology Id

Part Terminology Id

String

dimension

Partner ID

Partner ID

String

dimension

Phone

Phone

String

dimension

PickUpDateTime

PickUpDateTime

DateTime

metric

PostalCode

PostalCode

String

dimension

Price

Price

Float

metric

Primary Category Path

Primary Category Path

JSON

dimension

Primary Image URL

Primary Image URL

String

dimension

Primary Variant?

Primary Variant?

String

dimension

Product Category

Product Category

String

dimension

Product Level Conversion Rate

Product Level Conversion Rate

Float

metric

Product Level Pageviews

Product Level Pageviews

Long

metric

Product Name

Product Name

JSON

dimension

Product Tax Code

Product Tax Code

String

dimension

ProductName

ProductName

String

dimension

Program Participation

Program Participation

String

dimension

Promo Effective Date

Promo Effective Date

Date

dimension

Promo Expiration Date

Promo Expiration Date

Date

dimension

Promo ID

Promo ID

String

dimension

Promo Price

Promo Price

Float

metric

Promo Price Currency

Promo Price Currency

String

dimension

Promo Status

Promo Status

String

dimension

Promo Type

Promo Type

String

dimension

Publish Status

Publish Status

String

dimension

PurchaseOrderId

PurchaseOrderId

String

dimension

QuantityAmount

QuantityAmount

Long

metric

RecipientName

RecipientName

String

dimension

Refunded Sales

Refunded Sales

Float

metric

Repricer Status

Repricer Status

String

dimension

Repricer Strategy

Repricer Strategy

String

dimension

Reviews Count

Reviews Count

Long

metric

SHIP PRICE

SHIP PRICE

Float

metric

SKU

SKU

String

dimension

SKU ID

SKU ID

String

dimension

SKU OPT IN

SKU OPT IN

String

dimension

Searchable?

Searchable?

Boolean

dimension

Shelf Name

Shelf Name

String

dimension

Ship Methods

Ship Methods

String

dimension

Ship Node ID

Ship Node ID

String

dimension

Ship Node Name

Ship Node Name

String

dimension

Ship Node Type

Ship Node Type

String

dimension

ShipMethod

ShipMethod

String

dimension

Shipping Weight

Shipping Weight

Float

metric

Shipping Weight Unit

Shipping Weight Unit

JSON

dimension

ShippingProgramType

ShippingProgramType

String

dimension

Sku

Sku

String

dimension

State

State

String

dimension

Status Change Reason

Status Change Reason

String

dimension

Sub Category

Sub Category

String

dimension

Super Department

Super Department

String

dimension

Template ID

Template ID

String

dimension

Template Name

Template Name

String

dimension

Template Type

Template Type

String

dimension

Total LY GMV

Total LY GMV

Float

metric

Total Product Visits

Total Product Visits

Long

metric

Total Units Sold

Total Units Sold

Integer

metric

UPC

UPC

String

dimension

UnitOfMeasurement

UnitOfMeasurement

String

dimension

Variant Group Id

Variant Group Id

String

dimension

Variant Grouping Attributes

Variant Grouping Attributes

String

dimension

Variant Grouping Values

Variant Grouping Values

String

dimension

WFS Sales Restriction

WFS Sales Restriction

String

dimension

WPID

WPID

String

dimension

actualDeliveryDate

actualDeliveryDate

Date

dimension

cancelDate

cancelDate

Date

dimension

cancelReason

cancelReason

JSON

dimension

cancellationCustomerFault

cancellationCustomerFault

String

dimension

cancellationSellerFault

cancellationSellerFault

String

dimension

carrier

carrier

JSON

dimension

catlgItemId

catlgItemId

String

dimension

defectType

defectType

String

dimension

destinationState

destinationState

JSON

dimension

estimatedDeliveryDate

estimatedDeliveryDate

Date

dimension

legacySlrId

legacySlrId

String

dimension

offerId

offerId

JSON

dimension

orderLines.orderLine.charges.charge

orderLines.orderLine.charges.charge

JSON

dimension

orderLines.orderLine.fulfillment.pickUpBy

orderLines.orderLine.fulfillment.pickUpBy

String

dimension

orderLines.orderLine.fulfillment.storeId

orderLines.orderLine.fulfillment.storeId

String

dimension

orderLines.orderLine.intentToCancel

orderLines.orderLine.intentToCancel

Boolean

dimension

orderLines.orderLine.orderLineStatuses.orderLineStatus

orderLines.orderLine.orderLineStatuses.orderLineStatus

String

dimension

orderLines.orderLine.refund

orderLines.orderLine.refund

String

dimension

orderLines.orderLine.statusDate

orderLines.orderLine.statusDate

Date

dimension

orderPlacedDt

orderPlacedDt

Date

dimension

otd

otd

Float

metric

ots

ots

Float

metric

partnerId

partnerId

String

dimension

period

period

String

dimension

poNum

poNum

String

dimension

refundRateCustomerFault

refundRateCustomerFault

Float

metric

refundRateSellerFault

refundRateSellerFault

Float

metric

returnDate

returnDate

Date

dimension

returnReason

returnReason

String

dimension

salesOrder

salesOrder

Long

metric

shippingNodeType

shippingNodeType

String

dimension

trackingNum

trackingNum

String

dimension

vtr

vtr

Float

metric