Lazada Commerce data warehouse table groups

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

Table: ORDER

billing_city
Display name Billing city
Description Billing city
Field type dimension
Data type string.geo.city
billing_country
Display name Billing country
Description Country
Field type dimension
Data type string.geo.country
billing_name
Display name Billing name
Description Billing name
Field type dimension
Data type string.text.value
billing_post_code
Display name Billing post code
Description Post code
Field type dimension
Data type string.geo.zip
buyer_note
Display name Buyer note
Description Buyer note
Field type dimension
Data type string.text.value
created_at
Display name Order created date
Description Order created date
Field type dimension
Data type string.time.date
created_at_datetime
Display name Order created time and date
Description Order created time and date
Field type dimension
Data type string.time.datetime
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
delivery_info
Display name Delivery info
Description Delivery information
Field type dimension
Data type string.text.value
discount_code
Display name Discount code
Description The returned value is voucher ID
Field type dimension
Data type string.text.value
extra_attributes
Display name Extra attributes
Description Extra attributes which were passed to the Seller Center
Field type dimension
Data type string.text.value
gift_message
Display name Gift message
Description Gift message as specified by the customer
Field type dimension
Data type string.text.value
order_discount
Display name Order discount
Description Total discount for this order
Field type metric
Data type float.currency.value
order_discount_platform
Display name Order discount (Lazada)
Description The discount that is issued by Lazada
Field type metric
Data type float.currency.value
order_discount_seller
Display name Order discount (seller)
Description The discount that is issued by the seller
Field type metric
Data type float.currency.value
order_id
Display name Order ID
Description Represents the order ID
Field type dimension
Data type string.text.value
order_item_quantity
Display name Order item quantity
Description Number of items in order
Field type metric
Data type int.number.value
order_number
Display name Order number
Description Represents the order number
Field type dimension
Data type string.text.value
order_shipping_fee
Display name Order shipping fee
Description Total shipping fee for this order
Field type metric
Data type float.currency.value
order_shipping_fee_discount_platform
Display name Order shipping fee discount (Lazada)
Description Shipping fee discount from Lazada
Field type metric
Data type float.currency.value
order_shipping_fee_discount_seller
Display name Order shipping fee discount (seller)
Description Shipping fee discount from seller
Field type metric
Data type float.currency.value
order_shipping_fee_original
Display name 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_sub_total
Display name Order subtotal
Description Original subtotal for the order
Field type metric
Data type float.currency.value
payment_method
Display name Payment method
Description The method of the payment
Field type dimension
Data type string.text.value
remarks
Display name Remarks
Description Remarks
Field type dimension
Data type string.text.value
shipping_city
Display name Shipping city
Description City name
Field type dimension
Data type string.geo.city
shipping_country
Display name Shipping country
Description Country
Field type dimension
Data type string.geo.country
shipping_name
Display name Shipping name
Description Shipping name
Field type dimension
Data type string.text.value
shipping_post_code
Display name Shipping post code
Description Post code
Field type dimension
Data type string.geo.zip
statuses
Display name Status
Description An array of unique status of the items in the order
Field type dimension
Data type string.text.value
store_location
Display name Store location
Description Location of the store
Field type dimension
Data type string.text.value
store_name
Display name Store
Field type dimension
Data type string.text.value
updated_at_date
Display name Order updated date
Description Date of the last change to the order
Field type dimension
Data type string.time.date
updated_at_datetime
Display name Order updated time and date
Description Date and time of the last change to the order
Field type dimension
Data type string.time.datetime
warehouse_code
Display name Warehouse code
Description Warehouse Code of multi-wh sellers
Field type dimension
Data type string.text.value