Marketplace Reports
Historical Availability
Historical availability of data refers to the pulling in of past data from Walmart Market place in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.
Orders report
180 days
Data Source
To enable the Walmart Marketplace Reports, the datasource: Walmart Seller Marketplace/Walmart Vendor Marketplace has to be enabled on the Intentwise Platform
MarketPlace Order LineItem
Table name: marketplace_orderlineitem
For complete documentation, please click here.
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
currency_code
String
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
String
Countries associated with the account
purchase_order_id
String
A unique ID associated with the seller's purchase order
customer_order_id
String
The customer order ID
sku
String
A seller-provided Product ID
order_date
Timestamp
The date the customer submitted the sales order
quantity_unit_measurement
String
Unit of quantity
quantity_amount
Integer
The quantity of the unit of measurement for the item.
product_name
String
The name of the product associated with the line item.
line_item_status
String
Status of Line Item
last_status_modified_date
Timestamp
Last status modified date
order_type
String
Specifies if the order is a regular order or replacement order.
customer_email_id
String
The email address of the customer for the sales order
original_customer_order_id
Integer
A unique ID associated with the sales order for specified customer
shipping_phone
String
The customer's phone number
shipping_estimated_delivery_date
Timestamp
The estimated time and date for the delivery of the item.
shipping_estimated_ship_date
Timestamp
The estimated time and date when the item will be shipped.
shipping_method_code
String
The shipping method. Can be one of the following: Standard, Express, OneDay, WhiteGlove, Value or Freight
shipping_postaladdress_name
String
Elements of the customer's postal address
shipping_postaladdress_address1
String
Elements of the customer's postal address
shipping_postaladdress_address2
String
Elements of the customer's postal address
shipping_postaladdress_city
String
Elements of the customer's postal address
shipping_postaladdress_state
String
Elements of the customer's postal address
shipping_postaladdress_postal_code
String
Elements of the customer's postal address
shipping_postaladdress_country
String
Elements of the customer's postal address
shipping_postaladdress_address_type
String
Elements of the customer's postal address
line_number
String
The line number associated with the details for each individual item in the purchase order
fulfillment_option
String
Example : S2H, S2S, etc.
fulfillment_ship_method
String
Example : Value, Expedited, Standard, Rush, etc.
fulfillment_pickup_datetime
String
Gives pick up datetime information
seller_id
Integer
Seller ID
shipnode_type
String
Specifies the type of shipNode.
buyer_id
String
Unique ID of the buyer
mart
String
is_guest
String
payment_types
String
Type of Payment
shipnode_name
String
Name of Shipnode
shipnode_id
String
Unique ID of shipnode
item_condition
String
Information about the condition of the product.
item_image_url
String
Web URL for the image of the item.
item_weight_value
String
Weight Value
item_weight_unit
String
Unit Weight
return_order_id
String
Return Order IS
original_carrier_method
String
Carrier Method
reference_line_id
String
Reference Line ID
serial_numbers
String
intent_to_cancel
String
config_id
String
Config ID
seller_order_id
String
A unique ID associated with the sales order for specified Seller
total_amount
Integer
Total Amount
currency
String
Currency
refund_id
String
Refund ID
refund_comments
String
Refund Comments
fulfillment_store_id
String
Fulfillment Store ID
fulfillment_pickup_by
String
Fulfillment Picked by
fulfillment_shipping_program_type
String
Type of Shipping Program
download_date
Timestamp
Download Date
MarketPlace Order LineItemCharge
Table name: marketplace_orderlineitemcharge
For complete documentation, please click here.
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
currency_code
string
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
string
Countries associated with the account
purchase_order_id
string
A unique ID associated with the seller's purchase order
customer_order_id
string
The customer order ID
sku
string
A seller-provided Product ID
currency
string
Currency
charge_type
string
The charge type for line items can be one of the following: PRODUCT or SHIPPING
charge_name
string
If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount
amount
integer
The details for the amount of the tax charge
tax_name
string
The name associated with the tax.
tax_amount
integer
The details for the amount of the tax charge
seller_id
integer
Seller ID of the seller
line_number
string
Line Number
download_date
timestamp
Download Date
MarketPlace Order LineItemRefundCharge
Table name: marketplace_orderlineitemrefundcharge
For complete documentation, please click here.
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
currency_code
string
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
string
Countries associated with the account
purchase_order_id
string
A unique ID associated with the seller's purchase order
customer_order_id
string
The customer order ID
line_number
string
Line Number
refund_id
string
Refund ID
refund_reason
string
Reason of refund
charge_type
string
The charge type for line items can be one of the following: PRODUCT or SHIPPING
charge_name
string
If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount
charge_amount
integer
The details for the amount of the tax charge
tax_name
string
The name associated with the tax.
tax_amount
integer
The details for the amount of the tax charge
currency
string
Currency
download_date
timestamp
Download Date
seller_id
integer
Unique Seller ID of the Seller
MarketPlace Order LineItemStatus
Table name: marketplace_orderlineitemstatus
For complete documentation, please click here.
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
currency_code
string
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
string
Countries associated with the account
purchase_order_id
string
A unique ID associated with the seller's purchase order
customer_order_id
string
The customer order ID
line_number
string
Line Number
status
string
Status
statusquantity_amount
integer
The quantity of the unit of measurement for the item.
statusquantity_unit_of_measurement
string
Unit of quantity
cancellation_reason
string
If order is cancelled, cancellationReason will explain the reason
trackinginfo_ship_date_time
timestamp
List of information about the package shipment and tracking updates
trackinginfo_method_code
string
List of information about the package shipment and tracking updates
trackinginfo_tracking_number
string
List of information about the package shipment and tracking updates
trackinginfo_tracking_url
string
List of information about the package shipment and tracking updates
carriername_other_carrier
string
List of information about the package shipment and tracking updates
carriername_carrier
string
List of information about the package shipment and tracking updates
returncenteraddress_name
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_address1
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_address2
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_city
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_state
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_postal_code
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_country
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_day_phone
string
Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_email_id
string
Gives Sellers the ability to specify the RC center address during fulfillment
download_date
timestamp
Download Date
seller_id
integer
Unique Seller ID of the Seller
MarketPlace Order PickupPerson
Table name: marketplace_orderpickupperson
For complete documentation, please click here.
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
currency_code
string
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
string
Countries associated with the account
purchase_order_id
string
A unique ID associated with the seller's purchase order
customer_order_id
string
The customer order ID
complete_name
string
Details of the pickup person
first_name
string
Details of the pickup person
middle_name
string
Details of the pickup person
last_name
string
Details of the pickup person
general_suffix
string
Details of the pickup person
maturity_suffix
string
Details of the pickup person
title_of_respect
string
Details of the pickup person
empty
string
phone_id
string
Details of the pickup person
phone_area_code
string
Details of the pickup person
phone_extension
string
Details of the pickup person
phone_complete_number
string
Details of the pickup person
phone_type
string
Details of the pickup person
phone_subscriber_number
string
Details of the pickup person
phone_country_code
string
Details of the pickup person
phonevalidity_validation_type
string
Details of the pickup person
phonevalidity_validation_status
string
Details of the pickup person
phonevalidity_validated_date
timestamp
Details of the pickup person
phonevalidity_validated_by
string
Details of the pickup person
download_date
timestamp
Download Date
seller_id
integer
Unique Seller ID of the Seller
MarketPlace Order SubTotal
Table name: marketplace_ordersubtotal
For complete documentation, please click here.
account_id
integer
Intentwise account id
account_name
string
Intentwise account name
currency_code
string
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
string
Countries associated with the account
purchase_order_id
string
A unique ID associated with the seller's purchase order
customer_order_id
string
The customer order ID
sub_total_type
string
Total type
currency
string
Currency Unit
subtotal_amount
integer
Total Amount
download_date
timestamp
Download Date
seller_id
integer
Unique Seller ID of the Seller
MarketPlace Item Listing Quality
Table name: marketplace_item_listingquality
For complete documentation, please click here.
account_id
Integer
Intentwise Account ID
account_name
String
Intentwise account name
currency_code
String
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
String
Countries associated with the account
product_id
String
A unique ID associated with the seller's product
quality_score
Numeric
shipping_speed_impact
String
shipping_speed_score_value
Numeric
content_and_discoverability_impact
String
content_and_discoverability_score_value
Numeric
rating_and_reviews_impact
String
rating_and_reviews_score_value
Numeric
published_and_in_stock_impact
String
published_and_in_stock_score_value
Numeric
price_competitiveness_impact
String
price_competitiveness_score_value
Numeric
offer_impact
String
offer_score_value
Numeric
score_details
Super
wfs_enabled
Boolean
priority
String
category_name
String
product_name
String
item_id
String
stats
Super
post_purchase_issues
String
sku
String
A seller-provided Product ID
condition
String
product_type
String
trends
Super
last_30_days_conversion_rate
Numeric
last_30_days_page_views
Integer
gmv
Numeric
is_customer_favorites
Boolean
is_in_stock
Boolean
is_fast_and_free_shipping
Boolean
updated_timestamp
Date
Updated Timestamp
seller_id
Integer
Seller ID
download_date
Date
Download Date
MarketPlace Item Listing Quality Score Details
Table name: marketplace_item_listingquality_scoredetails
For complete documentation, please click here.
account_id
Integer
Intentwise Account ID
account_name
String
Intentwise account name
currency_code
String
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
String
Countries associated with the account
product_id
String
A unique ID associated with the seller's product
metric_name
String
Name of the metric
score_value
Numeric
Value of the score
seller_id
Integer
Seller ID
download_date
Date
Download Date
MarketPlace Reconciliation On SKU
Table name: marketplace_reconciliation_on_sku
For complete documentation, please click here.
account_id
Integer
Intentwise Account ID
account_name
String
Account Display Name
currency_code
String
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
String
Countries associated with the account
seller_id
Integer
Selling Partner ID
recon_date
Date
Date on which reconciliation report is available for download.
transaction_type
String
Indicates a debit or a credit Reserve: Funds debited from your account to cover for future refunds Release Reserve: Funds credited against a previous account reserve Sale: Transactions credited to your account for the orders shipped in each payment period Refund: Transactions refunded against a sale order Dispute Settlement: Adjustments credited or debited as part of dispute resolution Adjustment: A miscellaneous credit or debit made by Walmart to your account, including receiving error chargeback, damage in warehouse, lost inventory, and found inventory Service Fee: Debits applied to your account as payment for different Walmart services, including WFS fulfillment fee, storage fee, and more
transaction_description
String
Reason for the debit or credit
transaction_posted_timestamp
Date
Date that the transaction was posted in our payment system
amount
Numeric
Amount that was credited or debited to your account for the transaction
amount_type
String
Reason for the amount transaction, such as product price, product tax, shipping, commission on product, and more
transaction_key
String
Identifier that Walmart uses to internally track the transactions in case a seller contacts our operations team
transaction_reason_description
String
Describes the reason for a refund. This is only available if transaction type is refund.
partner_item_id
String
SKU of the purchased item
partner_gtin
String
GTIN of the purchased item (if applicable)
partner_item_name
String
Name of your item as it appears on Walmart.com
product_tax_code
String
Item's tax code, used to calculate sales tax for the item
product_type
String
Type of item sold
customer_order
Integer
Order number that the Walmart customer gets. One order number can be associated with multiple transactions.
customer_order_line
Integer
Line item within the customer order number that uniquely identifies an order
purchase_order
Integer
Unique number assigned to a specific inbound order
purchase_order_line
Integer
Line item within the PO number of the particular SKU that was ordered
ship_qty
String
Number of items sold or refunded
ship_to_state
String
Customer state where order was shipped
ship_to_city
String
Customer city where order was shipped
ship_to_zipcode
Integer
Customer zip code where order was shipped
shipping_method
String
Shipment speed chosen by the customer
fulfillment_type
String
Whether the item was seller-fulfilled or Walmart-fulfilled (WFS)
contract_category
String
Product category used to determine the commission for the item.
commission_rate
Numeric
Rate applied to your sale order, as determined by the contract category of the item
commission_rule
String
Dynamic commission rule ID (if applicable)
commission_saving
String
Discount on Referral Fee
commission_incentive_program
String
Program under which Discount was applied (Commission Incentive Program (Flash Deals/Custom Deals), Pricing Incentives (Competitive Adjusted Pricing, Reduced Referral Fee (BCAP), Pro Seller etc)
original_commission
String
Base Referral Fee
total_walmart_funded_savings_program
String
Total savings across Programs - WFS, Incentives, WMC etc.
download_date
Date
Download Date
MarketPlace Reconciliation On Account
Table name: marketplace_reconciliation_on_account
For complete documentation, please click here.
account_id
Integer
Intentwise Account ID
account_name
String
Account Display Name
currency_code
String
One single currency for billing, budgeting, bid settings & campaign performance metrics
country_code
String
Countries associated with the account
seller_id
Integer
Selling Partner ID
recon_date
Date
Date on which reconciliation report is available for download.
period_start_date
Date
Report Start Date
period_end_date
Date
Report End Date
total_payable
Numeric
The net amount transferred to your payment processor account for this payment cycle. It’s the sum of all transactions reflected in Amount field
currency
String
Currency
transaction_type
String
Indicates a debit or a credit Reserve: Funds debited from your account to cover for future refunds Release Reserve: Funds credited against a previous account reserve Sale: Transactions credited to your account for the orders shipped in each payment period Refund: Transactions refunded against a sale order Dispute Settlement: Adjustments credited or debited as part of dispute resolution Adjustment: A miscellaneous credit or debit made by Walmart to your account, including receiving error chargeback, damage in warehouse, lost inventory, and found inventory Service Fee: Debits applied to your account as payment for different Walmart services, including WFS fulfillment fee, storage fee, and more
transaction_description
String
Reason for the debit or credit
transaction_posted_timestamp
Date
Date that the transaction was posted in our payment system
amount
Numeric
Amount that was credited or debited to your account for the transaction
amount_type
String
Reason for the amount transaction, such as product price, product tax, shipping, commission on product, and more
campaign_id
String
Campaign Name for Walmart Connect sellers
download_date
Date
Download Date
Last updated
Was this helpful?