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.

IDTypeNameDescription
brands__custom_urlOBJECTbrands.custom_urlbrands.custom_url
brands__idTEXTbrands.idbrands.id
brands__image_urlTEXTbrands.image_urlbrands.image_url
brands__meta_descriptionTEXTbrands.meta_descriptionbrands.meta_description
brands__meta_keywordsOBJECTbrands.meta_keywordsbrands.meta_keywords
brands__nameTEXTbrands.namebrands.name
brands__page_titleTEXTbrands.page_titlebrands.page_title
brands__search_keywordsTEXTbrands.search_keywordsbrands.search_keywords

BigCommerce categories fields

The categories report of the BigCommerce connector includes 15 fields.

IDTypeNameDescription
categories__custom_urlOBJECTcategories.custom_urlcategories.custom_url
categories__default_product_sortTEXTcategories.default_product_sortcategories.default_product_sort
categories__descriptionTEXTcategories.descriptioncategories.description
categories__idTEXTcategories.idcategories.id
categories__image_urlTEXTcategories.image_urlcategories.image_url
categories__is_visibleBOOLEANcategories.is_visiblecategories.is_visible
categories__layout_fileTEXTcategories.layout_filecategories.layout_file
categories__meta_descriptionTEXTcategories.meta_descriptioncategories.meta_description
categories__meta_keywordsOBJECTcategories.meta_keywordscategories.meta_keywords
categories__nameTEXTcategories.namecategories.name
categories__page_titleTEXTcategories.page_titlecategories.page_title
categories__parent_idTEXTcategories.parent_idcategories.parent_id
categories__search_keywordsTEXTcategories.search_keywordscategories.search_keywords
categories__sort_orderTEXTcategories.sort_ordercategories.sort_order
categories__viewsNUMERICcategories.viewscategories.views

BigCommerce channels fields

The channels report of the BigCommerce connector includes 12 fields.

IDTypeNameDescription
channels__date_createdTIMESTAMPchannels.date_createdchannels.date_created
channels__date_modifiedTIMESTAMPchannels.date_modifiedchannels.date_modified
channels__external_idTEXTchannels.external_idchannels.external_id
channels__icon_urlTEXTchannels.icon_urlchannels.icon_url
channels__idTEXTchannels.idchannels.id
channels__is_enabledBOOLEANchannels.is_enabledchannels.is_enabled
channels__is_listable_from_uiBOOLEANchannels.is_listable_from_uichannels.is_listable_from_ui
channels__is_visibleBOOLEANchannels.is_visiblechannels.is_visible
channels__nameTEXTchannels.namechannels.name
channels__platformTEXTchannels.platformchannels.platform
channels__statusTEXTchannels.statuschannels.status
channels__typeTEXTchannels.typechannels.type

BigCommerce customers fields

The customers report of the BigCommerce connector includes 16 fields.

IDTypeNameDescription
customers__address_countNUMERICcustomers.address_countcustomers.address_count
customers__addressesOBJECTcustomers.addressescustomers.addresses
customers__attribute_countNUMERICcustomers.attribute_countcustomers.attribute_count
customers__authenticationOBJECTcustomers.authenticationcustomers.authentication
customers__companyTEXTcustomers.companycustomers.company
customers__customer_group_idTEXTcustomers.customer_group_idcustomers.customer_group_id
customers__date_createdTIMESTAMPcustomers.date_createdcustomers.date_created
customers__date_modifiedTIMESTAMPcustomers.date_modifiedcustomers.date_modified
customers__emailTEXTcustomers.emailcustomers.email
customers__first_nameTEXTcustomers.first_namecustomers.first_name
customers__idTEXTcustomers.idcustomers.id
customers__last_nameTEXTcustomers.last_namecustomers.last_name
customers__notesTEXTcustomers.notescustomers.notes
customers__phoneTEXTcustomers.phonecustomers.phone
customers__registration_ip_addressTEXTcustomers.registration_ip_addresscustomers.registration_ip_address
customers__tax_exempt_categoryTEXTcustomers.tax_exempt_categorycustomers.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)

