---
title: "Shopee Commerce metrics and dimensions"
slug: "shopee-commerce-fields"
description: "Explore the complete list of Shopee Commerce metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports."
updated: 2026-05-12T09:02:14Z
published: 2026-05-12T09:02:14Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Shopee Commerce metrics and dimensions

> Supermetrics brings all your Shopee Commerce data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse)

39 metrics163 dimensionsSearch fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### BUYER

| \| buyer_cpf_id** \| \| --- \| \| \\| Field label \\| Buyer CPF ID \\| \\| --- \\| --- \\| \\| Description \\| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer CPF ID \| \| Description \| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| buyer_cpf_id** |
| \| Field label \| Buyer CPF ID \| \| --- \| --- \| \| Description \| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer CPF ID |
| Description | Buyer's CPF number for taxation and invoice purposes. Only for Brazil order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| buyer_user_id** \| \| --- \| \| \\| Field label \\| Buyer user ID \\| \\| --- \\| --- \\| \\| Description \\| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer user ID \| \| Description \| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| buyer_user_id** |
| \| Field label \| Buyer user ID \| \| --- \| --- \| \| Description \| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer user ID |
| Description | The user id of buyer of this order, will be empty if it is a non-integrated order in TW region |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| buyer_username** \| \| --- \| \| \\| Field label \\| Buyer username \\| \\| --- \\| --- \\| \\| Description \\| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer username \| \| Description \| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| buyer_username** |
| \| Field label \| Buyer username \| \| --- \| --- \| \| Description \| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer username |
| Description | The name of buyer, will be masked as "****" if it is a non-integrated order in TW region |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| buyer_cancel_reason** \| \| --- \| \| \\| Field label \\| Buyer cancel reason \\| \\| --- \\| --- \\| \\| Description \\| Cancel reason from buyer, could be empty \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer cancel reason \| \| Description \| Cancel reason from buyer, could be empty \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| buyer_cancel_reason** |
| \| Field label \| Buyer cancel reason \| \| --- \| --- \| \| Description \| Cancel reason from buyer, could be empty \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer cancel reason |
| Description | Cancel reason from buyer, could be empty |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_buyer_cpf_id** \| \| --- \| \| \\| Field label \\| Buyer CPF ID \\| \\| --- \\| --- \\| \\| Description \\| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer CPF ID \| \| Description \| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_buyer_cpf_id** |
| \| Field label \| Buyer CPF ID \| \| --- \| --- \| \| Description \| Buyer's CPF number for taxation and invoice purposes. Only for Brazil order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer CPF ID |
| Description | Buyer's CPF number for taxation and invoice purposes. Only for Brazil order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_buyer_user_id** \| \| --- \| \| \\| Field label \\| Buyer user ID \\| \\| --- \\| --- \\| \\| Description \\| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer user ID \| \| Description \| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_buyer_user_id** |
| \| Field label \| Buyer user ID \| \| --- \| --- \| \| Description \| The user id of buyer of this order, will be empty if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer user ID |
| Description | The user id of buyer of this order, will be empty if it is a non-integrated order in TW region |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_buyer_username** \| \| --- \| \| \\| Field label \\| Buyer username \\| \\| --- \\| --- \\| \\| Description \\| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer username \| \| Description \| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_buyer_username** |
| \| Field label \| Buyer username \| \| --- \| --- \| \| Description \| The name of buyer, will be masked as "****" if it is a non-integrated order in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer username |
| Description | The name of buyer, will be masked as "****" if it is a non-integrated order in TW region |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_buyer_cancel_reason** \| \| --- \| \| \\| Field label \\| Buyer cancel reason \\| \\| --- \\| --- \\| \\| Description \\| Cancel reason from buyer, could be empty \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer cancel reason \| \| Description \| Cancel reason from buyer, could be empty \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_buyer_cancel_reason** |
| \| Field label \| Buyer cancel reason \| \| --- \| --- \| \| Description \| Cancel reason from buyer, could be empty \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer cancel reason |
| Description | Cancel reason from buyer, could be empty |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### DATASOURCE

| \| dataSourceName** \| \| --- \| \| \\| Field label \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| --- |
| dataSourceName** |
| \| Field label \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| Field label | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| Destinations | API, Data warehouse |
| \| system_metadata.data_source_logins** \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_logins** |
| \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source logins |
| Description | The data source login accounts that were used to authenticate against the data source |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.data_source_login_owners** \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_login_owners** |
| \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source login owners |
| Description | The Supermetrics users that created the data source login connections |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### INCOME

