# Integration Specifications

## 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

{% hint style="warning" %}
**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**](mailto:support@daasity.com) **to have the connection between platforms configured.**
{% endhint %}

## **API Endpoints**

The Daasity BigCommerce extractor is built based on the [BigCommerce REST API documentation](https://developer.bigcommerce.com/docs/rest). The following endpoints are used by Daasity to replicate data from BigCommerce:

* [Banners](https://developer.bigcommerce.com/api-reference/574c01ed636eb-get-all-banners)
* [Brands](https://developer.bigcommerce.com/docs/rest-catalog/brands)
  * [Brands](https://developer.bigcommerce.com/api-reference/c2610608c20c8-get-all-brands)
  * [Brand Meta Fields](https://developer.bigcommerce.com/api-reference/46f4d19da7931-get-all-brand-meta_fields)
* [Categories](https://developer.bigcommerce.com/docs/rest-catalog/categories)
  * [Categories](https://developer.bigcommerce.com/api-reference/9cc3a53863922-get-all-categories)
  * [Category Meta Fields](https://developer.bigcommerce.com/api-reference/9cc3a53863922-get-all-categories)
* [Channels](https://developer.bigcommerce.com/docs/rest-management/channels#get-all-channels)
  * [Channels](https://developer.bigcommerce.com/api-reference/d2298071793d6-get-all-channels)
  * [Channel Meta Fields](https://developer.bigcommerce.com/api-reference/e3c521fcecaea-get-channel-metafields)
  * [Customer Settings Per Channel](https://developer.bigcommerce.com/api-reference/d5e66c45b0415-get-customer-settings-per-channel)
* [Coupons](https://developer.bigcommerce.com/docs/rest-content/marketing/coupons)
* [Currencies](https://developer.bigcommerce.com/api-reference/2dc5722e06f7d-get-all-currencies)
* [Customers](https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers)
  * [Customers](https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers)
  * [Customer Attributes](https://developer.bigcommerce.com/api-reference/5092ca66caaee-get-all-customer-attributes)
  * [Customer Settings](https://developer.bigcommerce.com/api-reference/0c31a6d25e5ea-get-customer-settings)
* [Gift Certificates](https://developer.bigcommerce.com/api-reference/cee3b9dae1d79-get-all-gift-certificates)
* [Orders](https://developer.bigcommerce.com/docs/rest-management/orders)
  * [Orders](https://developer.bigcommerce.com/api-reference/82f91b58d0c98-get-all-orders)
  * [Order Coupons](https://developer.bigcommerce.com/api-reference/e95114e312eb1-get-order-messages)
  * [Order Messages](https://developer.bigcommerce.com/api-reference/e95114e312eb1-get-order-messages)
  * [Order Products](https://developer.bigcommerce.com/api-reference/3b4dfef625708-list-order-products)
  * [Order Refunds](https://developer.bigcommerce.com/api-reference/961867b3105c1-get-all-refunds)
  * [Order Shipments](https://developer.bigcommerce.com/api-reference/ff860667cfc4e-get-order-shipments)
  * [Order Shipping Addresses](https://developer.bigcommerce.com/api-reference/88829242e6459-get-a-shipping-address)
  * [Order Statuses](https://developer.bigcommerce.com/api-reference/d24b6b0f03eb7-get-all-order-statuses)
  * [Order Taxes](https://developer.bigcommerce.com/api-reference/5ba0733461006-get-all-order-taxes)
  * [Order Transactions](https://developer.bigcommerce.com/api-reference/4f98780edf0b9-get-transactions)
* [Payment Methods](https://developer.bigcommerce.com/api-reference/a6936b9439d0a-get-all-payment-methods)
* [Price Lists](https://developer.bigcommerce.com/api-reference/5e517c58b6fb9-get-all-price-lists)
* [Products](https://developer.bigcommerce.com/api-reference/5e517c58b6fb9-get-all-price-lists)
  * [Products](https://developer.bigcommerce.com/api-reference/5e517c58b6fb9-get-all-price-lists)
  * [Product Complex Rules](https://developer.bigcommerce.com/api-reference/51d3d92129c20-get-complex-rules)
  * [Product Meta Fields](https://developer.bigcommerce.com/api-reference/bb4459a9412f6-get-all-product-metafields)
  * [Product Reviews](https://developer.bigcommerce.com/api-reference/a77ee99acb04b-get-product-reviews)
* [Sites](https://developer.bigcommerce.com/api-reference/4981c78979bd3-get-sites)
* [Store Information](https://developer.bigcommerce.com/api-reference/bb1daaaeccae0-get-store-information)
* [Subscribers](https://developer.bigcommerce.com/api-reference/9463521ead2f5-get-subscribers)
* [Tax Classes](https://developer.bigcommerce.com/api-reference/9463521ead2f5-get-subscribers)
* [Tax Properties](https://developer.bigcommerce.com/api-reference/271c973d64dd4-get-tax-properties)

## Entity Relationship Diagram (ERD)

[Click here to view the ERD for the Daasity BigCommerce integration](https://lucid.app/documents/embedded/6d0a55d7-458a-4034-9c51-3dcb3dd797bd) 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.

* [Banners](#banners)
* [Brands](#brands)
  * Brands
  * Brand Meta Fields
  * Brand Meta Keywords
* [Categories](#categories)
  * Categories
  * Category Meta Keywords
  * Category Meta Fields
* [Channels](#channels)
  * Channels
  * Channel Meta Fields
  * Customer Settings Per Channel
* [Coupons](#coupons)
  * Coupons
  * Coupon Shipping Methods
* [Currencies](#currencies)
* [Customers](#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](#gift-certificates)
* [Orders](#orders)
  * 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
* [Payment Methods](#payment-methods)
* [Price Lists](#price-lists)
* [Products](#products)
  * 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](#sites)
  * Sites
  * URLs
* [Store Information](#store-information)
* [Subscribers](#subscribers)
* [Tax Classes](#tax-classes)
* [Tax Properties](#tax-properties)

### Banners

* Endpoint: [Banners](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

#### Brands

* Endpoint: [Brands](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: [Brands Meta Fields](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: [Brand](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

#### Categories

* Endpoint: [Categories](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: [Categories](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: [Category Meta Fields](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

#### Channels

* Endpoint: [Channels](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: [Channel Meta Fields](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 Channel

* Endpoint: [Settings Per Channel](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

#### Coupons

* Endpoint: [Coupons](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: [Coupons](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: [Currencies](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

#### Customers

* Endpoint: [Customers](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                               |
| email                                             | email                                             |
| 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: [Customer Attributes](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: [Customer Settings](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: [Customers](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: [Customers](https://developer.bigcommerce.com/api-reference/761ec193054b6-get-all-customers)
* Update Method: UPSERT
* Table Name: \[`big_commerce.customer_store_credit`s]

| JSON Element                          | Database Column |
| ------------------------------------- | --------------- |
| customer\_id (from the parent record) | customer\_id    |
| amount                                | amount          |

#### Customer Attribute Values

* Endpoint: [Customers](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:  
* 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: [Customers](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: [Customers](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: [Gift Certificates](https://developer.bigcommerce.com/api-reference/cee3b9dae1d79-get-all-gift-certificates)
* 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

#### Orders

* Endpoint: [Orders](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: [Order Coupons](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: [Order Messages](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: [Order Products](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: [Refunds](https://developer.bigcommerce.com/api-reference/961867b3105c1-get-all-refunds)
* Update Method: UPSERT
* Table Name: \[`big_commerce.order_refund`s]

| 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 Return Items

* Endpoint: [Refunds](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: [Refunds](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: [Order Shipments](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: [Order Shipments](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: [Order Shipping Address](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                          |
| email                          | email                          |
| 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: [Order Shipping Address](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: [Order Statuses](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: [Order Taxes](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: [Order Transactions](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: [Payment Methods](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: [Price Lists](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

#### Products

* Endpoint: [Products](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: [Product Complex Rules](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: [Product Meta Fields](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: [Product Reviews](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          |
| email          | email           |
| name           | name            |
| date\_reviewed | date\_reviewed  |
| date\_created  | date\_created   |
| date\_modified | date\_modified  |

#### Product Variants

* Endpoint: [Products](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 Variant Option Values

* Endpoint: [Products](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: [Products](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: [Products](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: [Products](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

#### Sites

* Endpoint: [Sites](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: [Sites](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: [Site Information](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: [Subscribers](https://developer.bigcommerce.com/api-reference/9463521ead2f5-get-subscribers)
* Update Method: UPSERT
* Table Name: \[`big_commerce.subscribers`]

| JSON Element | Database Column |
| ------------ | --------------- |
| id           | id              |
| email        | email           |
| 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: [Tax Classes](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: [Tax Properties](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     |