IDTypeNameDescription
order_products__applied_discountsOBJECTorder_products.applied_discountsorder_products.applied_discounts
order_products__base_cost_priceNUMERICorder_products.base_cost_priceorder_products.base_cost_price
order_products__base_priceTEXTorder_products.base_priceorder_products.base_price
order_products__base_totalNUMERICorder_products.base_totalorder_products.base_total
order_products__base_wrapping_costTEXTorder_products.base_wrapping_costorder_products.base_wrapping_cost
order_products__bin_picking_numberTEXTorder_products.bin_picking_numberorder_products.bin_picking_number
order_products__brandTEXTorder_products.brandorder_products.brand
order_products__configurable_fieldsOBJECTorder_products.configurable_fieldsorder_products.configurable_fields
order_products__cost_price_ex_taxNUMERICorder_products.cost_price_ex_taxorder_products.cost_price_ex_tax
order_products__cost_price_inc_taxNUMERICorder_products.cost_price_inc_taxorder_products.cost_price_inc_tax
order_products__cost_price_taxNUMERICorder_products.cost_price_taxorder_products.cost_price_tax
order_products__depthTEXTorder_products.depthorder_products.depth
order_products__ebay_item_idTEXTorder_products.ebay_item_idorder_products.ebay_item_id
order_products__ebay_transaction_idTEXTorder_products.ebay_transaction_idorder_products.ebay_transaction_id
order_products__event_dateTIMESTAMPorder_products.event_dateorder_products.event_date
order_products__event_nameTEXTorder_products.event_nameorder_products.event_name
order_products__external_idTEXTorder_products.external_idorder_products.external_id
order_products__fixed_shipping_costTEXTorder_products.fixed_shipping_costorder_products.fixed_shipping_cost
order_products__fulfillment_sourceTEXTorder_products.fulfillment_sourceorder_products.fulfillment_source
order_products__gift_certificate_idTEXTorder_products.gift_certificate_idorder_products.gift_certificate_id
order_products__heightTEXTorder_products.heightorder_products.height
order_products__idTEXTorder_products.idorder_products.id
order_products__is_bundled_productBOOLEANorder_products.is_bundled_productorder_products.is_bundled_product
order_products__is_refundedBOOLEANorder_products.is_refundedorder_products.is_refunded
order_products__nameTEXTorder_products.nameorder_products.name
order_products__name_customerTEXTorder_products.name_customerorder_products.name_customer
order_products__name_merchantTEXTorder_products.name_merchantorder_products.name_merchant
order_products__option_set_idTEXTorder_products.option_set_idorder_products.option_set_id
order_products__order_address_idTEXTorder_products.order_address_idorder_products.order_address_id
order_products__order_idTEXTorder_products.order_idorder_products.order_id
order_products__parent_order_product_idTEXTorder_products.parent_order_product_idorder_products.parent_order_product_id
order_products__price_ex_taxTEXTorder_products.price_ex_taxorder_products.price_ex_tax
order_products__price_inc_taxTEXTorder_products.price_inc_taxorder_products.price_inc_tax
order_products__price_taxTEXTorder_products.price_taxorder_products.price_tax
order_products__product_idTEXTorder_products.product_idorder_products.product_id
order_products__product_optionsOBJECTorder_products.product_optionsorder_products.product_options
order_products__quantityNUMERICorder_products.quantityorder_products.quantity
order_products__quantity_refundedNUMERICorder_products.quantity_refundedorder_products.quantity_refunded
order_products__quantity_shippedNUMERICorder_products.quantity_shippedorder_products.quantity_shipped
order_products__refund_amountNUMERICorder_products.refund_amountorder_products.refund_amount

BigCommerce order_products fields (order_products__return_id to order_products__wrapping_name)