| \| income_buyer_username** \| \| --- \| \| \\| Field label \\| Buyer username \\| \\| --- \\| --- \\| \\| Description \\| The username of the buyer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer username \| \| Description \| The username of the buyer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| income_buyer_username** |
| \| Field label \| Buyer username \| \| --- \| --- \| \| Description \| The username of the buyer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer username |
| Description | The username of the buyer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| buyer_payment_method** \| \| --- \| \| \\| Field label \\| Buyer payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method used by the buyer at checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Buyer payment method \| \| Description \| The payment method used by the buyer at checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| buyer_payment_method** |
| \| Field label \| Buyer payment method \| \| --- \| --- \| \| Description \| The payment method used by the buyer at checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Buyer payment method |
| Description | The payment method used by the buyer at checkout |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| seller_voucher_absorbed_amount** \| \| --- \| \| \\| Field label \\| Seller voucher absorbed amount \\| \\| --- \\| --- \\| \\| Description \\| Final value of voucher provided by seller for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Seller voucher absorbed amount \| \| Description \| Final value of voucher provided by seller for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| seller_voucher_absorbed_amount** |
| \| Field label \| Seller voucher absorbed amount \| \| --- \| --- \| \| Description \| Final value of voucher provided by seller for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Seller voucher absorbed amount |
| Description | Final value of voucher provided by seller for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_voucher_amount** \| \| --- \| \| \\| Field label \\| Shopee voucher amount \\| \\| --- \\| --- \\| \\| Description \\| Final value of voucher provided by Shopee for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee voucher amount \| \| Description \| Final value of voucher provided by Shopee for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_voucher_amount** |
| \| Field label \| Shopee voucher amount \| \| --- \| --- \| \| Description \| Final value of voucher provided by Shopee for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee voucher amount |
| Description | Final value of voucher provided by Shopee for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| net_escrow** \| \| --- \| \| \\| Field label \\| Net escrow \\| \\| --- \\| --- \\| \\| Description \\| The total amount the seller is expected to receive for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Net escrow \| \| Description \| The total amount the seller is expected to receive for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| net_escrow** |
| \| Field label \| Net escrow \| \| --- \| --- \| \| Description \| The total amount the seller is expected to receive for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Net escrow |
| Description | The total amount the seller is expected to receive for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_commission_fee** \| \| --- \| \| \\| Field label \\| Shopee commission fee \\| \\| --- \\| --- \\| \\| Description \\| The commission fee charged by Shopee platform if applicable \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee commission fee \| \| Description \| The commission fee charged by Shopee platform if applicable \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_commission_fee** |
| \| Field label \| Shopee commission fee \| \| --- \| --- \| \| Description \| The commission fee charged by Shopee platform if applicable \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee commission fee |
| Description | The commission fee charged by Shopee platform if applicable |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| transaction_fee** \| \| --- \| \| \\| Field label \\| Transaction fee \\| \\| --- \\| --- \\| \\| Description \\| Transaction fee paid by seller for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Transaction fee \| \| Description \| Transaction fee paid by seller for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| transaction_fee** |
| \| Field label \| Transaction fee \| \| --- \| --- \| \| Description \| Transaction fee paid by seller for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Transaction fee |
| Description | Transaction fee paid by seller for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| service_fee** \| \| --- \| \| \\| Field label \\| Service fee \\| \\| --- \\| --- \\| \\| Description \\| Amount charged by Shopee to seller for additional services \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Service fee \| \| Description \| Amount charged by Shopee to seller for additional services \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| service_fee** |
| \| Field label \| Service fee \| \| --- \| --- \| \| Description \| Amount charged by Shopee to seller for additional services \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Service fee |
| Description | Amount charged by Shopee to seller for additional services |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| seller_discount** \| \| --- \| \| \\| Field label \\| Seller discount \\| \\| --- \\| --- \\| \\| Description \\| Final sum of each item seller discount for this order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Seller discount \| \| Description \| Final sum of each item seller discount for this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| seller_discount** |
| \| Field label \| Seller discount \| \| --- \| --- \| \| Description \| Final sum of each item seller discount for this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Seller discount |
| Description | Final sum of each item seller discount for this order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_discount** \| \| --- \| \| \\| Field label \\| Shopee discount \\| \\| --- \\| --- \\| \\| Description \\| Final sum of each item Shopee discount for this order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee discount \| \| Description \| Final sum of each item Shopee discount for this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_discount** |
| \| Field label \| Shopee discount \| \| --- \| --- \| \| Description \| Final sum of each item Shopee discount for this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee discount |
| Description | Final sum of each item Shopee discount for this order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| merchandise_subtotal** \| \| --- \| \| \\| Field label \\| Merchandise subtotal \\| \\| --- \\| --- \\| \\| Description \\| Final amount paid by the buyer for the items in this order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Merchandise subtotal \| \| Description \| Final amount paid by the buyer for the items in this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| merchandise_subtotal** |
| \| Field label \| Merchandise subtotal \| \| --- \| --- \| \| Description \| Final amount paid by the buyer for the items in this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Merchandise subtotal |
| Description | Final amount paid by the buyer for the items in this order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_price** \| \| --- \| \| \\| Field label \\| Product price \\| \\| --- \\| --- \\| \\| Description \\| Amount paid by the buyer for the items in this order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Product price \| \| Description \| Amount paid by the buyer for the items in this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| product_price** |
| \| Field label \| Product price \| \| --- \| --- \| \| Description \| Amount paid by the buyer for the items in this order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Product price |
| Description | Amount paid by the buyer for the items in this order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_original_price** \| \| --- \| \| \\| Field label \\| Order original price \\| \\| --- \\| --- \\| \\| Description \\| The original price of the item before any promotion or discount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order original price \| \| Description \| The original price of the item before any promotion or discount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_original_price** |
| \| Field label \| Order original price \| \| --- \| --- \| \| Description \| The original price of the item before any promotion or discount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order original price |
| Description | The original price of the item before any promotion or discount |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| drc_adjustable_refund** \| \| --- \| \| \\| Field label \\| DRC adjustable refund \\| \\| --- \\| --- \\| \\| Description \\| The adjustable refund amount from Shopee Dispute Resolution Center \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| DRC adjustable refund \| \| Description \| The adjustable refund amount from Shopee Dispute Resolution Center \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| drc_adjustable_refund** |
| \| Field label \| DRC adjustable refund \| \| --- \| --- \| \| Description \| The adjustable refund amount from Shopee Dispute Resolution Center \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | DRC adjustable refund |
| Description | The adjustable refund amount from Shopee Dispute Resolution Center |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| seller_return_refund** \| \| --- \| \| \\| Field label \\| Seller return refund \\| \\| --- \\| --- \\| \\| Description \\| The return refund amount paid to the seller \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Seller return refund \| \| Description \| The return refund amount paid to the seller \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| seller_return_refund** |
| \| Field label \| Seller return refund \| \| --- \| --- \| \| Description \| The return refund amount paid to the seller \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Seller return refund |
| Description | The return refund amount paid to the seller |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| buyer_total_amount** \| \| --- \| \| \\| Field label \\| Buyer total amount \\| \\| --- \\| --- \\| \\| Description \\| The total amount paid by the buyer at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Buyer total amount \| \| Description \| The total amount paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| buyer_total_amount** |
| \| Field label \| Buyer total amount \| \| --- \| --- \| \| Description \| The total amount paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Buyer total amount |
| Description | The total amount paid by the buyer at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| merchant_subtotal** \| \| --- \| \| \\| Field label \\| Merchant subtotal \\| \\| --- \\| --- \\| \\| Description \\| The total item price paid by the buyer at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Merchant subtotal \| \| Description \| The total item price paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| merchant_subtotal** |
| \| Field label \| Merchant subtotal \| \| --- \| --- \| \| Description \| The total item price paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Merchant subtotal |
| Description | The total item price paid by the buyer at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| buyer_shipping_fee** \| \| --- \| \| \\| Field label \\| Buyer shipping fee \\| \\| --- \\| --- \\| \\| Description \\| The shipping fee paid by the buyer at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Buyer shipping fee \| \| Description \| The shipping fee paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| buyer_shipping_fee** |
| \| Field label \| Buyer shipping fee \| \| --- \| --- \| \| Description \| The shipping fee paid by the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Buyer shipping fee |
| Description | The shipping fee paid by the buyer at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| seller_voucher** \| \| --- \| \| \\| Field label \\| Seller voucher \\| \\| --- \\| --- \\| \\| Description \\| The voucher provided by seller to offset the amount the buyer pays at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Seller voucher \| \| Description \| The voucher provided by seller to offset the amount the buyer pays at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| seller_voucher** |
| \| Field label \| Seller voucher \| \| --- \| --- \| \| Description \| The voucher provided by seller to offset the amount the buyer pays at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Seller voucher |
| Description | The voucher provided by seller to offset the amount the buyer pays at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_voucher** \| \| --- \| \| \\| Field label \\| Shopee voucher \\| \\| --- \\| --- \\| \\| Description \\| The voucher provided by Shopee to offset the amount the buyer pays at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee voucher \| \| Description \| The voucher provided by Shopee to offset the amount the buyer pays at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_voucher** |
| \| Field label \| Shopee voucher \| \| --- \| --- \| \| Description \| The voucher provided by Shopee to offset the amount the buyer pays at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee voucher |
| Description | The voucher provided by Shopee to offset the amount the buyer pays at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_coins_redeemed** \| \| --- \| \| \\| Field label \\| Shopee coins redeemed \\| \\| --- \\| --- \\| \\| Description \\| Amount of coins used by the buyer at checkout to offset payment \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee coins redeemed \| \| Description \| Amount of coins used by the buyer at checkout to offset payment \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_coins_redeemed** |
| \| Field label \| Shopee coins redeemed \| \| --- \| --- \| \| Description \| Amount of coins used by the buyer at checkout to offset payment \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee coins redeemed |
| Description | Amount of coins used by the buyer at checkout to offset payment |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| buyer_service_fee** \| \| --- \| \| \\| Field label \\| Buyer service fee \\| \\| --- \\| --- \\| \\| Description \\| Additional service fee charged by Shopee to the buyer at checkout \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Buyer service fee \| \| Description \| Additional service fee charged by Shopee to the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| buyer_service_fee** |
| \| Field label \| Buyer service fee \| \| --- \| --- \| \| Description \| Additional service fee charged by Shopee to the buyer at checkout \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Buyer service fee |
| Description | Additional service fee charged by Shopee to the buyer at checkout |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| buyer_tax_amount** \| \| --- \| \| \\| Field label \\| Buyer tax amount \\| \\| --- \\| --- \\| \\| Description \\| The tax amount paid by the buyer \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Buyer tax amount \| \| Description \| The tax amount paid by the buyer \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| buyer_tax_amount** |
| \| Field label \| Buyer tax amount \| \| --- \| --- \| \| Description \| The tax amount paid by the buyer \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Buyer tax amount |
| Description | The tax amount paid by the buyer |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping_subtotal** \| \| --- \| \| \\| Field label \\| Shipping subtotal \\| \\| --- \\| --- \\| \\| Description \\| The final shipping cost of the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping subtotal \| \| Description \| The final shipping cost of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping_subtotal** |
| \| Field label \| Shipping subtotal \| \| --- \| --- \| \| Description \| The final shipping cost of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping subtotal |
| Description | The final shipping cost of the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping_fee_paid_by_buyer** \| \| --- \| \| \\| Field label \\| Shipping fee paid by buyer \\| \\| --- \\| --- \\| \\| Description \\| Shipping fee paid by the buyer \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping fee paid by buyer \| \| Description \| Shipping fee paid by the buyer \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping_fee_paid_by_buyer** |
| \| Field label \| Shipping fee paid by buyer \| \| --- \| --- \| \| Description \| Shipping fee paid by the buyer \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping fee paid by buyer |
| Description | Shipping fee paid by the buyer |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shopee_shipping_rebate** \| \| --- \| \| \\| Field label \\| Shopee shipping rebate \\| \\| --- \\| --- \\| \\| Description \\| The platform shipping subsidy to the seller \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shopee shipping rebate \| \| Description \| The platform shipping subsidy to the seller \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shopee_shipping_rebate** |
| \| Field label \| Shopee shipping rebate \| \| --- \| --- \| \| Description \| The platform shipping subsidy to the seller \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shopee shipping rebate |
| Description | The platform shipping subsidy to the seller |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping_fee_charged_by_logistics** \| \| --- \| \| \\| Field label \\| Shipping fee charged by logistics \\| \\| --- \\| --- \\| \\| Description \\| Final adjusted amount that the seller has to bear as part of escrow \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping fee charged by logistics \| \| Description \| Final adjusted amount that the seller has to bear as part of escrow \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping_fee_charged_by_logistics** |
| \| Field label \| Shipping fee charged by logistics \| \| --- \| --- \| \| Description \| Final adjusted amount that the seller has to bear as part of escrow \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping fee charged by logistics |
| Description | Final adjusted amount that the seller has to bear as part of escrow |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| income_estimated_shipping_fee** \| \| --- \| \| \\| Field label \\| Estimated shipping fee \\| \\| --- \\| --- \\| \\| Description \\| The estimated shipping fee calculated by Shopee based on logistics courier standards \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Estimated shipping fee \| \| Description \| The estimated shipping fee calculated by Shopee based on logistics courier standards \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| income_estimated_shipping_fee** |
| \| Field label \| Estimated shipping fee \| \| --- \| --- \| \| Description \| The estimated shipping fee calculated by Shopee based on logistics courier standards \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Estimated shipping fee |
| Description | The estimated shipping fee calculated by Shopee based on logistics courier standards |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| income_reverse_shipping_fee** \| \| --- \| \| \\| Field label \\| Reverse shipping fee \\| \\| --- \\| --- \\| \\| Description \\| Shopee charges the reverse shipping fee for the returned order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Reverse shipping fee \| \| Description \| Shopee charges the reverse shipping fee for the returned order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| income_reverse_shipping_fee** |
| \| Field label \| Reverse shipping fee \| \| --- \| --- \| \| Description \| Shopee charges the reverse shipping fee for the returned order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Reverse shipping fee |
| Description | Shopee charges the reverse shipping fee for the returned order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### ITEM

