Introduction

Datasources and destinations

Fields listing for Bigcommerce

Customers Address Count
Customers Address Count
Field IDcustomers/address_count
TypeNUMBER
Data Typedimension
Customers Addresses
Customers Addresses
Field IDcustomers/addresses
TypeTEXT
Data Typedimension
Customers Attribute Count
Customers Attribute Count
Field IDcustomers/attribute_count
TypeNUMBER
Data Typedimension
Customers Authentication
Customers Authentication
Field IDcustomers/authentication
TypeTEXT
Data Typedimension
Customers Company
Customers Company
Field IDcustomers/company
TypeTEXT
Data Typedimension
Customers Customer Group Id
Customers Customer Group Id
Field IDcustomers/customer_group_id
TypeNUMBER
Data Typedimension
Customers Date Created
Customers Date Created
Field IDcustomers/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
Customers Date Modified
Customers Date Modified
Field IDcustomers/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Customers Email
Customers Email
Field IDcustomers/email
TypeTEXT
Data Typedimension
Customers First Name
Customers First Name
Field IDcustomers/first_name
TypeTEXT
Data Typedimension
Customers Id
Customers Id
Field IDcustomers/id
TypeNUMBER
Data Typedimension
Customers Last Name
Customers Last Name
Field IDcustomers/last_name
TypeTEXT
Data Typedimension
Customers Notes
Customers Notes
Field IDcustomers/notes
TypeTEXT
Data Typedimension
Customers Phone
Customers Phone
Field IDcustomers/phone
TypeTEXT
Data Typedimension
Customers Registration Ip Address
Customers Registration Ip Address
Field IDcustomers/registration_ip_address
TypeTEXT
Data Typedimension
Customers Tax Exempt Category
Customers Tax Exempt Category
Field IDcustomers/tax_exempt_category
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Orders Base Handling Cost
Orders Base Handling Cost
Field IDorders/base_handling_cost
TypeTEXT
Data Typedimension
Orders Base Shipping Cost
Orders Base Shipping Cost
Field IDorders/base_shipping_cost
TypeTEXT
Data Typedimension
Orders Base Wrapping Cost
Orders Base Wrapping Cost
Field IDorders/base_wrapping_cost
TypeTEXT
Data Typedimension
Orders Billing Address
Orders Billing Address
Field IDorders/billing_address
TypeTEXT
Data Typedimension
Orders Cart Id
Orders Cart Id
Field IDorders/cart_id
TypeTEXT
Data Typedimension
Orders Channel Id
Orders Channel Id
Field IDorders/channel_id
TypeNUMBER
Data Typedimension
Orders Coupon Discount
Orders Coupon Discount
Field IDorders/coupon_discount
TypeTEXT
Data Typedimension
Orders Coupons
Orders Coupons
Field IDorders/coupons
TypeTEXT
Data Typedimension
Orders Currency Code
Orders Currency Code
Field IDorders/currency_code
TypeTEXT
Data Typedimension
Orders Currency Exchange Rate
Orders Currency Exchange Rate
Field IDorders/currency_exchange_rate
TypeTEXT
Data Typedimension
Orders Currency Id
Orders Currency Id
Field IDorders/currency_id
TypeNUMBER
Data Typedimension
Orders Customer Locale
Orders Customer Locale
Field IDorders/customer_locale
TypeTEXT
Data Typedimension
Orders Customer Message
Orders Customer Message
Field IDorders/customer_message
TypeTEXT
Data Typedimension
Orders Date Created
Orders Date Created
Field IDorders/date_created
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Orders Date Modified
Orders Date Modified
Field IDorders/date_modified
TypeYEAR_MONTH_DAY
Data Typedimension
Orders Date Shipped
Orders Date Shipped
Field IDorders/date_shipped
TypeYEAR_MONTH_DAY
Data Typedimension
Orders Default Currency Code
Orders Default Currency Code
Field IDorders/default_currency_code
TypeTEXT
Data Typedimension
Orders Default Currency Id
Orders Default Currency Id
Field IDorders/default_currency_id
TypeNUMBER
Data Typedimension
Orders Discount Amount
Orders Discount Amount
Field IDorders/discount_amount
TypeTEXT
Data Typedimension
Orders Ebay Order Id
Orders Ebay Order Id
Field IDorders/ebay_order_id
TypeTEXT
Data Typedimension
Orders External Id
Orders External Id
Field IDorders/external_id
TypeTEXT
Data Typedimension
Orders External Source
Orders External Source
Field IDorders/external_source
TypeTEXT
Data Typedimension
Orders Geoip Country
Orders Geoip Country
Field IDorders/geoip_country
TypeTEXT
Data Typedimension
Orders Geoip Country Iso2
Orders Geoip Country Iso2
Field IDorders/geoip_country_iso2
TypeTEXT
Data Typedimension
Orders Gift Certificate Amount
Orders Gift Certificate Amount
Field IDorders/gift_certificate_amount
TypeTEXT
Data Typedimension
Orders Handling Cost Ex Tax
Orders Handling Cost Ex Tax
Field IDorders/handling_cost_ex_tax
TypeTEXT
Data Typedimension
Orders Handling Cost Inc Tax
Orders Handling Cost Inc Tax
Field IDorders/handling_cost_inc_tax
TypeTEXT
Data Typedimension
Orders Handling Cost Tax
Orders Handling Cost Tax
Field IDorders/handling_cost_tax
TypeTEXT
Data Typedimension
Orders Handling Cost Tax Class Id
Orders Handling Cost Tax Class Id
Field IDorders/handling_cost_tax_class_id
TypeNUMBER
Data Typedimension
Orders Id
Orders Id
Field IDorders/id
TypeNUMBER
Data Typedimension
Orders Ip Address
Orders Ip Address
Field IDorders/ip_address
TypeTEXT
Data Typedimension
Orders Is Deleted
Orders Is Deleted
Field IDorders/is_deleted
TypeBOOLEAN
Data Typedimension
Orders Is Email Opt In
Orders Is Email Opt In
Field IDorders/is_email_opt_in
TypeBOOLEAN
Data Typedimension
Orders Items Shipped
Orders Items Shipped
Field IDorders/items_shipped
TypeNUMBER
Data Typedimension
Orders Items Total
Orders Items Total
Field IDorders/items_total
TypeNUMBER
Data Typedimension
Orders Order Is Digital
Orders Order Is Digital
Field IDorders/order_is_digital
TypeBOOLEAN
Data Typedimension
Orders Order Source
Orders Order Source
Field IDorders/order_source
TypeTEXT
Data Typedimension
Orders Payment Method
Orders Payment Method
Field IDorders/payment_method
TypeTEXT
Data Typedimension
Orders Payment Status
Orders Payment Status
Field IDorders/payment_status
TypeTEXT
Data Typedimension
Orders Products
Orders Products
Field IDorders/products
TypeTEXT
Data Typedimension
Orders Refunded Amount
Orders Refunded Amount
Field IDorders/refunded_amount
TypeTEXT
Data Typedimension
Orders Shipping Address Count
Orders Shipping Address Count
Field IDorders/shipping_address_count
TypeNUMBER
Data Typedimension
Orders Shipping Addresses
Orders Shipping Addresses
Field IDorders/shipping_addresses
TypeTEXT
Data Typedimension
Orders Shipping Cost Ex Tax
Orders Shipping Cost Ex Tax
Field IDorders/shipping_cost_ex_tax
TypeTEXT
Data Typedimension
Orders Shipping Cost Inc Tax
Orders Shipping Cost Inc Tax
Field IDorders/shipping_cost_inc_tax
TypeTEXT
Data Typedimension
Orders Shipping Cost Tax
Orders Shipping Cost Tax
Field IDorders/shipping_cost_tax
TypeTEXT
Data Typedimension
Orders Shipping Cost Tax Class Id
Orders Shipping Cost Tax Class Id
Field IDorders/shipping_cost_tax_class_id
TypeNUMBER
Data Typedimension
Orders Staff Notes
Orders Staff Notes
Field IDorders/staff_notes
TypeTEXT
Data Typedimension
Orders Status
Orders Status
Field IDorders/status
TypeTEXT
Data Typedimension
Orders Status Id
Orders Status Id
Field IDorders/status_id
TypeNUMBER
Data Typedimension
Orders Store Credit Amount
Orders Store Credit Amount
Field IDorders/store_credit_amount
TypeTEXT
Data Typedimension
Orders Subtotal Ex Tax
Orders Subtotal Ex Tax
Field IDorders/subtotal_ex_tax
TypeTEXT
Data Typedimension
Orders Subtotal Inc Tax
Orders Subtotal Inc Tax
Field IDorders/subtotal_inc_tax
TypeTEXT
Data Typedimension
Orders Subtotal Tax
Orders Subtotal Tax
Field IDorders/subtotal_tax
TypeTEXT
Data Typedimension
Orders Tax Provider Id
Orders Tax Provider Id
Field IDorders/tax_provider_id
TypeTEXT
Data Typedimension
Orders Total Ex Tax
Orders Total Ex Tax
Field IDorders/total_ex_tax
TypeTEXT
Data Typedimension
Orders Total Inc Tax
Orders Total Inc Tax
Field IDorders/total_inc_tax
TypeTEXT
Data Typedimension
Orders Wrapping Cost Ex Tax
Orders Wrapping Cost Ex Tax
Field IDorders/wrapping_cost_ex_tax
TypeTEXT
Data Typedimension
Orders Wrapping Cost Inc Tax
Orders Wrapping Cost Inc Tax
Field IDorders/wrapping_cost_inc_tax
TypeTEXT
Data Typedimension
Orders Wrapping Cost Tax
Orders Wrapping Cost Tax
Field IDorders/wrapping_cost_tax
TypeTEXT
Data Typedimension
Orders Wrapping Cost Tax Class Id
Orders Wrapping Cost Tax Class Id
Field IDorders/wrapping_cost_tax_class_id
TypeNUMBER
Data Typedimension
Order Products Type
Order Products Type
Field IDorder_products/type
TypeTEXT
Data Typedimension
Order Products Applied Discounts
Order Products Applied Discounts
Field IDorder_products/applied_discounts
TypeTEXT
Data Typedimension
Order Products Base Cost Price
Order Products Base Cost Price
Field IDorder_products/base_cost_price
TypeTEXT
Data Typemetric
Order Products Base Price
Order Products Base Price
Field IDorder_products/base_price
TypeTEXT
Data Typedimension
Order Products Base Total
Order Products Base Total
Field IDorder_products/base_total
TypeTEXT
Data Typedimension
Order Products Base Wrapping Cost
Order Products Base Wrapping Cost
Field IDorder_products/base_wrapping_cost
TypeTEXT
Data Typedimension
Order Products Bin Picking Number
Order Products Bin Picking Number
Field IDorder_products/bin_picking_number
TypeTEXT
Data Typedimension
Order Products Brand
Order Products Brand
Field IDorder_products/brand
TypeTEXT
Data Typedimension
Order Products Configurable Fields
Order Products Configurable Fields
Field IDorder_products/configurable_fields
TypeTEXT
Data Typedimension
Order Products Cost Price Ex Tax
Order Products Cost Price Ex Tax
Field IDorder_products/cost_price_ex_tax
TypeTEXT
Data Typedimension
Order Products Cost Price Inc Tax
Order Products Cost Price Inc Tax
Field IDorder_products/cost_price_inc_tax
TypeTEXT
Data Typedimension
Order Products Cost Price Tax
Order Products Cost Price Tax
Field IDorder_products/cost_price_tax
TypeTEXT
Data Typedimension
Order Products Depth
Order Products Depth
Field IDorder_products/depth
TypeTEXT
Data Typedimension
Order Products Ebay Item Id
Order Products Ebay Item Id
Field IDorder_products/ebay_item_id
TypeTEXT
Data Typedimension
Order Products Ebay Transaction Id
Order Products Ebay Transaction Id
Field IDorder_products/ebay_transaction_id
TypeTEXT
Data Typedimension
Order Products Event Date
Order Products Event Date
Field IDorder_products/event_date
TypeTEXT
Data Typedimension
Order Products Event Name
Order Products Event Name
Field IDorder_products/event_name
TypeTEXT
Data Typedimension
Order Products External Id
Order Products External Id
Field IDorder_products/external_id
TypeTEXT
Data Typedimension
Order Products Fixed Shipping Cost
Order Products Fixed Shipping Cost
Field IDorder_products/fixed_shipping_cost
TypeTEXT
Data Typedimension
Order Products Fulfillment Source
Order Products Fulfillment Source
Field IDorder_products/fulfillment_source
TypeTEXT
Data Typedimension
Order Products Gift Certificate Id
Order Products Gift Certificate Id
Field IDorder_products/gift_certificate_id
TypeNUMBER
Data Typedimension
Order Products Height
Order Products Height
Field IDorder_products/height
TypeTEXT
Data Typedimension
Order Products Id
Order Products Id
Field IDorder_products/id
TypeNUMBER
Data Typedimension
Order Products Is Bundled Product
Order Products Is Bundled Product
Field IDorder_products/is_bundled_product
TypeBOOLEAN
Data Typedimension
Order Products Is Refunded
Order Products Is Refunded
Field IDorder_products/is_refunded
TypeBOOLEAN
Data Typedimension
Order Products Name
Order Products Name
Field IDorder_products/name
TypeTEXT
Data Typedimension
Order Products Name Customer
Order Products Name Customer
Field IDorder_products/name_customer
TypeTEXT
Data Typedimension
Order Products Name Merchant
Order Products Name Merchant
Field IDorder_products/name_merchant
TypeTEXT
Data Typedimension
Order Products Option Set Id
Order Products Option Set Id
Field IDorder_products/option_set_id
TypeNUMBER
Data Typedimension
Order Products Order Address Id
Order Products Order Address Id
Field IDorder_products/order_address_id
TypeNUMBER
Data Typedimension
Order Products Parent Order Product Id
Order Products Parent Order Product Id
Field IDorder_products/parent_order_product_id
TypeNUMBER
Data Typedimension
Order Products Price Ex Tax
Order Products Price Ex Tax
Field IDorder_products/price_ex_tax
TypeTEXT
Data Typedimension
Order Products Price Inc Tax
Order Products Price Inc Tax
Field IDorder_products/price_inc_tax
TypeTEXT
Data Typedimension
Order Products Price Tax
Order Products Price Tax
Field IDorder_products/price_tax
TypeTEXT
Data Typedimension
Order Products Product Id
Order Products Product Id
Field IDorder_products/product_id
TypeNUMBER
Data Typedimension
Order Products Product Options
Order Products Product Options
Field IDorder_products/product_options
TypeTEXT
Data Typedimension
Order Products Quantity
Order Products Quantity
Field IDorder_products/quantity
TypeNUMBER
Data Typedimension
Order Products Quantity Refunded
Order Products Quantity Refunded
Field IDorder_products/quantity_refunded
TypeNUMBER
Data Typedimension
Order Products Quantity Shipped
Order Products Quantity Shipped
Field IDorder_products/quantity_shipped
TypeNUMBER
Data Typedimension
Order Products Refund Amount
Order Products Refund Amount
Field IDorder_products/refund_amount
TypeTEXT
Data Typedimension
Order Products Return Id
Order Products Return Id
Field IDorder_products/return_id
TypeNUMBER
Data Typedimension
Order Products Sku
Order Products Sku
Field IDorder_products/sku
TypeTEXT
Data Typedimension
Order Products Total Ex Tax
Order Products Total Ex Tax
Field IDorder_products/total_ex_tax
TypeTEXT
Data Typedimension
Order Products Total Inc Tax
Order Products Total Inc Tax
Field IDorder_products/total_inc_tax
TypeTEXT
Data Typedimension
Order Products Total Tax
Order Products Total Tax
Field IDorder_products/total_tax
TypeTEXT
Data Typedimension
Order Products Upc
Order Products Upc
Field IDorder_products/upc
TypeTEXT
Data Typedimension
Order Products Variant Id
Order Products Variant Id
Field IDorder_products/variant_id
TypeNUMBER
Data Typedimension
Order Products Weight
Order Products Weight
Field IDorder_products/weight
TypeTEXT
Data Typedimension
Order Products Width
Order Products Width
Field IDorder_products/width
TypeTEXT
Data Typedimension
Order Products Wrapping Cost Ex Tax
Order Products Wrapping Cost Ex Tax
Field IDorder_products/wrapping_cost_ex_tax
TypeTEXT
Data Typedimension
Order Products Wrapping Cost Inc Tax
Order Products Wrapping Cost Inc Tax
Field IDorder_products/wrapping_cost_inc_tax
TypeTEXT
Data Typedimension
Order Products Wrapping Cost Tax
Order Products Wrapping Cost Tax
Field IDorder_products/wrapping_cost_tax
TypeTEXT
Data Typedimension
Order Products Wrapping Id
Order Products Wrapping Id
Field IDorder_products/wrapping_id
TypeNUMBER
Data Typedimension
Order Products Wrapping Message
Order Products Wrapping Message
Field IDorder_products/wrapping_message
TypeTEXT
Data Typedimension
Order Products Wrapping Name
Order Products Wrapping Name
Field IDorder_products/wrapping_name
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension