PayPal
Vendo syncs payment transactions from PayPal, including payments received, refunds, customer profiles and installment tracking.
Last reviewed September 15, 2026
Source: Vendo imports transaction data from PayPal and transforms it into payment events and customer profiles for revenue analytics.
What Vendo Syncs
Source Streams
Vendo fetches two raw data streams from the PayPal Transaction Search API:
| Stream | Description |
|---|---|
| Transactions | Parent transaction records with amounts, payer info, status, and fees |
| Transaction Items | Line-item details within each transaction |
Produced Events
Vendo transforms raw transactions into four production tables:
| Event | Description |
|---|---|
| Payment Received | Successfully completed payments with customer and product details |
| Payment Refunded | Refunded payments with amount and refund status |
| Account Created | Customer’s first payment (used as an account lifecycle proxy) |
| Customers | Customer master profiles with aggregated transaction history |
Transaction Fields
| Field | Description |
|---|---|
| Transaction ID | Unique payment identifier |
| Amount & Currency | Payment amount with currency code |
| Fee Amount | PayPal processing fees |
| Status | Succeeded, denied, pending, or reversed |
| Invoice ID | Merchant invoice reference |
| Payment Method | Instrument type and subtype |
| Payer Email | Customer email address |
| Payer Name | Customer first and last name |
| Payer Country | Geographic origin |
| Shipping Info | Shipping address and method |
Revenue Breakdowns
| Field | Description |
|---|---|
| Sales Tax | Tax amount collected |
| Shipping Amount | Shipping charges |
| Discount Amount | Discounts applied |
| Tip Amount | Tips included |
| Credit Fees | Transactional and promotional credit fees |
Installment Detection
Vendo automatically detects recurring payments. It looks for installment patterns in product names (for example, “monthly” or “payment plan”). Vendo numbers installment transactions in sequence per customer and product, for cohort and retention analysis.
Currency Conversion
PayPal transactions can be in any currency. Vendo automatically:
- Reads the transaction’s source currency.
- Applies daily exchange rates to convert to your reporting currency.
- Exports both source and reporting currency amounts.
Authentication
PayPal uses the OAuth 2.0 Client Credentials flow.
- Requires a Client ID and Client Secret from your PayPal Developer account
- Vendo gets and refreshes tokens automatically
- Supports both Live and Sandbox environments
Setup
- In the Vendo app, go to Apps and click Add App.
- Select PayPal from the list of sources.
- Enter your Client ID and Client Secret.
- You can find them in your PayPal Developer Dashboard under Apps & Credentials.
- If you use the PayPal sandbox environment, select Sandbox Mode. For live data, leave it clear.
- Configure your reporting currency.
- Vendo validates the credentials and starts to sync transaction history.
Platform Details
| Setting | Value |
|---|---|
| Sync Method | Server-side via PayPal Transaction Search API |
| Page Size | Up to 500 transactions per request |
| Query Window | 7-day rolling windows (max 31 days per API call) |
| Event Codes | T0000, T0002, T0006, T0007 (standard payment events) |
| Deduplication | transaction_id on transactions, transaction_id + index on items |
| Test Filtering | Transactions matching “test” in product name are excluded |
Verify Setup
- After you connect, check that the app status shows Active.
- Verify that payment events appear in your Vendo BigQuery dataset.
- Compare recent transaction totals against your PayPal dashboard.
- Check that Vendo creates customer profiles from payer data.
- Review Vendo job logs for sync activity and any errors.