| \| order_item_item_id** \| \| --- \| \| \\| Field label \\| Item ID \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for an item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item ID \| \| Description \| Shopee's unique identifier for an item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_item_item_id** |
| \| Field label \| Item ID \| \| --- \| --- \| \| Description \| Shopee's unique identifier for an item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item ID |
| Description | Shopee's unique identifier for an item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_item_name** \| \| --- \| \| \\| Field label \\| Item name \\| \\| --- \\| --- \\| \\| Description \\| The name of the item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item name \| \| Description \| The name of the item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_item_name** |
| \| Field label \| Item name \| \| --- \| --- \| \| Description \| The name of the item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item name |
| Description | The name of the item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_item_sku** \| \| --- \| \| \\| Field label \\| Item SKU \\| \\| --- \\| --- \\| \\| Description \\| A item SKU (stock keeping unit) is an identifier defined by a seller, sometimes called parent SKU. Item SKU can be assigned to an item in Shopee Listings \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item SKU \| \| Description \| A item SKU (stock keeping unit) is an identifier defined by a seller, sometimes called parent SKU. Item SKU can be assigned to an item in Shopee Listings \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_item_sku** |
| \| Field label \| Item SKU \| \| --- \| --- \| \| Description \| A item SKU (stock keeping unit) is an identifier defined by a seller, sometimes called parent SKU. Item SKU can be assigned to an item in Shopee Listings \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item SKU |
| Description | A item SKU (stock keeping unit) is an identifier defined by a seller, sometimes called parent SKU. Item SKU can be assigned to an item in Shopee Listings |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_order_item_id** \| \| --- \| \| \\| Field label \\| Order item ID \\| \\| --- \\| --- \\| \\| Description \\| The identify of order item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order item ID \| \| Description \| The identify of order item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_order_item_id** |
| \| Field label \| Order item ID \| \| --- \| --- \| \| Description \| The identify of order item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order item ID |
| Description | The identify of order item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_model_id** \| \| --- \| \| \\| Field label \\| Model ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the model that belongs to the same item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Model ID \| \| Description \| ID of the model that belongs to the same item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_model_id** |
| \| Field label \| Model ID \| \| --- \| --- \| \| Description \| ID of the model that belongs to the same item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Model ID |
| Description | ID of the model that belongs to the same item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_model_name** \| \| --- \| \| \\| Field label \\| Model name \\| \\| --- \\| --- \\| \\| Description \\| Name of the model that belongs to the same item. A seller can offer models of the same item. For example, the seller could create a fixed-priced listing for a t-shirt design and offer the shirt in different colors and sizes. In this case, each color and size combination is a separate model. Each model can have a different quantity and price \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Model name \| \| Description \| Name of the model that belongs to the same item. A seller can offer models of the same item. For example, the seller could create a fixed-priced listing for a t-shirt design and offer the shirt in different colors and sizes. In this case, each color and size combination is a separate model. Each model can have a different quantity and price \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_model_name** |
| \| Field label \| Model name \| \| --- \| --- \| \| Description \| Name of the model that belongs to the same item. A seller can offer models of the same item. For example, the seller could create a fixed-priced listing for a t-shirt design and offer the shirt in different colors and sizes. In this case, each color and size combination is a separate model. Each model can have a different quantity and price \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Model name |
| Description | Name of the model that belongs to the same item. A seller can offer models of the same item. For example, the seller could create a fixed-priced listing for a t-shirt design and offer the shirt in different colors and sizes. In this case, each color and size combination is a separate model. Each model can have a different quantity and price |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_model_sku** \| \| --- \| \| \\| Field label \\| Model SKU \\| \\| --- \\| --- \\| \\| Description \\| A model SKU (stock keeping unit) is an identifier defined by a seller. It is only intended for the seller's use. Many sellers assign a SKU to an item of a specific type, size, and color, which are models of one item in Shopee Listings \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Model SKU \| \| Description \| A model SKU (stock keeping unit) is an identifier defined by a seller. It is only intended for the seller's use. Many sellers assign a SKU to an item of a specific type, size, and color, which are models of one item in Shopee Listings \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_model_sku** |
| \| Field label \| Model SKU \| \| --- \| --- \| \| Description \| A model SKU (stock keeping unit) is an identifier defined by a seller. It is only intended for the seller's use. Many sellers assign a SKU to an item of a specific type, size, and color, which are models of one item in Shopee Listings \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Model SKU |
| Description | A model SKU (stock keeping unit) is an identifier defined by a seller. It is only intended for the seller's use. Many sellers assign a SKU to an item of a specific type, size, and color, which are models of one item in Shopee Listings |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_wholesale** \| \| --- \| \| \\| Field label \\| Wholesale \\| \\| --- \\| --- \\| \\| Description \\| This value indicates whether buyer buy the order item in wholesale price \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Wholesale \| \| Description \| This value indicates whether buyer buy the order item in wholesale price \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_wholesale** |
| \| Field label \| Wholesale \| \| --- \| --- \| \| Description \| This value indicates whether buyer buy the order item in wholesale price \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Wholesale |
| Description | This value indicates whether buyer buy the order item in wholesale price |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_main_item** \| \| --- \| \| \\| Field label \\| Main item \\| \\| --- \\| --- \\| \\| Description \\| To indicate if this item is main item or sub item. True means main item, false means sub item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Main item \| \| Description \| To indicate if this item is main item or sub item. True means main item, false means sub item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_main_item** |
| \| Field label \| Main item \| \| --- \| --- \| \| Description \| To indicate if this item is main item or sub item. True means main item, false means sub item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Main item |
| Description | To indicate if this item is main item or sub item. True means main item, false means sub item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_image_url** \| \| --- \| \| \\| Field label \\| Image url \\| \\| --- \\| --- \\| \\| Description \\| The image url of the product. Default to be variation image, if the model does not have a variation image, will use an item main image instead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Image url \| \| Description \| The image url of the product. Default to be variation image, if the model does not have a variation image, will use an item main image instead \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| order_item_image_url** |
| \| Field label \| Image url \| \| --- \| --- \| \| Description \| The image url of the product. Default to be variation image, if the model does not have a variation image, will use an item main image instead \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Image url |
| Description | The image url of the product. Default to be variation image, if the model does not have a variation image, will use an item main image instead |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| order_item_add_on_deal** \| \| --- \| \| \\| Field label \\| Add on deal \\| \\| --- \\| --- \\| \\| Description \\| To indicate if this item belongs to an addon deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Add on deal \| \| Description \| To indicate if this item belongs to an addon deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_add_on_deal** |
| \| Field label \| Add on deal \| \| --- \| --- \| \| Description \| To indicate if this item belongs to an addon deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Add on deal |
| Description | To indicate if this item belongs to an addon deal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_add_on_deal_id** \| \| --- \| \| \\| Field label \\| Add on deal ID \\| \\| --- \\| --- \\| \\| Description \\| A unique ID to distinguish groups of items in Cart, and Order. (e.g. AddOnDeal) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Add on deal ID \| \| Description \| A unique ID to distinguish groups of items in Cart, and Order. (e.g. AddOnDeal) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_add_on_deal_id** |
| \| Field label \| Add on deal ID \| \| --- \| --- \| \| Description \| A unique ID to distinguish groups of items in Cart, and Order. (e.g. AddOnDeal) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Add on deal ID |
| Description | A unique ID to distinguish groups of items in Cart, and Order. (e.g. AddOnDeal) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_promotion_type** \| \| --- \| \| \\| Field label \\| Promotion type \\| \\| --- \\| --- \\| \\| Description \\| Available type：product_promotion, flash_sale, bundle_deal, add_on_deal_main, add_on_deal_sub. For items which attend multiple promotions will only show one promotion, the order of priority is: bundle_deal > add_on_deal_main > add_on_deal_sub > product_promotion >flash_sale \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Promotion type \| \| Description \| Available type：product_promotion, flash_sale, bundle_deal, add_on_deal_main, add_on_deal_sub. For items which attend multiple promotions will only show one promotion, the order of priority is: bundle_deal > add_on_deal_main > add_on_deal_sub > product_promotion >flash_sale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_promotion_type** |
| \| Field label \| Promotion type \| \| --- \| --- \| \| Description \| Available type：product_promotion, flash_sale, bundle_deal, add_on_deal_main, add_on_deal_sub. For items which attend multiple promotions will only show one promotion, the order of priority is: bundle_deal > add_on_deal_main > add_on_deal_sub > product_promotion >flash_sale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Promotion type |
| Description | Available type：product_promotion, flash_sale, bundle_deal, add_on_deal_main, add_on_deal_sub. For items which attend multiple promotions will only show one promotion, the order of priority is: bundle_deal > add_on_deal_main > add_on_deal_sub > product_promotion >flash_sale |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_promotion_id** \| \| --- \| \| \\| Field label \\| Promotion ID \\| \\| --- \\| --- \\| \\| Description \\| The ID of the promotion \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Promotion ID \| \| Description \| The ID of the promotion \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_promotion_id** |
| \| Field label \| Promotion ID \| \| --- \| --- \| \| Description \| The ID of the promotion \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Promotion ID |
| Description | The ID of the promotion |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_promotion_group_id** \| \| --- \| \| \\| Field label \\| Promotion group ID \\| \\| --- \\| --- \\| \\| Description \\| The identify of product promotion \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Promotion group ID \| \| Description \| The identify of product promotion \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_item_promotion_group_id** |
| \| Field label \| Promotion group ID \| \| --- \| --- \| \| Description \| The identify of product promotion \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Promotion group ID |
| Description | The identify of product promotion |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_item_product_location_id** \| \| --- \| \| \\| Field label \\| Product location ID \\| \\| --- \\| --- \\| \\| Description \\| The fulfilment warehouse ID(s) of the items in the order. (Multi-Warehouse sellers only) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product location ID \| \| Description \| The fulfilment warehouse ID(s) of the items in the order. (Multi-Warehouse sellers only) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_product_location_id** |
| \| Field label \| Product location ID \| \| --- \| --- \| \| Description \| The fulfilment warehouse ID(s) of the items in the order. (Multi-Warehouse sellers only) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product location ID |
| Description | The fulfilment warehouse ID(s) of the items in the order. (Multi-Warehouse sellers only) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_is_prescription_item** \| \| --- \| \| \\| Field label \\| Is prescription item \\| \\| --- \\| --- \\| \\| Description \\| To indicate if this item is prescription item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Is prescription item \| \| Description \| To indicate if this item is prescription item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_is_prescription_item** |
| \| Field label \| Is prescription item \| \| --- \| --- \| \| Description \| To indicate if this item is prescription item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Is prescription item |
| Description | To indicate if this item is prescription item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_is_b2c_owned_item** \| \| --- \| \| \\| Field label \\| Is B2C owned item \\| \\| --- \\| --- \\| \\| Description \\| Indicates if this is a B2C shop item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Is B2C owned item \| \| Description \| Indicates if this is a B2C shop item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_is_b2c_owned_item** |
| \| Field label \| Is B2C owned item \| \| --- \| --- \| \| Description \| Indicates if this is a B2C shop item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Is B2C owned item |
| Description | Indicates if this is a B2C shop item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_model_quantity_purchased** \| \| --- \| \| \\| Field label \\| Model quantity purchased \\| \\| --- \\| --- \\| \\| Description \\| The number of identical items purchased at the same time by the same buyer from one listing/item \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Model quantity purchased \| \| Description \| The number of identical items purchased at the same time by the same buyer from one listing/item \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_item_model_quantity_purchased** |
| \| Field label \| Model quantity purchased \| \| --- \| --- \| \| Description \| The number of identical items purchased at the same time by the same buyer from one listing/item \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Model quantity purchased |
| Description | The number of identical items purchased at the same time by the same buyer from one listing/item |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_item_model_original_price** \| \| --- \| \| \\| Field label \\| Model original price \\| \\| --- \\| --- \\| \\| Description \\| The original price of the item in the listing currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Model original price \| \| Description \| The original price of the item in the listing currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_item_model_original_price** |
| \| Field label \| Model original price \| \| --- \| --- \| \| Description \| The original price of the item in the listing currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Model original price |
| Description | The original price of the item in the listing currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_item_model_discounted_price** \| \| --- \| \| \\| Field label \\| Model discounted price \\| \\| --- \\| --- \\| \\| Description \\| The after-discount price of the item in the listing currency. If there is no discount, this value will be the same as the original price. In case of bundle deal items, this value will return 0 as bundles cannot be split to item level \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Model discounted price \| \| Description \| The after-discount price of the item in the listing currency. If there is no discount, this value will be the same as the original price. In case of bundle deal items, this value will return 0 as bundles cannot be split to item level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_item_model_discounted_price** |
| \| Field label \| Model discounted price \| \| --- \| --- \| \| Description \| The after-discount price of the item in the listing currency. If there is no discount, this value will be the same as the original price. In case of bundle deal items, this value will return 0 as bundles cannot be split to item level \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Model discounted price |
| Description | The after-discount price of the item in the listing currency. If there is no discount, this value will be the same as the original price. In case of bundle deal items, this value will return 0 as bundles cannot be split to item level |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_item_weight** \| \| --- \| \| \\| Field label \\| Weight \\| \\| --- \\| --- \\| \\| Description \\| The weight of the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Weight \| \| Description \| The weight of the item \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| order_item_weight** |
| \| Field label \| Weight \| \| --- \| --- \| \| Description \| The weight of the item \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Field label | Weight |
| Description | The weight of the item |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |

