Connectors E-commerce Magento

Sync, store and access your Magento data

Panoply makes it easier than ever to access your Magento data. Consolidate Magento, plus all other business data, in a secure data warehouse for a single source of truth. Explore your Magento data with our SQL workbench, in-product graphs and charts, or connect your favorite BI tools for advanced reporting and analysis.

See how to connect Panoply with Magento.

Get started

Panoply can connect with nearly any data source, via our Flex Connector or any 3rd party ETL tool. Our team will help you explore your options.

Talk To Us

Sync Magento data

Some of the available tables Panoply can collect from Magento include:

Catalog Product Entity

Describes specific categories and can be combined with the `catalog_category_entity_varchar` table and `catalog_category_product` mapping table to get category info for each product.

Catalog Category Product

A combination of product and category info. Products can be listed multiple times with different categories and vice versa. This table indexes the `catalog_category_entity` table (which has category details) and the `catalog_product_entity` table (which has product details).

Catalog Product Entity

Information about specific products, including the SKU and when they were added in Magento.

Customer Entity

Information about users that are registered on your website. Includes basic customer-level details like email address and registration date.

Quote

Information about carts created during checking, including whether or not the cart was converted to an order. Note: Due to the potential size of this table, Magento recommends periodically deleting records if certain criteria are met, such as unconverted carts more than 60 days old.

Quote Item

Data about items added to a cart, whether or not they were actually purchased. Note: Due to the potential size of this table, Magento recommends periodically deleting records if certain criteria are met, such as items in unconverted carts more than 60 days old.

Sales Order

Data about orders placed on your site, including order date, the customer who placed the order, the order total, and any discount or coupon codes used.

Sales Order Address

Shipping and billing information associated with specific orders.

Sales Order Item

Information about specific items from specific orders, such as details about the order, the product, and the quantity purchased.