IDTypeNameDescription
order_products__return_idTEXTorder_products.return_idorder_products.return_id
order_products__skuTEXTorder_products.skuorder_products.sku
order_products__total_ex_taxNUMERICorder_products.total_ex_taxorder_products.total_ex_tax
order_products__total_inc_taxNUMERICorder_products.total_inc_taxorder_products.total_inc_tax
order_products__total_taxNUMERICorder_products.total_taxorder_products.total_tax
order_products__typeTEXTorder_products.typeorder_products.type
order_products__upcTEXTorder_products.upcorder_products.upc
order_products__variant_idTEXTorder_products.variant_idorder_products.variant_id
order_products__weightTEXTorder_products.weightorder_products.weight
order_products__widthTEXTorder_products.widthorder_products.width
order_products__wrapping_cost_ex_taxNUMERICorder_products.wrapping_cost_ex_taxorder_products.wrapping_cost_ex_tax
order_products__wrapping_cost_inc_taxNUMERICorder_products.wrapping_cost_inc_taxorder_products.wrapping_cost_inc_tax
order_products__wrapping_cost_taxNUMERICorder_products.wrapping_cost_taxorder_products.wrapping_cost_tax
order_products__wrapping_idTEXTorder_products.wrapping_idorder_products.wrapping_id
order_products__wrapping_messageTEXTorder_products.wrapping_messageorder_products.wrapping_message
order_products__wrapping_nameTEXTorder_products.wrapping_nameorder_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)

IDTypeNameDescription
orders__base_handling_costTEXTorders.base_handling_costorders.base_handling_cost
orders__base_shipping_costTEXTorders.base_shipping_costorders.base_shipping_cost
orders__base_wrapping_costTEXTorders.base_wrapping_costorders.base_wrapping_cost
orders__billing_addressOBJECTorders.billing_addressorders.billing_address
orders__cart_idTEXTorders.cart_idorders.cart_id
orders__channel_idTEXTorders.channel_idorders.channel_id
orders__coupon_discountTEXTorders.coupon_discountorders.coupon_discount
orders__couponsOBJECTorders.couponsorders.coupons
orders__currency_codeTEXTorders.currency_codeorders.currency_code
orders__currency_exchange_rateTEXTorders.currency_exchange_rateorders.currency_exchange_rate
orders__currency_idTEXTorders.currency_idorders.currency_id
orders__customer_idTEXTorders.customer_idorders.customer_id
orders__customer_localeTEXTorders.customer_localeorders.customer_locale
orders__customer_messageTEXTorders.customer_messageorders.customer_message
orders__date_createdTIMESTAMPorders.date_createdorders.date_created
orders__date_modifiedTIMESTAMPorders.date_modifiedorders.date_modified
orders__date_shippedTIMESTAMPorders.date_shippedorders.date_shipped
orders__default_currency_codeTEXTorders.default_currency_codeorders.default_currency_code
orders__default_currency_idTEXTorders.default_currency_idorders.default_currency_id
orders__discount_amountNUMERICorders.discount_amountorders.discount_amount
orders__ebay_order_idTEXTorders.ebay_order_idorders.ebay_order_id
orders__external_idTEXTorders.external_idorders.external_id
orders__external_sourceTEXTorders.external_sourceorders.external_source
orders__geoip_countryCOUNTRYorders.geoip_countryorders.geoip_country
orders__geoip_country_iso2COUNTRYorders.geoip_country_iso2orders.geoip_country_iso2
orders__gift_certificate_amountNUMERICorders.gift_certificate_amountorders.gift_certificate_amount
orders__handling_cost_ex_taxNUMERICorders.handling_cost_ex_taxorders.handling_cost_ex_tax
orders__handling_cost_inc_taxNUMERICorders.handling_cost_inc_taxorders.handling_cost_inc_tax
orders__handling_cost_taxNUMERICorders.handling_cost_taxorders.handling_cost_tax
orders__handling_cost_tax_class_idTEXTorders.handling_cost_tax_class_idorders.handling_cost_tax_class_id
orders__idTEXTorders.idorders.id
orders__ip_addressTEXTorders.ip_addressorders.ip_address
orders__is_deletedBOOLEANorders.is_deletedorders.is_deleted
orders__is_email_opt_inBOOLEANorders.is_email_opt_inorders.is_email_opt_in
orders__items_shippedNUMERICorders.items_shippedorders.items_shipped
orders__items_totalNUMERICorders.items_totalorders.items_total
orders__order_is_digitalBOOLEANorders.order_is_digitalorders.order_is_digital
orders__order_sourceTEXTorders.order_sourceorders.order_source
orders__payment_methodTEXTorders.payment_methodorders.payment_method
orders__payment_statusTEXTorders.payment_statusorders.payment_status

