SleekView for EDD Stripe Pro: payment intents & order tables
Read directly from edd_orders, edd_order_transactions, and Stripe meta keys EDD writes. Surface payment intent id, Stripe customer id, and capture status as real columns without per-order detective work.
♾️ Lifetime License available
Stripe payment data hides in EDD transaction rows
EDD Stripe Pro Payment Gateway processes payments through Stripe and writes the payment intent id, charge id, and Stripe customer id into edd_order_transactions as the gateway transaction reference plus various keys in edd_ordermeta. EDD 3.0's default Orders screen shows order number, customer, status, and total; the Stripe references stay in the related transactions table, invisible until you click into each order.
SleekView reads edd_orders together with edd_order_transactions and edd_customers so payment intent id, Stripe customer id, and capture state become first-class joined columns. Finance reconciles payouts by listing every completed order with its pi_* reference, support pulls a customer's order history with Stripe ids inline, and risk reviews refunded orders with their original auth context.
Inline edits to order status route through EDD's CRUD layer where supported so the gateway's refund and capture hooks fire. Direct meta writes are guarded by conflict detection so a stale admin row never overwrites a Stripe webhook update.
Workflow
How SleekView joins EDD Stripe Pro data
Pick the base table
edd_orders for order workflows, edd_customers for CRM-style views, edd_order_transactions for payment audit. SleekView detects EDD 3.0 versus legacy automatically.
Compose joined columns
edd_order_transactions for payment intent and charge ids, edd_customers for customer fields, edd_order_adjustments for taxes or fees. Only relevant joins are listed.
Save and scope per role
Edit inline or bulk-process
Sample columns
A typical EDD Stripe Pro payments view
edd_orders with edd_order_transactions on order id, and edd_customers on customer id.
wp_edd_orders + wp_edd_order_transactions + wp_edd_customers
| Order | Status | Payment intent | Customer | Total | Date |
|---|---|---|---|---|---|
| #3128 | Complete | pi_3OXyZ012abcd | alex@studio.co | $48.00 | Apr 24 |
| #3127 | Pending | pi_3OXy91abcd02 | ria@design.io | $96.00 | Apr 24 |
| #3126 | Complete | pi_3OXy7Q12cdef | tom@hello.dev | $32.00 | Apr 23 |
| #3125 | Refunded | pi_3OXy0M12ghij | mia@brew.coop | $48.00 | Apr 23 |
Comparison
Default EDD Stripe Pro admin vs SleekView
Default EDD Stripe Pro admin
-
Stripe payment intent id sits in
edd_order_transactionsand isn't shown in the Orders list -
Stripe customer id isn't surfaced on
edd_customersrows - Refunds and charge captures need per-order click-through to inspect
- No saved view for orders with refunded Stripe charges in a date range
- EDD 3.0 transactions table is exposed but not joined into the main orders screen
SleekView
-
Join
edd_orderswithedd_order_transactionssopi_*ids are columns - Customer-rooted view showing Stripe customer id, LTV, and last order
- Saved view: Stripe-refunded orders for the last 90 days
- Inline-edit order status through EDD CRUD so refund hooks fire
- Export reconciliation lists with payment intent ids for the bookkeeper
Features
What SleekView gives you for EDD Stripe Pro Payment Gateway
Payment intents as columns
Join edd_order_transactions into the Orders view so Stripe's pi_* id becomes a sortable column. Finance reconciles against Stripe Dashboard without copying ids order by order.
Customer-rooted Stripe view
Build a view on edd_customers with Stripe customer id, total orders, total spent, and refund count as aggregate columns. Support sees Stripe context at the customer level, not just per order.
Refunds as their own view
Scope a view to refunded orders within a date range with Stripe payment intent and refund amount visible. Risk and finance get an audit list, not a per-order hunt.
Audience
Who uses SleekView for EDD Stripe Pro
Finance reconciliation
Match EDD orders to Stripe payouts: order total, payment intent id, charge date, currency. Export as CSV for monthly reconciliation against the Stripe Dashboard.
Support
Customer view with Stripe customer id and recent payment intents inline. Refund a charge through EDD CRUD without leaving WP admin.
Risk and fraud
Filter on refunded or disputed rows, sort by AVS/CVV response if your gateway plugin stores it. Pattern-spotting becomes a sort, not a custom SQL query.
The bigger picture
Why Stripe reconciliation needs joined EDD views
EDD Stripe Pro does what a gateway plugin should: it processes payments, writes references back to the order, and lets EDD's standard refund and capture flows talk to Stripe. The schema is also tidy: orders in edd_orders, payment references in edd_order_transactions, customers in edd_customers. Where it falls down is operational.
Finance reconciling a Stripe payout wants payment intent id next to order total next to date, and the default Orders screen shows none of that. Support investigating a refund wants the original payment intent and the linked Stripe customer id, which means clicking into the transaction record per order. Risk reviewing chargebacks wants a saved list of refunded charges with their original auth state.
SleekView's job is to compose the joins so these views exist as named tables: Stripe reconciliation, refund audit, customer Stripe view. Same EDD schema, same hooks, dramatically less context-switching between WP admin and the Stripe Dashboard.
Questions
Common questions about SleekView for EDD Stripe Pro Payment Gateway
Yes for the relational schema (edd_orders, edd_order_transactions, edd_customers). Those tables landed in EDD 3.0 and most stores have migrated. On older EDD versions Stripe references lived in edd_payment postmeta and would need a different mapping.
Status changes through EDD CRUD trigger the gateway's refund handlers as configured. The actual Stripe API call goes through EDD Stripe Pro's hook chain, not a SleekView shortcut, so the behaviour matches manual admin edits exactly.
EDD Recurring Payments stores subscriptions in edd_subscriptions with payment history linking back to orders. SleekView can show subscriptions as their own view (status, billing cycle, expiration) or join them to customers for a unified subscriber workspace, with Stripe customer id inline.
Yes. Status edits route through EDD's CRUD layer so completion notifications, refund notifications, and the hooks EDD Stripe Pro listens to all fire as expected. Bulk operations iterate per row through CRUD so side effects match manual edits.
If EDD Stripe Pro stores webhook event ids in edd_ordermeta or as part of a transaction record, SleekView can surface them as a column. The column picker lists meta keys actually present in your install, so the available fields depend on the gateway plugin's storage choices.
Customer queries hit indexed columns on edd_customers. Aggregate columns (lifetime spend, refund count) use subqueries that EDD already indexes for, but they're heavier than direct columns: keep them off triage views and on detail views to keep query plans fast.
Yes. Any SleekView table exports to CSV with the visible column set. Useful for monthly reconciliation against the Stripe Dashboard, end-of-quarter finance close, or sharing a filtered refund list with a payments analyst outside WordPress.
Stripe customer ids are pseudonymous identifiers, not personal data, but the email and address they're attached to are. Gate columns containing personal data to roles that need them (support, finance) via WordPress capabilities, and exclude them from views other staff can access.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Wpc Product Bundles
- Woocommerce Chronopost
- Paykickstart Bridge
- Wc Vendors
- Woocommerce Shipping Easypost
- Payu Money Woocommerce
- Woocommerce Eu Vat Assistant
- Edd Software Licenses
- Variation Swatches
- Woocommerce Shipping Rates
- Woocommerce Show Single Variations
- Woocommerce Product Comparison
- Woocommerce Google Product Feed
- Gooten Print On Demand
- Woocommerce Xero