Certain information in this article may be missing or out of date. We are in the process of updating the content.

BigCommerce is a flexible, robust ecommerce platform that provides established and emerging brands alike with everything they need to launch, promote, manage and scale a successful online store. Here are a few things you can expect from the BigCommerce/Grow integration.

Connecting BigCommerce

Before you get started, you will need to create an API account for each store.

1. In Grow, navigate to Data>Connections.
2. Select the blue Connect button at the end of the Your Top Data Sources options.
3. From the list of Connections, search and select BigCommerce.
4. Select Connect to BigCommerce.In the pop-up window, enter your Client ID, Access Token, and part of the API path: https://api.bigcommerce.com/stores/xxxxxxxxxx/v3/.
   Follow these steps to get the required details:
   1. In BigCommerce, go to Advanced Settings > API Accounts.
   2. Select API Account and give it a name.
   3. Copy the API path URL.
      You need to enter part of it in Grow later.
   4. Choose the settings for the OAuth Scopes as shown in the .gif image below.
      
   5. Click Save.
   6. A window pops up with the Client ID, Client Secret, and Access Token.
      Save these to your computer because this is the only time they are shown. (These are also automatically downloaded as a text file.)

   Here's an overview of the process in BigCommerce:

   

   You can refer to this BigCommerce help article for more details.

5. Click Connect to complete the connection.

Data Warehousing

BigCommerce is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.

Tables

The list of tables available will depend on your unique BigCommerce project. You can expect to see one table per dataset associated with the project ID in your connection.

Suggested Tables

The following suggested tables are available in Grow. These are toggled on by default when you sync your data for the first time.

• Customers
• Orders
• Products

Other Tables

These additional tables are available in Grow.

• Order Products

Warehousing Your Data

1. In the Connections Overview Page, click on your BigCommerce connection.
   This opens the Connection Details page.
2. Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
3. Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
   This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.

You may continue working within the app while your data is In Queue or Processing.

If your data source is not already connected, refer to the Connecting to a Data Source for more details.

Sync Interval

Full Sync

The default sync interval is 1 week.

Full sync intervals is 12 hours for Other Tables.

Incremental Sync

Incremental Sync is available for all BigCommerce warehouse tables. The default incremental sync interval is 1 hour.

Incremental sync is not supported for Other Tables.

To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.

Endpoints

Below is a list of the reports you can pull from BigCommerce, along with a description of the fields available with each report.

• Products: All products within the selected category, including product ID, keyword filter, name, type, SKU, search keywords, availability, description, cost price, retail price, sale price, is visible, is featured, inventory level, inventory warning level, dimensions, shipping price, is free shipping, rating total, rating count, total sold, date created, brand ID, view count, categories, modified date, event date start/end, condition, preorder release date, preorder message, order quantity minimum/maximum, tax class ID, primary image ID, etc.
• Orders: All orders matching the selected date range, including order ID, customer ID, created date, modified date, shipped date, status, subtotal, tax, base shipping/handling cost, wrapping cost, total, items total, payment method, payment provider ID, payment status, refunded amount, is digital, store credit amount, GC amount, IP country, currency, exchange rate, customer message, discount amount, coupon discount, is deleted, billing address, CC type, order source, etc.
• Customers: All customers, including customer ID, company, name, email, phone, created date, modified date, store credit, registration IP address, group ID, notes, tax exempt category, reset pass on login, accepts marketing, etc.