### ORDER

| \| order_sn** \| \| --- \| \| \\| Field label \\| Order SN \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for an order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order SN \| \| Description \| Shopee's unique identifier for an order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_sn** |
| \| Field label \| Order SN \| \| --- \| --- \| \| Description \| Shopee's unique identifier for an order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order SN |
| Description | Shopee's unique identifier for an order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_status** \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| Enumerated type that defines the current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| Enumerated type that defines the current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status** |
| \| Field label \| Order status \| \| --- \| --- \| \| Description \| Enumerated type that defines the current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order status |
| Description | Enumerated type that defines the current status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| region** \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Description \\| The two-digit code representing the region where the order was made \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Description \| The two-digit code representing the region where the order was made \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| region** |
| \| Field label \| Region \| \| --- \| --- \| \| Description \| The two-digit code representing the region where the order was made \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Region |
| Description | The two-digit code representing the region where the order was made |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| currency** \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| The three-digit code representing the currency unit for which the order was paid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| The three-digit code representing the currency unit for which the order was paid \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| currency** |
| \| Field label \| Currency \| \| --- \| --- \| \| Description \| The three-digit code representing the currency unit for which the order was paid \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Currency |
| Description | The three-digit code representing the currency unit for which the order was paid |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| payment_method** \| \| --- \| \| \\| Field label \\| Payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method that the buyer selected to pay for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment method \| \| Description \| The payment method that the buyer selected to pay for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method** |
| \| Field label \| Payment method \| \| --- \| --- \| \| Description \| The payment method that the buyer selected to pay for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment method |
| Description | The payment method that the buyer selected to pay for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cod** \| \| --- \| \| \\| Field label \\| COD (cash on delivery) \\| \\| --- \\| --- \\| \\| Description \\| This value indicates whether the order was a COD (cash on delivery) order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| COD (cash on delivery) \| \| Description \| This value indicates whether the order was a COD (cash on delivery) order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| cod** |
| \| Field label \| COD (cash on delivery) \| \| --- \| --- \| \| Description \| This value indicates whether the order was a COD (cash on delivery) order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | COD (cash on delivery) |
| Description | This value indicates whether the order was a COD (cash on delivery) order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| advance_package** \| \| --- \| \| \\| Field label \\| Advance package \\| \\| --- \\| --- \\| \\| Description \\| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advance package \| \| Description \| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| advance_package** |
| \| Field label \| Advance package \| \| --- \| --- \| \| Description \| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Advance package |
| Description | Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| booking_sn** \| \| --- \| \| \\| Field label \\| Booking SN \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Booking SN \| \| Description \| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| booking_sn** |
| \| Field label \| Booking SN \| \| --- \| --- \| \| Description \| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Booking SN |
| Description | Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cancel_by** \| \| --- \| \| \\| Field label \\| Cancel by \\| \\| --- \\| --- \\| \\| Description \\| Could be one of buyer, seller, system or Ops \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancel by \| \| Description \| Could be one of buyer, seller, system or Ops \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| cancel_by** |
| \| Field label \| Cancel by \| \| --- \| --- \| \| Description \| Could be one of buyer, seller, system or Ops \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancel by |
| Description | Could be one of buyer, seller, system or Ops |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cancel_reason** \| \| --- \| \| \\| Field label \\| Cancel reason \\| \\| --- \\| --- \\| \\| Description \\| The reason for buyer, seller or system cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancel reason \| \| Description \| The reason for buyer, seller or system cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| cancel_reason** |
| \| Field label \| Cancel reason \| \| --- \| --- \| \| Description \| The reason for buyer, seller or system cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancel reason |
| Description | The reason for buyer, seller or system cancellation |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dropshipper** \| \| --- \| \| \\| Field label \\| Dropshipper \\| \\| --- \\| --- \\| \\| Description \\| For Indonesia orders only. The name of the dropshipper \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Dropshipper \| \| Description \| For Indonesia orders only. The name of the dropshipper \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dropshipper** |
| \| Field label \| Dropshipper \| \| --- \| --- \| \| Description \| For Indonesia orders only. The name of the dropshipper \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Dropshipper |
| Description | For Indonesia orders only. The name of the dropshipper |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| fulfillment_flag** \| \| --- \| \| \\| Field label \\| Fulfillment flag \\| \\| --- \\| --- \\| \\| Description \\| Use this field to indicate the order is fulfilled by Shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Fulfillment flag \| \| Description \| Use this field to indicate the order is fulfilled by Shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| fulfillment_flag** |
| \| Field label \| Fulfillment flag \| \| --- \| --- \| \| Description \| Use this field to indicate the order is fulfilled by Shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Fulfillment flag |
| Description | Use this field to indicate the order is fulfilled by Shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| days_to_ship** \| \| --- \| \| \\| Field label \\| Days to ship \\| \\| --- \\| --- \\| \\| Description \\| Shipping preparation time set by the seller when listing item on Shopee \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Days to ship \| \| Description \| Shipping preparation time set by the seller when listing item on Shopee \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| days_to_ship** |
| \| Field label \| Days to ship \| \| --- \| --- \| \| Description \| Shipping preparation time set by the seller when listing item on Shopee \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Days to ship |
| Description | Shipping preparation time set by the seller when listing item on Shopee |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| goods_to_declare** \| \| --- \| \| \\| Field label \\| Goods to declare \\| \\| --- \\| --- \\| \\| Description \\| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Goods to declare \| \| Description \| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| goods_to_declare** |
| \| Field label \| Goods to declare \| \| --- \| --- \| \| Description \| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Goods to declare |
| Description | Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| message_to_seller** \| \| --- \| \| \\| Field label \\| Message to seller \\| \\| --- \\| --- \\| \\| Description \\| Message to seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Message to seller \| \| Description \| Message to seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| message_to_seller** |
| \| Field label \| Message to seller \| \| --- \| --- \| \| Description \| Message to seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Message to seller |
| Description | Message to seller |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| note** \| \| --- \| \| \\| Field label \\| Note \\| \\| --- \\| --- \\| \\| Description \\| The note seller made for own reference \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Note \| \| Description \| The note seller made for own reference \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| note** |
| \| Field label \| Note \| \| --- \| --- \| \| Description \| The note seller made for own reference \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Note |
| Description | The note seller made for own reference |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| actual_shipping_fee_confirmed** \| \| --- \| \| \\| Field label \\| Actual shipping fee confirmed \\| \\| --- \\| --- \\| \\| Description \\| Determine whether the actual shipping fee is confirmed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Actual shipping fee confirmed \| \| Description \| Determine whether the actual shipping fee is confirmed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| actual_shipping_fee_confirmed** |
| \| Field label \| Actual shipping fee confirmed \| \| --- \| --- \| \| Description \| Determine whether the actual shipping fee is confirmed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Actual shipping fee confirmed |
| Description | Determine whether the actual shipping fee is confirmed |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_carrier** \| \| --- \| \| \\| Field label \\| Shipping carrier \\| \\| --- \\| --- \\| \\| Description \\| The logistics service provider that the buyer selected for the order to deliver items \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping carrier \| \| Description \| The logistics service provider that the buyer selected for the order to deliver items \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_carrier** |
| \| Field label \| Shipping carrier \| \| --- \| --- \| \| Description \| The logistics service provider that the buyer selected for the order to deliver items \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping carrier |
| Description | The logistics service provider that the buyer selected for the order to deliver items |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| split_up** \| \| --- \| \| \\| Field label \\| Split up \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether this order is split \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Split up \| \| Description \| Indicates whether this order is split \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| split_up** |
| \| Field label \| Split up \| \| --- \| --- \| \| Description \| Indicates whether this order is split \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Split up |
| Description | Indicates whether this order is split |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_order_status** \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| Enumerated type that defines the current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| Enumerated type that defines the current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_order_status** |
| \| Field label \| Order status \| \| --- \| --- \| \| Description \| Enumerated type that defines the current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order status |
| Description | Enumerated type that defines the current status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_region** \| \| --- \| \| \\| Field label \\| Region \\| \\| --- \\| --- \\| \\| Description \\| The two-digit code representing the region where the order was made \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Region \| \| Description \| The two-digit code representing the region where the order was made \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| order_item_region** |
| \| Field label \| Region \| \| --- \| --- \| \| Description \| The two-digit code representing the region where the order was made \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Region |
| Description | The two-digit code representing the region where the order was made |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| order_item_currency** \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| The three-digit code representing the currency unit for which the order was paid \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| The three-digit code representing the currency unit for which the order was paid \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_item_currency** |
| \| Field label \| Currency \| \| --- \| --- \| \| Description \| The three-digit code representing the currency unit for which the order was paid \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Currency |
| Description | The three-digit code representing the currency unit for which the order was paid |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_item_payment_method** \| \| --- \| \| \\| Field label \\| Payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method that the buyer selected to pay for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment method \| \| Description \| The payment method that the buyer selected to pay for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_payment_method** |
| \| Field label \| Payment method \| \| --- \| --- \| \| Description \| The payment method that the buyer selected to pay for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment method |
| Description | The payment method that the buyer selected to pay for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_cod** \| \| --- \| \| \\| Field label \\| COD (cash on delivery) \\| \\| --- \\| --- \\| \\| Description \\| This value indicates whether the order was a COD (cash on delivery) order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| COD (cash on delivery) \| \| Description \| This value indicates whether the order was a COD (cash on delivery) order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_cod** |
| \| Field label \| COD (cash on delivery) \| \| --- \| --- \| \| Description \| This value indicates whether the order was a COD (cash on delivery) order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | COD (cash on delivery) |
| Description | This value indicates whether the order was a COD (cash on delivery) order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_advance_package** \| \| --- \| \| \\| Field label \\| Advance package \\| \\| --- \\| --- \\| \\| Description \\| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Advance package \| \| Description \| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_advance_package** |
| \| Field label \| Advance package \| \| --- \| --- \| \| Description \| Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Advance package |
| Description | Indicate whether order will be fulfilled using advance fulfilment stock or not. If value is true, order will be matched with a booking and seller should not arrange shipment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_booking_sn** \| \| --- \| \| \\| Field label \\| Booking SN \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Booking SN \| \| Description \| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_booking_sn** |
| \| Field label \| Booking SN \| \| --- \| --- \| \| Description \| Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Booking SN |
| Description | Shopee's unique identifier for a booking. Only returned for advance fulfilment matched order only |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_cancel_by** \| \| --- \| \| \\| Field label \\| Cancel by \\| \\| --- \\| --- \\| \\| Description \\| Could be one of buyer, seller, system or Ops \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancel by \| \| Description \| Could be one of buyer, seller, system or Ops \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_cancel_by** |
| \| Field label \| Cancel by \| \| --- \| --- \| \| Description \| Could be one of buyer, seller, system or Ops \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancel by |
| Description | Could be one of buyer, seller, system or Ops |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_cancel_reason** \| \| --- \| \| \\| Field label \\| Cancel reason \\| \\| --- \\| --- \\| \\| Description \\| The reason for buyer, seller or system cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancel reason \| \| Description \| The reason for buyer, seller or system cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_cancel_reason** |
| \| Field label \| Cancel reason \| \| --- \| --- \| \| Description \| The reason for buyer, seller or system cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancel reason |
| Description | The reason for buyer, seller or system cancellation |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_dropshipper** \| \| --- \| \| \\| Field label \\| Dropshipper \\| \\| --- \\| --- \\| \\| Description \\| For Indonesia orders only. The name of the dropshipper \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Dropshipper \| \| Description \| For Indonesia orders only. The name of the dropshipper \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_dropshipper** |
| \| Field label \| Dropshipper \| \| --- \| --- \| \| Description \| For Indonesia orders only. The name of the dropshipper \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Dropshipper |
| Description | For Indonesia orders only. The name of the dropshipper |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_fulfillment_flag** \| \| --- \| \| \\| Field label \\| Fulfillment flag \\| \\| --- \\| --- \\| \\| Description \\| Use this field to indicate the order is fulfilled by shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Fulfillment flag \| \| Description \| Use this field to indicate the order is fulfilled by shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_fulfillment_flag** |
| \| Field label \| Fulfillment flag \| \| --- \| --- \| \| Description \| Use this field to indicate the order is fulfilled by shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Fulfillment flag |
| Description | Use this field to indicate the order is fulfilled by shopee or seller. Applicable values: fulfilled_by_shopee, fulfilled_by_cb_seller, fulfilled_by_local_seller |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_days_to_ship** \| \| --- \| \| \\| Field label \\| Days to ship \\| \\| --- \\| --- \\| \\| Description \\| Shipping preparation time set by the seller when listing item on Shopee \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Days to ship \| \| Description \| Shipping preparation time set by the seller when listing item on Shopee \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_item_days_to_ship** |
| \| Field label \| Days to ship \| \| --- \| --- \| \| Description \| Shipping preparation time set by the seller when listing item on Shopee \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Days to ship |
| Description | Shipping preparation time set by the seller when listing item on Shopee |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_item_goods_to_declare** \| \| --- \| \| \\| Field label \\| Goods to declare \\| \\| --- \\| --- \\| \\| Description \\| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Goods to declare \| \| Description \| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_goods_to_declare** |
| \| Field label \| Goods to declare \| \| --- \| --- \| \| Description \| Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Goods to declare |
| Description | Only work for cross-border order.This value indicates whether the order contains goods that are required to declare at customs. "T" means true and it will mark as "T" on the shipping label; "F" means false and it will mark as "P" on the shipping label. This value is accurate ONLY AFTER the order trackingNo is generated, please capture this value AFTER your retrieve the trackingNo |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_message_to_seller** \| \| --- \| \| \\| Field label \\| Message to seller \\| \\| --- \\| --- \\| \\| Description \\| Message to seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Message to seller \| \| Description \| Message to seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_message_to_seller** |
| \| Field label \| Message to seller \| \| --- \| --- \| \| Description \| Message to seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Message to seller |
| Description | Message to seller |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_note** \| \| --- \| \| \\| Field label \\| Note \\| \\| --- \\| --- \\| \\| Description \\| The note seller made for own reference \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Note \| \| Description \| The note seller made for own reference \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_note** |
| \| Field label \| Note \| \| --- \| --- \| \| Description \| The note seller made for own reference \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Note |
| Description | The note seller made for own reference |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_actual_shipping_fee_confirmed** \| \| --- \| \| \\| Field label \\| Actual shipping fee confirmed \\| \\| --- \\| --- \\| \\| Description \\| Determine whether the actual shipping fee is confirmed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Actual shipping fee confirmed \| \| Description \| Determine whether the actual shipping fee is confirmed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_actual_shipping_fee_confirmed** |
| \| Field label \| Actual shipping fee confirmed \| \| --- \| --- \| \| Description \| Determine whether the actual shipping fee is confirmed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Actual shipping fee confirmed |
| Description | Determine whether the actual shipping fee is confirmed |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_shipping_carrier** \| \| --- \| \| \\| Field label \\| Shipping carrier \\| \\| --- \\| --- \\| \\| Description \\| The logistics service provider that the buyer selected for the order to deliver items \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping carrier \| \| Description \| The logistics service provider that the buyer selected for the order to deliver items \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_shipping_carrier** |
| \| Field label \| Shipping carrier \| \| --- \| --- \| \| Description \| The logistics service provider that the buyer selected for the order to deliver items \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping carrier |
| Description | The logistics service provider that the buyer selected for the order to deliver items |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_item_split_up** \| \| --- \| \| \\| Field label \\| Split up \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether this order is split \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Split up \| \| Description \| Indicates whether this order is split \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_item_split_up** |
| \| Field label \| Split up \| \| --- \| --- \| \| Description \| Indicates whether this order is split \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Split up |
| Description | Indicates whether this order is split |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| estimated_shipping_fee** \| \| --- \| \| \\| Field label \\| Estimated shipping fee \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Estimated shipping fee \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| estimated_shipping_fee** |
| \| Field label \| Estimated shipping fee \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Estimated shipping fee |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| reverse_shipping_fee** \| \| --- \| \| \\| Field label \\| Reverse shipping fee \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Reverse shipping fee \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| reverse_shipping_fee** |
| \| Field label \| Reverse shipping fee \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Reverse shipping fee |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_amount** \| \| --- \| \| \\| Field label \\| Order total \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_amount** |
| \| Field label \| Order total \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### PRODUCT

