1. Help Center
  2. Data Source Guides

Guide: Using BigCommerce with Databox


How to connect BigCommerce to Databox


How to connect BigCommerce to Databox

bigcommerce connect gif

To connect a BigCommerce Account in Databox, go to Data Manager > + New connection. Type BigCommerce in the search bar and click on the green Connect button. Next, click the green Connect now button.

This will open the  Authorization window, which is where you will be prompted to enter your BigCommerce site hash and access code to authorize the Databox app. 

Pro Tip: Each BigCommerce Account must be connected as a separate Data Source in Databox (1 Account = 1 Data Source). Learn more here.

How to access your API key, access token / API key secret?

To successfully connect your BigCommerce with Databox, you will need to use your  Site hash and API Key in the connect process. You can get more information on how to access your API key here.

You have to be a BigCommerce store owner to create an API account to obtain the access token. 

To find the Site hash, login into your BigCommerce account, choose the store you want to connect to Databox. Once you are in the UI, you can see the Site hash in the URL.

Example: store-yoursitehash.mybigcommerce.com (the bold part being the Site hash). Copy your Site hash and paste it in Databox's Activate BigCommerce window. 

To access the API Key in your BigCommerce Account, follow the steps below:

  1. Navigate to   Settings > API Accounts and click on the Create API Account button.
  2. Select  Choose V2/V3 API token from the Account type drop-down list. 
  3. Enter a Name for your app/integration. Under OAuth scopes, select Read-Only options. Click the Save button.
  4. After you have saved the account, a pop-up window will appear with your Client ID, Client Secret, and Access Token. Copy the Access Token and paste it in Databox's Activate BigCommerce window.

You should note down the information which is shown on the pop-up window, especially your Access Token because it won't appear in your BigCommerce Account again. If you are using Edge, Chrome, or Firefox, a text file containing your Client ID, Client Secret, and Access Token will be downloaded to your computer.

Once you have entered your Site hash and Access Token in Databox's Activate BigCommerce window, click the green Activate button to authorize the Databox app. 

What's the maximum amount of historical data initially available when you use a new BigCommerce Data Source Metric in Databox?

When you connect a new BigCommerce Data Source in Databox, 36 months worth of historical data is initially synced. 
Certain Metrics may have more or less historical data available. For more information about the amount of historical data available for a specific Metric, please contact our Support Team at help@databox.com.

For more information about the amount of historical data available for a specific Metric [learn more here (Metric Considerations jumplink) or contact] please contact our Support Team via live chat or at help@databox.com.

Pro Tip: In order to start syncing data for a Metric, you can add it to your Metrics screen, use it in a Scorecard, set a Goal around it, create an Alert for it, or add it to a Databoard. Learn more here.   

The amount of historical data you're able to access in Databox is dependent on your Databox plan. Learn more here.

What time zone does BigCommerce data sync in? 

BigCommerce data is synced in the time zone set in the BigCommerce Account. For example, if your BigCommerce Account time zone is set as EST, your BigCommerce data will sync with Databox in EST. 

How often does BigCommerce data sync?

All BigCommerce Data Sources will sync every hour with Databox. Learn more here.

You may experience sync delays for certain Metrics, learn more about this here.

How to build a Databoard using BigCommerce data


Popular BigCommerce Metrics

View a full list of BigCommerce Metrics available in Databox here.

How to build a Databoard

  1. Navigate to  Databoards > + New Databoard > Start Blank
  2. Go to the Datablock Library on the left-hand side of the Designer to find the Metric Library.
  3. Select the appropriate BigCommerce Account from the Data Source drop-down list in the Metric Library.
  4. View the list of pre-built BigCommerce Datablocks in the Metric Library. Drag and drop your selected Datablock onto your Databoard.    
  5.  If a pre-built Datablock isn't available for your use case, navigate to the Visualization Types section above the Metric Library.
  6. View the list of Visualizations available in Databox. Click on the Visualization or drag and drop the selected Datablock to your Databoard.
  7. Click on the Datablock on the Databoard to open the corresponding Datablock Editor on the right-hand side of the Designer.
  8. In the Metrics drop-down, click  Data Source to select the appropriate Data Source. This will filter out metrics from the specific Data Source.
  9. In the main Metrics drop-down, select the metric you'd like to display on the Datablock, using the Search bar if needed. This will update the Datablock, and it will populate with the corresponding data. 
  10. Complete steps 4-9 until your Databoard is complete.

Additional Information


Metric Considerations

Due to the way data is received from the API provider, you may experience a sync delay for the following Metrics:

    • Orders Count by Product

    • Average Price

    • Products sold

    • Products sold by Brand

    • Merchandising Revenue by Product

    • Units Sold

    • Quantity Sold by Product

    • Quantity Sold by Brand