BigCommerce orders fields (orders__products to orders__wrapping_cost_tax_class_id)

IDTypeNameDescription
orders__productsOBJECTorders.productsorders.products
orders__refunded_amountNUMERICorders.refunded_amountorders.refunded_amount
orders__shipping_address_countNUMERICorders.shipping_address_countorders.shipping_address_count
orders__shipping_addressesOBJECTorders.shipping_addressesorders.shipping_addresses
orders__shipping_cost_ex_taxNUMERICorders.shipping_cost_ex_taxorders.shipping_cost_ex_tax
orders__shipping_cost_inc_taxNUMERICorders.shipping_cost_inc_taxorders.shipping_cost_inc_tax
orders__shipping_cost_taxNUMERICorders.shipping_cost_taxorders.shipping_cost_tax
orders__shipping_cost_tax_class_idTEXTorders.shipping_cost_tax_class_idorders.shipping_cost_tax_class_id
orders__staff_notesTEXTorders.staff_notesorders.staff_notes
orders__statusTEXTorders.statusorders.status
orders__status_idTEXTorders.status_idorders.status_id
orders__store_credit_amountNUMERICorders.store_credit_amountorders.store_credit_amount
orders__subtotal_ex_taxNUMERICorders.subtotal_ex_taxorders.subtotal_ex_tax
orders__subtotal_inc_taxNUMERICorders.subtotal_inc_taxorders.subtotal_inc_tax
orders__subtotal_taxNUMERICorders.subtotal_taxorders.subtotal_tax
orders__tax_provider_idTEXTorders.tax_provider_idorders.tax_provider_id
orders__total_ex_taxNUMERICorders.total_ex_taxorders.total_ex_tax
orders__total_inc_taxNUMERICorders.total_inc_taxorders.total_inc_tax
orders__wrapping_cost_ex_taxNUMERICorders.wrapping_cost_ex_taxorders.wrapping_cost_ex_tax
orders__wrapping_cost_inc_taxNUMERICorders.wrapping_cost_inc_taxorders.wrapping_cost_inc_tax
orders__wrapping_cost_taxNUMERICorders.wrapping_cost_taxorders.wrapping_cost_tax
orders__wrapping_cost_tax_class_idTEXTorders.wrapping_cost_tax_class_idorders.wrapping_cost_tax_class_id

BigCommerce pages fields

The pages report of the BigCommerce connector includes 19 fields.

IDTypeNameDescription
pages__bodyTEXTpages.bodypages.body
pages__channel_idTEXTpages.channel_idpages.channel_id
pages__contact_fieldsTEXTpages.contact_fieldspages.contact_fields
pages__emailTEXTpages.emailpages.email
pages__feedTEXTpages.feedpages.feed
pages__idTEXTpages.idpages.id
pages__is_customers_onlyBOOLEANpages.is_customers_onlypages.is_customers_only
pages__is_homepageBOOLEANpages.is_homepagepages.is_homepage
pages__is_visibleBOOLEANpages.is_visiblepages.is_visible
TEXTpages.linkpages.link
pages__meta_descriptionTEXTpages.meta_descriptionpages.meta_description
pages__meta_keywordsTEXTpages.meta_keywordspages.meta_keywords
pages__meta_titleTEXTpages.meta_titlepages.meta_title
pages__nameTEXTpages.namepages.name
pages__parent_idTEXTpages.parent_idpages.parent_id
pages__search_keywordsTEXTpages.search_keywordspages.search_keywords
pages__sort_orderTEXTpages.sort_orderpages.sort_order
pages__typeTEXTpages.typepages.type
pages__urlTEXTpages.urlpages.url

