Stripe and Postgres: checks before reconciling partner sales
Stripe Data Pipeline public preview: status delays, a separate schema and sales checks before calculating partner rewards.
On 15 October 2026, Stripe announced Data Pipeline’s Postgres synchronization public preview. The announcement was published that day. This update concerns advertisers already using Stripe; check eligibility for your account and country separately.
What reconciliation must consider
The documentation says preview updates to payment_intents and creation of checkout_sessions can lag by up to ten minutes. A freshly queried record should therefore not automatically become the final basis for a partner payout.
The connection guide requires Postgres 13+, a separate user and schema. Do not edit Stripe-managed tables. The data schema includes account identifiers, update timestamps and refund fields: consider these when designing reconciliation.
An advertiser’s practical test
Our recommendation is to start with a separate report, without automatically switching the existing conversion acceptance process. Prepare a checklist containing internal order, payment identifier, partner source, expected status, observed status, observation time and discrepancy reason. Do not use email as the only linking key.
With permitted test data, check successful payment, cancellation, refund and repeated processing of one order. These are control scenarios, not real paid conversions. When data arrives late, retain the result for another check instead of immediately marking the lead rejected. Assign an owner for discrepancies and define the acceptable reconciliation window in advance.
When to continue
Continue the pilot when rerunning it creates no duplicate outcomes, refunds are reflected correctly and each accepted order can be traced. Stop automatic use of the data when an unexplained mismatch occurs or the order link is lost. Budget for database capacity, storage, maintenance and analyst time; preview terms do not make the entire process costless.
In our AffiliateCore platform, prepare your result-confirmation rules before launching an offer. Advertiser login. This news does not mean Stripe Data Pipeline is already integrated into AffiliateCore. Checked on 15 October 2026.