Lazada Commerce fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

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

15 metrics56 dimensions

BILLING

billing_name
Field label Billing name
Description Billing name
Field type dimension
Data type string.text.value
billing_city
Field label Billing city
Description Billing city
Field type dimension
Data type string.geo.city
billing_post_code
Field label Billing post code
Description Post code
Field type dimension
Data type string.geo.zip
billing_country
Field label Billing country
Description Country
Field type dimension
Data type string.geo.country

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

LINE ITEM

item_name
Field label Item name
Description Name of the item
Field type dimension
Data type string.text.value
item_variation
Field label Item variation
Description Variations of the item
Field type dimension
Data type string.text.value
item_status
Field label Item status
Description Status of the line item
Field type dimension
Data type string.text.value
seller_sku
Field label Seller SKU
Description Seller SKU of the item
Field type dimension
Data type string.text.value
item_retail_price
Field label Item retail price
Description Retail price of the item
Field type metric
Data type float.currency.value
item_paid_amount
Field label Item paid amount
Description Paid price of the item, excluding shipping fee
Field type metric
Data type float.currency.value
item_shipping_fee
Field label Item shipping fee
Description Shipping fee of the item
Field type metric
Data type float.currency.value
item_quantity
Field label Item quantity
Description Number of items (Per item SKU)
Field type metric
Data type int.number.value

ORDER

order_number
Field label Order number
Description Represents the order number
Field type dimension
Data type string.text.value
order_id
Field label Order ID
Description Represents the order ID
Field type dimension
Data type string.text.value
statuses
Field label Status
Description An array of unique status of the items in the order
Field type dimension
Data type string.text.value
discount_code
Field label Discount code
Description The returned value is voucher ID
Field type dimension
Data type string.text.value
warehouse_code
Field label Warehouse code
Description Warehouse Code of multi-wh sellers
Field type dimension
Data type string.text.value
payment_method
Field label Payment method
Description The method of the payment
Field type dimension
Data type string.text.value
buyer_note
Field label Buyer note
Description Buyer note
Field type dimension
Data type string.text.value
delivery_info
Field label Delivery info
Description Delivery information
Field type dimension
Data type string.text.value
extra_attributes
Field label Extra attributes
Description Extra attributes which were passed to the Seller Center
Field type dimension
Data type string.text.value
remarks
Field label Remarks
Description Remarks
Field type dimension
Data type string.text.value
gift_message
Field label Gift message
Description Gift message as specified by the customer
Field type dimension
Data type string.text.value
promised_shipping_time
Field label Promised shipping time
Description Target shipping time for the soonest order item if they are available
Field type dimension
Data type string.text.value
created_at
Field label Order created date
Description Order created date
Field type dimension
Data type string.time.date
created_at_datetime
Field label Order created time and date
Description Order created time and date
Field type dimension
Data type string.time.datetime
updated_at_date
Field label Order updated date
Description Date of the last change to the order
Field type dimension
Data type string.time.date
updated_at_datetime
Field label Order updated time and date
Description Date and time of the last change to the order
Field type dimension
Data type string.time.datetime
orders
Field label Orders
Description Number of orders
Field type metric
Data type int.number.value
order_item_quantity
Field label Order item quantity
Description Number of items in order
Field type metric
Data type int.number.value
order_sub_total
Field label Order subtotal
Description Original subtotal for the order
Field type metric
Data type float.currency.value
order_shipping_fee
Field label Order shipping fee
Description Total shipping fee for this order
Field type metric
Data type float.currency.value
order_shipping_fee_original
Field label Order shipping fee original
Description The original shipping fee which are supposed to be charged to the customer, before any type of shipping fee promotion
Field type metric
Data type float.currency.value
order_shipping_fee_discount_platform
Field label Order shipping fee discount (Lazada)
Description Shipping fee discount from Lazada
Field type metric
Data type float.currency.value
order_shipping_fee_discount_seller
Field label Order shipping fee discount (seller)
Description Shipping fee discount from seller
Field type metric
Data type float.currency.value
order_discount
Field label Order discount
Description Total discount for this order
Field type metric
Data type float.currency.value
order_discount_platform
Field label Order discount (Lazada)
Description The discount that is issued by Lazada
Field type metric
Data type float.currency.value
order_discount_seller
Field label Order discount (seller)
Description The discount that is issued by the seller
Field type metric
Data type float.currency.value
order_grand_total
Field label Order grand total
Description Grand total unadjusted price for the order (order subtotal - discounts + shipping fees)
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

SHIPPING

shipping_name
Field label Shipping name
Description Shipping name
Field type dimension
Data type string.text.value
shipping_city
Field label Shipping city
Description City name
Field type dimension
Data type string.geo.city
shipping_post_code
Field label Shipping post code
Description Post code
Field type dimension
Data type string.geo.zip
shipping_country
Field label Shipping country
Description Country
Field type dimension
Data type string.geo.country

STORE

store_name
Field label Store
Field type dimension
Data type string.text.value
store_location
Field label Store location
Description Location of the store
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