BigCommerce products fields

The products report of the BigCommerce connector includes 75 fields.

BigCommerce products fields (products__availability to products__name)

IDTypeNameDescription
products__availabilityTEXTproducts.availabilityproducts.availability
products__availability_descriptionTEXTproducts.availability_descriptionproducts.availability_description
products__base_variant_idTEXTproducts.base_variant_idproducts.base_variant_id
products__bin_picking_numberTEXTproducts.bin_picking_numberproducts.bin_picking_number
products__brand_idTEXTproducts.brand_idproducts.brand_id
products__brand_name or brand_idTEXTproducts.brand_name or brand_idproducts.brand_name or brand_id
products__bulk_pricing_rulesOBJECTproducts.bulk_pricing_rulesproducts.bulk_pricing_rules
products__calculated_priceNUMERICproducts.calculated_priceproducts.calculated_price
products__categoriesOBJECTproducts.categoriesproducts.categories
products__conditionTEXTproducts.conditionproducts.condition
products__cost_priceNUMERICproducts.cost_priceproducts.cost_price
products__custom_fieldsOBJECTproducts.custom_fieldsproducts.custom_fields
products__custom_urlOBJECTproducts.custom_urlproducts.custom_url
products__date_createdTIMESTAMPproducts.date_createdproducts.date_created
products__date_modifiedTIMESTAMPproducts.date_modifiedproducts.date_modified
products__depthNUMERICproducts.depthproducts.depth
products__descriptionTEXTproducts.descriptionproducts.description
products__fixed_cost_shipping_priceNUMERICproducts.fixed_cost_shipping_priceproducts.fixed_cost_shipping_price
products__gift_wrapping_options_listOBJECTproducts.gift_wrapping_options_listproducts.gift_wrapping_options_list
products__gift_wrapping_options_typeTEXTproducts.gift_wrapping_options_typeproducts.gift_wrapping_options_type
products__gtinTEXTproducts.gtinproducts.gtin
products__heightNUMERICproducts.heightproducts.height
products__idTEXTproducts.idproducts.id
products__imagesOBJECTproducts.imagesproducts.images
products__inventory_levelTEXTproducts.inventory_levelproducts.inventory_level
products__inventory_trackingTEXTproducts.inventory_trackingproducts.inventory_tracking
products__inventory_warning_levelTEXTproducts.inventory_warning_levelproducts.inventory_warning_level
products__is_condition_shownBOOLEANproducts.is_condition_shownproducts.is_condition_shown
BOOLEANproducts.is_featuredproducts.is_featured
products__is_free_shippingBOOLEANproducts.is_free_shippingproducts.is_free_shipping
products__is_preorder_onlyBOOLEANproducts.is_preorder_onlyproducts.is_preorder_only
products__is_price_hiddenBOOLEANproducts.is_price_hiddenproducts.is_price_hidden
products__is_visibleBOOLEANproducts.is_visibleproducts.is_visible
products__layout_fileTEXTproducts.layout_fileproducts.layout_file
products__map_priceNUMERICproducts.map_priceproducts.map_price
products__meta_descriptionTEXTproducts.meta_descriptionproducts.meta_description
products__meta_keywordsOBJECTproducts.meta_keywordsproducts.meta_keywords
products__modifiersOBJECTproducts.modifiersproducts.modifiers
products__mpnTEXTproducts.mpnproducts.mpn
products__nameTEXTproducts.nameproducts.name

