Marketplace Reports
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 |
Last updated