Odoo and PayPal integration

What moves between them

The main flow runs from PayPal into Odoo. Completed PayPal orders and payments are polled on a schedule or received via PayPal webhook events and posted into Odoo's accounting module, mapped to the matching Odoo customer (partner) and sales order. PayPal transaction IDs are stored in Odoo account.move records for reconciliation. Customer records are aligned in both directions so each PayPal customer corresponds to an Odoo partner, and payment amounts match between the two systems. GL postings flow one way, from PayPal transaction data into Odoo's journal entries.

How ml-connector handles it

ml-connector stores the Odoo API key encrypted and refreshes the PayPal OAuth token on each request cycle, caching it to avoid token endpoint hammering. It polls PayPal's transaction search API within a 31-day rolling window and filters on transaction timestamp to avoid re-processing the same records twice. For each PayPal order or payment, it looks up the matching Odoo partner by email address and the matching sales order by reference or amount, then creates or updates the corresponding Odoo account.move (journal entry) with the PayPal transaction ID as the external reference. If a PayPal webhook is enabled, ml-connector also accepts push events, validates the RSA-SHA256 signature, and processes them immediately. Both polling and webhook flows use the same transformation logic so records stay consistent regardless of how they arrive. Retries account for PayPal rate limits and Odoo API timeouts.

A real-world example

A mid-sized B2B software company runs Odoo for accounting and CRM, and uses PayPal for invoicing and payments from customers worldwide. Before the integration, the finance team watched PayPal's transaction list daily, manually found the matching Odoo customer and invoice for each payment, and created journal entries by hand to clear accounts receivable. Month-end reconciliation meant chasing orphaned payments that hadn't been matched yet. With Odoo and PayPal connected, each PayPal order or payment posts into Odoo's journal automatically, matched to the customer and invoice, and the accounts receivable balance is live and accurate without manual intervention.

What you can do

• •Post PayPal orders and completed payments into Odoo's accounting module, matched to the correct customer and sales order.
• •Match PayPal customers to Odoo partners by email address so each payment lands on the right invoice and account.
• •Store PayPal transaction IDs in Odoo journal entries for audit and reconciliation.
• •Handle OAuth 2.0 token refresh on PayPal and API key auth on Odoo, with secure credential storage.
• •Poll PayPal transactions on a schedule within a rolling 31-day window, or accept webhooks when configured, with retries and a full audit trail.

Questions

Which direction does data move between Odoo and PayPal?

The main flow is PayPal into Odoo. Orders and payments from PayPal post into Odoo's accounting module as journal entries, matched to the correct customer and sales order. Customer records are aligned in both directions so each PayPal email maps to an Odoo partner. GL postings move one way only; PayPal has no GL account objects, so there is nothing to write back.

How does ml-connector match PayPal payments to Odoo invoices?

ml-connector matches by customer email address and order reference or amount. When a PayPal order arrives, it searches for an Odoo partner with the same email, then looks for a sales order with a matching external reference or total amount. Once matched, the payment posts into Odoo's journal against the correct invoice line. If no match is found, the payment is flagged for manual review.

Does the integration support PayPal webhooks or does it only poll?

Both. ml-connector can poll PayPal's transaction search API on a schedule within a rolling 31-day window, or receive webhooks if they are registered in PayPal's Developer Dashboard. Both paths use the same transformation logic and validate signatures, so records stay consistent regardless of how they arrive. Webhooks are faster for real-time sync, while polling is more reliable for high-volume accounts.