Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Extracts Magento Commerce storefront data including orders, invoices, credit memos, products and their attributes, categories, carts (quotes), inventory and stock status, coupons and sales rules, and multi-store configuration (websites, store groups, store views). This enables analysis of revenue and refunds, product performance, inventory levels and stockouts, promotion effectiveness, abandoned carts, and multi-store operations.
Represents placed sales orders with customer, items, totals, shipping, and status. Enables analysis of GMV/revenue, AOV, order status flows, cohort performance, and fulfillment outcomes.
Represents billed documents tied to orders with amounts and taxes. Supports analysis of invoiced vs. ordered revenue, payment capture timing, and financial reconciliation.
Represents refunds for orders or invoices, including refunded items and amounts. Enables refund rate tracking, net revenue calculations, and return analysis.
Represents active and abandoned shopping carts with items, customer details, and checkout info. Used for funnel and abandonment analysis, recovery performance, and pre-purchase behavior insights.
Represents catalog SKUs with attributes, pricing, media, and relationships. Enables product performance analysis (sales, AOV contribution), merchandising, pricing strategy, and attribute-based segmentation.
Represents on-hand and sellable quantities by SKU, stock, and source. Supports stockout monitoring, days-of-supply, fulfillment readiness, and multi-source allocation analysis.
Represents the product taxonomy and hierarchy. Enables category-level sales, conversion, and assortment performance reporting.
Represents cart price rules and coupon codes with activation and usage controls. Used to measure promo lift, redemption rate, discount leakage, and campaign ROI.
Represents the multi-store hierarchy and configuration (websites, store groups, store views) including locale, currency, and base URLs. Enables multi-store, regional, and localization slicing of KPIs and reporting.
Represents buyers and shoppers inferred from orders and carts with associated details. Supports cohorting, CLV, repeat purchase rate, and segmentation for lifecycle and personalization analysis.
Uses a Magento admin access token or your Magento username and password to obtain a bearer token
Requires a Magento account to connect.
Operational data, performance metrics, and business insights.
Authenticate Magento in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Magento data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.