| \| item_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for a product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| Shopee's unique identifier for a product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| item_id** |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| Shopee's unique identifier for a product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | Shopee's unique identifier for a product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_name** \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Name of the item in local language \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| Name of the item in local language \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_name** |
| \| Field label \| Product name \| \| --- \| --- \| \| Description \| Name of the item in local language \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product name |
| Description | Name of the item in local language |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_sku** \| \| --- \| \| \\| Field label \\| Product SKU \\| \\| --- \\| --- \\| \\| Description \\| An item SKU (stock keeping unit) is an identifier defined by a seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product SKU \| \| Description \| An item SKU (stock keeping unit) is an identifier defined by a seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_sku** |
| \| Field label \| Product SKU \| \| --- \| --- \| \| Description \| An item SKU (stock keeping unit) is an identifier defined by a seller \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product SKU |
| Description | An item SKU (stock keeping unit) is an identifier defined by a seller |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| description_type** \| \| --- \| \| \\| Field label \\| Description type \\| \\| --- \\| --- \\| \\| Description \\| Type of description: normal or extended \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Description type \| \| Description \| Type of description: normal or extended \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| description_type** |
| \| Field label \| Description type \| \| --- \| --- \| \| Description \| Type of description: normal or extended \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Description type |
| Description | Type of description: normal or extended |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| description** \| \| --- \| \| \\| Field label \\| Description \\| \\| --- \\| --- \\| \\| Description \\| Item description. Populated when description_type is normal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Description \| \| Description \| Item description. Populated when description_type is normal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| description** |
| \| Field label \| Description \| \| --- \| --- \| \| Description \| Item description. Populated when description_type is normal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Description |
| Description | Item description. Populated when description_type is normal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_image_gs** \| \| --- \| \| \\| Field label \\| Product image \\| \\| --- \\| --- \\| \\| Description \\| First product image URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \\| Destinations \\| Google Sheets \\| \| \| Field label \| Product image \| \| Description \| First product image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| \| Destinations \| Google Sheets \| |
| product_image_gs** |
| \| Field label \| Product image \| \| --- \| --- \| \| Description \| First product image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| \| Destinations \| Google Sheets \| |
| Field label | Product image |
| Description | First product image URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| Destinations | Google Sheets |
| \| product_image** \| \| --- \| \| \\| Field label \\| Product image \\| \\| --- \\| --- \\| \\| Description \\| First product image URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \\| Destinations \\| \\| \| \| Field label \| Product image \| \| Description \| First product image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| \| Destinations \| \| |
| product_image** |
| \| Field label \| Product image \| \| --- \| --- \| \| Description \| First product image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| \| Destinations \| \| |
| Field label | Product image |
| Description | First product image URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| Destinations |  |
| \| category_id** \| \| --- \| \| \\| Field label \\| Category ID \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for the product category \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Category ID \| \| Description \| Shopee's unique identifier for the product category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| category_id** |
| \| Field label \| Category ID \| \| --- \| --- \| \| Description \| Shopee's unique identifier for the product category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Category ID |
| Description | Shopee's unique identifier for the product category |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| category_name** \| \| --- \| \| \\| Field label \\| Category name \\| \\| --- \\| --- \\| \\| Description \\| Display name of the product category \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Category name \| \| Description \| Display name of the product category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| category_name** |
| \| Field label \| Category name \| \| --- \| --- \| \| Description \| Display name of the product category \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Category name |
| Description | Display name of the product category |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| brand_id** \| \| --- \| \| \\| Field label \\| Brand ID \\| \\| --- \\| --- \\| \\| Description \\| Shopee's unique identifier for the brand \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Brand ID \| \| Description \| Shopee's unique identifier for the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| brand_id** |
| \| Field label \| Brand ID \| \| --- \| --- \| \| Description \| Shopee's unique identifier for the brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Brand ID |
| Description | Shopee's unique identifier for the brand |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| brand_name** \| \| --- \| \| \\| Field label \\| Brand name \\| \\| --- \\| --- \\| \\| Description \\| Original brand name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Brand name \| \| Description \| Original brand name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| brand_name** |
| \| Field label \| Brand name \| \| --- \| --- \| \| Description \| Original brand name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Brand name |
| Description | Original brand name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_status** \| \| --- \| \| \\| Field label \\| Product status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the item: NORMAL, BANNED, UNLIST, REVIEWING, SELLER_DELETE, or SHOPEE_DELETE \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product status \| \| Description \| Current status of the item: NORMAL, BANNED, UNLIST, REVIEWING, SELLER_DELETE, or SHOPEE_DELETE \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_status** |
| \| Field label \| Product status \| \| --- \| --- \| \| Description \| Current status of the item: NORMAL, BANNED, UNLIST, REVIEWING, SELLER_DELETE, or SHOPEE_DELETE \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product status |
| Description | Current status of the item: NORMAL, BANNED, UNLIST, REVIEWING, SELLER_DELETE, or SHOPEE_DELETE |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| condition** \| \| --- \| \| \\| Field label \\| Condition \\| \\| --- \\| --- \\| \\| Description \\| Whether the item is NEW or USED \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Condition \| \| Description \| Whether the item is NEW or USED \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| condition** |
| \| Field label \| Condition \| \| --- \| --- \| \| Description \| Whether the item is NEW or USED \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Condition |
| Description | Whether the item is NEW or USED |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_currency** \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| Three-digit currency code for the item's listing currency \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| Three-digit currency code for the item's listing currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| product_currency** |
| \| Field label \| Currency \| \| --- \| --- \| \| Description \| Three-digit currency code for the item's listing currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Currency |
| Description | Three-digit currency code for the item's listing currency |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| is_pre_order** \| \| --- \| \| \\| Field label \\| Is pre-order \\| \\| --- \\| --- \\| \\| Description \\| Whether the item is a pre-order product \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is pre-order \| \| Description \| Whether the item is a pre-order product \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| is_pre_order** |
| \| Field label \| Is pre-order \| \| --- \| --- \| \| Description \| Whether the item is a pre-order product \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is pre-order |
| Description | Whether the item is a pre-order product |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| is_fulfillment_by_shopee** \| \| --- \| \| \\| Field label \\| Is fulfillment by Shopee \\| \\| --- \\| --- \\| \\| Description \\| True if the item only has a default model and it is an FBS model \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is fulfillment by Shopee \| \| Description \| True if the item only has a default model and it is an FBS model \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| is_fulfillment_by_shopee** |
| \| Field label \| Is fulfillment by Shopee \| \| --- \| --- \| \| Description \| True if the item only has a default model and it is an FBS model \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is fulfillment by Shopee |
| Description | True if the item only has a default model and it is an FBS model |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| deboost** \| \| --- \| \| \\| Field label \\| Deboost \\| \\| --- \\| --- \\| \\| Description \\| If true, the item's search ranking is lowered \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Deboost \| \| Description \| If true, the item's search ranking is lowered \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| deboost** |
| \| Field label \| Deboost \| \| --- \| --- \| \| Description \| If true, the item's search ranking is lowered \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Deboost |
| Description | If true, the item's search ranking is lowered |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| item_dangerous** \| \| --- \| \| \\| Field label \\| Item dangerous \\| \\| --- \\| --- \\| \\| Description \\| 0 for non-dangerous product, 1 for dangerous product \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item dangerous \| \| Description \| 0 for non-dangerous product, 1 for dangerous product \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_dangerous** |
| \| Field label \| Item dangerous \| \| --- \| --- \| \| Description \| 0 for non-dangerous product, 1 for dangerous product \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item dangerous |
| Description | 0 for non-dangerous product, 1 for dangerous product |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| package_length** \| \| --- \| \| \\| Field label \\| Package length \\| \\| --- \\| --- \\| \\| Description \\| The length of the package for this item \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Package length \| \| Description \| The length of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| package_length** |
| \| Field label \| Package length \| \| --- \| --- \| \| Description \| The length of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Package length |
| Description | The length of the package for this item |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| package_width** \| \| --- \| \| \\| Field label \\| Package width \\| \\| --- \\| --- \\| \\| Description \\| The width of the package for this item \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Package width \| \| Description \| The width of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| package_width** |
| \| Field label \| Package width \| \| --- \| --- \| \| Description \| The width of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Package width |
| Description | The width of the package for this item |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| package_height** \| \| --- \| \| \\| Field label \\| Package height \\| \\| --- \\| --- \\| \\| Description \\| The height of the package for this item \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Package height \| \| Description \| The height of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| package_height** |
| \| Field label \| Package height \| \| --- \| --- \| \| Description \| The height of the package for this item \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Package height |
| Description | The height of the package for this item |
| Field type | dimension |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| weight** \| \| --- \| \| \\| Field label \\| Weight \\| \\| --- \\| --- \\| \\| Description \\| The weight of the item in kilograms \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Weight \| \| Description \| The weight of the item in kilograms \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| weight** |
| \| Field label \| Weight \| \| --- \| --- \| \| Description \| The weight of the item in kilograms \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Field label | Weight |
| Description | The weight of the item in kilograms |
| Field type | dimension |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| product_created_date** \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| Date when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| product_created_date** |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| Date when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | Date when the item was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| product_created_datetime** \| \| --- \| \| \\| Field label \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Created datetime \| \| Description \| Date and time when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| product_created_datetime** |
| \| Field label \| Created datetime \| \| --- \| --- \| \| Description \| Date and time when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Created datetime |
| Description | Date and time when the item was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| product_updated_date** \| \| --- \| \| \\| Field label \\| Updated date \\| \\| --- \\| --- \\| \\| Description \\| Date of the last update to the item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated date \| \| Description \| Date of the last update to the item \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| product_updated_date** |
| \| Field label \| Updated date \| \| --- \| --- \| \| Description \| Date of the last update to the item \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Updated date |
| Description | Date of the last update to the item |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| product_updated_datetime** \| \| --- \| \| \\| Field label \\| Updated datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time of the last update to the item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated datetime \| \| Description \| Date and time of the last update to the item \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| product_updated_datetime** |
| \| Field label \| Updated datetime \| \| --- \| --- \| \| Description \| Date and time of the last update to the item \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Updated datetime |
| Description | Date and time of the last update to the item |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| original_price** \| \| --- \| \| \\| Field label \\| Original price \\| \\| --- \\| --- \\| \\| Description \\| The original price of the item in the listing currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Original price \| \| Description \| The original price of the item in the listing currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| original_price** |
| \| Field label \| Original price \| \| --- \| --- \| \| Description \| The original price of the item in the listing currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Original price |
| Description | The original price of the item in the listing currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| current_price** \| \| --- \| \| \\| Field label \\| Current price \\| \\| --- \\| --- \\| \\| Description \\| The current price of the item. If under a promotion, this is the promotion price \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Current price \| \| Description \| The current price of the item. If under a promotion, this is the promotion price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| current_price** |
| \| Field label \| Current price \| \| --- \| --- \| \| Description \| The current price of the item. If under a promotion, this is the promotion price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Current price |
| Description | The current price of the item. If under a promotion, this is the promotion price |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_available_stock** \| \| --- \| \| \\| Field label \\| Total available stock \\| \\| --- \\| --- \\| \\| Description \\| Total available stock across all warehouses \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total available stock \| \| Description \| Total available stock across all warehouses \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| total_available_stock** |
| \| Field label \| Total available stock \| \| --- \| --- \| \| Description \| Total available stock across all warehouses \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Total available stock |
| Description | Total available stock across all warehouses |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### QUERY

