✨ 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 Easy Digital Downloads: orders & customers as tables

Read directly from EDD 3.0+ relational tables (edd_orders, edd_order_items, edd_customers, edd_logs). Build joined views, lifetime-value tables, and file-download audits without per-order click-through.

♾️ Lifetime License available

SleekView table view for Easy Digital Downloads

EDD's relational schema, finally usable as tables

EDD 3.0 split orders, order items, customers, addresses, and logs across multiple custom tables — a deliberate move that solved postmeta-bottleneck performance issues on busy stores. The downside is the same as every relational schema: data that lives in five tables doesn't show up in one screen unless something joins it. SleekView reads edd_orders, edd_order_items, edd_customers, edd_order_addresses, edd_order_adjustments, edd_order_transactions, and edd_logs together so you can build views that match how teams actually work.

The most useful joins: orders plus customers (for support pulling a customer's history mid-call), orders plus order items plus product post type (for fulfilment seeing what shipped), and the file-download log joined to customer email (for answering "who downloaded what, when"). Per-customer aggregate views — total orders, total spent, refund count — turn edd_customers into a CRM-style table sortable by lifetime value without exporting to a separate analytics tool.

Inline edits to order status route through EDD's CRUD layer where supported, so refund logic, file-access changes, and license-key revocation hooks fire as expected. The fixed-column default Orders screen stays where it is for merchants who like it; SleekView is an additional admin surface tuned for ops, finance, and support teams.

Workflow

Compose joined views across EDD's relational tables

1

Pick a base table

edd_orders for order workflows, edd_customers for CRM-style views, edd_logs_file_downloads for download audit. SleekView detects EDD 3.0 versus legacy automatically.
2

Add joins as needed

Left-join edd_customers, edd_order_items, edd_order_addresses, or edd_order_adjustments from the column picker. Aggregates (item count, total adjustments) are opt-in per view since they're heavier.
3

Surface custom meta

edd_ordermeta and edd_customermeta keys appear in the column picker scoped to keys actually present in your data — useful for license-extension data or custom checkout fields.
4

Save and gate per role

Fulfilment sees pending orders with line items, finance sees joined adjustments and transactions, support sees customer-rooted views. One config per workflow, gated by WordPress capability.

Sample columns

A typical EDD orders view

Joins edd_orders with edd_customers (or just email) and the related order items.
Source: wp_edd_orders + wp_edd_order_items + wp_edd_customers + wp_edd_logs
Order Status Customer Total Items Date
#3128 Complete alex@studio.co $48.00 1 Apr 24
#3127 Pending ria@design.io $96.00 2 Apr 24
#3126 Complete tom@hello.dev $32.00 1 Apr 23
#3125 Refunded mia@brew.coop $48.00 1 Apr 23

Comparison

Default EDD admin vs SleekView

Default EDD admin

  • Order list shows a fixed column set — no easy way to add custom-meta columns
  • Customers, addresses, and logs live in separate tables that aren't joined into the order list
  • File-download logs (edd_logs_file_downloads) need separate screens to inspect
  • Bulk-status changes go through Order screens one at a time
  • Cross-customer audit (lifetime value, refunds) requires custom queries

SleekView

  • Read from edd_orders, edd_order_items, edd_customers, edd_logs together
  • Per-customer lifetime-value views (sum of edd_orders.total)
  • File-download log audit table joined to customer email
  • Inline-edit order status and notes
  • Save filtered views per role (fulfilment, finance, support)

Features

What SleekView gives you for Easy Digital Downloads

Joined views across EDD tables

Build a single view that joins edd_orders with edd_customers and edd_order_items — orders, customer, and product list in one row. Add adjustments and transactions as needed.

Lifetime value and customer audit

Per-customer aggregate views: total orders, total spent, refund count, last-order date. Sort by spend without exporting a CSV — turns edd_customers into a CRM-style workspace.

File-download log audit

Surface edd_logs_file_downloads as a tabular log with customer email and product columns. Answer "who downloaded what, when" inline — useful for licensing disputes or IP audits.

Audience

Who uses SleekView for EDD

Fulfilment

Pending orders sorted by date with line items visible — no per-order click-through. License-key generation status visible inline if you run EDD Software Licensing.

Finance

Order audit table joined with adjustments and transactions, filtered by date range and currency. Export to CSV for the bookkeeper without leaving WordPress.

Support

Customer view: all orders, total spent, last order, recent download log entries — without leaving WP admin. Refund history and license status visible during the call.

The bigger picture

Why digital-store ops need joined views

EDD makes digital storefronts straightforward — license keys, software downloads, paid newsletters, course access, design assets. The relational schema introduced in 3.0 is technically correct: orders are not their own line items, customers are not their own orders, logs are not transactions. But operationally, the people running the store want all of those joined back together for a given task.

A support agent triaging a license-key issue wants the customer, the order, the order item with product slug, and the recent download log entries — all on one screen, all keyed to the customer's email. A finance lead reconciling tax season wants orders joined with adjustments and transactions, filtered by date range and currency, exportable. A marketing manager looking at lifetime value wants edd_customers sorted by spend with order count visible.

The default EDD admin shows the right data in the wrong shape for these jobs. SleekView's job is to compose the joins. Same database, same hooks, dramatically less context-switching for everyone except the merchant browsing the standard Orders screen.

Questions

Common questions about SleekView for Easy Digital Downloads

For the relational tables (edd_orders, edd_customers, edd_order_items) yes — those landed in EDD 3.0. Older versions stored orders as edd_payment posts with payment data in postmeta, and SleekView would need a different mapping. Most stores have migrated to 3.0 by now since EDD's own admin assumes the new schema for any store updated past 3.0.

 

Yes. edd_order_items can either aggregate into a column (count plus product names concatenated) or expand as a related child table per row when you need full per-line-item detail. The aggregate column is fine for triage views; the expandable table is better for fulfilment when each line matters individually.

 

Yes — edd_order_addresses, edd_order_adjustments (taxes, discounts, fees), and edd_order_transactions are all exposed as joinable tables. Adjustments often hide important context: a discount code applied at checkout shows up here, not on the order row, so a discount-audit view typically joins adjustments to orders by order id.

 

Yes. SleekView writes through EDD's CRUD layer where supported, so status-change hooks (refunds revoking file access, license-key adjustments, completion notifications) fire as expected. Bulk operations iterate per row through the same CRUD path so side effects are identical to manual admin edits — no special bulk-mode that bypasses logic.

 

EDD Software Licensing stores license data in its own table (edd_licenses and related). SleekView can show those as a separate view or join license to order or customer for a license-management workspace. Site-activation tracking from Software Licensing also gets its own table that's exposable for activation audit views.

 

Yes. Build a view rooted on edd_customers with order count, total spent, refund count, and last-order date as aggregate columns. Useful for support (one row per customer with everything they bought), sales (find high-LTV customers for outreach), and marketing (segment by spend bucket without exporting to a CRM).

 

EDD Recurring Payments stores subscription data 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-management workspace. Failed-renewal queues and upcoming-expiration filters become straightforward saved views.

 

Customer queries hit indexed columns (id, email, date_created) on edd_customers. Aggregate columns (lifetime spend, order count) are computed via 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. Pagination is keyset where the schema allows.

 

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