Integration guideSourcesAvailable

Magento

Vendo syncs order and customer data from your Magento warehouse export and transforms it into commerce events for revenue analytics.

Last reviewed July 13, 2026

Source — Vendo imports order lifecycle and customer data from your Magento database export in BigQuery and transforms it 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) and 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 is derived from the standard Magento tables — sales_order, sales_shipment, sales_creditmemo, and customer_entity — using 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 be replicated to a BigQuery dataset first (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

In the Vendo app (app2.vendodata.com ), navigate to Apps and click Add App
Select Magento from the integration catalog
Enter the GCP Project ID and BigQuery Dataset ID of your Magento export
Optionally set the customer identifier column (default: email) and reporting currency (default: USD)
Vendo validates access and begins syncing — historical data is imported in date-windowed chunks, then incremental syncs 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 connecting, check the app status shows Active
Verify 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