BigCommerce products fields (products__open_graph_description to products__width)

IDTypeNameDescription
products__open_graph_descriptionTEXTproducts.open_graph_descriptionproducts.open_graph_description
products__open_graph_titleTEXTproducts.open_graph_titleproducts.open_graph_title
products__open_graph_typeTEXTproducts.open_graph_typeproducts.open_graph_type
products__open_graph_use_imageBOOLEANproducts.open_graph_use_imageproducts.open_graph_use_image
products__open_graph_use_meta_descriptionBOOLEANproducts.open_graph_use_meta_descriptionproducts.open_graph_use_meta_description
products__open_graph_use_product_nameBOOLEANproducts.open_graph_use_product_nameproducts.open_graph_use_product_name
products__option_set_displayTEXTproducts.option_set_displayproducts.option_set_display
products__option_set_idTEXTproducts.option_set_idproducts.option_set_id
products__optionsOBJECTproducts.optionsproducts.options
products__order_quantity_maximumNUMERICproducts.order_quantity_maximumproducts.order_quantity_maximum
products__order_quantity_minimumNUMERICproducts.order_quantity_minimumproducts.order_quantity_minimum
products__page_titleTEXTproducts.page_titleproducts.page_title
products__preorder_messageTEXTproducts.preorder_messageproducts.preorder_message
products__preorder_release_dateTIMESTAMPproducts.preorder_release_dateproducts.preorder_release_date
products__priceNUMERICproducts.priceproducts.price
products__price_hidden_labelTEXTproducts.price_hidden_labelproducts.price_hidden_label
products__product_tax_codeTEXTproducts.product_tax_codeproducts.product_tax_code
OBJECTproducts.related_productsproducts.related_products
products__retail_priceNUMERICproducts.retail_priceproducts.retail_price
products__reviews_countNUMERICproducts.reviews_countproducts.reviews_count
products__reviews_rating_sumNUMERICproducts.reviews_rating_sumproducts.reviews_rating_sum
products__sale_priceNUMERICproducts.sale_priceproducts.sale_price
products__search_keywordsTEXTproducts.search_keywordsproducts.search_keywords
products__skuTEXTproducts.skuproducts.sku
products__sort_orderTEXTproducts.sort_orderproducts.sort_order
products__tax_class_idTEXTproducts.tax_class_idproducts.tax_class_id
products__total_soldNUMERICproducts.total_soldproducts.total_sold
products__typeTEXTproducts.typeproducts.type
products__upcTEXTproducts.upcproducts.upc
products__variantsOBJECTproducts.variantsproducts.variants
products__videosOBJECTproducts.videosproducts.videos
products__view_countNUMERICproducts.view_countproducts.view_count
products__warrantyTEXTproducts.warrantyproducts.warranty
products__weightNUMERICproducts.weightproducts.weight
products__widthNUMERICproducts.widthproducts.width

BigCommerce store fields

The store report of the BigCommerce connector includes 40 fields.

