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 |
Use in Adverity |
|---|---|---|
AUR |
AUR |
dimension |
Address 1 |
Address 1 |
dimension |
Address 2 |
Address 2 |
dimension |
Address Type |
Address Type |
dimension |
Address1 |
Address1 |
dimension |
Address2 |
Address2 |
dimension |
AddressType |
AddressType |
dimension |
Amount |
Amount |
metric |
Amount Type |
Amount Type |
dimension |
Authorized Orders |
Authorized Orders |
dimension |
Authorized Sales |
Authorized Sales |
dimension |
Authorized Units |
Authorized Units |
dimension |
AvailToSell Quantity |
AvailToSell Quantity |
metric |
Average Rating |
Average Rating |
metric |
Base Commission Rate |
Base Commission Rate |
metric |
Base Item Id |
Base Item Id |
dimension |
Brand |
Brand |
dimension |
Buy Box Eligible |
Buy Box Eligible |
dimension |
Buy Box Item Price |
Buy Box Item Price |
metric |
Buy Box Shipping Price |
Buy Box Shipping Price |
metric |
CURRENCY |
CURRENCY |
dimension |
Cancelled Sales |
Cancelled Sales |
dimension |
Cancelled Units |
Cancelled Units |
dimension |
Carrier Method Name |
Carrier Method Name |
dimension |
Category |
Category |
dimension |
Charge |
Charge |
dimension |
City |
City |
dimension |
Commission |
Commission |
dimension |
Commission Incentive Program |
Commission Incentive Program |
dimension |
Commission Rate |
Commission Rate |
metric |
Commission Rule |
Commission Rule |
dimension |
Commission Saving |
Commission Saving |
metric |
Comparison Price |
Comparison Price |
dimension |
Comparison Price Currency |
Comparison Price Currency |
dimension |
Country |
Country |
dimension |
Currency |
Currency |
dimension |
Customer Email ID |
Customer Email ID |
dimension |
Customer Order # |
Customer Order # |
metric |
Customer Order ID |
Customer Order ID |
metric |
Customer Order line # |
Customer Order line # |
metric |
CustomerEmailId |
CustomerEmailId |
dimension |
CustomerOrderId |
CustomerOrderId |
metric |
Department |
Department |
dimension |
Estimated Delivery Date |
Estimated Delivery Date |
metric |
Estimated Ship Date |
Estimated Ship Date |
metric |
EstimatedDeliveryDate |
EstimatedDeliveryDate |
metric |
EstimatedShipDate |
EstimatedShipDate |
metric |
Fulfillment Details |
Fulfillment Details |
dimension |
Fulfillment Lag Time |
Fulfillment Lag Time |
metric |
Fulfillment Option |
Fulfillment Option |
dimension |
Fulfillment Type |
Fulfillment Type |
dimension |
FulfillmentOption |
FulfillmentOption |
dimension |
GMV |
GMV |
dimension |
GMV Comp % |
GMV Comp % |
dimension |
GMV-Commission |
GMV-Commission |
dimension |
GTIN |
GTIN |
metric |
Input Quantity |
Input Quantity |
metric |
Item Condition |
Item Condition |
dimension |
Item Conversion Rate |
Item Conversion Rate |
dimension |
Item Creation Date |
Item Creation Date |
dimension |
Item ID |
Item ID |
metric |
Item Last Updated |
Item Last Updated |
dimension |
Item Page URL |
Item Page URL |
dimension |
Lifecycle Status |
Lifecycle Status |
dimension |
Line Number |
Line Number |
metric |
LineNumber |
LineNumber |
metric |
MSRP |
MSRP |
metric |
Maximum Seller Allowed Price |
Maximum Seller Allowed Price |
metric |
Method Code |
Method Code |
dimension |
MethodCode |
MethodCode |
dimension |
Minimum Seller Allowed Price |
Minimum Seller Allowed Price |
metric |
Offer End Date |
Offer End Date |
dimension |
Offer Start Date |
Offer Start Date |
dimension |
Order Date |
Order Date |
metric |
Order Line Status |
Order Line Status |
dimension |
OrderDate |
OrderDate |
metric |
Original Carrier Method |
Original Carrier Method |
metric |
Original Commission |
Original Commission |
metric |
PRICE |
PRICE |
metric |
PRODUCT NAME |
PRODUCT NAME |
dimension |
Partner GTIN |
Partner GTIN |
metric |
Partner Item Id |
Partner Item Id |
metric |
Partner Item Name |
Partner Item Name |
dimension |
Period End Date |
Period End Date |
dimension |
Period Start Date |
Period Start Date |
dimension |
Phone |
Phone |
metric |
Pick Up By |
Pick Up By |
dimension |
Pick Up DateTime |
Pick Up DateTime |
metric |
PickUpDateTime |
PickUpDateTime |
metric |
Postal Code |
Postal Code |
metric |
PostalCode |
PostalCode |
metric |
Price |
Price |
metric |
Primary Category Path |
Primary Category Path |
dimension |
Primary Image URL |
Primary Image URL |
dimension |
Primary Variant? |
Primary Variant? |
dimension |
Product Category |
Product Category |
dimension |
Product Level Conversion Rate |
Product Level Conversion Rate |
dimension |
Product Level Pageviews |
Product Level Pageviews |
dimension |
Product Name |
Product Name |
dimension |
Product Tax Code |
Product Tax Code |
metric |
Product Type |
Product Type |
dimension |
ProductName |
ProductName |
dimension |
Promo Effective Date |
Promo Effective Date |
dimension |
Promo Expiration Date |
Promo Expiration Date |
dimension |
Promo ID |
Promo ID |
dimension |
Promo Price |
Promo Price |
dimension |
Promo Price Currency |
Promo Price Currency |
dimension |
Promo Status |
Promo Status |
dimension |
Promo Type |
Promo Type |
dimension |
Publish Status |
Publish Status |
dimension |
Purchase Order # |
Purchase Order # |
metric |
Purchase Order ID |
Purchase Order ID |
metric |
Purchase Order line # |
Purchase Order line # |
metric |
PurchaseOrderId |
PurchaseOrderId |
metric |
Quantity Amount |
Quantity Amount |
metric |
QuantityAmount |
QuantityAmount |
metric |
Recipient Name |
Recipient Name |
dimension |
RecipientName |
RecipientName |
dimension |
Refund |
Refund |
dimension |
Refunded Sales |
Refunded Sales |
dimension |
Reviews Count |
Reviews Count |
metric |
SHIP PRICE |
SHIP PRICE |
dimension |
SKU |
SKU |
metric |
SKU ID |
SKU ID |
dimension |
Searchable? |
Searchable? |
dimension |
Ship Method |
Ship Method |
dimension |
Ship Methods |
Ship Methods |
dimension |
Ship Node ID |
Ship Node ID |
dimension |
Ship Node Name |
Ship Node Name |
dimension |
Ship Node Type |
Ship Node Type |
dimension |
Ship Qty |
Ship Qty |
metric |
Ship to City |
Ship to City |
dimension |
Ship to State |
Ship to State |
dimension |
Ship to Zipcode |
Ship to Zipcode |
metric |
ShipMethod |
ShipMethod |
dimension |
Shipping Method |
Shipping Method |
dimension |
Shipping Node Type |
Shipping Node Type |
dimension |
Shipping Program Type |
Shipping Program Type |
dimension |
Shipping Weight |
Shipping Weight |
metric |
Shipping Weight Unit |
Shipping Weight Unit |
dimension |
ShippingProgramType |
ShippingProgramType |
dimension |
Sku |
Sku |
metric |
State |
State |
dimension |
Status Change Reason |
Status Change Reason |
dimension |
Status Date |
Status Date |
metric |
Store ID |
Store ID |
dimension |
Sub Category |
Sub Category |
dimension |
Super Department |
Super Department |
dimension |
Total LY GMV |
Total LY GMV |
dimension |
Total Payable |
Total Payable |
metric |
Total Product Visits |
Total Product Visits |
dimension |
Total Units Sold |
Total Units Sold |
dimension |
Transaction Description |
Transaction Description |
dimension |
Transaction Key |
Transaction Key |
metric |
Transaction Posted Timestamp |
Transaction Posted Timestamp |
dimension |
Transaction Reason Description |
Transaction Reason Description |
dimension |
Transaction Type |
Transaction Type |
dimension |
UPC |
UPC |
metric |
Unit Of Measurement |
Unit Of Measurement |
dimension |
UnitOfMeasurement |
UnitOfMeasurement |
dimension |
Variant Group Id |
Variant Group Id |
dimension |
Variant Grouping Attributes |
Variant Grouping Attributes |
dimension |
Variant Grouping Values |
Variant Grouping Values |
dimension |
WPID |
WPID |
dimension |
actualDeliveryDate |
actualDeliveryDate |
dimension |
cancelDate |
cancelDate |
dimension |
cancelReason |
cancelReason |
dimension |
cancellationCustomerFault |
cancellationCustomerFault |
dimension |
cancellationSellerFault |
cancellationSellerFault |
metric |
carrier |
carrier |
dimension |
catlgItemId |
catlgItemId |
dimension |
destinationState |
destinationState |
dimension |
estimatedDeliveryDate |
estimatedDeliveryDate |
dimension |
offerConditionCode |
offerConditionCode |
metric |
offerId |
offerId |
dimension |
orderLines.orderLine.charges.charge |
orderLines.orderLine.charges.charge |
dimension |
orderLines.orderLine.fulfillment.pickUpBy |
orderLines.orderLine.fulfillment.pickUpBy |
dimension |
orderLines.orderLine.fulfillment.storeId |
orderLines.orderLine.fulfillment.storeId |
dimension |
orderLines.orderLine.orderLineStatuses.orderLineStatus |
orderLines.orderLine.orderLineStatuses.orderLineStatus |
dimension |
orderLines.orderLine.refund |
orderLines.orderLine.refund |
dimension |
orderLines.orderLine.statusDate |
orderLines.orderLine.statusDate |
metric |
orderPlacedDt |
orderPlacedDt |
dimension |
partnerId |
partnerId |
metric |
period |
period |
dimension |
poNum |
poNum |
dimension |
refundRateCustomerFault |
refundRateCustomerFault |
metric |
refundRateSellerFault |
refundRateSellerFault |
metric |
returnDate |
returnDate |
dimension |
returnReason |
returnReason |
dimension |
salesOrder |
salesOrder |
metric |
shippingNodeType |
shippingNodeType |
dimension |
trackingNum |
trackingNum |
dimension |