| \| system_metadata.query_date_range_start** \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| system_metadata.query_date_range_start** |
| \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Start date |
| Description | The start date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_range_end** \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_range_end** |
| \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | End date |
| Description | The end date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_timezone** \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| system_metadata.query_timezone** |
| \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Field label | Timezone |
| Description | The timezone that is supplied to the query |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| system_metadata.query_filters** \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_filters** |
| \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Filters |
| Description | All filters used in the query |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_date_start** \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_start** |
| \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Start |
| Description | When the query was started |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_end** \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_end** |
| \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | End |
| Description | When the query completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_duration** \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| system_metadata.query_duration** |
| \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| Field label | Duration |
| Description | The duration in seconds of the query |
| Field type | dimension |
| Data type | [int.duration.seconds](/apidocs/field-data-types#duration) |
| \| system_metadata.query_accounts** \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_accounts** |
| \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Accounts |
| Description | A list of accounts of which the data was pulled from |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_excluded_accounts** \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_excluded_accounts** |
| \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Excluded invalid accounts |
| Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### RETURN

| \| return_sn** \| \| --- \| \| \\| Field label \\| Return SN \\| \\| --- \\| --- \\| \\| Description \\| The serial number of return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return SN \| \| Description \| The serial number of return \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| return_sn** |
| \| Field label \| Return SN \| \| --- \| --- \| \| Description \| The serial number of return \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return SN |
| Description | The serial number of return |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_status** \| \| --- \| \| \\| Field label \\| Return status \\| \\| --- \\| --- \\| \\| Description \\| Enumerated type that defines the current status of the return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return status \| \| Description \| Enumerated type that defines the current status of the return \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_status** |
| \| Field label \| Return status \| \| --- \| --- \| \| Description \| Enumerated type that defines the current status of the return \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return status |
| Description | Enumerated type that defines the current status of the return |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_reason** \| \| --- \| \| \\| Field label \\| Return reason \\| \\| --- \\| --- \\| \\| Description \\| Indicates the original return reason submitted by the buyer when initiating the return request \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return reason \| \| Description \| Indicates the original return reason submitted by the buyer when initiating the return request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_reason** |
| \| Field label \| Return reason \| \| --- \| --- \| \| Description \| Indicates the original return reason submitted by the buyer when initiating the return request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return reason |
| Description | Indicates the original return reason submitted by the buyer when initiating the return request |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_text_reason** \| \| --- \| \| \\| Field label \\| Return text reason \\| \\| --- \\| --- \\| \\| Description \\| Reason that buyer provide \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return text reason \| \| Description \| Reason that buyer provide \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_text_reason** |
| \| Field label \| Return text reason \| \| --- \| --- \| \| Description \| Reason that buyer provide \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return text reason |
| Description | Reason that buyer provide |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| reassessed_request_reason** \| \| --- \| \| \\| Field label \\| Reassessed request reason \\| \\| --- \\| --- \\| \\| Description \\| Indicates the return reason reassessed by the platform as more suitable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Reassessed request reason \| \| Description \| Indicates the return reason reassessed by the platform as more suitable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| reassessed_request_reason** |
| \| Field label \| Reassessed request reason \| \| --- \| --- \| \| Description \| Indicates the return reason reassessed by the platform as more suitable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Reassessed request reason |
| Description | Indicates the return reason reassessed by the platform as more suitable |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_currency** \| \| --- \| \| \\| Field label \\| Return currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Return currency \| \| Description \| Currency of the return \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| return_currency** |
| \| Field label \| Return currency \| \| --- \| --- \| \| Description \| Currency of the return \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Return currency |
| Description | Currency of the return |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| return_tracking_number** \| \| --- \| \| \\| Field label \\| Return tracking number \\| \\| --- \\| --- \\| \\| Description \\| The tracking number assigned by the shipping carrier for item shipment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return tracking number \| \| Description \| The tracking number assigned by the shipping carrier for item shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_tracking_number** |
| \| Field label \| Return tracking number \| \| --- \| --- \| \| Description \| The tracking number assigned by the shipping carrier for item shipment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return tracking number |
| Description | The tracking number assigned by the shipping carrier for item shipment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| needs_logistics** \| \| --- \| \| \\| Field label \\| Needs logistics \\| \\| --- \\| --- \\| \\| Description \\| Items to be sent back to seller \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Needs logistics \| \| Description \| Items to be sent back to seller \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| needs_logistics** |
| \| Field label \| Needs logistics \| \| --- \| --- \| \| Description \| Items to be sent back to seller \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Needs logistics |
| Description | Items to be sent back to seller |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| return_refund_type** \| \| --- \| \| \\| Field label \\| Return/refund type \\| \\| --- \\| --- \\| \\| Description \\| To indicate whether the return is RRBOC (Return/Refund request raised before Order Complete) or RRAOC (Return/Refund request raised after Order Complete) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return/refund type \| \| Description \| To indicate whether the return is RRBOC (Return/Refund request raised before Order Complete) or RRAOC (Return/Refund request raised after Order Complete) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_refund_type** |
| \| Field label \| Return/refund type \| \| --- \| --- \| \| Description \| To indicate whether the return is RRBOC (Return/Refund request raised before Order Complete) or RRAOC (Return/Refund request raised after Order Complete) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return/refund type |
| Description | To indicate whether the return is RRBOC (Return/Refund request raised before Order Complete) or RRAOC (Return/Refund request raised after Order Complete) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_solution** \| \| --- \| \| \\| Field label \\| Return solution \\| \\| --- \\| --- \\| \\| Description \\| To indicate the most updated solution of the Return/Refund request \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return solution \| \| Description \| To indicate the most updated solution of the Return/Refund request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_solution** |
| \| Field label \| Return solution \| \| --- \| --- \| \| Description \| To indicate the most updated solution of the Return/Refund request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return solution |
| Description | To indicate the most updated solution of the Return/Refund request |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_refund_request_type** \| \| --- \| \| \\| Field label \\| Return/refund request type \\| \\| --- \\| --- \\| \\| Description \\| To indicate the type of return refund request \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return/refund request type \| \| Description \| To indicate the type of return refund request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_refund_request_type** |
| \| Field label \| Return/refund request type \| \| --- \| --- \| \| Description \| To indicate the type of return refund request \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return/refund request type |
| Description | To indicate the type of return refund request |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| seller_arranged** \| \| --- \| \| \\| Field label \\| Seller arranged \\| \\| --- \\| --- \\| \\| Description \\| To indicate whether the return_sn is using the Seller Arrange return method. This would only be True for TW and BR \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Seller arranged \| \| Description \| To indicate whether the return_sn is using the Seller Arrange return method. This would only be True for TW and BR \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| seller_arranged** |
| \| Field label \| Seller arranged \| \| --- \| --- \| \| Description \| To indicate whether the return_sn is using the Seller Arrange return method. This would only be True for TW and BR \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Seller arranged |
| Description | To indicate whether the return_sn is using the Seller Arrange return method. This would only be True for TW and BR |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| shipping_proof_mandatory** \| \| --- \| \| \\| Field label \\| Shipping proof mandatory \\| \\| --- \\| --- \\| \\| Description \\| To indicate whether uploading shipping proof is mandatory for seller to confirm Arrange Pickup \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Shipping proof mandatory \| \| Description \| To indicate whether uploading shipping proof is mandatory for seller to confirm Arrange Pickup \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| shipping_proof_mandatory** |
| \| Field label \| Shipping proof mandatory \| \| --- \| --- \| \| Description \| To indicate whether uploading shipping proof is mandatory for seller to confirm Arrange Pickup \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Shipping proof mandatory |
| Description | To indicate whether uploading shipping proof is mandatory for seller to confirm Arrange Pickup |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| validation_type** \| \| --- \| \| \\| Field label \\| Validation type \\| \\| --- \\| --- \\| \\| Description \\| To indicate whether seller or warehouse will expect to receive the return parcel from buyer and validate the condition of the parcel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Validation type \| \| Description \| To indicate whether seller or warehouse will expect to receive the return parcel from buyer and validate the condition of the parcel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| validation_type** |
| \| Field label \| Validation type \| \| --- \| --- \| \| Description \| To indicate whether seller or warehouse will expect to receive the return parcel from buyer and validate the condition of the parcel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Validation type |
| Description | To indicate whether seller or warehouse will expect to receive the return parcel from buyer and validate the condition of the parcel |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| seller_proof_status** \| \| --- \| \| \\| Field label \\| Seller proof status \\| \\| --- \\| --- \\| \\| Description \\| Proof status \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Seller proof status \| \| Description \| Proof status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| seller_proof_status** |
| \| Field label \| Seller proof status \| \| --- \| --- \| \| Description \| Proof status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Seller proof status |
| Description | Proof status |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| seller_compensation_status** \| \| --- \| \| \\| Field label \\| Seller compensation status \\| \\| --- \\| --- \\| \\| Description \\| Compensation status \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Seller compensation status \| \| Description \| Compensation status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| seller_compensation_status** |
| \| Field label \| Seller compensation status \| \| --- \| --- \| \| Description \| Compensation status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Seller compensation status |
| Description | Compensation status |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_buyer_username** \| \| --- \| \| \\| Field label \\| Return buyer username \\| \\| --- \\| --- \\| \\| Description \\| Buyer's nickname, will be masked as '****' if it is a non-integrated return in TW region \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return buyer username \| \| Description \| Buyer's nickname, will be masked as '****' if it is a non-integrated return in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_buyer_username** |
| \| Field label \| Return buyer username \| \| --- \| --- \| \| Description \| Buyer's nickname, will be masked as '****' if it is a non-integrated return in TW region \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return buyer username |
| Description | Buyer's nickname, will be masked as '****' if it is a non-integrated return in TW region |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_created_date** \| \| --- \| \| \\| Field label \\| Return created date \\| \\| --- \\| --- \\| \\| Description \\| The time of return create \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Return created date \| \| Description \| The time of return create \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| return_created_date** |
| \| Field label \| Return created date \| \| --- \| --- \| \| Description \| The time of return create \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Return created date |
| Description | The time of return create |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| return_created_datetime** \| \| --- \| \| \\| Field label \\| Return created datetime \\| \\| --- \\| --- \\| \\| Description \\| The time of return create \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Return created datetime \| \| Description \| The time of return create \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| return_created_datetime** |
| \| Field label \| Return created datetime \| \| --- \| --- \| \| Description \| The time of return create \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Return created datetime |
| Description | The time of return create |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| return_updated_date** \| \| --- \| \| \\| Field label \\| Return updated date \\| \\| --- \\| --- \\| \\| Description \\| The time of modify return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Return updated date \| \| Description \| The time of modify return \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| return_updated_date** |
| \| Field label \| Return updated date \| \| --- \| --- \| \| Description \| The time of modify return \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Return updated date |
| Description | The time of modify return |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| return_updated_datetime** \| \| --- \| \| \\| Field label \\| Return updated datetime \\| \\| --- \\| --- \\| \\| Description \\| The time of modify return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Return updated datetime \| \| Description \| The time of modify return \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| return_updated_datetime** |
| \| Field label \| Return updated datetime \| \| --- \| --- \| \| Description \| The time of modify return \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Return updated datetime |
| Description | The time of modify return |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| return_due_date** \| \| --- \| \| \\| Field label \\| Return due date \\| \\| --- \\| --- \\| \\| Description \\| The last time seller deal with this return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Return due date \| \| Description \| The last time seller deal with this return \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| return_due_date** |
| \| Field label \| Return due date \| \| --- \| --- \| \| Description \| The last time seller deal with this return \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Return due date |
| Description | The last time seller deal with this return |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| return_due_datetime** \| \| --- \| \| \\| Field label \\| Return due datetime \\| \\| --- \\| --- \\| \\| Description \\| The last time seller deal with this return \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Return due datetime \| \| Description \| The last time seller deal with this return \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| return_due_datetime** |
| \| Field label \| Return due datetime \| \| --- \| --- \| \| Description \| The last time seller deal with this return \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Return due datetime |
| Description | The last time seller deal with this return |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| refund_amount** \| \| --- \| \| \\| Field label \\| Refund amount \\| \\| --- \\| --- \\| \\| Description \\| Amount of the refund \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Refund amount \| \| Description \| Amount of the refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| refund_amount** |
| \| Field label \| Refund amount \| \| --- \| --- \| \| Description \| Amount of the refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Refund amount |
| Description | Amount of the refund |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| amount_before_discount** \| \| --- \| \| \\| Field label \\| Amount before discount \\| \\| --- \\| --- \\| \\| Description \\| Order price before discount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Amount before discount \| \| Description \| Order price before discount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| amount_before_discount** |
| \| Field label \| Amount before discount \| \| --- \| --- \| \| Description \| Order price before discount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Amount before discount |
| Description | Order price before discount |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### STORE

| \| store_name** \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| store_name** |
| \| Field label \| Store name \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_id** \| \| --- \| \| \\| Field label \\| Store ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_id** |
| \| Field label \| Store ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### TIME

| \| today** \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| --- |
| today** |
| \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| Field label | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| Destinations | API, Data warehouse |
| \| year** \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year** |
| \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week** \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week** |
| \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week_iso** \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week_iso** |
| \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_month** \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| year_month** |
| \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| Field label | Year & month |
| Field type | dimension |
| Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |
| \| month** \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| month** |
| \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| Field label | Month |
| Field type | dimension |
| Data type | [string.time.month](/apidocs/field-data-types#time) |
| \| year_week** \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| year_week** |
| \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.yearweek](/apidocs/field-data-types#time) |
| \| year_week_iso** \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| year_week_iso** |
| \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) |
| \| week** \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| week** |
| \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| Field label | Week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.week](/apidocs/field-data-types#time) |
| \| week_iso** \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| week_iso** |
| \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| Field label | Week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.weekiso](/apidocs/field-data-types#time) |
| \| day_of_month** \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| day_of_month** |
| \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| Field label | Day of month |
| Field type | dimension |
| Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) |
| \| day_of_week_name** \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| day_of_week_name** |
| \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.dayofweek](/apidocs/field-data-types#time) |
| \| day_of_week_name_iso** \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| day_of_week_name_iso** |
| \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) |
| \| date** \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| atom** \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| atom** |
| \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Datetime |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |

