It's easier than ever to access your BigCommerce data with Panoply's BigCommerce Snap Connector. Consolidate BigCommerce, plus all other business data, in a secure data warehouse for a single source of truth. Explore it with our SQL workbench, in-product graphs and charts, or connect your favorite BI tools for advanced reporting and analysis.
Some of the available tables Panoply can collect from BigCommerce include:
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.
Sync BigCommerce data with multiple sources in Panoply, then access it via your BI tool
“ 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.