It's easier than ever to analyze your Shopify data with Panoply's Shopify Snap Connector. Consolidate Shopify, plus all other business data in a secure data warehouse, then explore it with our SQL workbench and in-product graphs and charts. You can also connect your favorite BI tools for more advanced Shopify reporting and analysis.
Some of the available tables Panoply can collect from Shopify include:
An order is a customer's completed request to purchase one or more products from a shop. An order is created when a customer completes the checkout process, during which time they provide an email address or phone number, billing address, and payment information.
The Customer resource stores information about a shop's customers, such as their contact details, their order history, and whether they've agreed to receive email marketing. The Customer resource also holds information on the status of a customer's account.
The Product resource lets you update and create products in a merchant's store. You can use product variants with the Product resource to create or update different versions of the same product. You can also add or update product images.
You can query the Checkout resource to return abandoned checkouts. A checkout is considered abandoned when a customer leaves the checkout after the first page without completing their purchase.
A custom collection is a grouping of products that a merchant can create to make their store easier to browse. The merchant creates a custom collection and then selects the products that will go into it.
The Metafield resource allows you to add additional information to other Admin API resources. Metafields can be used in several ways, such as to add a summary to a blog post or to share information with other Shopify apps.
The Collect resource connects a product to a custom collection. Collects are meant for managing the relationship between products and custom collections. For every product in a custom collection, there is a collect that tracks the ID of both product and custom collection.
Sync Shopify data with multiple sources in Panoply, then access it via your BI tool