### TIMESTAMP

| \| create_time** \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the date and time that the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| create_time** |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | Timestamp that indicates the date and time that the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| create_datetime** \| \| --- \| \| \\| Field label \\| Create datetime \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the date and time that the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Create datetime \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| create_datetime** |
| \| Field label \| Create datetime \| \| --- \| --- \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Create datetime |
| Description | Timestamp that indicates the date and time that the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| pay_time** \| \| --- \| \| \\| Field label \\| Paid date \\| \\| --- \\| --- \\| \\| Description \\| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Paid date \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| pay_time** |
| \| Field label \| Paid date \| \| --- \| --- \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Paid date |
| Description | The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| pay_datetime** \| \| --- \| \| \\| Field label \\| Paid datetime \\| \\| --- \\| --- \\| \\| Description \\| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Paid datetime \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| pay_datetime** |
| \| Field label \| Paid datetime \| \| --- \| --- \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Paid datetime |
| Description | The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| pickup_done_time** \| \| --- \| \| \\| Field label \\| Pickup done date \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when pickup is done \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Pickup done date \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| pickup_done_time** |
| \| Field label \| Pickup done date \| \| --- \| --- \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Pickup done date |
| Description | The timestamp when pickup is done |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| pickup_done_datetime** \| \| --- \| \| \\| Field label \\| Pickup done datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when pickup is done \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Pickup done datetime \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| pickup_done_datetime** |
| \| Field label \| Pickup done datetime \| \| --- \| --- \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Pickup done datetime |
| Description | The timestamp when pickup is done |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| ship_by_date** \| \| --- \| \| \\| Field label \\| Ship by date \\| \\| --- \\| --- \\| \\| Description \\| The deadline to ship out the parcel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Ship by date \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| ship_by_date** |
| \| Field label \| Ship by date \| \| --- \| --- \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Ship by date |
| Description | The deadline to ship out the parcel |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| ship_by_datetime** \| \| --- \| \| \\| Field label \\| Ship by datetime \\| \\| --- \\| --- \\| \\| Description \\| The deadline to ship out the parcel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Ship by datetime \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| ship_by_datetime** |
| \| Field label \| Ship by datetime \| \| --- \| --- \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Ship by datetime |
| Description | The deadline to ship out the parcel |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| update_time** \| \| --- \| \| \\| Field label \\| Update date \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Update date \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| update_time** |
| \| Field label \| Update date \| \| --- \| --- \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Update date |
| Description | Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| updated_datetime** \| \| --- \| \| \\| Field label \\| Updated datetime \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated datetime \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| updated_datetime** |
| \| Field label \| Updated datetime \| \| --- \| --- \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Updated datetime |
| Description | Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_item_create_time** \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the date and time that the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_item_create_time** |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | Timestamp that indicates the date and time that the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_item_create_datetime** \| \| --- \| \| \\| Field label \\| Create datetime \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the date and time that the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Create datetime \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_item_create_datetime** |
| \| Field label \| Create datetime \| \| --- \| --- \| \| Description \| Timestamp that indicates the date and time that the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Create datetime |
| Description | Timestamp that indicates the date and time that the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_item_pay_time** \| \| --- \| \| \\| Field label \\| Paid date \\| \\| --- \\| --- \\| \\| Description \\| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Paid date \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_item_pay_time** |
| \| Field label \| Paid date \| \| --- \| --- \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Paid date |
| Description | The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_item_pay_datetime** \| \| --- \| \| \\| Field label \\| Paid datetime \\| \\| --- \\| --- \\| \\| Description \\| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Paid datetime \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_item_pay_datetime** |
| \| Field label \| Paid datetime \| \| --- \| --- \| \| Description \| The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Paid datetime |
| Description | The time when the order status is updated from UNPAID to PAID. This value is NULL when order is not paid yet |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_item_pickup_done_time** \| \| --- \| \| \\| Field label \\| Pickup done date \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when pickup is done \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Pickup done date \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_item_pickup_done_time** |
| \| Field label \| Pickup done date \| \| --- \| --- \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Pickup done date |
| Description | The timestamp when pickup is done |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_item_pickup_done_datetime** \| \| --- \| \| \\| Field label \\| Pickup done datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when pickup is done \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Pickup done datetime \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_item_pickup_done_datetime** |
| \| Field label \| Pickup done datetime \| \| --- \| --- \| \| Description \| The timestamp when pickup is done \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Pickup done datetime |
| Description | The timestamp when pickup is done |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_item_ship_by_date** \| \| --- \| \| \\| Field label \\| Ship by date \\| \\| --- \\| --- \\| \\| Description \\| The deadline to ship out the parcel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Ship by date \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_item_ship_by_date** |
| \| Field label \| Ship by date \| \| --- \| --- \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Ship by date |
| Description | The deadline to ship out the parcel |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_item_ship_by_datetime** \| \| --- \| \| \\| Field label \\| Ship by datetime \\| \\| --- \\| --- \\| \\| Description \\| The deadline to ship out the parcel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Ship by datetime \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_item_ship_by_datetime** |
| \| Field label \| Ship by datetime \| \| --- \| --- \| \| Description \| The deadline to ship out the parcel \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Ship by datetime |
| Description | The deadline to ship out the parcel |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_item_update_time** \| \| --- \| \| \\| Field label \\| Update date \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Update date \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_item_update_time** |
| \| Field label \| Update date \| \| --- \| --- \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Update date |
| Description | Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_item_updated_datetime** \| \| --- \| \| \\| Field label \\| Updated datetime \\| \\| --- \\| --- \\| \\| Description \\| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated datetime \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_item_updated_datetime** |
| \| Field label \| Updated datetime \| \| --- \| --- \| \| Description \| Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Updated datetime |
| Description | Timestamp that indicates the last time that there was a change in value of order, such as order status changed from 'Paid' to 'Completed' |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |