SleekView for SureCart Checkout: orders, line items & customers as tables
SureCart runs as a hosted commerce backend mirrored into WordPress via its REST API, with local cache rows for orders, line items, customers, and products. SleekView reads those cache tables as joined columns so checkout ops, refunds, and lifetime value land on one screen instead of inside the SureCart sidebar.
♾️ Lifetime License available
SureCart's hosted orders, surfaced as flat tables
SureCart Checkout keeps the merchant of record on its own hosted infrastructure, and the WordPress plugin caches orders, line items, products, customers, and subscriptions locally so admin screens can render without a round-trip on every page load. The default admin paints each section as a slim React list scoped to one resource at a time, which is fine for a quick scan but awkward when an order, its customer, and the line items all matter for the same task.
SleekView reads the local cache tables (wp_surecart_orders, wp_surecart_line_items, wp_surecart_customers, wp_surecart_products) directly and joins them by order_id and customer_id. The result is one row per order with customer email, line-item summary, discount applied, tax line, and gateway status all visible together. Filters cover date ranges, status, gateway, currency, and any custom field synced from SureCart.
Inline edits route through SureCart's REST API where the resource supports updates (notes, fulfilment status, customer profile fields), so the hosted backend stays the source of truth. Where the API does not allow writes, SleekView surfaces the field read-only and flags it so admins know to use the SureCart dashboard for that specific change.
Workflow
SureCart cache as a joined workspace
Pick the base resource
wp_surecart_orders for order workflows, wp_surecart_customers for CRM-style views, or wp_surecart_line_items for fulfilment-by-product. SleekView auto-detects the SureCart plugin version.
Add joins and aggregates
wp_surecart_customers for email and LTV, and aggregate wp_surecart_line_items into per-order item count plus product summary. Adjustments and tax lines are joinable too when needed.
Save views per role
Edit through the API
Sample columns
A typical SureCart Checkout view
wp_surecart_orders with wp_surecart_customers and aggregated wp_surecart_line_items.
wp_surecart_orders + wp_surecart_line_items + wp_surecart_customers + wp_surecart_products
| Order | Status | Customer | Total | Items | Gateway | Date |
|---|---|---|---|---|---|---|
| #SC-4912 | Paid | alex@studio.co | $129.00 | 2 | Stripe | May 14 |
| #SC-4911 | Processing | ria@design.io | $58.00 | 1 | PayPal | May 14 |
| #SC-4910 | Paid | tom@hello.dev | $240.00 | 3 | Stripe | May 13 |
| #SC-4909 | Refunded | mia@brew.coop | $58.00 | 1 | Stripe | May 13 |
Comparison
Default SureCart Checkout admin vs SleekView
Default SureCart Checkout admin
- Orders, customers, and line items each render in separate React panels with no shared filter context
- No joined customer column on the orders list, support agents pivot to the customer screen every time
- Filtering by gateway or currency requires clicking through the order detail to confirm
- Bulk fulfilment updates go one order at a time through the dashboard
-
Lifetime value across
wp_surecart_customersneeds an export from the hosted dashboard
SleekView
-
Join
wp_surecart_orderstowp_surecart_customersand aggregatedwp_surecart_line_itemsin one row - Filter by gateway, currency, status, or any cached custom field
- Inline-edit order notes and fulfilment status through the SureCart REST API
-
Per-customer lifetime totals computed across the cached
ordersrows - Save views per role: fulfilment, refunds, finance reconciliation
Features
What SleekView gives you for SureCart Checkout
Joined cache tables
Orders, customers, line items, and products are joined client-side from the local SureCart cache. One row tells the full story instead of three sidebar clicks per order.
Gateway and currency filters
Saved filters for Stripe versus PayPal, USD versus EUR, plus any custom field synced from SureCart. The orders queue stops being a single flat list and becomes a set of focused views.
API-routed inline edits
Writeable fields call the SureCart REST API so the hosted backend stays canonical. Read-only fields are flagged in the column header so admins know which changes need the SureCart dashboard.
Audience
Who uses SleekView for SureCart Checkout
Fulfilment
Paid orders sorted by date with line-item summary and shipping address visible inline. Mark fulfilled in bulk, the API call fires per row so SureCart automations still run.
Finance
Reconciliation view joining orders, gateways, and tax line per currency. Export to CSV per period without leaving WordPress.
Support
Customer-rooted view with order count, last order date, and refund history. Resolve a ticket without opening the SureCart dashboard side panel.
The bigger picture
Why headless commerce still needs flat admin tables
SureCart splits the merchant of record from the WordPress install so a small site can run real commerce without taking on PCI scope, but the hosted backend means the WordPress admin is showing a mirror, not the canonical record. That trade is fine for compliance and great for setup speed, and it leaves a familiar gap on the admin side: data lives in separate tables and gets rendered in separate React panels, so day-to-day ops keep clicking between them. SleekView treats the cache as a joinable schema and composes the views ops people actually use.
A fulfilment lead can see paid orders for the day with shipping address and line items in one row, finance can reconcile gateway by gateway per currency without exporting to a separate dashboard, and support can pull a customer with order history and last refund visible during a chat. Inline edits route through SureCart's own REST API so the hosted backend stays authoritative, which keeps tax, refund logic, and gateway behaviour identical to a dashboard-driven change. The default SureCart admin remains intact for merchants who prefer it.
SleekView adds the joined surface most teams need once order volume passes a few dozen per day.
Questions
Common questions about SleekView for SureCart Checkout
It reads from the local cache that the SureCart plugin already maintains (wp_surecart_orders, wp_surecart_customers, and related tables). For writes, it calls the same SureCart REST endpoints the official plugin uses, so audit trails and webhook events in SureCart stay consistent.
SureCart's plugin schedules sync via WP-Cron and webhooks. SleekView surfaces a last_synced_at column when available so admins can spot a row that has not refreshed, and a manual resync button calls the SureCart resource endpoint on demand.
Fulfilment status, internal notes, and customer profile fields are writeable through the SureCart REST API. Refunds and full cancellations are typically routed through SureCart directly so its gateway and tax logic apply, and SleekView links out for those actions.
 
Yes. wp_surecart_line_items can aggregate into a count plus product names column on the orders view, or expand as an inline child table when a fulfilment row needs full per-item detail (SKU, price, quantity, variant).
Yes. Root a view on wp_surecart_customers with aggregate columns for total spend, order count, and last-order date. Filter by currency to compare buckets without mixing totals from different gateways.
SureCart stores currency on every order, and SleekView surfaces it as a filterable column. LTV totals can be grouped by currency or scoped per currency so a USD lifetime value and an EUR lifetime value never get added into one misleading number.
 
Any custom field the SureCart sync writes into wp_surecart_orders or wp_surecart_customers appears in the column picker. Useful for checkout-survey answers or referral codes captured at purchase.
SleekView maps to whichever cache tables the installed SureCart version creates. The plugin reorganised its cache schema once during its 1.x cycle, and SleekView detects the version on activation and maps columns accordingly.
 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 2checkout
- Automatewoo
- Woocommerce Product Vendors
- Woocommerce Checkout Fees
- Woocommerce Iyzico
- Woocommerce Gift Ultimate
- Woocommerce Favorites
- Alibaba Dropshipping
- Charitable
- Iconic Woothumbs
- Woocommerce Variation Stock
- Woocommerce Shipping Australia Post
- Woocommerce Google Shopping
- Woocommerce
- Woocommerce Shipment Tracking Pro