Walmart Marketplace
The table below gives information about all the data fields that you can import from Walmart Marketplace.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
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 |
|