IDTypeNameDescription
store__account_uuidTEXTstore.account_uuidstore.account_uuid
store__active_comparison_modulesOBJECTstore.active_comparison_modulesstore.active_comparison_modules
store__addressTEXTstore.addressstore.address
store__admin_emailTEXTstore.admin_emailstore.admin_email
store__control_panel_base_urlTEXTstore.control_panel_base_urlstore.control_panel_base_url
store__countryCOUNTRYstore.countrystore.country
store__country_codeCOUNTRYstore.country_codestore.country_code
store__currencyTEXTstore.currencystore.currency
store__currency_symbolTEXTstore.currency_symbolstore.currency_symbol
store__currency_symbol_locationTEXTstore.currency_symbol_locationstore.currency_symbol_location
store__decimal_placesTEXTstore.decimal_placesstore.decimal_places
store__decimal_separatorTEXTstore.decimal_separatorstore.decimal_separator
store__default_channel_idTEXTstore.default_channel_idstore.default_channel_id
store__default_site_idTEXTstore.default_site_idstore.default_site_id
store__dimension_decimal_placesTEXTstore.dimension_decimal_placesstore.dimension_decimal_places
store__dimension_decimal_tokenTEXTstore.dimension_decimal_tokenstore.dimension_decimal_token
store__dimension_thousands_tokenTEXTstore.dimension_thousands_tokenstore.dimension_thousands_token
store__dimension_unitsTEXTstore.dimension_unitsstore.dimension_units
store__domainTEXTstore.domainstore.domain
store__favicon_urlTEXTstore.favicon_urlstore.favicon_url
store__featuresOBJECTstore.featuresstore.features
store__first_nameTEXTstore.first_namestore.first_name
store__idTEXTstore.idstore.id
store__industryTEXTstore.industrystore.industry
store__is_price_entered_with_taxBOOLEANstore.is_price_entered_with_taxstore.is_price_entered_with_tax
store__languageTEXTstore.languagestore.language
store__last_nameTEXTstore.last_namestore.last_name
OBJECTstore.logostore.logo
store__nameTEXTstore.namestore.name
store__order_emailTEXTstore.order_emailstore.order_email
store__phoneTEXTstore.phonestore.phone
store__plan_is_trialBOOLEANstore.plan_is_trialstore.plan_is_trial
store__plan_levelTEXTstore.plan_levelstore.plan_level
store__plan_nameTEXTstore.plan_namestore.plan_name
store__secure_urlTEXTstore.secure_urlstore.secure_url
store__statusTEXTstore.statusstore.status
store__store_idTEXTstore.store_idstore.store_id
store__thousands_separatorTEXTstore.thousands_separatorstore.thousands_separator
store__timezoneOBJECTstore.timezonestore.timezone
store__weight_unitsTEXTstore.weight_unitsstore.weight_units

BigCommerce transactions fields

The transactions report of the BigCommerce connector includes 22 fields.

IDTypeNameDescription
transactions__amountNUMERICtransactions.amounttransactions.amount
transactions__avs_resultOBJECTtransactions.avs_resulttransactions.avs_result
transactions__credit_cardOBJECTtransactions.credit_cardtransactions.credit_card
transactions__currencyTEXTtransactions.currencytransactions.currency
transactions__customOBJECTtransactions.customtransactions.custom
transactions__cvv_resultOBJECTtransactions.cvv_resulttransactions.cvv_result
transactions__date_createdTIMESTAMPtransactions.date_createdtransactions.date_created
transactions__eventTEXTtransactions.eventtransactions.event
transactions__fraud_reviewBOOLEANtransactions.fraud_reviewtransactions.fraud_review
transactions__gatewayTEXTtransactions.gatewaytransactions.gateway
transactions__gateway_transaction_idTEXTtransactions.gateway_transaction_idtransactions.gateway_transaction_id
transactions__gift_certificateOBJECTtransactions.gift_certificatetransactions.gift_certificate
transactions__idTEXTtransactions.idtransactions.id
transactions__methodTEXTtransactions.methodtransactions.method
transactions__offlineOBJECTtransactions.offlinetransactions.offline
transactions__order_idTEXTtransactions.order_idtransactions.order_id
transactions__payment_instrument_tokenTEXTtransactions.payment_instrument_tokentransactions.payment_instrument_token
transactions__payment_method_idTEXTtransactions.payment_method_idtransactions.payment_method_id
transactions__reference_transaction_idTEXTtransactions.reference_transaction_idtransactions.reference_transaction_id
transactions__statusTEXTtransactions.statustransactions.status
transactions__store_creditOBJECTtransactions.store_credittransactions.store_credit
transactions__testBOOLEANtransactions.testtransactions.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.

IDTypeNameDescriptionReport
account_idTEXTAccount IDAccount ID.
account_nameTEXTAccount NameAccount name.
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate.
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20