BigCommerce 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 City of the billing address
Field type dimension
Data type string.geo.city
billing_company
Display name Billing company
Description Company name of the billing address
Field type dimension
Data type string.text.value
billing_country
Display name Billing country
Description Country of the billing address
Field type dimension
Data type string.geo.country
billing_country_iso2
Display name Billing country (ISO2)
Description ISO 2-letter code for the billing country
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Display name Billing email
Description Email address of the billing address
Field type dimension
Data type string.text.email
billing_first_name
Display name Billing first name
Description First name of the billing address
Field type dimension
Data type string.text.value
billing_last_name
Display name Billing last name
Description Last name of the billing address
Field type dimension
Data type string.text.value
billing_phone
Display name Billing phone
Description Phone number of the billing address
Field type dimension
Data type string.text.phone
billing_state
Display name Billing state
Description State/province of the billing address
Field type dimension
Data type string.geo.region
billing_street_1
Display name Billing street 1
Description Street address of the billing address
Field type dimension
Data type string.geo.street
billing_street_2
Display name Billing street 2
Description Additional street address of the billing address
Field type dimension
Data type string.geo.street
billing_zip
Display name Billing zip
Description Zip/postal code of the billing address
Field type dimension
Data type string.geo.zip
channel_id
Display name Channel ID
Description Shows where the order originated
Field type dimension
Data type string.text.value
coupon
Display name Coupon
Description The coupon amount that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
created_date
Display name Created date
Description Date the order was created
Field type dimension
Data type string.time.date
created_datetime
Display name Created datetime
Description Date and time the order was created
Field type dimension
Data type string.time.datetime
currency_code
Display name Currency code
Description The currency code associated with the price record being acted upon
Field type dimension
Data type string.currency.code
currency_id
Display name Currency ID
Description The active currency ID
Field type dimension
Data type string.text.value
custom_status
Display name Custom status
Description Custom status of the order
Field type dimension
Data type string.text.value
customer_id
Display name Customer ID
Description Unique identifier for the customer
Field type dimension
Data type string.text.value
customer_message
Display name Customer message
Description Message that the customer entered
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
discount_amount
Display name Discount
Description Amount of discount for this transaction
Field type metric
Data type float.currency.value
external_id
Display name External ID
Description The order ID in another system, such as the Amazon order ID if this is an Amazon order
Field type dimension
Data type string.text.value
geoip_country
Display name GeoIP country
Description The full name of the country where the customer made the purchase, based on the IP
Field type dimension
Data type string.geo.country
geoip_country_iso2
Display name GeoIP country (ISO2)
Description The country where the customer made the purchase, in ISO2 format, based on the IP
Field type dimension
Data type string.geo.country.twolettercode
gift_certificate
Display name Gift certificate
Description The gift certificate that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
handling
Display name Handling
Description The value of the handling cost, including tax
Field type metric
Data type float.currency.value
ip_address
Display name IP address
Description IPv4 Address of the customer, if known
Field type dimension
Data type string.text.value
ip_address_v6
Display name IP address v6
Description IPv6 Address of the customer, if known
Field type dimension
Data type string.text.value
items_shipped
Display name Items shipped
Description The number of items that have been shipped
Field type metric
Data type int.number.value
items_total
Display name Items total
Description The total number of items in the order
Field type metric
Data type int.number.value
modified_date
Display name Modified date
Description Date the order was last modified
Field type dimension
Data type string.time.date
modified_datetime
Display name Modified datetime
Description Date and time the order was last modified
Field type dimension
Data type string.time.datetime
order_id
Display name Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
order_is_digital
Display name Order is digital
Description Whether this is an order for digital products
Field type dimension
Data type bool
order_source
Display name Order source
Description Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing
Field type dimension
Data type string.text.value
payment_method
Display name Payment method
Description The payment method for this order
Field type dimension
Data type string.text.value
payment_provider_id
Display name Payment provider ID
Description The external transaction ID/payment ID within this order’s payment provider
Field type dimension
Data type string.text.value
payment_status
Display name Payment status
Description Status of the payment
Field type dimension
Data type string.text.value
refunded_amount
Display name Refunded amount
Description The amount refunded from this transaction
Field type metric
Data type float.currency.value
shipped_date
Display name Shipped date
Description Date the order was shipped
Field type dimension
Data type string.time.date
shipped_datetime
Display name Shipped datetime
Description Date and time the order was shipped
Field type dimension
Data type string.time.datetime
shipping
Display name Shipping
Description The value of shipping cost, including tax
Field type metric
Data type float.currency.value
status
Display name Status
Description Current status of the order
Field type dimension
Data type string.text.value
status_id
Display name Status ID
Description The status ID of the order
Field type dimension
Data type string.text.value
store_credit
Display name Store credit
Description The store credit that the shopper has redeemed on this individual order
Field type metric
Data type float.currency.value
store_hash
Display name Store hash
Description The name of the store
Field type dimension
Data type string.text.value
subtotal
Display name Subtotal
Description The value of subtotal including tax
Field type metric
Data type float.currency.value
total
Display name Total
Description Total value of the order including tax
Field type metric
Data type float.currency.value
wrapping
Display name Wrapping
Description The value of the wrapping cost, including tax
Field type metric
Data type float.currency.value

Table: ORDER_ITEM

