LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page

Was this helpful?

  1. Connectors
  2. Data Sources
  3. Ecommerce Platforms
  4. BigCommerce v2

Schema Information

Structured details and metadata about the BigCommerce connector and its corresponding tables and fields.

PreviousHow to Integrate BigCommerce Account with DatonNextRelease Notes

Last updated 1 year ago

Was this helpful?

Tables/APIs

The following is the list of tables or APIs associated with the BigCommerce v2 connector:

Banners

Fields

Field Name
Data Type

id

NUMERIC

name

STRING

content

STRING

page

STRING

item_id

STRING

location

STRING

date_created

STRING

date_type

STRING

date_from

STRING

date_to

STRING

visible

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Brands

Fields

Field Name
Data Type

id

NUMERIC

name

STRING

page_title

STRING

meta_keywords

STRING

meta_description

STRING

image_url

STRING

search_keywords

STRING

custom_url

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Catalog

Fields

Field Name
Data Type

cost_price

NUMERIC

price

NUMERIC

sale_price

NUMERIC

retail_price

NUMERIC

weight

NUMERIC

width

NUMERIC

height

NUMERIC

depth

NUMERIC

is_free_shipping

BOOLEAN

fixed_cost_shipping_price

NUMERIC

purchasing_disabled

BOOLEAN

purchasing_disabled_message

STRING

upc

STRING

inventory_level

NUMERIC

inventory_warning_level

NUMERIC

bin_picking_number

STRING

id

NUMERIC

product_id

NUMERIC

sku

STRING

sku_id

NUMERIC

option_values

RECORD

calculated_price

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

map_price

NUMERIC

calculated_weight

NUMERIC

image_url

STRING

mpn

STRING

gtin

STRING

Categories

Fields

Field Name
Data Type

id

NUMERIC

parent_id

NUMERIC

name

STRING

description

STRING

views

NUMERIC

sort_order

NUMERIC

page_title

STRING

meta_keywords

STRING

meta_description

STRING

layout_file

STRING

image_url

STRING

is_visible

BOOLEAN

search_keywords

STRING

default_product_sort

STRING

custom_url

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Coupons

Fields

Field Name
Data Type

id

NUMERIC

name

STRING

type

STRING

amount

STRING

min_purchase

STRING

expires

STRING

enabled

BOOLEAN

code

STRING

applies_to

RECORD

num_uses

NUMERIC

max_uses

NUMERIC

max_uses_per_customer

NUMERIC

restricted_to

RECORD

shipping_methods

STRING

date_created

TIMESTAMP

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Orders

Fields

Field Name
Data Type

id

NUMERIC

customer_id

NUMERIC

date_created

DATETIME

date_modified

DATETIME

date_shipped

STRING

status_id

NUMERIC

status

STRING

subtotal_ex_tax

STRING

subtotal_inc_tax

STRING

subtotal_tax

STRING

base_shipping_cost

STRING

shipping_cost_ex_tax

STRING

shipping_cost_inc_tax

STRING

shipping_cost_tax

STRING

shipping_cost_tax_class_id

NUMERIC

base_handling_cost

STRING

handling_cost_ex_tax

STRING

handling_cost_inc_tax

STRING

handling_cost_tax

STRING

handling_cost_tax_class_id

NUMERIC

base_wrapping_cost

STRING

wrapping_cost_ex_tax

STRING

wrapping_cost_inc_tax

STRING

wrapping_cost_tax

STRING

wrapping_cost_tax_class_id

NUMERIC

total_ex_tax

STRING

total_inc_tax

STRING

total_tax

STRING

items_total

NUMERIC

items_shipped

NUMERIC

payment_method

STRING

payment_status

STRING

refunded_amount

STRING

order_is_digital

BOOLEAN

store_credit_amount

STRING

gift_certificate_amount

STRING

ip_address

STRING

ip_address_v6

STRING

geoip_country

STRING

geoip_country_iso2

STRING

currency_id

NUMERIC

currency_code

STRING

currency_exchange_rate

STRING

default_currency_id

NUMERIC

default_currency_code

STRING

staff_notes

STRING

customer_message

STRING

discount_amount

STRING

coupon_discount

STRING

shipping_address_count

NUMERIC

is_deleted

BOOLEAN

ebay_order_id

STRING

billing_address

RECORD

is_email_opt_in

BOOLEAN

order_source

STRING

channel_id

NUMERIC

products

RECORD

shipping_addresses

RECORD

coupons

RECORD

tax_provider_id

STRING

customer_locale

STRING

external_order_id

STRING

store_default_currency_code

STRING

store_default_to_transactional_exchange_rate

STRING

custom_status

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Pricelists

Fields

Field Name
Data Type

id

NUMERIC

name

STRING

date_created

TIMESTAMP

date_modified

TIMESTAMP

active

BOOLEAN

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Product_images

Fields

Field Name
Data Type

id

NUMERIC

product_id

NUMERIC

is_thumbnail

BOOLEAN

sort_order

NUMERIC

description

STRING

image_file

STRING

url_zoom

STRING

url_standard

STRING

url_thumbnail

STRING

url_tiny

STRING

date_modified

TIMESTAMP

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Product_reviews

Fields

Field Name
Data Type

id

NUMERIC

email

STRING

name

STRING

rating

NUMERIC

text

STRING

title

STRING

status

STRING

date_created

