Integration Specifications
This article will help you learn about how Daasity replicates data from BigCommerce, limitations to the data we can extract and where the data is stored in the BigCommerce schema.
Integration Overview
BigCommerce is an e-commerce platform that empowers businesses to build, scale, and optimize online stores with a wide range of features and integrations.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
Growth
NOTE: The Store Manager user will need to install and allow Daasity App through BigCommerce Marketplace for the OAuth authentication process, or use an API Account.
To use the API Account, please contact support@daasity.com to have the connection between platforms configured.
API Endpoints
The Daasity BigCommerce extractor is built based on the BigCommerce REST API documentation. The following endpoints are used by Daasity to replicate data from BigCommerce:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity BigCommerce integration illustrating the different tables and keys to join across tables.
BigCommerce Schema
The Daasity BigCommerce extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.
Brands
Brand Meta Fields
Brand Meta Keywords
Categories
Category Meta Keywords
Category Meta Fields
Channels
Channel Meta Fields
Customer Settings Per Channel
Coupons
Coupon Shipping Methods
Customers
Customer Attributes
Customer Settings
Customer Addresses
Customer Store Credits
Customer Attribute Values
Customer Form Fields
Customer Channel Ids
Customer Segment Ids
Orders
Order Coupons
Order Messages
Order Products
Order Refunds
Order Return Items
Order Refund Payments
Order Shipments
Order Shipment Items
Order Shipping Addresses
Order Shipping Address Form Fields
Order Statuses
Order Taxes
Order Transactions
Products
Product Complex Rules
Product Meta Fields
Product Reviews
Product Variants
Product Variant Option Values
Product Bulk Pricing Rules
Product Modifiers
Product Modifiers Option Values
Sites
URLs
Banners
Endpoint: Banners
Update Method: UPSERT
Table Name: [
big_commerce.banners]
Brands
Brands
Endpoint: Brands
Update Method: UPSERT
Table Name: [
big_commerce.brands]
Brand Meta Fields
Endpoint: Brands Meta Fields
Update Method: UPSERT
Table Name: [
big_commerce.brand_meta_fields]
Brand Meta Keywords
Endpoint: Brand
Update Method: UPSERT
Table Name: [
big_commerce.brand_meta_keywords]
Categories
Categories
Endpoint: Categories
Update Method: UPSERT
Table Name: [
big_commerce.categories]
Category Meta Keywords
Endpoint: Categories
Update Method: UPSERT
Table Name: [
big_commerce.category_meta_keywords]
Category Meta Fields
Endpoint: Category Meta Fields
Update Method: UPSERT
Table Name: [
big_commerce.category_meta_fields]
Channels
Channels
Endpoint: Channels
Update Method: UPSERT
Table Name: [
big_commerce.channels]
Channel Meta Fields
Endpoint: Channel Meta Fields
Update Method: UPSERT
Table Name: [
big_commerce.channel_meta_fields]
Customer Settings Per Channel
Endpoint: Settings Per Channel
Update Method: UPSERT
Table Name: [
big_commerce.customer_settings_per_channel]
Coupons
Coupons
Endpoint: Coupons
Update Method: UPSERT
Table Name: [
big_commerce.coupons]
Coupon Shipping Methods
Endpoint: Coupons
Update Method: UPSERT
Table Name: [
big_commerce.coupon_shipping_methods]
Currencies
Endpoint: Currencies
Update Method: UPSERT
Table Name: [
big_commerce.currencies]
Customers
Customers
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customers]
Customer Attributes
Endpoint: Customer Attributes
Update Method: UPSERT
Table Name: [
big_commerce.customer_attributes]
Customer Settings
Endpoint: Customer Settings
Update Method: UPSERT
Table Name: [
big_commerce.customer_settings]
Customer Addresses
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customer_addresses]
Customer Store Credits
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customer_store_credits]
Customer Attribute Values
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customer_attribute_values]
Customer Form Fields
Endpoint:
Update Method: UPSERT
Table Name: [
big_commerce.customer_form_fields]
Customer Channel Ids
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customer_channel_ids]
Customer Segment Ids
Endpoint: Customers
Update Method: UPSERT
Table Name: [
big_commerce.customer_segment_ids]
Gift Certificates
Endpoint: Gift Certificates
Update Method: UPSERT
Table Name: [
big_commerce.gift_certificates]
Orders
Orders
Endpoint: Orders
Update Method: UPSERT
Table Name: [
big_commerce.orders]
Order Coupons
Endpoint: Order Coupons
Update Method: UPSERT
Table Name: [
big_commerce.order_coupons]
Order Messages
Endpoint: Order Messages
Update Method: UPSERT
Table Name: [
big_commerce.order_messages]
Order Products
Endpoint: Order Products
Update Method: UPSERT
Table Name: [
big_commerce.order_products]
Order Refunds
Endpoint: Refunds
Update Method: UPSERT
Table Name: [
big_commerce.order_refunds]
Order Return Items
Endpoint: Refunds
Update Method: UPSERT
Table Name: [
big_commerce.order_refund_items]
Order Refund Payments
Endpoint: Refunds
Update Method: UPSERT
Table Name: [
big_commerce.order_refund_payments]
Order Shipments
Endpoint: Order Shipments
Update Method: UPSERT
Table Name: [
big_commerce.order_shipments]
Order Shipment Items
Endpoint: Order Shipments
Update Method: UPSERT
Table Name: [
big_commerce.order_shipment_items]
Order Shipping Addresses
Endpoint: Order Shipping Address
Update Method: UPSERT
Table Name: [
big_commerce.order_shipping_addresses]
Order Shipping Address Form Fields
Endpoint: Order Shipping Address
Update Method: UPSERT
Table Name: [
big_commerce.order_shipping_address_form_fields
Order Statuses
Endpoint: Order Statuses
Update Method: UPSERT
Table Name: [
big_commerce.order_statuses]
Order Taxes
Endpoint: Order Taxes
Update Method: UPSERT
Table Name: [
big_commerce.order_taxes]
Order Transactions
Endpoint: Order Transactions
Update Method: UPSERT
Table Name: [
big_commerce.order_transactions]
Payment Methods
Endpoint: Payment Methods
Update Method: UPSERT
Table Name: [
big_commerce.payment_methods]
Price Lists
Endpoint: Price Lists
Update Method: UPSERT
Table Name: [
big_commerce.price_lists]
Products
Products
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.products]
Product Complex Rules
Endpoint: Product Complex Rules
Update Method: UPSERT
Table Name: [
big_commerce.product_complex_rules]
Product Meta Fields
Endpoint: Product Meta Fields
Update Method: UPSERT
Table Name: [
big_commerce.product_meta_fields]
Product Reviews
Endpoint: Product Reviews
Update Method: UPSERT
Table Name: [
big_commerce.product_reviews]
Product Variants
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.product_variants]
Product Variant Option Values
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.product_variant_option_values]
Product Bulk Pricing Rules
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.product_bulk_pricing_rules]
Product Modifiers
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.product_modifiers]
Product Modifiers Option Values
Endpoint: Products
Update Method: UPSERT
Table Name: [
big_commerce.product_modifiers_option_values]
Sites
Sites
Endpoint: Sites
Update Method: UPSERT
Table Name: [
big_commerce.sites]
URLs
Endpoint: Sites
Update Method: UPSERT
Table Name: [
big_commerce.site_urls]
Store Information
Endpoint: Site Information
Update Method: UPSERT
Table Name: [
big_commerce.store_information]
Subscribers
Endpoint: Subscribers
Update Method: UPSERT
Table Name: [
big_commerce.subscribers]
Tax Classes
Endpoint: Tax Classes
Update Method: UPSERT
Table Name: [
big_commerce.tax_classes]
Tax Properties
Endpoint: Tax Properties
Update Method: UPSERT
Table Name: [
big_commerce.tax_properties]
Last updated