BigCommerce + Orcabase

Your BigCommerce store, in plain answers.

Sync BigCommerce through Fivetran and ask about sales, categories, customers and stock in plain words, right next to your ads and emails.

Get started How to connect

Synced by Fivetran
Syncs every 6 hours
No Fivetran account needed

AgentBigCommerce connected

Which categories grew fastest this quarter?

Reading your BigCommerce data…

Brewing gear grew fastest: up 41% on last quarter, to $12.6k.

Coffee is still two thirds of sales.
Grinders drove most of the gear growth.
Gift sales nearly doubled in the last three weeks.

Growth by category vs last quarter, %

How I got this· 4 steps

Looked at your BigCommerce orders and catalog
Grouped sales by category
Compared this quarter with the last
Found the products behind each change

Example answer. Numbers are illustrative.

In plain words

How can I analyze BigCommerce data?

Fivetran copies your BigCommerce orders, catalog and customers into a database Orcabase hosts for you and keeps the copy up to date. You ask in plain words, and the agent answers with the number, a chart and how it got there.

Because your store sits next to your ads and emails, you can ask which campaigns sell which categories.

Ask in plain words

What you can ask about your BigCommerce data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

Meet the data agent

Which categories grew fastest this quarter?
What were our best sellers last month?
Which customer groups spend the most?
What’s our average order value, week by week?
Which coupons bring repeat customers?
Which products are low on stock?
How many orders shipped late last month?
Show me revenue by brand.

What comes in

Your BigCommerce data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

Orders

Every order, with its products, shipping, taxes and discounts.

Catalog

Products, variants, categories and brands.

Customers

Who bought, their customer groups and order history.

Coupons and refunds

Codes used, and money given back.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your BigCommerce data.

How metrics work

Revenue
Orders minus refunds, without tax and shipping.
Category share
Each category’s share of revenue.
Average order value
Revenue divided by the number of orders.
Repeat purchase rate
Share of customers with two or more orders.

Dashboards to start with

Your BigCommerce numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

Store

4 charts

Revenue by week
Revenue by category
Best sellers
Average order value

Customers

3 charts

New vs returning
Revenue by customer group
Repeat purchase rate

About dashboards

Better together

Ask across BigCommerce and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

“Which Google Ads campaigns sell our best categories?”

BigCommerce + Google Ads

“Which email flows bring customers back?”

BigCommerce + Klaviyo

“Do store sales match what’s in the books?”

BigCommerce + QuickBooks

How to connect

Connect BigCommerce, step by step.

1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for BigCommerce. Pick the database to sync into.
2
Connect BigCommerce on Fivetran’s page
Fivetran’s page asks for your store hash and an access token, which you get by creating an API account in BigCommerce’s settings.
3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your BigCommerce data.

What you’ll need

A BigCommerce login with admin rights, to create an API account.
The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.

At a glance

How it connects: Synced by Fivetran
How fresh: Every 6 hours, as standard.
Where your data lives: A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up: An admin in your organization.
Your login: You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost: Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.

Sync apps with FivetranStep-by-step, in the docs.

Questions

About BigCommerce and Orcabase

More in the docs: Sync apps with Fivetran

Can Orcabase change my store?

No. The API account only needs to read, and Orcabase only reads the synced copy.

Can I see revenue by category and brand?

Yes. Orders keep their products, and products keep their categories and brands, so any number can be split by either.

Do I need a Fivetran account?

No. Orcabase uses its own. You sign in to BigCommerce on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.

How fresh is my BigCommerce data in Orcabase?

Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.

What does syncing cost?

Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Keep exploring

More data sources

All data sources

Your BigCommerce data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.

Get started All data sources