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

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