SleekView for Lemon Squeezy: orders, subscriptions & licenses as tables
The Lemon Squeezy plugin keeps a local cache of orders and subscription state and authenticates against the Lemon Squeezy API for the rest. SleekView merges both into sortable tables so finance and support stop bouncing between WP Admin and the Lemon Squeezy dashboard.
♾️ Lifetime License available
Merchant of record data without two browser tabs
Lemon Squeezy positions itself as a Stripe alternative that handles VAT, sales tax, and chargebacks as the merchant of record. The official WordPress plugin syncs products and license keys, processes checkout via hosted Lemon Squeezy pages, and stores a local cache of orders and license activations against custom post types and tables. Anything beyond that lives in the Lemon Squeezy dashboard, which means an admin who wants to answer "which EU customers refunded last month" ends up reconciling two systems.
SleekView reads the plugin's local cache directly, then optionally enriches each row with live API fields like tax breakdowns, refund timestamps, and subscription renewal dates. Build one view that lists orders by country with VAT total as a sortable column, another that shows active licenses by product with last-activation date, and a third that tracks subscription renewals coming up in the next seven days. Save each view, scope it to a role, and the data lives where the rest of WordPress operations already happens.
Writes still route through the plugin's API client so the merchant-of-record contract stays intact. Refunds, license deactivations, and subscription cancellations call the official endpoints; SleekView never writes refund records straight to the database. The result is a familiar inline-edit experience for support staff with no risk of desyncing the local cache from Lemon Squeezy's source of truth.
Workflow
How SleekView surfaces Lemon Squeezy data
Read the plugin's local cache
Add API-enriched columns
Save views per workflow
Edit through the official API
Sample columns
A typical Lemon Squeezy orders view
Lemon Squeezy plugin custom tables + Lemon Squeezy API
| Order # | Customer | Country | Total | VAT | Status |
|---|---|---|---|---|---|
| LS-8821 | alex@studio.co | DE | $184.00 | $29.39 | Paid |
| LS-8820 | ria@design.io | US | $72.50 | $0.00 | Paid |
| LS-8819 | tom@hello.dev | GB | $312.00 | $52.00 | Pending |
| LS-8818 | mia@brew.coop | FR | $48.00 | $8.00 | Refunded |
Comparison
Lemon Squeezy plugin admin vs SleekView
Default Lemon Squeezy WordPress admin
- Order detail screens link out to the Lemon Squeezy dashboard for most fields
- License activation history lives behind a per-license drilldown
- No cross-product subscription renewal calendar inside WordPress
- VAT and tax breakdowns aren't first-class columns in the local list
- No way to save a filter like 'EU refunds last 30 days' for repeat use
SleekView
- Merge local cache + API fields into one inline-sortable row
- Filter orders by country, tax rate, gateway response, and date together
- License activation table with product, machine ID, and last-seen timestamp
- Subscription renewal calendar as a saved view per pricing tier
- Inline refund and license deactivation route through the official API
Features
What SleekView gives you for Lemon Squeezy for WordPress
Tax and country filters that exist
Filter by billing country, tax rate, and reverse-charge flag in one view. The merchant-of-record data Lemon Squeezy collects becomes a regular column you can sort and group on, not a detail-screen modal.
License activations as a table
Each activation row carries product, instance ID, machine name, last-seen date, and current state. Filter to activations that haven't checked in for 30 days, deactivate them inline, and the API call goes through the plugin's client.
Renewals before they happen
Save a view that lists subscriptions renewing in the next seven days, sorted by amount, with the customer email visible. Support gets a heads-up window for outreach without exporting CSVs from the dashboard.
Audience
Who uses SleekView for Lemon Squeezy
Finance ops
Refunds and chargebacks by country and product, sortable by VAT amount. Reconcile against monthly Lemon Squeezy payouts inside WordPress; no second login for routine numbers.
Customer support
Open a customer email and see every order, every active license, and every upcoming renewal in one row set. Deactivate a license inline when a buyer reports a stolen device.
Plugin authors
Cross-product license views to spot abuse patterns: one license key activated on twenty machines, customers whose subscription lapsed but whose license still pings home, products with the highest refund rate.
The bigger picture
Why merchant-of-record data needs a local table
Lemon Squeezy solves a real problem for digital sellers. They handle VAT registration in 50+ countries, sales tax in every US state, chargeback disputes, and PCI scope. The cost is that the data lives on their servers, the WordPress plugin is mostly a sync layer, and most operational answers require logging into the Lemon Squeezy dashboard.
That's fine for a solo developer with ten orders a month. It's painful for a plugin author with three products, two pricing tiers, and a support team triaging refund and license requests every day. SleekView reads the local cache the plugin already maintains, layers in live API fields where they help, and routes writes through the official client so the merchant-of-record contract stays clean.
The result is a row-level workspace inside WordPress for the data that matters daily, with the Lemon Squeezy dashboard still owning the parts where it should be the source of truth.
Questions
Common questions about SleekView for Lemon Squeezy for WordPress
It uses whatever API key the Lemon Squeezy plugin already holds. SleekView calls the plugin's own client to fetch enriched fields (tax, refund timestamps, license activation history) and to write changes (refunds, deactivations). No second key, no separate OAuth flow, and the plugin's existing rate-limit and error handling are reused.
Yes. Refunds go through the Lemon Squeezy API endpoint that creates the refund record and the corresponding tax credit on Lemon Squeezy's side. SleekView doesn't touch the local database independently, so the merchant-of-record paperwork stays consistent. The same applies to subscription cancellations and license deactivations.
Yes. Both are stored in the plugin's local cache with a type discriminator, so SleekView treats them as one source with type as a filterable column. Build a unified order view, or split them into two saved views if your team wants subscriptions on one screen and one-offs on another.
The Lemon Squeezy plugin syncs via webhooks plus a scheduled reconciliation job. SleekView surfaces the last-sync timestamp as an optional column and can fetch fresh data per row on demand for support cases. It doesn't try to be a replacement for the plugin's sync engine, only a better surface for the data the plugin already has.
Yes. Lemon Squeezy's licensing API records activations with instance ID, machine name, and last-checked timestamp. The plugin caches these locally; SleekView pivots the data into a normal table with each activation as one row. Bulk deactivation is supported and runs through the API endpoint that revokes the activation.
Filters and sorts run against the local cache and never hit the API. Only optional enrichment columns (live tax breakdowns, real-time renewal status) trigger API calls, and SleekView batches them per page so a 50-row table is one or two API calls, not 50. Heavy enrichment columns are off by default for that reason.
Yes, with an aggregate view. SleekView supports group-by columns, so a product-level summary with refund count, refund total, and refund rate against gross sales is one saved view. It's a derived view sourced from the same orders table, refreshed when the underlying orders change.
Different, not better. The Lemon Squeezy dashboard owns payouts, tax filings, and merchant-of-record reporting. SleekView wins on day-to-day reconciliation that touches WordPress data too: matching customers across products, joining orders with WordPress users, and saving filtered views the support team uses every shift.
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 checkout