✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for EDD PayPal Pro Payment Gateway

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

1

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.
2

Compose joined columns

Left-join edd_order_transactions for PayPal txn and payer ids, edd_customers for customer fields, edd_order_adjustments for taxes or fees.
3

Save and scope per role

Name the views ("PayPal reconciliation last 30d", "Refunded this quarter", "Pending captures") and gate by WordPress capability so each team gets its own table.
4

Edit inline or bulk-process

Flip status through CRUD so refund and capture hooks fire, PayPal's IPN handler stays in charge, and bulk operations iterate per row safely.

Sample columns

A typical EDD PayPal Pro payments view

Joins edd_orders with edd_order_transactions on order id, and edd_customers on customer id.
Source: 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_transactions and 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_orders with edd_order_transactions so 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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