Payment Truth for WooCommerce
Read-only WooCommerce Stripe reconciliation for payment status, amount, currency, and refund mismatches.
View the Project on GitHub moxianyu6975-cpu/payment-truth-for-woocommerce
How to Reconcile WooCommerce Orders with Stripe Payments Safely
Quick answer
WooCommerce–Stripe reconciliation means matching each order to its Stripe PaymentIntent or charge, then comparing payment status, gross amount, currency, and refunded total. A safe workflow identifies disagreements first and keeps state-changing actions separate from diagnosis.
Minimum evidence for each order
Collect these fields from both systems:
| Evidence | WooCommerce | Stripe |
|---|---|---|
| Identifier | Order ID/number and transaction ID | PaymentIntent or charge ID |
| Status | Order status and paid date | PaymentIntent or charge status |
| Amount | Gross order total | Authorized or collected amount |
| Currency | Order currency | Payment currency |
| Refunds | Total refunded amount | Refund total attached to the charge |
| Timing | Creation, paid, and note timestamps | Object, event, and refund timestamps |
Do not match records only by customer name, displayed amount, or approximate time when a provider identifier is available.
A read-only reconciliation workflow
- Select a bounded recent order window.
- Keep only orders created through the supported Stripe gateway.
- Resolve each order to its stored PaymentIntent or charge ID.
- Read the provider record without changing it.
- Normalize amounts into the currency’s smallest unit.
- Compare status, amount, currency, and refunded total.
- Record mismatches with timestamps and identifiers.
- Review order notes, events, webhooks, and logs before making a correction.
- Recheck the record after the underlying issue is resolved.
Common mismatch patterns
- Stripe succeeded while WooCommerce still considers the order unpaid.
- WooCommerce considers the order paid while Stripe reports a terminal failure.
- Gross amounts differ.
- Currencies differ.
- Refunded totals differ.
- A pending order exceeds the expected age.
- The WooCommerce order has no usable Stripe reference.
Automating the comparison without automating the decision
Payment Truth for WooCommerce implements this read-only comparison for stores using the official WooCommerce Stripe Gateway. It scans a configurable recent window, uses the gateway’s existing Stripe connection, stores normalized findings without customer identity or card data, and can send opt-in alerts for newly opened findings.
It does not replace accounting reconciliation, repair webhooks, edit orders, capture money, or issue refunds. Those boundaries keep detection separate from financial and fulfillment decisions.