Shopee Commerce metrics and dimensions

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Shopee Commerce data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

7 metrics111 dimensions

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
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
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
buyer_cancel_reason
Field label Buyer cancel reason
Description Cancel reason from buyer, could be empty
Field type dimension
Data type string.text.value
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
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
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
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

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
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
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

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
order_item_item_name
Field label Item name
Description The name of the item
Field type dimension
Data type string.text.value
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
order_item_order_item_id
Field label Order item ID
Description The identify of order item
Field type dimension
Data type string.text.value
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
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
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
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
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
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
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
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
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
order_item_promotion_id
Field label Promotion ID
Description The ID of the promotion
Field type dimension
Data type string.text.value
order_item_promotion_group_id
Field label Promotion group ID
Description The identify of product promotion
Field type dimension
Data type int.number.value
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
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
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
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
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
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
order_item_weight
Field label Weight
Description The weight of the item
Field type metric
Data type float.number.value

ORDER

order_sn
Field label Order SN
Description Shopee's unique identifier for an order
Field type dimension
Data type string.text.value
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
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
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
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
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
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
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
cancel_by
Field label Cancel by
Description Could be one of buyer, seller, system or Ops
Field type dimension
Data type string.text.value
cancel_reason
Field label Cancel reason
Description The reason for buyer, seller or system cancellation
Field type dimension
Data type string.text.value
dropshipper
Field label Dropshipper
Description For Indonesia orders only. The name of the dropshipper
Field type dimension
Data type string.text.value
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
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
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
message_to_seller
Field label Message to seller
Description Message to seller
Field type dimension
Data type string.text.value
note
Field label Note
Description The note seller made for own reference
Field type dimension
Data type string.text.value
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
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
split_up
Field label Split up
Description Indicates whether this order is split
Field type dimension
Data type string.text.value
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
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
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
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
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
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
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
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
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
order_item_dropshipper
Field label Dropshipper
Description For Indonesia orders only. The name of the dropshipper
Field type dimension
Data type string.text.value
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
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
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
order_item_message_to_seller
Field label Message to seller
Description Message to seller
Field type dimension
Data type string.text.value
order_item_note
Field label Note
Description The note seller made for own reference
Field type dimension
Data type string.text.value
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
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
order_item_split_up
Field label Split up
Description Indicates whether this order is split
Field type dimension
Data type string.text.value
estimated_shipping_fee
Field label Estimated shipping fee
Field type metric
Data type float.currency.value
reverse_shipping_fee
Field label Reverse shipping fee
Field type metric
Data type float.currency.value
total_amount
Field label Order total
Field type metric
Data type float.currency.value

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
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
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
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

STORE

store_name
Field label Store name
Field type dimension
Data type string.text.value
store_id
Field label Store ID
Field type dimension
Data type string.text.value

TIME

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

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
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
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
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
pickup_done_time
Field label Pickup done date
Description The timestamp when pickup is done
Field type dimension
Data type string.time.date
pickup_done_datetime
Field label Pickup done datetime
Description The timestamp when pickup is done
Field type dimension
Data type string.time.datetime
ship_by_date
Field label Ship by date
Description The deadline to ship out the parcel
Field type dimension
Data type string.time.date
ship_by_datetime
Field label Ship by datetime
Description The deadline to ship out the parcel
Field type dimension
Data type string.time.datetime
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
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
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
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
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
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
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
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
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
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
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
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