Magento
Vendo syncs order and customer data from your Magento warehouse export and transforms it into commerce events for revenue analytics.
Last reviewed September 15, 2026
Source: Vendo imports order lifecycle and customer data from your Magento database export in BigQuery. It transforms the data into commerce events for revenue analytics.
What Vendo Syncs
Vendo reads from a BigQuery export of your Magento database (for example, a Fivetran-managed replication). It renders five production data streams:
| Stream | Description |
|---|---|
| Order Received | Order-created events with revenue, products, and customer details |
| Order Fulfilled | Shipment-based fulfillment events |
| Order Refunded | Full-refund events from credit memos |
| Order Partially Refunded | Partial-refund events from credit memos |
| Customer Properties | Customer profile properties for identity and segmentation |
Each stream comes from the standard Magento tables: sales_order, sales_shipment, sales_creditmemo and customer_entity. Vendo uses their update timestamps for incremental windows.
Prerequisites
- A BigQuery export of your Magento database. Vendo does not connect to the Magento application directly. Your Magento tables must first be replicated to a BigQuery dataset (Fivetran is a common way to do this).
- Vendo’s service access to that dataset (arranged during onboarding).
Authentication
Magento connects through your warehouse export, so there are no store API keys to create.
- Requires the GCP Project ID and BigQuery Dataset ID of your Magento export
- Optional configuration: customer identifier column (defaults to email) and reporting currency (defaults to USD)
Setup
The Vendo team sets up the Magento app for you.
- In the Vendo app (app2.vendodata.com ), go to Data → Integrations → Connected Apps and click Add App.
- Select Magento from the list of sources.
- Click Request Access.
- Give the Vendo team the GCP Project ID and BigQuery Dataset ID of your Magento export.
- Optionally, give the customer identifier column (default: email) and reporting currency (default: USD).
- Vendo validates access and starts to sync. It imports historical data in date-windowed chunks. Incremental syncs then run on your source schedule.
Platform Details
| Setting | Value |
|---|---|
| Sync Method | Warehouse queries against your Magento BigQuery export |
| Incremental Windows | Date-windowed on updated_at / created_at timestamps per stream |
| Load Behavior | Idempotent MERGE keyed per table (safe re-runs) |
| Source Tables | sales_order, sales_shipment, sales_creditmemo, customer_entity |
| Identity | Magento customer identifier (default: email, configurable) |
| Currency | Reporting currency configurable (default: USD) |
Verify Setup
- After you connect, check that the app status shows Active.
- Verify that order and customer data appears in your Vendo BigQuery dataset.
- Compare recent order counts and revenue against your Magento admin reports.
- Review Vendo job logs for sync activity and any errors.