WooCommerce data warehouse table groups

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

Table: ORDERS

account_name
Display name Store URL
Description The URL of the store
Field type dimension
Data type string.text.url
billing_address_line_1
Display name Billing address line 1
Description Address line 1
Field type dimension
Data type string.text.value
billing_address_line_2
Display name Billing address line 2
Description Address line 2
Field type dimension
Data type string.text.value
billing_city
Display name Billing city
Description City name
Field type dimension
Data type string.geo.city
billing_company_name
Display name Billing company name
Description Company name
Field type dimension
Data type string.text.value
billing_country
Display name Billing country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Display name Billing email
Description Email address
Field type dimension
Data type string.text.email
billing_first_name
Display name Billing first name
Description Billing first name
Field type dimension
Data type string.text.value
billing_last_name
Display name Billing last name
Description Billing last name
Field type dimension
Data type string.text.value
billing_phone
Display name Billing phone
Description Phone number
Field type dimension
Data type string.text.phone
billing_postcode
Display name Billing post code
Description Postal code
Field type dimension
Data type string.text.value
billing_state
Display name Billing state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
created_via
Display name Order created via
Description Shows where the order was created
Field type dimension
Data type string.text.value
customer_id
Display name Customer ID
Description User ID who owns the order. 0 for guests. Default is 0
Field type dimension
Data type string.text.value
customer_ip_address
Display name Customer IP address
Description Customer's IP address
Field type dimension
Data type string.text.value
customer_note
Display name Customer note
Description Note left by customer during checkout
Field type dimension
Data type string.text.value
customer_user_agent
Display name Customer user agent
Description User agent of the customer
Field type dimension
Data type string.text.value
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
needs_payment
Display name Order is paid
Description Define if the order is paid. It will set the status to processing and reduce stock items
Field type dimension
Data type bool
order_cart_tax
Display name Order cart tax
Description Sum of line item taxes only
Field type metric
Data type float.currency.value
order_completed_date
Display name Order completed date
Description The date the order was completed, in the site's timezone
Field type dimension
Data type string.time.date
order_completed_date_gmt
Display name Order completed date (GMT)
Description The date the order was completed, in the GMT timezone
Field type dimension
Data type string.time.date
order_completed_datetime
Display name Order completed datetime
Description The datetime the order was completed, in the site's timezone
Field type dimension
Data type string.time.datetime
order_completed_datetime_gmt
Display name Order completed datetime (GMT)
Description The datetime the order was completed, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_created_date
Display name Order created date
Description The date the order was created, in the site's timezone
Field type dimension
Data type string.time.date
order_created_datetime
Display name Order created datetime
Description The datetime the order was created, in the site's timezone
Field type dimension
Data type string.time.datetime
order_created_datetime_gmt
Display name Order created datetime (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_created_gmt
Display name Order created date (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.date
order_currency
Display name Order currency
Description Currency the order was created with, in ISO format
Field type dimension
Data type string.currency.code
order_discount_tax
Display name Order discount tax
Description Total discount tax amount for the order
Field type metric
Data type float.currency.value
order_discount_total
Display name Order discount total
Description Total discount amount for the order
Field type metric
Data type float.currency.value
order_id
Display name Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
order_key
Display name Order key
Description Key of the order
Field type dimension
Data type string.text.value
order_modified_date
Display name Order modified date
Description The date the order was last modified, in the site's timezone
Field type dimension
Data type string.time.date
order_modified_datetime
Display name Order modified datetime
Description The datetime the order was last modified, in the site's timezone
Field type dimension
Data type string.time.datetime
order_modified_datetime_gmt
Display name Order modified datetime (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_modified_gmt
Display name Order modified date (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.date
order_number
Display name Order number
Description Number of the order
Field type dimension
Data type string.text.value
order_paid_date
Display name Order paid date
Description The date the order was paid, in the site's timezone
Field type dimension
Data type string.time.date
order_paid_date_gmt
Display name Order paid date (GMT)
Description The date the order was paid, in the GMT timezone
Field type dimension
Data type string.time.date
order_paid_datetime
Display name Order paid datetime
Description The datetime the order was paid, in the site's timezone
Field type dimension
Data type string.time.datetime
order_paid_datetime_gmt
Display name Order paid datetime (GMT)
Description The datetime the order was paid, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_shipping_tax
Display name Order shipping tax
Description Total shipping tax amount for the order
Field type metric
Data type float.currency.value
order_shipping_total
Display name Order shipping total
Description Total shipping amount for the order
Field type metric
Data type float.currency.value
order_status
Display name Order status
Description Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending
Field type dimension
Data type string.text.value
order_total
Display name Order total
Description Grand total
Field type metric
Data type float.currency.value
order_total_tax
Display name Order total tax
Description Sum of all taxes
Field type metric
Data type float.currency.value
parent_id
Display name Order parent ID
Description Parent ID of the order
Field type dimension
Data type string.text.value
payment_method
Display name Payment method ID
Description Payment method ID
Field type dimension
Data type string.text.value
payment_method_title
Display name Payment method title
Description Payment method title
Field type dimension
Data type string.text.value
prices_include_tax
Display name Prices include tax
Description True the prices included tax during checkout
Field type dimension
Data type bool
shipping_address_line_1
Display name Shipping address line 1
Description Shipping address line 1
Field type dimension
Data type string.text.value
shipping_address_line_2
Display name Shipping address line 2
Description Shipping address line 2
Field type dimension
Data type string.text.value
shipping_city
Display name Shipping city
Description Shipping city name
Field type dimension
Data type string.geo.city
shipping_company_name
Display name Shipping company name
Description Shipping company name
Field type dimension
Data type string.text.value
shipping_country
Display name Shipping country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
shipping_first_name
Display name Shipping first name
Description Shipping first name
Field type dimension
Data type string.text.value
shipping_last_name
Display name Shipping last name
Description Shipping last name
Field type dimension
Data type string.text.value
shipping_phone
Display name Shipping phone
Description Shipping phone number
Field type dimension
Data type string.text.phone
shipping_postcode
Display name Shipping post code
Description Shipping postal code
Field type dimension
Data type string.text.value
shipping_state
Display name Shipping state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
transaction_id
Display name Unique transaction ID
Description Unique transaction ID
Field type dimension
Data type string.text.value

Table: ORDER_ITEMS

account_name
Display name Store URL
Description The URL of the store
Field type dimension
Data type string.text.url
billing_address_line_1
Display name Billing address line 1
Description Address line 1
Field type dimension
Data type string.text.value
billing_address_line_2
Display name Billing address line 2
Description Address line 2
Field type dimension
Data type string.text.value
billing_city
Display name Billing city
Description City name
Field type dimension
Data type string.geo.city
billing_company_name
Display name Billing company name
Description Company name
Field type dimension
Data type string.text.value
billing_country
Display name Billing country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Display name Billing email
Description Email address
Field type dimension
Data type string.text.email
billing_first_name
Display name Billing first name
Description Billing first name
Field type dimension
Data type string.text.value
billing_last_name
Display name Billing last name
Description Billing last name
Field type dimension
Data type string.text.value
billing_phone
Display name Billing phone
Description Phone number
Field type dimension
Data type string.text.phone
billing_postcode
Display name Billing post code
Description Postal code
Field type dimension
Data type string.text.value
billing_state
Display name Billing state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
created_via
Display name Order created via
Description Shows where the order was created
Field type dimension
Data type string.text.value
customer_id
Display name Customer ID
Description User ID who owns the order. 0 for guests. Default is 0
Field type dimension
Data type string.text.value
customer_ip_address
Display name Customer IP address
Description Customer's IP address
Field type dimension
Data type string.text.value
customer_note
Display name Customer note
Description Note left by customer during checkout
Field type dimension
Data type string.text.value
customer_user_agent
Display name Customer user agent
Description User agent of the customer
Field type dimension
Data type string.text.value
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
line_item_discount
Display name Item discount
Description Discount applied for the line-item. (Item discount = Item subtotal - Item total)
Field type metric
Data type float.currency.value
line_item_id
Display name Line item ID
Description Item ID
Field type dimension
Data type string.text.value
line_item_image_id
Display name Line item image ID
Description Line item image ID
Field type dimension
Data type string.text.value
line_item_image_url
Display name Line item image URL
Description Line item image URL
Field type dimension
Data type string.text.url
line_item_name
Display name Product name
Description Product name
Field type dimension
Data type string.text.value
line_item_parent_name
Display name Product parent name
Description Product parent name
Field type dimension
Data type string.text.value
line_item_price
Display name Item price
Description Cost per line item unit
Field type metric
Data type float.currency.value
line_item_product_id
Display name Product ID
Description Product ID
Field type dimension
Data type string.text.value
line_item_sku
Display name Line item SKU
Description Product SKU
Field type dimension
Data type string.text.value
line_item_subtotal
Display name Item subtotal
Description Line item subtotal (before discounts)
Field type metric
Data type float.currency.value
line_item_tax_class
Display name Line item tax class
Description Slug of the tax class of product
Field type dimension
Data type string.text.value
line_item_total
Display name Item total
Description Line total (after discounts)
Field type metric
Data type float.currency.value
line_item_total_tax
Display name Item tax
Description Tax for the line item
Field type metric
Data type float.currency.value
line_item_variation_id
Display name Product variation ID
Description Variation ID, if applicable
Field type dimension
Data type string.text.value
needs_payment
Display name Order is paid
Description Define if the order is paid. It will set the status to processing and reduce stock items
Field type dimension
Data type bool
order_completed_date
Display name Order completed date
Description The date the order was completed, in the site's timezone
Field type dimension
Data type string.time.date
order_completed_date_gmt
Display name Order completed date (GMT)
Description The date the order was completed, in the GMT timezone
Field type dimension
Data type string.time.date
order_completed_datetime
Display name Order completed datetime
Description The datetime the order was completed, in the site's timezone
Field type dimension
Data type string.time.datetime
order_completed_datetime_gmt
Display name Order completed datetime (GMT)
Description The datetime the order was completed, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_created_date
Display name Order created date
Description The date the order was created, in the site's timezone
Field type dimension
Data type string.time.date
order_created_datetime
Display name Order created datetime
Description The datetime the order was created, in the site's timezone
Field type dimension
Data type string.time.datetime
order_created_datetime_gmt
Display name Order created datetime (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_created_gmt
Display name Order created date (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.date
order_currency
Display name Order currency
Description Currency the order was created with, in ISO format
Field type dimension
Data type string.currency.code
order_id
Display name Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
order_key
Display name Order key
Description Key of the order
Field type dimension
Data type string.text.value
order_modified_date
Display name Order modified date
Description The date the order was last modified, in the site's timezone
Field type dimension
Data type string.time.date
order_modified_datetime
Display name Order modified datetime
Description The datetime the order was last modified, in the site's timezone
Field type dimension
Data type string.time.datetime
order_modified_datetime_gmt
Display name Order modified datetime (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_modified_gmt
Display name Order modified date (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.date
order_number
Display name Order number
Description Number of the order
Field type dimension
Data type string.text.value
order_paid_date
Display name Order paid date
Description The date the order was paid, in the site's timezone
Field type dimension
Data type string.time.date
order_paid_date_gmt
Display name Order paid date (GMT)
Description The date the order was paid, in the GMT timezone
Field type dimension
Data type string.time.date
order_paid_datetime
Display name Order paid datetime
Description The datetime the order was paid, in the site's timezone
Field type dimension
Data type string.time.datetime
order_paid_datetime_gmt
Display name Order paid datetime (GMT)
Description The datetime the order was paid, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_status
Display name Order status
Description Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending
Field type dimension
Data type string.text.value
parent_id
Display name Order parent ID
Description Parent ID of the order
Field type dimension
Data type string.text.value
payment_method
Display name Payment method ID
Description Payment method ID
Field type dimension
Data type string.text.value
payment_method_title
Display name Payment method title
Description Payment method title
Field type dimension
Data type string.text.value
prices_include_tax
Display name Prices include tax
Description True the prices included tax during checkout
Field type dimension
Data type bool
quantity
Display name Item quantity
Description Number of line item units
Field type metric
Data type int.number.value
shipping_address_line_1
Display name Shipping address line 1
Description Shipping address line 1
Field type dimension
Data type string.text.value
shipping_address_line_2
Display name Shipping address line 2
Description Shipping address line 2
Field type dimension
Data type string.text.value
shipping_city
Display name Shipping city
Description Shipping city name
Field type dimension
Data type string.geo.city
shipping_company_name
Display name Shipping company name
Description Shipping company name
Field type dimension
Data type string.text.value
shipping_country
Display name Shipping country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
shipping_first_name
Display name Shipping first name
Description Shipping first name
Field type dimension
Data type string.text.value
shipping_last_name
Display name Shipping last name
Description Shipping last name
Field type dimension
Data type string.text.value
shipping_phone
Display name Shipping phone
Description Shipping phone number
Field type dimension
Data type string.text.phone
shipping_postcode
Display name Shipping post code
Description Shipping postal code
Field type dimension
Data type string.text.value
shipping_state
Display name Shipping state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
transaction_id
Display name Unique transaction ID
Description Unique transaction ID
Field type dimension
Data type string.text.value