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.

Get easy access to all your BigCommerce data in all your tools.

BI tools commonly used with BigCommerce data

BigCommerce