TIMESTAMP

date_modified

TIMESTAMP

date_reviewed

TIMESTAMP

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Product_variants

Fields

Field Name
Data Type

id

NUMERIC

product_id

NUMERIC

sku

STRING

price

NUMERIC

calculated_price

NUMERIC

sale_price

NUMERIC

retail_price

NUMERIC

map_price

NUMERIC

weight

NUMERIC

width

NUMERIC

height

NUMERIC

depth

NUMERIC

is_free_shipping

BOOLEAN

fixed_cost_shipping_price

NUMERIC

calculated_weight

NUMERIC

purchasing_disabled

BOOLEAN

purchasing_disabled_message

STRING

image_url

STRING

cost_price

NUMERIC

upc

STRING

mpn

STRING

gtin

STRING

inventory_level

NUMERIC

inventory_warning_level

NUMERIC

bin_picking_number

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

option_values

RECORD

sku_id

NUMERIC

Products

Fields

Field Name
Data Type

calculated_price

NUMERIC

categories

STRING

brand_id

NUMERIC

option_set_id

NUMERIC

option_set_display

STRING

inventory_level

NUMERIC

inventory_warning_level

NUMERIC

inventory_tracking

STRING

reviews_rating_sum

NUMERIC

reviews_count

NUMERIC

total_sold

NUMERIC

fixed_cost_shipping_price

NUMERIC

is_free_shipping

BOOLEAN

is_visible

BOOLEAN

is_featured

BOOLEAN

related_products

STRING

warranty

STRING

bin_picking_number

STRING

layout_file

STRING

upc

STRING

mpn

STRING

gtin

STRING

search_keywords

STRING

availability

STRING

availability_description

STRING

gift_wrapping_options_type

STRING

sort_order

NUMERIC

condition

STRING

is_condition_shown

BOOLEAN

order_quantity_minimum

NUMERIC

order_quantity_maximum

NUMERIC

page_title

STRING

meta_description

STRING

date_created

TIMESTAMP

date_modified

TIMESTAMP

view_count

NUMERIC

preorder_message

STRING

is_preorder_only

BOOLEAN

is_price_hidden

BOOLEAN

price_hidden_label

STRING

custom_url

RECORD

base_variant_id

NUMERIC

open_graph_type

STRING

open_graph_title

STRING

open_graph_description

STRING

open_graph_use_meta_description

BOOLEAN

open_graph_use_product_name

BOOLEAN

open_graph_use_image

BOOLEAN

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Storecurrency

Fields

Field Name
Data Type

id

NUMERIC

is_default

BOOLEAN

last_updated

TIMESTAMP

country_iso2

STRING

currency_code

STRING

currency_exchange_rate

STRING

auto_update

BOOLEAN

token_location

STRING

token

STRING

decimal_token

STRING

thousands_token

STRING

decimal_places

NUMERIC

name

STRING

enabled

BOOLEAN

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

default_for_country_codes

STRING

is_transactional

BOOLEAN

use_default_name

BOOLEAN

Subscribers

Fields

Field Name
Data Type

email

STRING

first_name

STRING

last_name

STRING

source

STRING

order_id

NUMERIC

channel_id

NUMERIC

id

NUMERIC

date_modified

TIMESTAMP

date_created

TIMESTAMP

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

consents

STRING

Retrieves the list of drafted banners associated with the BigCommerce store. For more information on the API, see

Allows you to create, modify, and delete individual brands linked with the products in your BigCommerce store. For more information on the API, see

Helps to retrieve details such as MPN, warranty, price, and images for each product. The Catalog encompasses a store's assortment of physical and digital products. For more information on the API, see

Allows a BigCommerce store owner to create, modify, and delete categories. For more information on the API, see

Assists in retrieving data linked to a category or product discounts that can be applied to orders for consumers who input a specific code for a specific BigCommerce store. For more information on the API, see

Retrieves the data of creating, updating, and deleting orders along with order shipments and order shipping addresses for a BigCommerce store. For more information on the API, see

Retrieves the pricing list details assigned to a BigCommerce store's specific sales channel, customer group, or customer group. For more information on the API, see

Retrieves all the lists of product images associated with a BigCommerce store. For more information on the API, see

Retrieves a list of all the reviews associated with a product for a given BigCommerce store. For more information on the API, see

Retrieves arbitrary key-value attributes like variant images and their meta fields associated with a BigCommerce store product. For more information on the API, see

Retrieves the list of product variants, variant options, pricing, reviews, images, and videos for a BigCommerce store product, in addition to complex rules, custom fields, and metafields data. For more information on the API, see

Retrieves the data related to the alternate currency display options on the storefront for a BigCommerce store. For more information on the API, see .

Retrieves the data related to subscribers for a BigCommerce store. For more information on the API, see

BigCommerce v2- banners.
BigCommerce v2- brands.
BigCommerce v2- catalog.
BigCommerce v2- categories.
BigCommerce v2- coupons.
BigCommerce v2- orders.
BigCommerce v2- pricelists.
BigCommerce v2- product images.
BigCommerce v2- product reviews.
BigCommerce v2- product variants.
BigCommerce v2- products.
BigCommerce v2- storecurrency
BigCommerce v2- subscribers.
Banners
Brands
Catalog
Categories
Coupons
Orders
Pricelists
Product_images
Product_reviews
Product_variants
Products
Storecurrency
Subscribers