SleekView for EDD PayPal Pro: PayPal transactions & order tables
Read directly from edd_orders, edd_order_transactions, and PayPal meta keys EDD writes. Surface PayPal transaction id, payer id, and capture state as columns instead of per-order detective work.
♾️ Lifetime License available
PayPal references buried in the transactions table
EDD PayPal Pro Payment Gateway processes payments through PayPal and writes the PayPal transaction id, payer id, and gateway response into edd_order_transactions alongside meta keys in edd_ordermeta. EDD 3.0's default Orders screen shows order number, customer, status, and total; the PayPal references live in the related transactions table, hidden until you click each order open one at a time.
SleekView reads edd_orders joined with edd_order_transactions and edd_customers so PayPal transaction id, payer id, and capture state become first-class columns. Finance reconciles against the PayPal activity export by listing every completed order with its transaction id, support investigates disputes with payer references inline, and ops triages pending-state orders before they expire.
Inline edits to order status route through EDD's CRUD layer where supported, so PayPal's refund and capture hooks fire as expected. Direct writes to gateway meta are guarded by conflict detection so an admin row never overwrites a fresh IPN or webhook callback.
Workflow
How SleekView joins EDD PayPal 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 PayPal txn and payer ids, edd_customers for customer fields, edd_order_adjustments for taxes or fees.
Save and scope per role
Edit inline or bulk-process
Sample columns
A typical EDD PayPal 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 | PayPal txn | Customer | Total | Date |
|---|---|---|---|---|---|
| #3128 | Complete | 9XJ12345AB678901C | alex@studio.co | £48.00 | Apr 24 |
| #3127 | Pending | 9XJ12345AB678902C | ria@design.io | £96.00 | Apr 24 |
| #3126 | Complete | 9XJ12345AB678903C | tom@hello.dev | £32.00 | Apr 23 |
| #3125 | Refunded | 9XJ12345AB678904C | mia@brew.coop | £48.00 | Apr 23 |
Comparison
Default EDD PayPal Pro admin vs SleekView
Default EDD PayPal Pro admin
-
PayPal transaction id lives in
edd_order_transactionsand isn't shown on the Orders list - Payer id and email aren't joined into the row-level view of an order
- Refunds need per-order click-through to inspect against PayPal's activity log
- No saved view for orders pending PayPal capture across a date range
- IPN failures sit in order notes that nobody reads
SleekView
-
Join
edd_orderswithedd_order_transactionsso PayPal txn ids are columns - Customer-rooted view showing payer id, LTV, and last PayPal txn
- Saved view: PayPal-refunded orders in the last 90 days
- Inline-edit order status through EDD CRUD so refund hooks fire
- Export reconciliation lists with PayPal transaction ids for the bookkeeper
Features
What SleekView gives you for EDD PayPal Pro Payment Gateway
PayPal transactions as columns
Join edd_order_transactions into the Orders view so PayPal's transaction id is sortable. Finance reconciles against PayPal's activity export without copying ids order by order.
Customer-rooted PayPal view
Build a view on edd_customers with payer id, total orders, total spent, and refund count. Support sees PayPal context at the customer level, not just per order.
Refunds as their own view
Scope a view to refunded orders in a date range with PayPal transaction id and refund amount visible. Risk and finance get an audit list, not a per-order hunt.
Audience
Who uses SleekView for EDD PayPal Pro
Finance reconciliation
Match EDD orders to PayPal payouts: order total, transaction id, payer email, currency. Export to CSV for monthly reconciliation against PayPal's activity download.
Support
Customer view with payer email and recent PayPal txns inline. Investigate disputes without leaving WP admin or opening every order.
Risk and disputes
Filter on refunded or disputed rows, sort by amount and date. Pattern-spotting becomes a sort, not a custom SQL query against transactions.
The bigger picture
Why PayPal reconciliation needs joined EDD views
EDD PayPal Pro processes PayPal payments cleanly and writes transaction references back into EDD's relational tables. The data is all there. The default Orders screen still doesn't show it, because the screen is fixed-column and doesn't join the related transactions or customers tables.
Finance ends up downloading PayPal's activity export and copying transaction ids by hand for monthly reconciliation. Support investigating a dispute clicks into each order to find the payer email. Risk reviewing refunded orders has no saved list, just a status filter that mixes refunds with other terminal states.
SleekView's job is to compose the joins as named tables: PayPal reconciliation, refund audit, customer PayPal view. Same EDD schema, same hooks, dramatically less hunting through transactions one order at a time.
Questions
Common questions about SleekView for EDD PayPal 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 by now. On older EDD versions PayPal references lived in edd_payment postmeta and need a different mapping.
Status changes through EDD CRUD trigger the gateway's refund handlers as configured. The actual PayPal API call goes through EDD PayPal Pro's hook chain, not a SleekView shortcut, so the behaviour matches manual admin edits exactly.
 
If your store uses EDD Recurring Payments with PayPal billing agreements, subscriptions live in edd_subscriptions with payment history linking back to orders. SleekView can render subscriptions as their own view with PayPal payer id inline, or join them to customers for a subscriber workspace.
Yes. Status edits route through EDD CRUD so completion notifications, refund notifications, and the hooks EDD PayPal Pro listens to all fire as expected. Bulk operations iterate per row through CRUD so side effects match manual edits.
 
If EDD PayPal Pro stores IPN reference ids or webhook event ids in edd_ordermeta or as part of a transaction record, SleekView surfaces them as a column. The column picker lists meta keys actually present in your install.
Queries hit indexed columns on edd_orders directly. Joins to edd_order_transactions use order id, which is indexed. Aggregate columns (refund count, lifetime spend) are opt-in per view since they're heavier than direct columns.
SleekView exports to CSV with the visible column set. The column order and headers are configurable per view, so you can shape an export to mirror PayPal's activity-download fields for easier line-by-line reconciliation.
 Yes. Gate columns containing payer email or shipping address to roles that need them (support, finance) via WordPress capabilities, and exclude them from views other staff can access. The PayPal transaction id alone is a pseudonymous reference.
 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
- Wcfm Vendor Staff
- Wholesale Market
- Yith Woocommerce Gift Cards
- Woocommerce Cybersource
- Woocommerce Zip Checkout
- Woocommerce Quickbooks Sync
- Givewp
- Product Vendors Marketplace
- Woocommerce Coinbase Commerce
- Woocommerce Tax Jar
- Woocommerce Product Search
- Woocommerce Octobat
- Woocommerce Instamojo
- Edd Mailchimp
- Wcam Marketplace
- Ultimate Membership Pro Indeed
- Memberium Infusionsoft Pro
- Restrict User Access
- Ultimatemember Real Time Notifications
- Subscriptio
- Wp Community
- Restrict User Access Pro
- Content Locker Pro
- Profile Magic
- Members Management Pro
- Memberium Keap
- Paid Membership Pro Pro
- Memberium
- Wp Private Content Pro
- Paid Memberships Pro