Hooray! We just launched a direct integration with 🛍   BigCommerce 🛍! Check it out Hooray—Panoply now offers direct integration with BigCommerce!

BigCommerce

BigCommerce is an ecommerce platform that allows merchants to sell physical, digital, and service-based products.

Panoply’s BigCommerce ETL integration automatically syncs your BigCommerce data into tables inside Panoply where you can further transform it with SQL.

All your business data in one place

Sync, store, and access your data from over 50+ data sources with Panoply. Get unlimited access free for 14 days.

Try Free

Sync BigCommerce data into Panoply

ETL the Modern Way. Get your data out of BigCommerce so you can analyze it.
Here’s a sample of the raw BigCommerce data that Panoply will replicate to your warehouse:
Catalog
Info on brands, categories, products, bulks pricing, rules, and custom fields associated with your catalog. Includes product including modifiers, reviews, variants, videos, and more.
Channels
Key channel data including currency assignments, channel listings, and channel sites.
Currencies
Currency data for your BigCommerce store such as the default currency, exchange rate, and more.
Customers
Includes a range of customer data including details like customer id, contact information, and attributes.
Geography
Data about the countries and states associated with your BigCommerce store.
Marketing
Information about your BigCommerce banners, coupons, and gift certificates.
Orders
Detailed data on orders, including coupons, products, refunds, shipments, order statuses, taxes, and transactions.
Payments
A list of payment methods and processing methods associated with your BigCommerce store.
Price Lists
Data on your pricing, including price lists, records of historical pricing information, and price list assignments by customer group, pricelist, or channel.
Shipping
Information about your BigCommerce store's shipping methods, zones, and products.
Sites
Data about the site routes and headless storefronts associated with your BigCommerce account.
Store Content
Info on about the blog posts and blog tags used by your BigCommerce store including the full text and publication dates of your blog posts.
Store Information
Metadata about your BigCommerce store, including its name, URL, address, default currency, and more.
Subscribers
Details about your BigCommerce store's subscribers, including email address, name, source, and creation date.
Tax Classes
Info on the tax classes associated with your BigCommerce store.
Widgets
Information on the widgets used in your BigCommerce store and the template files they target.
Wishlists
Data about customer wishlists including customer id, wishlist name, items on the wishlist, and whether or not the wishlist is public.
View BigCommerce documentation

Modernizing BigCommerce ETL

What is ETL?

Integrating data for analytics can be especially hard in a fast-shifting, rapid growth startup environment, where relevant business data might be spread out across a collection of apps and spreadsheets. ETL (Extract, Transform, Load) tools will help you collect your data from APIs and file transfers (the Extract step), convert them into standardized analytics-ready tables (the Transform step) and put them all into a single data repository (the Load step) to centralize your analytics efforts.

The shift to ELT

The traditional ETL model is a relic of the pre-cloud era, when compute resources were expensive, and everything needed to be cleaned up before analysis. These days, moving the transformation step closer to the time of analysis is not only feasible, it’s desirable. ELT lets you load raw data, increasing your analytical flexibility and moving relevant data more quickly from your engineering team to your analytics and BI teams.

All in one BigCommerce data pipeline

Panoply’s 80+ data connectors and built-in automated cloud data warehouse will let you go from a collection of siloed datasets to sophisticated analyses that integrate your BigCommerce data in a matter of minutes. Panoply is the only tool that combines an ETL process with a data warehouse, giving you total control over your data from sync to storage. We’ll handle all the infrastructure so you can skip the engineering work and go straight to analysis with your favorite BI tool.

Screenshots

Panoply has given us drastic improvements in query speed and brought all our data in one place. Our visualizations in Looker are much more fast and efficient.
John Wessel - Freshwater Systems
Read the customer success story

Connect Your Data for Free

Sync and store your data free for 14 days

Try Panoply Free Request Demo

Free 14 day trial. No credit card required.