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
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
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.
Add joins as needed
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.
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.
Save and gate per role
Sample columns
A typical EDD orders view
edd_orders with edd_customers (or just email) and the related order items.
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_logstogether -
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.
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
- Woocommerce Product Bundles
- Woocommerce Product Vendors
- Woocommerce Purchase Order Gateway
- Woocommerce Multistore
- Wpc Fly Cart
- Woocommerce Shipping Ups
- Paypal Payments
- Woocommerce Customer Order Csv Export
- Woocommerce Payments Stripe
- Wholesale Suite
- Woocommerce Table Rate Shipping
- Wpc Product Bundles
- Checkout Field Editor
- Yith Woocommerce Product Add Ons
- Wcfm Frontend Manager