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.
Key Topics
Click on the links below to take you to the section where you can learn more about this Integration
- Integration Availability
- API Endpoints
- Entity Relationship Diagram (ERD)
- BigCommerce Schema
- Release Updates
Integration Availability
This integration is available for:
- Pro
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 build based on the BigCommerce REST API documentation (https://developer.bigcommerce.com/docs/rest).
Daasity is currently using the V2 and V3 set of BigCommerce REST endpoints.
The following endpoints are used by Daasity to replicate data from BigCommerce:
- Banners
- Brands
- Brands
- Brand Meta Fields
- Brand Meta Keywords
- Categories
- Categories
- Category Meta Keywords
- Category Meta Fields
- Channels
- Channels
- Channel Meta Fields
- Customer Settings Per Channels
- Coupons
- Coupons
- Coupon Shipping Methods
- Currencies
- Customers
- Customers
- Customer Attributes
- Customer Settings
- Customer Addresses
- Customer Store Credits
- Customer Attribute Values
- Customer Form Fields
- Customer Channel Ids
- Customer Segment Ids
- Gift Certificates
- Orders
- Orders
- Order Coupons
- Order Messages
- Order Products
- Order Refunds
- Order Refund Items
- Order Refund Payments
- Order Shipments
- Order Shipment Items
- Order Shipping Addresses
- Order Shipping Address Form Fields
- Order Statuses
- Order Taxes
- Order Transactions
- Payment Methods
- Price Lists
- Products
- Products
- Product Complex Rules
- Product Meta Fields
- Product Reviews
- Product Variants
- Product Variants Option Values
- Product Bulk Pricing Rules
- Product Modifiers
- Product Modifiers Option Values
- Sites
- Sites
- URLs
- Store Information
- Subscribers
- Tax Classes
- Tax Properties
Entity Relationship Diagram (ERD)
The embedded diagram houses the ERD for the Daasity BigCommerce extractor illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.
BigCommerce Schema
- Banners
Endpoint: https://developer.bigcommerce.com/api-reference/574c01ed636eb-get-all-banners
Update Method: Upsert
Table name: big_commerce.banners
JSON Element |
Database Column |
id |
id |
name |
name |
content |
content |
page |
page |
item_id |
item_id |
location |
location |
date_created |
date_created |
date_type |
date_type |
date_from |
date_from |
date_to |
date_to |
visible |
(visible == 1) = true : false |
- Brands
Endpoint: https://developer.bigcommerce.com/api-reference/c2610608c20c8-get-all-brands
Update Method: Upsert
Table name: big_commerce.brands
JSON Element |
Database Column |
id |
id |
name |
name |
page_title |
page_title |
meta_description |
meta_description |
image_url |
image_url |
search_keywords |
search_keywords |
custom_url :: url |
custom_url |
custom_url :: is_customized |
custom_url_is_customized |
- Brand Meta Fields
Endpoint: https://developer.bigcommerce.com/api-reference/46f4d19da7931-get-all-brand-
meta_fields
Update Method: Upsert
Table name: big_commerce.brand_meta_fields
JSON Element |
Database Column |
id |
id |
brand_id (path param) |
brand_id |
key |
key |
value |
value |
namespace |
namespace |
permission_set |
permission_set |
resource_type |
resource_type |
resource_id |
resource_id |
description |
description |
date_created |
date_created |
date_modified |
date_modified |
- Brand Meta Keywords
Endpoint: https://developer.bigcommerce.com/api-reference/c2610608c20c8-get-all-brands
Update Method: Upsert
Table name: big_commerce.brand_meta_keywords
JSON Element |
Database Column |
brand_id (path param) |
brand_id |
keyword |
keyword |
- Categories
Endpoint: https://developer.bigcommerce.com/api-reference/9cc3a53863922-get-all-categories
Update Method: Upsert
Table name: big_commerce.categories
JSON Element |
Database Column |
id |
id |
parent_id |
parent_id |
name |
name |
description |
description |
views |
views |
sort_order |
sort_order |
page_title |
page_title |
meta_description |
meta_description |
layout_file |
layout_file |
image_url |
image_url |
is_visible |
is_visible |
search_keywords |
search_keywords |
default_product_sort |
default_product_sort |
custom_url :: url |
custom_url |
custom_url :: is_customized |
custom_url_is_customized |
- Category Meta Keywords
Endpoint: https://developer.bigcommerce.com/api-reference/9cc3a53863922-get-all-categories
Update Method: Upsert
Table name: big_commerce.category_meta_keywords
JSON Element |
Database Column |
category_id (path param) |
category_id |
keyword |
keyword |
- Category Meta Fields
Endpoint: https://developer.bigcommerce.com/api-reference/a9396e154d15e-get-all-
category-metafields
Update Method: Upsert
Table name: big_commerce.category_meta_fields
JSON Element |
Database Column |
id |
id |
category_id (path param) |
category_id |
key |
key |
value |
value |
namespace |
namespace |
permission_set |
permission_set |
resource_type |
resource_type |
resource_id |
resource_id |
description |
description |
date_created |
date_created |
date_modified |
date_modified |
- Channels
Endpoint: https://developer.bigcommerce.com/api-reference/d2298071793d6-get-all-channels
Update Method: Upsert
Table name: big_commerce.channels
JSON Element |
Database Column |
id |
id |
external_id |
external_id |
is_listable_from_ui |
is_listable_from_ui |
is_visible |
is_visible |
status |
status |
name |
name |
type |
type |
platform |
platform |
date_created |
date_created |
date_modified |
date_modified |
icon_url |
icon_url |
- Channel Meta Fields
Endpoint: https://developer.bigcommerce.com/api-reference/e3c521fcecaea-get-channel-metafields
Update Method: Upsert
Table name: big_commerce.channel_meta_fields
JSON Element |
Database Column |
id |
id |
channel_id (path param) |
channel_id |
permission_set |
permission_set |
namespace |
namespace |
key |
key |
value |
value |
description |
description |
resource_type |
resource_type |
resource_id |
resource_id |
date_created |
date_created |
date_modified |
date_modified |
- Customer Settings Per Channels
Endpoint: https://developer.bigcommerce.com/api-reference/d5e66c45b0415-get-customer-settings-per-channel
Update Method: Upsert
Table name: big_commerce.customer_settings_per_channel
JSON Element |
Database Column |
privacy_settings :: ask_shopper_for_tracking_consent |
privacy_settings_ask_shopper_for_tracking_consent |
privacy_settings :: ask_shopper_for_tracking_consent_on_checkout |
privacy_settings_ask_shopper_for_tracking_consent_on_checkout |
privacy_settings :: policy_url |
privacy_settings_policy_url |
customer_group_settings :: guest_customer_group_id |
customer_group_settings_guest_customer_group_id |
customer_group_settings :: default_customer_group_id |
customer_group_settings_default_customer_group_id |
allow_global_logins |
allow_global_logins |
- Coupons
Endpoint: https://developer.bigcommerce.com/api-reference/d03532e4ad994-get-all-coupons
Update Method: Upsert
Table name: big_commerce.coupons
JSON Element |
Database Column |
id |
id |
name |
name |
type |
type |
amount |
amount |
min_purchase |
min_purchase |
expires |
expires |
enabled |
enabled |
code |
code |
applies_to :: entity |
applies_to_entity |
applies_to :: ids (joins values using ‘,’ as separator) |
applies_to_ids |
num_uses |
num_uses |
max_uses |
max_uses |
max_uses_per_customer |
max_uses_per_customer |
date_created |
date_created |
- Coupon Shipping Methods
Endpoint: https://developer.bigcommerce.com/api-reference/d03532e4ad994-get-all-coupons
Update Method: Upsert
Table name: big_commerce.coupon_shipping_methods
JSON Element |
Database Column |
coupon_id (from the parent record) |
coupon_id |
shipping_method (from the list of values) |
shipping_method |
- Currencies
Endpoint: https://developer.bigcommerce.com/api-reference/2dc5722e06f7d-get-all-currencies
Update Method: Upsert
Table name: big_commerce.currencies
JSON Element |
Database Column |
id |
id |
is_default |
is_default |
last_updated |
last_updated |
country_iso2 |
country_iso2 |
currency_code |
currency_code |
currency_exchange_rate |
currency_exchange_rate |
name |
name |
token |
token |
auto_update |
auto_update |
token_location |
token_location |
decimal_token |
decimal_token |
thousands_token |
thousands_token |
decimal_places |
decimal_places |
enabled |
enabled |
is_transactional |
is_transactional |
use_default_name |
use_default_name |
- Customers
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customers
JSON Element |
Database Column |
id |
id |
authentication :: force_password_reset |
authentication_force_password_reset |
company |
company |
customer_group_id |
customer_group_id |
|
|
first_name |
first_name |
last_name |
last_name |
notes |
notes |
phone |
phone |
registration_ip_address |
registration_ip_address |
tax_exempt_category |
tax_exempt_category |
date_created |
date_created |
date_modified |
date_modified |
accepts_product_review_abandoned_cart_emails |
accepts_product_review_abondoned_cart_emails |
origin_channel_id |
origin_channel_id |
shopper_profile_id |
shopper_profile_id |
- Customer Attributes
Endpoint: https://developer.bigcommerce.com/api-reference/5092ca66caaee-get-all-customer-attributes
Update Method: Upsert
Table name: big_commerce.customer_attributes
JSON Element |
Database Column |
id |
id |
name |
name |
type |
type |
date_created |
date_created |
date_modified |
date_modified |
- Customer Settings
Endpoint: https://developer.bigcommerce.com/api-reference/0c31a6d25e5ea-get-customer-settings
Update Method: Upsert
Table name: big_commerce.customer_settings
JSON Element |
Database Column |
privacy_settings :: ask_shopper_for_tracking_consent |
privacy_settings_ask_shopper_for_tracking_consent |
privacy_settings :: ask_shopper_for_tracking_consent_on_checkout |
privacy_settings_ask_shopper_for_tracking_consent_on_checkout |
privacy_settings :: policy_url |
privacy_settings_policy_url |
customer_group_settings :: guest_customer_group_id |
customer_group_settings_guest_customer_group_id |
customer_group_settings :: default_customer_group_id |
customer_group_settings_default_customer_group_id |
- Customer Addresses
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_addresses
JSON Element |
Database Column |
id |
id |
address1 |
address1 |
address2 |
address2 |
address_type |
address_type |
city |
city |
company |
company |
country |
country |
country_code |
country_code |
customer_id |
customer_id |
first_name |
first_name |
last_name |
last_name |
phone |
phone |
postal_code |
postal_code |
state_or_province |
state_or_province |
- Customer Store Credits
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_store_credits
JSON Element |
Database Column |
customer_id (from the parent record) |
customer_id |
amount |
amount |
- Customer Attribute Values
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_attribute_values
JSON Element |
Database Column |
id |
id |
customer_id |
customer_id |
attribute_id |
attribute_id |
attribute_value |
attribute_value |
date_created |
date_created |
date_modified |
date_modified |
- Customer Form Fields
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_form_fields
JSON Element |
Database Column |
customer_id (from the parent record) |
customer_id |
name |
name |
value |
value |
- Customer Channel Ids
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_channel_ids
JSON Element |
Database Column |
customer_id (from the parent record) |
customer_id |
channel_id (from the list of values) |
channel_id |
- Customer Segment Ids
Endpoint: https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers
Update Method: Upsert
Table name: big_commerce.customer_segment_ids
JSON Element |
Database Column |
customer_id (from the parent record) |
customer_id |
segment_id (from the list of values) |
segment_id |
- Gift Certificates
Endpoint: https://developer.bigcommerce.com/api-reference/cee3b9dae1d79-get-all-gift-certi cates
Update Method: Upsert
Table name: big_commerce.gift_certificates
JSON Element |
Database Column |
id |
id |
code |
code |
amount |
amount |
status |
status |
balance |
balance |
to_name |
to_name |
order_id |
order_id |
template |
template |
to_email |
to_email |
from_name |
from_name |
from_email |
from_email |
customer_id |
customer_id |
expiry_date |
expiry_date |
purchase_date |
purchase_date |
- Orders
Endpoint: https://developer.bigcommerce.com/api-reference/82f91b58d0c98-get-all-orders
Update Method: Upsert
Table name: big_commerce.orders
JSON Element |
Database Column |
id |
id |
customer_id |
customer_id |
date_created |
date_created |
date_modified |
date_modified |
date_shipped |
date_shipped |
status_id |
status_id |
status |
status |
subtotal_ex_tax |
subtotal_ex_tax |
subtotal_inc_tax |
subtotal_inc_tax |
subtotal_tax |
subtotal_tax |
base_shipping_cost |
base_shipping_cost |
shipping_cost_ex_tax |
shipping_cost_ex_tax |
shipping_cost_inc_tax |
shipping_cost_inc_tax |
shipping_cost_tax |
shipping_cost_tax |
shipping_cost_tax_class_id |
shipping_cost_tax_class_id |
base_handling_cost |
base_handling_cost |
handling_cost_ex_tax |
handling_cost_ex_tax |
handling_cost_inc_tax |
handling_cost_inc_tax |
handling_cost_tax |
handling_cost_tax |
handling_cost_tax_class_id |
handling_cost_tax_class_id |
base_wrapping_cost |
base_wrapping_cost |
wrapping_cost_ex_tax |
wrapping_cost_ex_tax |
wrapping_cost_inc_tax |
wrapping_cost_inc_tax |
wrapping_cost_tax |
wrapping_cost_tax |
wrapping_cost_tax_class_id |
wrapping_cost_tax_class_id |
total_ex_tax |
total_ex_tax |
total_inc_tax |
total_inc_tax |
total_tax |
total_tax |
items_total |
items_total |
items_shipped |
items_shipped |
payment_method |
payment_method |
payment_provider_id |
payment_provider_id |
payment_status |
payment_status |
refunded_amount |
refunded_amount |
order_is_digital |
order_is_digital |
store_credit_amount |
store_credit_amount |
gift_certificate_amount |
gift_certificate_amount |
ip_address |
ip_address |
ip_address_v6 |
ip_address_v6 |
geoip_country |
geoip_country |
geoip_country_iso2 |
geoip_country_iso2 |
currency_id |
currency_id |
currency_code |
currency_code |
currency_exchange_rate |
currency_exchange_rate |
default_currency_id |
default_currency_id |
default_currency_code |
default_currency_code |
staff_notes |
staff_notes |
customer_message |
customer_message |
discount_amount |
discount_amount |
coupon_discount |
coupon_discount |
shipping_address_count |
shipping_address_count |
is_deleted |
is_deleted |
ebay_order_id |
ebay_order_id |
cart_id |
cart_id |
is_email_opt_in |
is_email_opt_in |
credit_card_type |
credit_card_type |
order_source |
order_source |
channel_id |
channel_id |
external_source |
external_source |
external_id |
external_id |
external_merchant_id |
external_merchant_id |
tax_provider_id |
tax_provider_id |
customer_locale |
customer_locale |
external_order_id |
external_order_id |
store_default_currency_code |
store_default_currency_code |
store_default_to_transactional_exchange_rate |
store_default_to_transactional_exchange_rate |
custom_status |
custom_status |
billing_address :: first_name |
billing_address_first_name |
billing_address :: last_name |
billing_address_last_name |
billing_address :: company |
billing_address_company |
billing_address :: street_1 |
billing_address_street_1 |
billing_address :: street_2 |
billing_address_street_2 |
billing_address :: city |
billing_address_city |
billing_address :: state |
billing_address_state |
billing_address :: zip |
billing_address_zip |
billing_address :: country |
billing_address_country |
billing_address :: country_iso2 |
billing_address_country_iso2 |
billing_address :: phone |
billing_address_phone |
billing_address :: email |
billing_address_email |
products :: url |
product_url |
products :: resource |
product_resource |
shipping_addresses :: url |
shipping_addresses_url |
shipping_addresses :: resource |
shipping_addresses_resource |
coupons :: url |
coupons_url |
coupons :: resource |
coupons_resource |
- Order Coupons
Endpoint: https://developer.bigcommerce.com/api-reference/da43a76da17f3-list-order-coupons
Update Method: Upsert
Table name: big_commerce.order_coupons
JSON Element |
Database Column |
order_id |
order_id |
id |
id |
coupon_id |
coupon_id |
code |
code |
amount |
amount |
type |
type |
discount |
discount |
- Order Messages
Endpoint: https://developer.bigcommerce.com/api-reference/e95114e312eb1-get-order-messages
Update Method: Upsert
Table name: big_commerce.order_messages
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
staff_id |
staff_id |
customer_id |
customer_id |
type |
type |
subject |
subject |
message |
message |
status |
status |
is_flagged |
is_flagged |
date_created |
date_created |
- Order Products
Endpoint: https://developer.bigcommerce.com/api-reference/3b4dfef625708-list-order-products
Update Method: Upsert
Table name: big_commerce.order_products
JSON Element |
Database Column |
order_id |
order_id |
id |
id |
product_id |
product_id |
variant_id |
variant_id |
order_address_id |
order_address_id |
name |
name |
name_customer |
name_customer |
name_merchant |
name_merchant |
sku |
sku |
upc |
upc |
type |
type |
base_price |
base_price |
price_ex_tax |
price_ex_tax |
price_inc_tax |
price_inc_tax |
price_tax |
price_tax |
base_total |
base_total |
total_ex_tax |
total_ex_tax |
total_inc_tax |
total_inc_tax |
total_tax |
total_tax |
weight |
weight |
width |
width |
height |
height |
depth |
depth |
quantity |
quantity |
base_cost_price |
base_cost_price |
cost_price_inc_tax |
cost_price_inc_tax |
cost_price_ex_tax |
cost_price_ex_tax |
cost_price_tax |
cost_price_tax |
is_refunded |
is_refunded |
quantity_refunded |
quantity_refunded |
refund_amount |
refund_amount |
return_id |
return_id |
wrapping_id |
wrapping_id |
wrapping_name |
wrapping_name |
base_wrapping_cost |
base_wrapping_cost |
wrapping_cost_ex_tax |
wrapping_cost_ex_tax |
wrapping_cost_inc_tax |
wrapping_cost_inc_tax |
wrapping_cost_tax |
wrapping_cost_tax |
wrapping_message |
wrapping_cost_tax |
quantity_shipped |
quantity_shipped |
event_name |
event_name |
event_date |
event_date |
fixed_shipping_cost |
fixed_shipping_cost |
ebay_item_id |
ebay_item_id |
ebay_transaction_id |
ebay_transaction_id |
option_set_id |
option_set_id |
parent_order_product_id |
parent_order_product_id |
is_bundled_product |
is_bundled_product |
bin_picking_number |
bin_picking_number |
external_id |
external_id |
fulfillment_source |
fulfillment_source |
brand |
brand |
gift_certificate_id |
gift_certificate_id |
- Order Refunds
Endpoint: https://developer.bigcommerce.com/api-reference/961867b3105c1-get-all-refunds
Update Method: Upsert
Table name: big_commerce.order_refunds
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
user_id |
user_id |
created |
created |
reason |
reason |
total_amount |
total_amount |
total_tax |
total_tax |
uses_merchant_override_values |
uses_merchant_override_values |
- Order Refund Items
Endpoint: https://developer.bigcommerce.com/api-reference/961867b3105c1-get-all-refunds
Update Method: Upsert
Table name: big_commerce.order_refund_items
JSON Element |
Database Column |
item_type |
item_type |
item_id |
item_id |
quantity |
quantity |
requested_amount |
requested_amount |
reason |
reason |
order_id (from the parent record) |
order_id |
refund_id (from the parent record) |
refund_id |
- Order Refund Payments
Endpoint: https://developer.bigcommerce.com/api-reference/961867b3105c1-get-all-refunds
Update Method: Upsert
Table name: big_commerce.order_refund_payments
JSON Element |
Database Column |
id |
id |
provider_id |
provider_id |
amount |
amount |
offline |
offline |
is_declined |
is_declined |
declined_message |
declined_message |
order_id (from the parent record) |
order_id |
refund_id (from the parent record) |
refund_id |
- Order Shipments
Endpoint: https://developer.bigcommerce.com/api-reference/ff860667cfc4e-get-order-shipments
Update Method: Upsert
Table name: big_commerce.order_shipments
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
customer_id |
customer_id |
order_address_id |
order_address_id |
date_created |
date_created |
tracking_number |
tracking_number |
merchant_shipping_cost |
merchant_shipping_cost |
shipping_method |
shipping_method |
comments |
comments |
shipping_provider |
shipping_provider |
tracking_carrier |
tracking_carrier |
tracking_link |
tracking_link |
billing_address :: first_name |
billing_address_first_name |
billing_address :: last_name |
billing_address_last_name |
billing_address :: company |
billing_address_company |
billing_address :: street_1 |
billing_address_street_1 |
billing_address :: street_2 |
billing_address_street_2 |
billing_address :: city |
billing_address_city |
billing_address :: state |
billing_address_state |
billing_address :: zip |
billing_address_zip |
billing_address :: country |
billing_address_country |
billing_address :: country_iso2 |
billing_address_country_iso2 |
billing_address :: phone |
billing_address_phone |
billing_address :: email |
billing_address_email |
shipping_address :: first_name |
shipping_address_first_name |
shipping_address :: last_name |
shipping_address_last_name |
shipping_address :: company |
shipping_address_company |
shipping_address :: street_1 |
shipping_address_street_1 |
shipping_address :: street_2 |
shipping_address_street_2 |
shipping_address :: city |
shipping_address_city |
shipping_address :: zip |
shipping_address_zip |
shipping_address :: country |
shipping_address_country |
shipping_address :: country_iso2 |
shipping_address_country_iso2 |
shipping_address :: phone |
shipping_address_phone |
shipping_address :: email |
shipping_address_email |
- Order Shipment Items
Endpoint: https://developer.bigcommerce.com/api-reference/ff860667cfc4e-get-order-shipments
Update Method: Upsert
Table name: big_commerce.order_shipment_items
JSON Element |
Database Column |
order_product_id |
order_product_id |
product_id |
product_id |
quantity |
quantity |
shipment_id (from the parent record) |
shipment_id |
- Order Shipping Addresses
Endpoint: https://developer.bigcommerce.com/api-reference/88829242e6459-get-a-shipping-address
Update Method: Upsert
Table name: big_commerce.order_shipping_addresses
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
first_name |
first_name |
last_name |
last_name |
company |
company |
street_1 |
street_1 |
street_2 |
street_2 |
city |
city |
zip |
zip |
country |
country |
country_iso2 |
country_iso2 |
state |
state |
|
|
phone |
phone |
items_total |
items_total |
items_shipped |
items_shipped |
shipping_method |
shipping_method |
base_cost |
base_cost |
cost_ex_tax |
cost_ex_tax |
cost_inc_tax |
cost_inc_tax |
cost_tax |
cost_tax |
cost_tax_class_id |
cost_tax_class_id |
base_handling_cost |
base_handling_cost |
handling_cost_ex_tax |
handling_cost_ex_tax |
handling_cost_inc_tax |
handling_cost_inc_tax |
handling_cost_tax |
handling_cost_tax |
handling_cost_tax_class_id |
handling_cost_tax_class_id |
shipping_zone_id |
shipping_zone_id |
shipping_zone_name |
shipping_zone_name |
shipping_quotes :: url |
shipping_quotes_url |
shipping_quotes :: resource |
shipping_quotes_resource |
- Order Shipping Address Form Fields
Endpoint: https://developer.bigcommerce.com/api-reference/88829242e6459-get-a-shipping-address
Update Method: Upsert
Table name: big_commerce.order_shipping_address_form_fields
JSON Element |
Database Column |
order_shipping_address_id (from the parent record) |
order_shipping_address_id |
name |
name |
value |
value |
- Order Statuses
Endpoint: https://developer.bigcommerce.com/api-reference/d24b6b0f03eb7-get-all-order-statuses
Update Method: Upsert
Table name: big_commerce.order_statuses
JSON Element |
Database Column |
id |
id |
name |
name |
system_label |
system_label |
custom_label |
custom_label |
system_description |
system_description |
order_value |
order_value |
- Order Taxes
Endpoint: https://developer.bigcommerce.com/api-reference/5ba0733461006-get-all-order-taxes
Update Method: Upsert
Table name: big_commerce.order_taxes
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
order_address_id |
order_address_id |
tax_rate_id |
tax_rate_id |
sales_tax_id |
sales_tax_id |
tax_class_id |
tax_class_id |
name |
name |
class |
class |
rate |
rate |
priority |
priority |
priority_amount |
priority_amount |
line_amount |
line_amount |
- Order Transactions
Endpoint: https://developer.bigcommerce.com/api-reference/4f98780edf0b9-get-transactions
Update Method: Upsert
Table name: big_commerce.order_transactions
JSON Element |
Database Column |
id |
id |
order_id |
order_id |
event |
event |
method |
method |
amount |
amount |
currency |
currency |
gateway |
gateway |
gateway_transaction_id |
gateway_transaction_id |
payment_method_id |
payment_method_id |
status |
status |
test |
test |
fraud_review |
fraud_review |
reference_transaction_id |
reference_transaction_id |
date_created |
date_created |
avs_result |
avs_result |
cvv_result |
cvv_result |
credit_card |
credit_card |
gift_certificate |
gift_certificate |
store_credit |
store_credit |
offline |
offline |
custom |
custom |
payment_instrument_token |
payment_instrument_token |
custom_provider_field_result |
custom_provider_field_result |
- Payment Methods
Endpoint: https://developer.bigcommerce.com/api-reference/a6936b9439d0a-get-all-payment-methods
Update Method: Upsert
Table name: big_commerce.payment_methods
JSON Element |
Database Column |
code |
code |
name |
name |
test_mode |
test_mode |
- Price Lists
Endpoint: https://developer.bigcommerce.com/api-reference/5e517c58b6fb9-get-all-price-lists
Update Method: Upsert
Table name: big_commerce.price_lists
JSON Element |
Database Column |
id |
id |
name |
name |
date_modified |
date_modified |
date_created |
date_created |
active |
active |
- Products
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.products
JSON Element |
Database Column |
id |
id |
name |
name |
type |
type |
description |
description |
weight |
weight |
width |
width |
depth |
depth |
height |
height |
price |
price |
cost_price |
cost_price |
retail_price |
retail_price |
sale_price |
sale_price |
map_price |
map_price |
tax_class_id |
tax_class_id |
product_tax_code |
product_tax_code |
calculated_price |
calculated_price |
brand_id |
brand_id |
option_set_id |
option_set_id |
option_set_display |
option_set_display |
inventory_level |
inventory_level |
inventory_warning_level |
inventory_warning_level |
inventory_tracking |
inventory_tracking |
reviews_rating_sum |
reviews_rating_sum |
reviews_count |
reviews_count |
total_sold |
total_sold |
fixed_cost_shipping_price |
fixed_cost_shipping_price |
is_free_shipping |
is_free_shipping |
is_visible |
is_visible |
is_featured |
is_featured |
warranty |
warranty |
bin_picking_number |
bin_picking_number |
layout_file |
layout_file |
upc |
upc |
mpn |
mpn |
gtin |
gtin |
search_keywords |
search_keywords |
availability |
availability |
availability_description |
availability_description |
gift_wrapping_options_type |
gift_wrapping_options_type |
sort_order |
sort_order |
condition |
condition |
is_condition_shown |
is_condition_shown |
order_quantity_minimum |
order_quantity_minimum |
order_quantity_maximum |
order_quantity_maximum |
page_title |
page_title |
meta_description |
meta_description |
date_created |
date_created |
date_modified |
date_modified |
view_count |
view_count |
preorder_release_date |
preorder_release_date |
preorder_message |
preorder_message |
is_preorder_only |
is_preorder_only |
is_price_hidden |
is_price_hidden |
price_hidden_label |
price_hidden_label |
base_variant_id |
base_variant_id |
open_graph_type |
open_graph_type |
open_graph_title |
open_graph_title |
open_graph_description |
open_graph_description |
open_graph_use_meta_description |
open_graph_use_meta_description |
open_graph_use_product_name |
open_graph_use_product_name |
open_graph_use_image |
open_graph_use_image |
custom_url :: url |
custom_url |
custom_url :: is_customized |
custom_url_is_customized |
- Product Complex Rules
Endpoint: https://developer.bigcommerce.com/api-reference/51d3d92129c20-get-complex-rules
Update Method: Upsert
Table name: big_commerce.product_complex_rules
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
sort_order |
sort_order |
enabled |
enabled |
stop |
stop |
price_adjuster |
price_adjuster |
price_adjuster_value |
price_adjuster_value |
weight_adjuster |
weight_adjuster |
weight_adjuster_value |
weight_adjuster_value |
purchasing_disabled |
purchasing_disabled |
purchasing_disabled_message |
purchasing_disabled_message |
purchasing_hidden |
purchasing_hidden |
image_url |
image_url |
- Product Meta Fields
Endpoint: https://developer.bigcommerce.com/api-reference/bb4459a9412f6-get-all-product-metafields
Update Method: Upsert
Table name: big_commerce.product_meta_fields
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
key |
key |
value |
value |
namespace |
namespace |
permission_set |
permission_set |
resource_type |
resource_type |
resource_id |
resource_id |
description |
description |
date_created |
date_created |
date_modified |
date_modified |
- Product Reviews
Endpoint: https://developer.bigcommerce.com/api-reference/a77ee99acb04b-get-product-reviews
Update Method: Upsert
Table name: big_commerce.product_reviews
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
rating |
rating |
title |
title |
text |
text |
status |
status |
|
|
name |
name |
date_reviewed |
date_reviewed |
date_created |
date_created |
date_modified |
date_modified |
- Product Variants
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.product_variants
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
sku |
sku |
sku_id |
sku_id |
price |
price |
calculated_price |
calculated_price |
sale_price |
sale_price |
retail_price |
retail_price |
map_price |
map_price |
weight |
weight |
calculated_weight |
calculated_weight |
width |
width |
height |
height |
depth |
depth |
is_free_shipping |
is_free_shipping |
fixed_cost_shipping_price |
fixed_cost_shipping_price |
purchasing_disabled |
purchasing_disabled |
purchasing_disabled_message |
purchasing_disabled_message |
image_url |
image_url |
cost_price |
cost_price |
upc |
upc |
mpn |
mpn |
gtin |
gtin |
inventory_level |
inventory_level |
inventory_warning_level |
inventory_warning_level |
bin_picking_number |
bin_picking_number |
- Product Variants Option Values
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.product_variant_option_values
JSON Element |
Database Column |
id |
id |
variant_id |
variant_id |
product_id |
product_id |
label |
label |
option_id |
option_id |
option_display_name |
option_display_name |
- Product Bulk Pricing Rules
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.product_bulk_pricing_rules
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
quantity_min |
quantity_min |
quantity_max |
quantity_max |
type |
type |
amount |
amount |
- Product Modifiers
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.product_modifiers
JSON Element |
Database Column |
id |
id |
product_id |
product_id |
display_name |
display_name |
name |
name |
type |
type |
required |
required |
sort_order |
sort_order |
config :: default_value |
config_default_value |
config :: checked_by_default |
config_checked_by_default |
config :: checkbox_label |
config_checkbox_label |
config :: date_limited |
config_date_limited |
config :: date_limit_mode |
config_date_limit_mode |
config :: date_earliest_value |
config_date_earliest_value |
config :: date_latest_value |
config_date_latest_value |
config :: file_types_mode |
config_file_types_mode |
config :: file_types_supported (from the list of values) |
config_file_types_supported |
config :: file_types_other |
config_file_types_other |
config :: file_max_size |
config_file_max_size |
config :: text_characters_limited |
config_text_characters_limited |
config :: text_min_length |
config_text_min_length |
config :: text_max_length |
config_text_max_length |
config :: text_lines_limited |
config_text_lines_limited |
config :: text_max_lines |
config_text_max_lines |
config :: number_limited |
config_number_limited |
config :: number_limit_mode |
config_number_limit_mode |
config :: number_lowest_value |
config_number_lowest_value |
config :: number_highest_value |
config_number_highest_value |
config :: number_integers_only |
config_number_integers_only |
config :: product_list_adjusts_inventory |
config_product_list_adjusts_inventory |
config :: product_list_adjusts_pricing |
config_product_list_adjusts_pricing |
config :: product_list_shipping_calc |
config_product_list_shipping_calc |
- Product Modifiers Option Values
Endpoint: https://developer.bigcommerce.com/api-reference/4101d472a814d-get-all-products
Update Method: Upsert
Table name: big_commerce.product_modifiers_option_values
JSON Element |
Database Column |
id |
id |
modifier_id |
modifier_id |
product_id |
product_id |
option_id |
option_id |
is_default |
is_default |
label |
label |
sort_order |
sort_order |
adjusters :: price :: adjuster |
adjusters_price_adjuster |
adjusters :: price :: adjuster_value |
adjusters_price_adjuster_value |
adjusters :: weight :: adjuster |
adjusters_weight_adjuster |
adjusters :: weight :: adjuster_value |
adjusters_weight_adjuster_value |
adjusters :: image_url |
adjusters_image_url |
adjusters :: purchasing_disabled :: status |
adjusters_purchasing_disabled_status |
adjusters :: purchasing_disabled :: message |
adjusters_purchasing_disabled_message |
- Sites
Endpoint: https://developer.bigcommerce.com/api-reference/4981c78979bd3-get-sites
Update Method: Upsert
Table name: big_commerce.sites
JSON Element |
Database Column |
id |
id |
url |
url |
channel_id |
channel_id |
created_at |
created_at |
updated_at |
updated_at |
is_checkout_url_customized |
is_checkout_url_customized |
- URLs
Endpoint: https://developer.bigcommerce.com/api-reference/4981c78979bd3-get-sites
Update Method: Upsert
Table name: big_commerce.site_urls
JSON Element |
Database Column |
site_id (from parent record) |
site_id |
url |
url |
type |
type |
created_at |
created_at |
updated_at |
updated_at |
- Store Information
Endpoint: https://developer.bigcommerce.com/api-reference/bb1daaaeccae0-get-store-information
Update Method: Upsert
Table name: big_commerce.store_information
JSON Element |
Database Column |
id |
id |
account_uuid |
account_uuid |
domain |
domain |
secure_url |
secure_url |
control_panel_base_url |
control_panel_base_url |
status |
status |
name |
name |
first_name |
first_name |
last_name |
last_name |
address |
address |
country |
country |
country_code |
country_code |
phone |
phone |
admin_email |
admin_email |
order_email |
order_email |
favicon_url |
favicon_url |
timezone :: name |
timezone_name |
timezone :: raw_offset |
timezone_raw_offset |
timezone :: dst_offset |
timezone_dst_offset |
timezone :: dst_correction |
timezone_dst_correction |
timezone :: date_format :: display |
timezone_date_format_display |
timezone :: date_format :: export |
timezone_date_format_export |
timezone :: date_format :: extended_display |
timezone_date_format_extended_display |
language |
language |
currency |
currency |
currency_symbol |
currency_symbol |
decimal_separator |
decimal_separator |
thousands_separator |
thousands_separator |
decimal_places |
decimal_places |
currency_symbol_location |
currency_symbol_location |
weight_units |
weight_units |
dimension_units |
dimension_units |
dimension_decimal_places |
dimension_decimal_places |
dimension_decimal_token |
dimension_decimal_token |
dimension_thousands_token |
dimension_thousands_token |
plan_name |
plan_name |
plan_level |
plan_level |
plan_is_trial |
plan_is_trial |
industry |
industry |
logo :: url |
logo_url |
is_price_entered_with_tax |
is_price_entered_with_tax |
store_id |
store_id |
default_site_id |
default_site_id |
default_channel_id |
default_channel_id |
features :: stencil_enabled |
features_stencil_enabled |
features :: sitewidehttps_enabled |
features_sitewidehttps_enabled |
features :: facebook_catalog_id |
features_facebook_catalog_id |
features :: checkout_type |
features_checkout_type |
features :: wishlists_enabled |
features_wishlists_enabled |
features :: graphql_storefront_api_enabled |
features_graphql_storefront_api_enabled |
features :: shopper_consent_tracking_enabled |
features_shopper_consent_tracking_enabled |
features :: multi_storefront_enabled |
features_multi_storefront_enabled |
- Subscribers
Endpoint: https://developer.bigcommerce.com/api-reference/9463521ead2f5-get-subscribers
Update Method: Upsert
Table name: big_commerce.subscribers
JSON Element |
Database Column |
id |
id |
|
|
first_name |
first_name |
last_name |
last_name |
source |
source |
order_id |
order_id |
created_at |
created_at |
updated_at |
updated_at |
channel_id |
channel_id |
- Tax Classes
Endpoint: https://developer.bigcommerce.com/api-reference/f1da4843af414-get-all-tax-classes
Update Method: Upsert
Table name: big_commerce.tax_classes
JSON Element |
Database Column |
id |
id |
name |
name |
date_modified |
date_modified |
date_created |
date_created |
- Tax Properties
Endpoint: https://developer.bigcommerce.com/api-reference/271c973d64dd4-get-tax-properties
Update Method: Upsert
Table name: big_commerce.tax_properties
JSON Element |
Database Column |
id |
id |
code |
code |
display_name |
display_name |
description |
description |
created_at |
created_at |
updated_at |
updated_at |
Release Updates
March, 13, 2023
- Added refund_id to order_refund_items and order_refund_payments