Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your BigCommerce data to
BigCommerce Connector Reference
57 metrics289 dimensions
The BigCommerce connector exposes 346 fields (57 metrics, 289 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
BigCommerce Fields
BigCommerce brands fields
The brands report of the BigCommerce connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| brands__custom_url | OBJECT | brands.custom_url | brands.custom_url |
| brands__id | TEXT | brands.id | brands.id |
| brands__image_url | TEXT | brands.image_url | brands.image_url |
| brands__meta_description | TEXT | brands.meta_description | brands.meta_description |
| brands__meta_keywords | OBJECT | brands.meta_keywords | brands.meta_keywords |
| brands__name | TEXT | brands.name | brands.name |
| brands__page_title | TEXT | brands.page_title | brands.page_title |
| brands__search_keywords | TEXT | brands.search_keywords | brands.search_keywords |
BigCommerce categories fields
The categories report of the BigCommerce connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| categories__custom_url | OBJECT | categories.custom_url | categories.custom_url |
| categories__default_product_sort | TEXT | categories.default_product_sort | categories.default_product_sort |
| categories__description | TEXT | categories.description | categories.description |
| categories__id | TEXT | categories.id | categories.id |
| categories__image_url | TEXT | categories.image_url | categories.image_url |
| categories__is_visible | BOOLEAN | categories.is_visible | categories.is_visible |
| categories__layout_file | TEXT | categories.layout_file | categories.layout_file |
| categories__meta_description | TEXT | categories.meta_description | categories.meta_description |
| categories__meta_keywords | OBJECT | categories.meta_keywords | categories.meta_keywords |
| categories__name | TEXT | categories.name | categories.name |
| categories__page_title | TEXT | categories.page_title | categories.page_title |
| categories__parent_id | TEXT | categories.parent_id | categories.parent_id |
| categories__search_keywords | TEXT | categories.search_keywords | categories.search_keywords |
| categories__sort_order | TEXT | categories.sort_order | categories.sort_order |
| categories__views | NUMERIC | categories.views | categories.views |
BigCommerce channels fields
The channels report of the BigCommerce connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| channels__date_created | channels.date_created | channels.date_created | |
| channels__date_modified | channels.date_modified | channels.date_modified | |
| channels__external_id | TEXT | channels.external_id | channels.external_id |
| channels__icon_url | TEXT | channels.icon_url | channels.icon_url |
| channels__id | TEXT | channels.id | channels.id |
| channels__is_enabled | BOOLEAN | channels.is_enabled | channels.is_enabled |
| channels__is_listable_from_ui | BOOLEAN | channels.is_listable_from_ui | channels.is_listable_from_ui |
| channels__is_visible | BOOLEAN | channels.is_visible | channels.is_visible |
| channels__name | TEXT | channels.name | channels.name |
| channels__platform | TEXT | channels.platform | channels.platform |
| channels__status | TEXT | channels.status | channels.status |
| channels__type | TEXT | channels.type | channels.type |
BigCommerce customers fields
The customers report of the BigCommerce connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers__address_count | NUMERIC | customers.address_count | customers.address_count |
| customers__addresses | OBJECT | customers.addresses | customers.addresses |
| customers__attribute_count | NUMERIC | customers.attribute_count | customers.attribute_count |
| customers__authentication | OBJECT | customers.authentication | customers.authentication |
| customers__company | TEXT | customers.company | customers.company |
| customers__customer_group_id | TEXT | customers.customer_group_id | customers.customer_group_id |
| customers__date_created | customers.date_created | customers.date_created | |
| customers__date_modified | customers.date_modified | customers.date_modified | |
| customers__email | TEXT | customers.email | customers.email |
| customers__first_name | TEXT | customers.first_name | customers.first_name |
| customers__id | TEXT | customers.id | customers.id |
| customers__last_name | TEXT | customers.last_name | customers.last_name |
| customers__notes | TEXT | customers.notes | customers.notes |
| customers__phone | TEXT | customers.phone | customers.phone |
| customers__registration_ip_address | TEXT | customers.registration_ip_address | customers.registration_ip_address |
| customers__tax_exempt_category | TEXT | customers.tax_exempt_category | customers.tax_exempt_category |
BigCommerce order_products fields
The order_products report of the BigCommerce connector includes 56 fields.
BigCommerce order_products fields (order_products__applied_discounts to order_products__refund_amount)
| ID | Type | Name | Description |
|---|---|---|---|
| order_products__applied_discounts | OBJECT | order_products.applied_discounts | order_products.applied_discounts |
| order_products__base_cost_price | NUMERIC | order_products.base_cost_price | order_products.base_cost_price |
| order_products__base_price | TEXT | order_products.base_price | order_products.base_price |
| order_products__base_total | NUMERIC | order_products.base_total | order_products.base_total |
| order_products__base_wrapping_cost | TEXT | order_products.base_wrapping_cost | order_products.base_wrapping_cost |
| order_products__bin_picking_number | TEXT | order_products.bin_picking_number | order_products.bin_picking_number |
| order_products__brand | TEXT | order_products.brand | order_products.brand |
| order_products__configurable_fields | OBJECT | order_products.configurable_fields | order_products.configurable_fields |
| order_products__cost_price_ex_tax | NUMERIC | order_products.cost_price_ex_tax | order_products.cost_price_ex_tax |
| order_products__cost_price_inc_tax | NUMERIC | order_products.cost_price_inc_tax | order_products.cost_price_inc_tax |
| order_products__cost_price_tax | NUMERIC | order_products.cost_price_tax | order_products.cost_price_tax |
| order_products__depth | TEXT | order_products.depth | order_products.depth |
| order_products__ebay_item_id | TEXT | order_products.ebay_item_id | order_products.ebay_item_id |
| order_products__ebay_transaction_id | TEXT | order_products.ebay_transaction_id | order_products.ebay_transaction_id |
| order_products__event_date | order_products.event_date | order_products.event_date | |
| order_products__event_name | TEXT | order_products.event_name | order_products.event_name |
| order_products__external_id | TEXT | order_products.external_id | order_products.external_id |
| order_products__fixed_shipping_cost | TEXT | order_products.fixed_shipping_cost | order_products.fixed_shipping_cost |
| order_products__fulfillment_source | TEXT | order_products.fulfillment_source | order_products.fulfillment_source |
| order_products__gift_certificate_id | TEXT | order_products.gift_certificate_id | order_products.gift_certificate_id |
| order_products__height | TEXT | order_products.height | order_products.height |
| order_products__id | TEXT | order_products.id | order_products.id |
| order_products__is_bundled_product | BOOLEAN | order_products.is_bundled_product | order_products.is_bundled_product |
| order_products__is_refunded | BOOLEAN | order_products.is_refunded | order_products.is_refunded |
| order_products__name | TEXT | order_products.name | order_products.name |
| order_products__name_customer | TEXT | order_products.name_customer | order_products.name_customer |
| order_products__name_merchant | TEXT | order_products.name_merchant | order_products.name_merchant |
| order_products__option_set_id | TEXT | order_products.option_set_id | order_products.option_set_id |
| order_products__order_address_id | TEXT | order_products.order_address_id | order_products.order_address_id |
| order_products__order_id | TEXT | order_products.order_id | order_products.order_id |
| order_products__parent_order_product_id | TEXT | order_products.parent_order_product_id | order_products.parent_order_product_id |
| order_products__price_ex_tax | TEXT | order_products.price_ex_tax | order_products.price_ex_tax |
| order_products__price_inc_tax | TEXT | order_products.price_inc_tax | order_products.price_inc_tax |
| order_products__price_tax | TEXT | order_products.price_tax | order_products.price_tax |
| order_products__product_id | TEXT | order_products.product_id | order_products.product_id |
| order_products__product_options | OBJECT | order_products.product_options | order_products.product_options |
| order_products__quantity | NUMERIC | order_products.quantity | order_products.quantity |
| order_products__quantity_refunded | NUMERIC | order_products.quantity_refunded | order_products.quantity_refunded |
| order_products__quantity_shipped | NUMERIC | order_products.quantity_shipped | order_products.quantity_shipped |
| order_products__refund_amount | NUMERIC | order_products.refund_amount | order_products.refund_amount |
BigCommerce order_products fields (order_products__return_id to order_products__wrapping_name)
| ID | Type | Name | Description |
|---|---|---|---|
| order_products__return_id | TEXT | order_products.return_id | order_products.return_id |
| order_products__sku | TEXT | order_products.sku | order_products.sku |
| order_products__total_ex_tax | NUMERIC | order_products.total_ex_tax | order_products.total_ex_tax |
| order_products__total_inc_tax | NUMERIC | order_products.total_inc_tax | order_products.total_inc_tax |
| order_products__total_tax | NUMERIC | order_products.total_tax | order_products.total_tax |
| order_products__type | TEXT | order_products.type | order_products.type |
| order_products__upc | TEXT | order_products.upc | order_products.upc |
| order_products__variant_id | TEXT | order_products.variant_id | order_products.variant_id |
| order_products__weight | TEXT | order_products.weight | order_products.weight |
| order_products__width | TEXT | order_products.width | order_products.width |
| order_products__wrapping_cost_ex_tax | NUMERIC | order_products.wrapping_cost_ex_tax | order_products.wrapping_cost_ex_tax |
| order_products__wrapping_cost_inc_tax | NUMERIC | order_products.wrapping_cost_inc_tax | order_products.wrapping_cost_inc_tax |
| order_products__wrapping_cost_tax | NUMERIC | order_products.wrapping_cost_tax | order_products.wrapping_cost_tax |
| order_products__wrapping_id | TEXT | order_products.wrapping_id | order_products.wrapping_id |
| order_products__wrapping_message | TEXT | order_products.wrapping_message | order_products.wrapping_message |
| order_products__wrapping_name | TEXT | order_products.wrapping_name | order_products.wrapping_name |
BigCommerce orders fields
The orders report of the BigCommerce connector includes 62 fields.
BigCommerce orders fields (orders__base_handling_cost to orders__payment_status)
| ID | Type | Name | Description |
|---|---|---|---|
| orders__base_handling_cost | TEXT | orders.base_handling_cost | orders.base_handling_cost |
| orders__base_shipping_cost | TEXT | orders.base_shipping_cost | orders.base_shipping_cost |
| orders__base_wrapping_cost | TEXT | orders.base_wrapping_cost | orders.base_wrapping_cost |
| orders__billing_address | OBJECT | orders.billing_address | orders.billing_address |
| orders__cart_id | TEXT | orders.cart_id | orders.cart_id |
| orders__channel_id | TEXT | orders.channel_id | orders.channel_id |
| orders__coupon_discount | TEXT | orders.coupon_discount | orders.coupon_discount |
| orders__coupons | OBJECT | orders.coupons | orders.coupons |
| orders__currency_code | TEXT | orders.currency_code | orders.currency_code |
| orders__currency_exchange_rate | TEXT | orders.currency_exchange_rate | orders.currency_exchange_rate |
| orders__currency_id | TEXT | orders.currency_id | orders.currency_id |
| orders__customer_id | TEXT | orders.customer_id | orders.customer_id |
| orders__customer_locale | TEXT | orders.customer_locale | orders.customer_locale |
| orders__customer_message | TEXT | orders.customer_message | orders.customer_message |
| orders__date_created | orders.date_created | orders.date_created | |
| orders__date_modified | orders.date_modified | orders.date_modified | |
| orders__date_shipped | orders.date_shipped | orders.date_shipped | |
| orders__default_currency_code | TEXT | orders.default_currency_code | orders.default_currency_code |
| orders__default_currency_id | TEXT | orders.default_currency_id | orders.default_currency_id |
| orders__discount_amount | NUMERIC | orders.discount_amount | orders.discount_amount |
| orders__ebay_order_id | TEXT | orders.ebay_order_id | orders.ebay_order_id |
| orders__external_id | TEXT | orders.external_id | orders.external_id |
| orders__external_source | TEXT | orders.external_source | orders.external_source |
| orders__geoip_country | COUNTRY | orders.geoip_country | orders.geoip_country |
| orders__geoip_country_iso2 | COUNTRY | orders.geoip_country_iso2 | orders.geoip_country_iso2 |
| orders__gift_certificate_amount | NUMERIC | orders.gift_certificate_amount | orders.gift_certificate_amount |
| orders__handling_cost_ex_tax | NUMERIC | orders.handling_cost_ex_tax | orders.handling_cost_ex_tax |
| orders__handling_cost_inc_tax | NUMERIC | orders.handling_cost_inc_tax | orders.handling_cost_inc_tax |
| orders__handling_cost_tax | NUMERIC | orders.handling_cost_tax | orders.handling_cost_tax |
| orders__handling_cost_tax_class_id | TEXT | orders.handling_cost_tax_class_id | orders.handling_cost_tax_class_id |
| orders__id | TEXT | orders.id | orders.id |
| orders__ip_address | TEXT | orders.ip_address | orders.ip_address |
| orders__is_deleted | BOOLEAN | orders.is_deleted | orders.is_deleted |
| orders__is_email_opt_in | BOOLEAN | orders.is_email_opt_in | orders.is_email_opt_in |
| orders__items_shipped | NUMERIC | orders.items_shipped | orders.items_shipped |
| orders__items_total | NUMERIC | orders.items_total | orders.items_total |
| orders__order_is_digital | BOOLEAN | orders.order_is_digital | orders.order_is_digital |
| orders__order_source | TEXT | orders.order_source | orders.order_source |
| orders__payment_method | TEXT | orders.payment_method | orders.payment_method |
| orders__payment_status | TEXT | orders.payment_status | orders.payment_status |
BigCommerce orders fields (orders__products to orders__wrapping_cost_tax_class_id)
| ID | Type | Name | Description |
|---|---|---|---|
| orders__products | OBJECT | orders.products | orders.products |
| orders__refunded_amount | NUMERIC | orders.refunded_amount | orders.refunded_amount |
| orders__shipping_address_count | NUMERIC | orders.shipping_address_count | orders.shipping_address_count |
| orders__shipping_addresses | OBJECT | orders.shipping_addresses | orders.shipping_addresses |
| orders__shipping_cost_ex_tax | NUMERIC | orders.shipping_cost_ex_tax | orders.shipping_cost_ex_tax |
| orders__shipping_cost_inc_tax | NUMERIC | orders.shipping_cost_inc_tax | orders.shipping_cost_inc_tax |
| orders__shipping_cost_tax | NUMERIC | orders.shipping_cost_tax | orders.shipping_cost_tax |
| orders__shipping_cost_tax_class_id | TEXT | orders.shipping_cost_tax_class_id | orders.shipping_cost_tax_class_id |
| orders__staff_notes | TEXT | orders.staff_notes | orders.staff_notes |
| orders__status | TEXT | orders.status | orders.status |
| orders__status_id | TEXT | orders.status_id | orders.status_id |
| orders__store_credit_amount | NUMERIC | orders.store_credit_amount | orders.store_credit_amount |
| orders__subtotal_ex_tax | NUMERIC | orders.subtotal_ex_tax | orders.subtotal_ex_tax |
| orders__subtotal_inc_tax | NUMERIC | orders.subtotal_inc_tax | orders.subtotal_inc_tax |
| orders__subtotal_tax | NUMERIC | orders.subtotal_tax | orders.subtotal_tax |
| orders__tax_provider_id | TEXT | orders.tax_provider_id | orders.tax_provider_id |
| orders__total_ex_tax | NUMERIC | orders.total_ex_tax | orders.total_ex_tax |
| orders__total_inc_tax | NUMERIC | orders.total_inc_tax | orders.total_inc_tax |
| orders__wrapping_cost_ex_tax | NUMERIC | orders.wrapping_cost_ex_tax | orders.wrapping_cost_ex_tax |
| orders__wrapping_cost_inc_tax | NUMERIC | orders.wrapping_cost_inc_tax | orders.wrapping_cost_inc_tax |
| orders__wrapping_cost_tax | NUMERIC | orders.wrapping_cost_tax | orders.wrapping_cost_tax |
| orders__wrapping_cost_tax_class_id | TEXT | orders.wrapping_cost_tax_class_id | orders.wrapping_cost_tax_class_id |
BigCommerce pages fields
The pages report of the BigCommerce connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| pages__body | TEXT | pages.body | pages.body |
| pages__channel_id | TEXT | pages.channel_id | pages.channel_id |
| pages__contact_fields | TEXT | pages.contact_fields | pages.contact_fields |
| pages__email | TEXT | pages.email | pages.email |
| pages__feed | TEXT | pages.feed | pages.feed |
| pages__id | TEXT | pages.id | pages.id |
| pages__is_customers_only | BOOLEAN | pages.is_customers_only | pages.is_customers_only |
| pages__is_homepage | BOOLEAN | pages.is_homepage | pages.is_homepage |
| pages__is_visible | BOOLEAN | pages.is_visible | pages.is_visible |
| pages__link | TEXT | pages.link | pages.link |
| pages__meta_description | TEXT | pages.meta_description | pages.meta_description |
| pages__meta_keywords | TEXT | pages.meta_keywords | pages.meta_keywords |
| pages__meta_title | TEXT | pages.meta_title | pages.meta_title |
| pages__name | TEXT | pages.name | pages.name |
| pages__parent_id | TEXT | pages.parent_id | pages.parent_id |
| pages__search_keywords | TEXT | pages.search_keywords | pages.search_keywords |
| pages__sort_order | TEXT | pages.sort_order | pages.sort_order |
| pages__type | TEXT | pages.type | pages.type |
| pages__url | TEXT | pages.url | pages.url |
BigCommerce products fields
The products report of the BigCommerce connector includes 75 fields.
BigCommerce products fields (products__availability to products__name)
| ID | Type | Name | Description |
|---|---|---|---|
| products__availability | TEXT | products.availability | products.availability |
| products__availability_description | TEXT | products.availability_description | products.availability_description |
| products__base_variant_id | TEXT | products.base_variant_id | products.base_variant_id |
| products__bin_picking_number | TEXT | products.bin_picking_number | products.bin_picking_number |
| products__brand_id | TEXT | products.brand_id | products.brand_id |
| products__brand_name or brand_id | TEXT | products.brand_name or brand_id | products.brand_name or brand_id |
| products__bulk_pricing_rules | OBJECT | products.bulk_pricing_rules | products.bulk_pricing_rules |
| products__calculated_price | NUMERIC | products.calculated_price | products.calculated_price |
| products__categories | OBJECT | products.categories | products.categories |
| products__condition | TEXT | products.condition | products.condition |
| products__cost_price | NUMERIC | products.cost_price | products.cost_price |
| products__custom_fields | OBJECT | products.custom_fields | products.custom_fields |
| products__custom_url | OBJECT | products.custom_url | products.custom_url |
| products__date_created | products.date_created | products.date_created | |
| products__date_modified | products.date_modified | products.date_modified | |
| products__depth | NUMERIC | products.depth | products.depth |
| products__description | TEXT | products.description | products.description |
| products__fixed_cost_shipping_price | NUMERIC | products.fixed_cost_shipping_price | products.fixed_cost_shipping_price |
| products__gift_wrapping_options_list | OBJECT | products.gift_wrapping_options_list | products.gift_wrapping_options_list |
| products__gift_wrapping_options_type | TEXT | products.gift_wrapping_options_type | products.gift_wrapping_options_type |
| products__gtin | TEXT | products.gtin | products.gtin |
| products__height | NUMERIC | products.height | products.height |
| products__id | TEXT | products.id | products.id |
| products__images | OBJECT | products.images | products.images |
| products__inventory_level | TEXT | products.inventory_level | products.inventory_level |
| products__inventory_tracking | TEXT | products.inventory_tracking | products.inventory_tracking |
| products__inventory_warning_level | TEXT | products.inventory_warning_level | products.inventory_warning_level |
| products__is_condition_shown | BOOLEAN | products.is_condition_shown | products.is_condition_shown |
| products__is_featured | BOOLEAN | products.is_featured | products.is_featured |
| products__is_free_shipping | BOOLEAN | products.is_free_shipping | products.is_free_shipping |
| products__is_preorder_only | BOOLEAN | products.is_preorder_only | products.is_preorder_only |
| BOOLEAN | products.is_price_hidden | products.is_price_hidden | |
| products__is_visible | BOOLEAN | products.is_visible | products.is_visible |
| products__layout_file | TEXT | products.layout_file | products.layout_file |
| products__map_price | NUMERIC | products.map_price | products.map_price |
| products__meta_description | TEXT | products.meta_description | products.meta_description |
| products__meta_keywords | OBJECT | products.meta_keywords | products.meta_keywords |
| products__modifiers | OBJECT | products.modifiers | products.modifiers |
| products__mpn | TEXT | products.mpn | products.mpn |
| products__name | TEXT | products.name | products.name |
BigCommerce products fields (products__open_graph_description to products__width)
| ID | Type | Name | Description |
|---|---|---|---|
| products__open_graph_description | TEXT | products.open_graph_description | products.open_graph_description |
| products__open_graph_title | TEXT | products.open_graph_title | products.open_graph_title |
| products__open_graph_type | TEXT | products.open_graph_type | products.open_graph_type |
| products__open_graph_use_image | BOOLEAN | products.open_graph_use_image | products.open_graph_use_image |
| products__open_graph_use_meta_description | BOOLEAN | products.open_graph_use_meta_description | products.open_graph_use_meta_description |
| products__open_graph_use_product_name | BOOLEAN | products.open_graph_use_product_name | products.open_graph_use_product_name |
| products__option_set_display | TEXT | products.option_set_display | products.option_set_display |
| products__option_set_id | TEXT | products.option_set_id | products.option_set_id |
| products__options | OBJECT | products.options | products.options |
| products__order_quantity_maximum | NUMERIC | products.order_quantity_maximum | products.order_quantity_maximum |
| products__order_quantity_minimum | NUMERIC | products.order_quantity_minimum | products.order_quantity_minimum |
| products__page_title | TEXT | products.page_title | products.page_title |
| products__preorder_message | TEXT | products.preorder_message | products.preorder_message |
| products__preorder_release_date | products.preorder_release_date | products.preorder_release_date | |
| products__price | NUMERIC | products.price | products.price |
| TEXT | products.price_hidden_label | products.price_hidden_label | |
| products__product_tax_code | TEXT | products.product_tax_code | products.product_tax_code |
| products__related_products | OBJECT | products.related_products | products.related_products |
| products__retail_price | NUMERIC | products.retail_price | products.retail_price |
| products__reviews_count | NUMERIC | products.reviews_count | products.reviews_count |
| products__reviews_rating_sum | NUMERIC | products.reviews_rating_sum | products.reviews_rating_sum |
| products__sale_price | NUMERIC | products.sale_price | products.sale_price |
| products__search_keywords | TEXT | products.search_keywords | products.search_keywords |
| products__sku | TEXT | products.sku | products.sku |
| products__sort_order | TEXT | products.sort_order | products.sort_order |
| products__tax_class_id | TEXT | products.tax_class_id | products.tax_class_id |
| products__total_sold | NUMERIC | products.total_sold | products.total_sold |
| products__type | TEXT | products.type | products.type |
| products__upc | TEXT | products.upc | products.upc |
| products__variants | OBJECT | products.variants | products.variants |
| products__videos | OBJECT | products.videos | products.videos |
| products__view_count | NUMERIC | products.view_count | products.view_count |
| products__warranty | TEXT | products.warranty | products.warranty |
| products__weight | NUMERIC | products.weight | products.weight |
| products__width | NUMERIC | products.width | products.width |
BigCommerce store fields
The store report of the BigCommerce connector includes 40 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| store__account_uuid | TEXT | store.account_uuid | store.account_uuid |
| store__active_comparison_modules | OBJECT | store.active_comparison_modules | store.active_comparison_modules |
| store__address | TEXT | store.address | store.address |
| store__admin_email | TEXT | store.admin_email | store.admin_email |
| store__control_panel_base_url | TEXT | store.control_panel_base_url | store.control_panel_base_url |
| store__country | COUNTRY | store.country | store.country |
| store__country_code | COUNTRY | store.country_code | store.country_code |
| store__currency | TEXT | store.currency | store.currency |
| store__currency_symbol | TEXT | store.currency_symbol | store.currency_symbol |
| store__currency_symbol_location | TEXT | store.currency_symbol_location | store.currency_symbol_location |
| store__decimal_places | TEXT | store.decimal_places | store.decimal_places |
| store__decimal_separator | TEXT | store.decimal_separator | store.decimal_separator |
| store__default_channel_id | TEXT | store.default_channel_id | store.default_channel_id |
| store__default_site_id | TEXT | store.default_site_id | store.default_site_id |
| store__dimension_decimal_places | TEXT | store.dimension_decimal_places | store.dimension_decimal_places |
| store__dimension_decimal_token | TEXT | store.dimension_decimal_token | store.dimension_decimal_token |
| store__dimension_thousands_token | TEXT | store.dimension_thousands_token | store.dimension_thousands_token |
| store__dimension_units | TEXT | store.dimension_units | store.dimension_units |
| store__domain | TEXT | store.domain | store.domain |
| store__favicon_url | TEXT | store.favicon_url | store.favicon_url |
| store__features | OBJECT | store.features | store.features |
| store__first_name | TEXT | store.first_name | store.first_name |
| store__id | TEXT | store.id | store.id |
| store__industry | TEXT | store.industry | store.industry |
| store__is_price_entered_with_tax | BOOLEAN | store.is_price_entered_with_tax | store.is_price_entered_with_tax |
| store__language | TEXT | store.language | store.language |
| store__last_name | TEXT | store.last_name | store.last_name |
| store__logo | OBJECT | store.logo | store.logo |
| store__name | TEXT | store.name | store.name |
| store__order_email | TEXT | store.order_email | store.order_email |
| store__phone | TEXT | store.phone | store.phone |
| store__plan_is_trial | BOOLEAN | store.plan_is_trial | store.plan_is_trial |
| store__plan_level | TEXT | store.plan_level | store.plan_level |
| store__plan_name | TEXT | store.plan_name | store.plan_name |
| store__secure_url | TEXT | store.secure_url | store.secure_url |
| store__status | TEXT | store.status | store.status |
| store__store_id | TEXT | store.store_id | store.store_id |
| store__thousands_separator | TEXT | store.thousands_separator | store.thousands_separator |
| store__timezone | OBJECT | store.timezone | store.timezone |
| store__weight_units | TEXT | store.weight_units | store.weight_units |
BigCommerce transactions fields
The transactions report of the BigCommerce connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| transactions__amount | NUMERIC | transactions.amount | transactions.amount |
| transactions__avs_result | OBJECT | transactions.avs_result | transactions.avs_result |
| transactions__credit_card | OBJECT | transactions.credit_card | transactions.credit_card |
| transactions__currency | TEXT | transactions.currency | transactions.currency |
| transactions__custom | OBJECT | transactions.custom | transactions.custom |
| transactions__cvv_result | OBJECT | transactions.cvv_result | transactions.cvv_result |
| transactions__date_created | transactions.date_created | transactions.date_created | |
| transactions__event | TEXT | transactions.event | transactions.event |
| transactions__fraud_review | BOOLEAN | transactions.fraud_review | transactions.fraud_review |
| transactions__gateway | TEXT | transactions.gateway | transactions.gateway |
| transactions__gateway_transaction_id | TEXT | transactions.gateway_transaction_id | transactions.gateway_transaction_id |
| transactions__gift_certificate | OBJECT | transactions.gift_certificate | transactions.gift_certificate |
| transactions__id | TEXT | transactions.id | transactions.id |
| transactions__method | TEXT | transactions.method | transactions.method |
| transactions__offline | OBJECT | transactions.offline | transactions.offline |
| transactions__order_id | TEXT | transactions.order_id | transactions.order_id |
| transactions__payment_instrument_token | TEXT | transactions.payment_instrument_token | transactions.payment_instrument_token |
| transactions__payment_method_id | TEXT | transactions.payment_method_id | transactions.payment_method_id |
| transactions__reference_transaction_id | TEXT | transactions.reference_transaction_id | transactions.reference_transaction_id |
| transactions__status | TEXT | transactions.status | transactions.status |
| transactions__store_credit | OBJECT | transactions.store_credit | transactions.store_credit |
| transactions__test | BOOLEAN | transactions.test | transactions.test |
BigCommerce other fields
The BigCommerce connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |