BigCommerce
The table below gives information about all the data fields that you can import from BigCommerce.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
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 |
|
|
|
|
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 |
|