billing_city
Display name Billing city
Description City of the billing address
Field type dimension
Data type string.geo.city
billing_company
Display name Billing company
Description Company name of the billing address
Field type dimension
Data type string.text.value
billing_country
Display name Billing country
Description Country of the billing address
Field type dimension
Data type string.geo.country
billing_country_iso2
Display name Billing country (ISO2)
Description ISO 2-letter code for the billing country
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Display name Billing email
Description Email address of the billing address
Field type dimension
Data type string.text.email
billing_first_name
Display name Billing first name
Description First name of the billing address
Field type dimension
Data type string.text.value
billing_last_name
Display name Billing last name
Description Last name of the billing address
Field type dimension
Data type string.text.value
billing_phone
Display name Billing phone
Description Phone number of the billing address
Field type dimension
Data type string.text.phone
billing_state
Display name Billing state
Description State/province of the billing address
Field type dimension
Data type string.geo.region
billing_street_1
Display name Billing street 1
Description Street address of the billing address
Field type dimension
Data type string.geo.street
billing_street_2
Display name Billing street 2
Description Additional street address of the billing address
Field type dimension
Data type string.geo.street
billing_zip
Display name Billing zip
Description Zip/postal code of the billing address
Field type dimension
Data type string.geo.zip
brand
Display name Brand
Description The products brand
Field type dimension
Data type string.text.value
channel_id
Display name Channel ID
Description Shows where the order originated
Field type dimension
Data type string.text.value
created_date
Display name Created date
Description Date the order was created
Field type dimension
Data type string.time.date
created_datetime
Display name Created datetime
Description Date and time the order was created
Field type dimension
Data type string.time.datetime
currency_code
Display name Currency code
Description The currency code associated with the price record being acted upon
Field type dimension
Data type string.currency.code
currency_id
Display name Currency ID
Description The active currency ID
Field type dimension
Data type string.text.value
custom_status
Display name Custom status
Description Custom status of the order
Field type dimension
Data type string.text.value
customer_id
Display name Customer ID
Description Unique identifier for the customer
Field type dimension
Data type string.text.value
customer_message
Display name Customer message
Description Message that the customer entered
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
external_id
Display name External ID
Description The order ID in another system, such as the Amazon order ID if this is an Amazon order
Field type dimension
Data type string.text.value
geoip_country
Display name GeoIP country
Description The full name of the country where the customer made the purchase, based on the IP
Field type dimension
Data type string.geo.country
geoip_country_iso2
Display name GeoIP country (ISO2)
Description The country where the customer made the purchase, in ISO2 format, based on the IP
Field type dimension
Data type string.geo.country.twolettercode
ip_address
Display name IP address
Description IPv4 Address of the customer, if known
Field type dimension
Data type string.text.value
ip_address_v6
Display name IP address v6
Description IPv6 Address of the customer, if known
Field type dimension
Data type string.text.value
modified_date
Display name Modified date
Description Date the order was last modified
Field type dimension
Data type string.time.date
modified_datetime
Display name Modified datetime
Description Date and time the order was last modified
Field type dimension
Data type string.time.datetime
order_id
Display name Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
order_is_digital
Display name Order is digital
Description Whether this is an order for digital products
Field type dimension
Data type bool
order_source
Display name Order source
Description Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing
Field type dimension
Data type string.text.value
payment_method
Display name Payment method
Description The payment method for this order
Field type dimension
Data type string.text.value
payment_provider_id
Display name Payment provider ID
Description The external transaction ID/payment ID within this order’s payment provider
Field type dimension
Data type string.text.value
payment_status
Display name Payment status
Description Status of the payment
Field type dimension
Data type string.text.value
price_base
Display name Price (base)
Description The product’s cost price
Field type metric
Data type float.currency.value
price_inc_tax
Display name Price (inc tax)
Description The product’s cost price including tax
Field type metric
Data type float.currency.value
product_id
Display name Product ID
Description Numeric ID of the product
Field type dimension
Data type string.text.value
product_name
Display name Product name
Description Name of the product
Field type dimension
Data type string.text.value
quantity
Display name Quantity
Description Quantity of the product ordered
Field type metric
Data type int.number.value
quantity_refunded
Display name Quantity refunded
Description The total quantity of product refunded from this transaction
Field type metric
Data type int.number.value
shipped_date
Display name Shipped date
Description Date the order was shipped
Field type dimension
Data type string.time.date
shipped_datetime
Display name Shipped datetime
Description Date and time the order was shipped
Field type dimension
Data type string.time.datetime
sku
Display name SKU
Description User-defined product code/stock keeping unit (SKU)
Field type dimension
Data type string.text.value
status
Display name Status
Description Current status of the order
Field type dimension
Data type string.text.value
status_id
Display name Status ID
Description The status ID of the order
Field type dimension
Data type string.text.value
store_hash
Display name Store hash
Description The name of the store
Field type dimension
Data type string.text.value
total_base
Display name Total (base)
Description Total base price
Field type metric
Data type float.currency.value
total_inc_tax
Display name Total (inc tax)
Description Total base price including tax
Field type metric
Data type float.currency.value
type
Display name Type
Description Type of product
Field type dimension
Data type string.text.value
upc
Display name UPC
Description Universal product code. Can be written to for custom products and catalog products
Field type dimension
Data type string.text.value