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.

Report Type
Historical Availability

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.

Column Name
DataType
Description

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.

Column Name
Data Type
Description

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.

Column Name
Data Type
Description

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.

Column Name
Data Type
Description

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.

Column Name
Data Type
Description

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.

Column Name
Data Type
Description

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.

Column Name
Data type
Description

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.

Column Name
Data type
Description

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.

Column Name
Data type
Description

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.

Column Name
Data type
Description

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?