SleekView for PagSeguro for WooCommerce: orders & PagSeguro metadata as tables
PagSeguro's WooCommerce plugin writes transaction IDs, boleto barcodes, and PIX QR references as order metadata. SleekView pivots those keys into named columns, HPOS-aware, with gateway-scoped filters for Brazilian finance teams.
♾️ Lifetime License available
PagSeguro metadata as first-class columns
PagSeguro for WooCommerce does not add its own primary tables. Transaction data lives as WooCommerce order metadata: pagseguro_transaction_id, pagseguro_payment_method, boleto barcodes, PIX QR references, and installment count are written through the WooCommerce meta API to wp_wc_orders_meta on HPOS or wp_postmeta on legacy. The default orders list ignores them because the screen renders core fields only.
SleekView reads the right storage automatically and pivots the pagseguro_* meta keys into named columns. A payment-method filter scopes the view to PagSeguro orders. Boleto barcodes, PIX expiry, and installment count become inline columns, which means Brazilian finance and support teams resolve reconciliation and customer queries in one screen instead of multiple tabs.
Edits route through the WooCommerce CRUD layer for the columns the plugin marks editable. Refunds still flow through PagSeguro's admin action that calls its API; SleekView never duplicates that path.
Workflow
From buried meta keys to gateway-scoped tables
Detect storage mode
wc_orders_meta or postmeta accordingly. Storage detection matches what the PagSeguro plugin itself does.
Pivot PagSeguro keys
pagseguro_transaction_id, pagseguro_payment_method, boleto barcodes, and installment count from meta into named columns.
Save views per role
Edit inline or bulk-update
Sample columns
A typical PagSeguro orders view
wp_wc_orders_meta + wp_postmeta (pagseguro_* keys)
| Order # | Status | Total | PagSeguro TXN | Method | Date |
|---|---|---|---|---|---|
| #88601 | Paid | R$345,00 | 7F8A12... | Card 3x | May 17 |
| #88600 | Awaiting boleto | R$220,00 | 7F8A11... | Boleto | May 17 |
| #88599 | Paid | R$129,00 | 7F8A10... | PIX | May 16 |
| #88598 | Cancelled | R$540,00 | 7F8A0F... | Card 1x | May 16 |
Comparison
Default PagSeguro for WooCommerce admin vs SleekView
Default PagSeguro for WooCommerce admin
-
pagseguro_transaction_idhidden in order meta, never in the orders list - Boleto barcodes buried per-order with no expiry filter
- Installment count (parcelas) not exposed as a column
- No filter to isolate PagSeguro orders from other gateways
- PIX expiry timestamps invisible to support, who chase pending QRs blind
SleekView
-
Pivot pagseguro_transaction_id and
pagseguro_payment_methodinto named columns - Filter by gateway to scope the view to PagSeguro orders only
- Surface boleto barcode and expiry as columns for pending-payment triage
-
HPOS-aware: reads
wc_orders_metaon modern stores,postmetaon legacy - Installment count visible inline for AOV-by-parcelas cohort analysis
Features
What SleekView gives you for PagSeguro for WooCommerce
HPOS-aware reads
PagSeguro uses the WooCommerce meta API. SleekView mirrors that, reading wc_orders_meta on HPOS and postmeta on legacy. Views work the same on WooCommerce 8.2+ and older installs.
Boleto expiry triage
Boletos have a fixed expiry window and customers often pay close to it. Surface boleto barcodes and expiry as columns so support can chase pending orders before the boleto lapses and revenue is lost.
Method-scoped filters
Filter by pagseguro_payment_method to see card, boleto, PIX, and account-money cohorts separately. Pair with date and status for finance reconciliation per method.
Audience
Who uses SleekView for PagSeguro
Finance teams
Reconcile PagSeguro settlement files against WooCommerce orders by filtering on payment method and date, with pagseguro_transaction_id inline. Brazilian finance teams collapse monthly matching into one saved view.
Customer support
Customer queries a payment? Search by PagSeguro transaction ID or order number, see method, installments, and boleto expiry inline. Pending-boleto chase becomes a one-screen workflow.
Conversion analysts
Segment by pagseguro_payment_method to compare card versus boleto versus PIX conversion. Surface installment count for AOV comparisons inside the orders view.
The bigger picture
PagSeguro metadata belongs in the orders list
WooCommerce's orders list shows core fields and treats gateway metadata as out-of-scope. That works for stores with one gateway. It fails for Brazilian stores running PagSeguro across card, boleto, PIX, and account-money in parallel, where boleto share alone can decide whether a month closes profitably.
Finance reconciling PagSeguro settlements needs pagseguro_transaction_id as a column to match payout lines. Support fielding pending-boleto queries needs expiry timestamps inline so they can chase customers before the boleto lapses. Conversion analysts comparing parcelas need installment count as a filter chip.
The default workflow forces a tab-flip between the PagSeguro merchant dashboard and WooCommerce admin. SleekView pivots pagseguro_* meta into proper columns and detects HPOS automatically, which collapses each workflow into one saved view. The gateway still owns API operations, refunds still flow through PagSeguro, but the data PagSeguro writes into your orders finally becomes queryable as plain WooCommerce data.
Questions
Common questions about SleekView for PagSeguro for WooCommerce
PagSeguro does not add primary tables. Transaction data lives as WooCommerce order metadata. SleekView reads wc_orders_meta on HPOS or postmeta on legacy automatically.
pagseguro_transaction_id, pagseguro_payment_method, boleto barcodes, PIX QR references, installment count, and any other pagseguro_* key your install writes. The agent UI lists every present key automatically.
No. Refunds go through PagSeguro's API via the WooCommerce admin's refund flow. SleekView surfaces refund state but never proxies the gateway API. Inline edits affect only local fields.
 
Yes. SleekView detects HPOS vs legacy and reads accordingly, same as the PagSeguro plugin. WooCommerce 8.2+ defaults to HPOS; older installs on postmeta still work.
Yes. Filter by _payment_method = pagseguro or by presence of pagseguro_transaction_id. Useful for stores running multiple Brazilian gateways that need to reconcile each independently.
PagSeguro writes boleto expiry to order meta. SleekView surfaces it as a column so support can chase pending boletos in the last 48 hours before they lapse. This is a real revenue lever on Brazilian stores where boleto share is high.
 Yes. Pivot installment count into a filter chip and a column. Compare AOV and refund rates between 1x, 3x, 6x, and 12x cohorts inside the orders view, no separate analytics tool needed.
 Yes. Filter to PagSeguro orders by date range, surface the tax columns recorded as line-item meta (ICMS, IPI, ISS), and export to CSV. The saved view reruns each month so finance does not rebuild the report.
 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 Additional Variation Images
- Woocommerce Moneris
- Woocommerce Sage Accounting
- Woocommerce Multi Currency Switcher
- Wpc Product Quantity
- Woocommerce Shipping Ups
- Wcfm Bookings
- Product Csv Import Export
- Woo Direct Checkout
- Woocommerce Back In Stock
- Wcfm Marketplace
- Woocommerce Eway Gateway
- Woocommerce Product Filter
- Woocommerce Australia Post Pro
- Woocommerce Wholesale Lead Capture
- Nextend Social Login
- User Registration
- User Meta Manager
- Memberpress Buddypress
- Easy Affiliate
- Groups Wp Pro
- Memberpress Coupons
- Academypress
- Woocommerce Paid Courses
- Indeed Ultimate Member
- Ultimate Membership Pro
- Wp Fluent Affiliate
- Ultimatemember Private Content
- Restrict Content Pro
- Tva Thrive Apprentice