SleekView for Metorik: orders, customers & subscriptions as tables
Metorik mirrors WooCommerce data from wp_posts (post_type=shop_order), wp_postmeta, and HPOS wp_wc_orders into its hosted reports. SleekView reads the same WordPress tables locally so operators get Metorik-style segments without leaving WP Admin.
♾️ Lifetime License available
Get Metorik-style segments without leaving WP Admin
Metorik is a hosted reporting layer for WooCommerce that pulls orders, refunds, subscriptions, and customers from wp_posts (post_type=shop_order) and wp_postmeta, plus the HPOS wp_wc_orders and wp_wc_order_addresses tables when enabled. The data lands in a separate dashboard with strong segmenting, but every report lives outside WordPress and behind another login.
SleekView reads the same WooCommerce tables directly. Order status, total, currency, customer email, payment method, and any postmeta key Metorik tracks become first-class columns and filters. Subscription rows from wp_posts (post_type=shop_subscription) join the same surface, and customer rows pivot in from wp_users and wp_usermeta for lifetime value views.
Edits route through WooCommerce's own CRUD layer through wc_update_order and the REST API, so refunds, notes, and status changes write back through the same hooks the WooCommerce admin uses. There is no second data store to keep in sync, and HPOS is detected automatically.
Workflow
From WooCommerce tables to Metorik-style segments
Detect the WooCommerce source
wp_wc_orders or legacy wp_posts (post_type=shop_order) plus wp_postmeta as the order source.
Compose the order columns
wp_users and wp_usermeta.
Save and scope views
Edit through WooCommerce CRUD
wc_update_order so WooCommerce hooks fire and HPOS stays consistent.
Sample columns
A typical Metorik-style orders view
wp_posts (post_type=shop_order) + wp_postmeta (or HPOS wp_wc_orders)
| Order | Customer | Total | LTV | Segment | Status |
|---|---|---|---|---|---|
| #10482 | alex@studio.co | €128.40 | €1,902 | Repeat buyer | Completed |
| #10483 | ria@design.io | $84.00 | $84 | First order | Processing |
| #10484 | tom@hello.dev | £312.50 | £3,140 | VIP | Refunded |
| #10485 | mia@brew.coop | €46.80 | €420 | At risk | Completed |
Comparison
Default Metorik for WooCommerce admin vs SleekView
Default Metorik for WooCommerce admin
- Reports live in a hosted dashboard outside WordPress, behind a separate login
-
Order rows reference
shop_orderIDs but you have to click back into WP Admin to act on them -
Custom
wp_postmetakeys (referral source, gift wrap) are not always exposed as filters -
Subscription data from
wp_posts (post_type=shop_subscription)lives on its own tab - HPOS detection is transparent but report joins still require a Metorik subscription
SleekView
-
Orders, refunds, and subscriptions from
wp_wc_ordersin one queryable grid inside WP Admin -
Every custom
wp_postmetakey Metorik tracks becomes a sortable column -
Pivot customer LTV in from
wp_users+wp_usermetawithout an external dashboard -
Inline edits write through
wc_update_orderso WooCommerce hooks still fire - Saved segments can be scoped per role so finance and fulfilment see only their slice
Features
What SleekView gives you for Metorik for WooCommerce
Orders joined to customers
Pivot wp_users and wp_usermeta beside every order row. Lifetime value, order count, and customer tags sit next to the current order's _order_total.
Segment combinations
Stack filters on status, payment method, country, currency, and Metorik tags in one panel. Save Repeat buyers in DE or At-risk VIPs as named views.
Inline edits via WooCommerce CRUD
Change status, add a note, or trigger a refund directly from the table. Writes go through wc_update_order, so all WooCommerce hooks and HPOS shadow writes still fire.
Audience
Who uses SleekView for Metorik for WooCommerce
Finance and ops leads
Pull a daily reconciliation view of shop_order rows joined to _payment_method and _order_currency. Sort by total, filter by refund state, and export the slice that needs investigating.
Lifecycle marketers
Build customer segments inside WP Admin without paying for the hosted dashboard. Group by Metorik's segment postmeta and identify lapsed buyers ready for a winback email.
Support agents
See an order's history, refund status, and customer LTV in one row. Triage faster than clicking through Metorik then back into WooCommerce for every ticket.
The bigger picture
Why WooCommerce stores need queryable order views
Metorik built a strong business on the gap between WooCommerce's stock order screen and what an operator actually wants to see. The default edit.php?post_type=shop_order table shows a fixed set of columns, hides custom wp_postmeta keys, and forces anyone who wants real segmentation into either SQL or a hosted dashboard. Metorik's answer was to copy the data into a separate product, which works but introduces a second login, a recurring subscription, and a context switch for every order action.
SleekView treats the same WooCommerce tables as a queryable surface inside WP Admin. Orders, subscriptions, refunds, and customer lifetime value join in one grid; segment tags from wp_postmeta become filters; edits route through wc_update_order so existing hooks keep firing. Finance teams reconcile in seconds, marketers build winback segments without exporting, support agents triage tickets with full customer context.
The hosted dashboard becomes a backup, not the primary workflow, and HPOS works transparently throughout.
Questions
Common questions about SleekView for Metorik for WooCommerce
Yes. SleekView detects whether WooCommerce is reading from legacy wp_posts or the new wp_wc_orders tables and queries the active source. HPOS shadow writes continue to behave normally, so other plugins reading legacy postmeta still work.
Only if you want the hosted dashboard, the email reports, or Metorik's segment automation. SleekView reads the same WooCommerce tables Metorik does, so the columns and segments are available locally. Teams that already pay for Metorik can use SleekView as an in-admin companion.
 
Yes. Rows from wp_posts (post_type=shop_subscription) can be joined to the parent order on _subscription_renewal. Renewal cadence, next payment date, and switch history surface as columns.
Yes. Status changes, notes, and refunds route through wc_update_order and the WooCommerce REST API, so the normal hooks (woocommerce_order_status_changed and so on) fire. There is no direct write to wp_postmeta, which keeps HPOS shadow writes consistent.
Every wp_postmeta key the WooCommerce or Metorik plugins create can be added as a column or filter. Common ones (_billing_country, _order_total, _metorik_segment) ship preconfigured, and developers can register more with a filter hook.
No. SleekView paginates queries against the existing WooCommerce indexes, the same way the standard edit.php?post_type=shop_order screen does. There is no background sync, no cache invalidation, and no front-end script.
Yes. Any saved view exports to CSV with the active filters, sort order, and visible columns. Finance teams use the export for accounting handoff, marketers use it for segment uploads to email tools.
 Yes. SleekView reads from your own WooCommerce tables; no order data is shipped to an external service. Erasure requests honoured by WooCommerce's privacy tools also remove the row from every SleekView grid.
 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 Correos
- Woocommerce Pre Order Pro
- Woocommerce Gift Registry
- Woocommerce Quick Order
- Checkoutwc
- Woocommerce Pricing Deals
- Bigcommerce
- Dokan
- Woocommerce Affirm
- Customer Reviews For Woocommerce
- Order Status Manager
- Woocommerce Coingate
- Woocommerce Recently Viewed
- Woocommerce Paypal Checkout
- Woocommerce Store Credit