BigCommerce

The table below gives information about all the data fields that you can import from BigCommerce.

Field UI name

Field API name

Data Type

Description

Use in Adverity

Docs

accepts_product_review_abandoned_cart_emails

accepts_product_review_abandoned_cart_emails

Boolean

dimension

authentication.force_password_reset

authentication.force_password_reset

Boolean

dimension

base_handling_cost

base_handling_cost

Float

metric

base_shipping_cost

base_shipping_cost

Float

metric

base_wrapping_cost

base_wrapping_cost

Float

metric

billing_address.city

billing_address.city

String

dimension

billing_address.company

billing_address.company

String

dimension

billing_address.country

billing_address.country

String

dimension

billing_address.country_iso2

billing_address.country_iso2

String

dimension

billing_address.email

billing_address.email

String

dimension

billing_address.first_name

billing_address.first_name

String

dimension

billing_address.form_fields

billing_address.form_fields

String

dimension

billing_address.last_name

billing_address.last_name

String

dimension

billing_address.phone

billing_address.phone

Long

metric

billing_address.state

billing_address.state

String

dimension

billing_address.street_1

billing_address.street_1

String

dimension

billing_address.street_2

billing_address.street_2

String

dimension

billing_address.zip

billing_address.zip

String

dimension

cart_id

cart_id

String

dimension

channel_id

channel_id

Long

dimension

channel_ids

channel_ids

String

dimension

company

company

String

dimension

coupon_discount

coupon_discount

Float

metric

credit_card_type

credit_card_type

String

dimension

currency_code

currency_code

String

dimension

currency_exchange_rate

currency_exchange_rate

Float

metric

currency_id

currency_id

Long

dimension

custom_status

custom_status

String

dimension

customer_group_id

customer_group_id

Long

dimension

customer_id

customer_id

Long

dimension

customer_locale

customer_locale

String

dimension

customer_message

customer_message

String

dimension

date_created

date_created

Date

dimension

date_modified

date_modified

Date

dimension

date_shipped

date_shipped

String

dimension

default_currency_code

default_currency_code

String

dimension

default_currency_id

default_currency_id

Long

dimension

discount_amount

discount_amount

Float

metric

ebay_order_id

ebay_order_id

Long

dimension

email

email

String

dimension

external_id

external_id

String

dimension

external_merchant_id

external_merchant_id

String

dimension

external_order_id

external_order_id

String

dimension

external_source

external_source

String

dimension

first_name

first_name

String

dimension

geoip_country

geoip_country

String

dimension

geoip_country_iso2

geoip_country_iso2

String

dimension

gift_certificate_amount

gift_certificate_amount

Float

metric

handling_cost_ex_tax

handling_cost_ex_tax

Float

metric

handling_cost_inc_tax

handling_cost_inc_tax

Float

metric

handling_cost_tax

handling_cost_tax

Float

metric

handling_cost_tax_class_id

handling_cost_tax_class_id

Long

dimension

id

id

Long

dimension

ip_address

ip_address

String

dimension

ip_address_v6

ip_address_v6

String

dimension

is_deleted

is_deleted

Boolean

dimension

is_email_opt_in

is_email_opt_in

Boolean

dimension

items_shipped

items_shipped

Long

metric

items_total

items_total

Long

metric

last_name

last_name

String

dimension

notes

notes

String

dimension

order_is_digital

order_is_digital

Boolean

dimension

order_source

order_source

String

dimension

origin_channel_id

origin_channel_id

Long

dimension

payment_method

payment_method

String

dimension

payment_provider_id

payment_provider_id

String

dimension

payment_status

payment_status

String

dimension

phone

phone

String

dimension

refunded_amount

refunded_amount

Float

metric

registration_ip_address

registration_ip_address

String

dimension

shipping_address_count

shipping_address_count

Long

metric

shipping_cost_ex_tax

shipping_cost_ex_tax

Float

metric

shipping_cost_inc_tax

shipping_cost_inc_tax

Float

metric

shipping_cost_tax

shipping_cost_tax

Float

metric

shipping_cost_tax_class_id

shipping_cost_tax_class_id

Long

dimension

staff_notes

staff_notes

String

dimension

status

status

String

dimension

status_id

status_id

Long

dimension

store_credit_amount

store_credit_amount

Float

metric

store_default_currency_code

store_default_currency_code

String

dimension

store_default_to_transactional_exchange_rate

store_default_to_transactional_exchange_rate

Float

metric

subtotal_ex_tax

subtotal_ex_tax

Float

metric

subtotal_inc_tax

subtotal_inc_tax

Float

metric

subtotal_tax

subtotal_tax

Float

metric

tax_exempt_category

tax_exempt_category

String

dimension

tax_provider_id

tax_provider_id

String

dimension

total_ex_tax

total_ex_tax

Float

metric

total_inc_tax

total_inc_tax

Float

metric

total_tax

total_tax

Float

metric

wrapping_cost_ex_tax

wrapping_cost_ex_tax

Float

metric

wrapping_cost_inc_tax

wrapping_cost_inc_tax

Float

metric

wrapping_cost_tax

wrapping_cost_tax

Float

metric

wrapping_cost_tax_class_id

wrapping_cost_tax_class_id

Long

dimension